Modeling low-code databases with executable UML

Abstract

This study aims to create a method for transforming a Unified Modeling Language (UML) class model into an open-source end-user database. The manual transformation of UML class models into a database can be time-consuming and prone to errors. By making a database schema from a UML class model in standard XMI format, our framework offers an automated alternative and makes the transformation more useful. The tool gets the tables, attributes, and connections that compose the schema from the class model's classes, properties, and relationships. The tool also has an abstract RESTful web service component to give the newly made database a web interface. Such a tool will make it easier for software engineers with less experience, especially students, to learn and use UML class models. We implemented the framework for a Baserow end-user database and evaluated it on a student internship use case. The accompanying code is available as an open-source GitHub repository.