M-lab

Model-driven Software Engineering Laboratory

The domain of the M-lab research laboratory is model-driven software engineering. The work of the laboratory is done by teachers and associates of the Faculty of Electrical Engineering, as well as students of all study cycles at the University of Banja Luka, whose scientific research interests are in the field of laboratory work.

Amadeos

AMADEOS is the first online web-based business-process-model-driven tool for automatic database design. It enables database designers to automatically derive the target conceptual database model (CDM) from a collection of business process models that are represented by BPMN or UML activity diagram, and to transform it into the corresponding relational database model (RDM) for the selected DBMS.

Finally, designers are able to automatically generate the corresponding DDL script and generate the target physical database schema. At the moment, the following DBMSs are supported: MySQL, Microsoft SQL Server, PostgreSQL, Oracle, IBM DB2.

Try Amadeos

For more details about the approach and AMADEOS system, we refer to the following most representative references:

Spasic, Z., Vukotic, A., Brdjanin, D., Banjac, D., Banjac, G.: UML-based Forward Database Engineering. INFOTEH 2023. (presentation)
Brdjanin, D., Vukotic, A. Banjac, D., Banjac, G., Maric, S.: Automatic Derivation of the Initial Conceptual Database Model from a Set of Business Process Models. Computer Science and Information Systems, 19(1):455–493, 2022. (http://comsis.org/archive.php?show=pprinista-34)
Brdjanin, D., Ilic, S., Banjac, G., Banjac, D., Maric, S.: Automatic derivation of conceptual database models from differently serialized business process models. Software & Systems Modeling, 20(1):89-115, 2021. (https://rdcu.be/b5npz)
Brdjanin, D., Banjac, D., Banjac, G., Maric, S.: Automated Two-phase Business Model-driven Synthesis of Conceptual Database Models. Computer Science and Information Systems, 16(2):657–688, 2019. (http://comsis.org/archive.php?show=pprwims-8678)
Brdjanin, D., Banjac, G., Banjac, D., Maric, S.: An experiment in model-driven conceptual database design. Software & Systems Modeling, 18(3):1859–1883, 2019. (https://rdcu.be/J2iK)
Brdjanin, D., Maric, S.: An Approach to Automated Conceptual Database Design Based on the UML Activity Diagram. Computer Science and Information Systems, 9(1): 249–283, 2012. (http://comsis.org/archive.php?show=ppr319-1103)

TexToData

TexToData is the first online multilingual tool enabling automatic conversion of a natural language text into the target conceptual database model represented by a UML class diagram.

Try TexToData

For more details about the approach and TexToData system, we refer to the following most representative references:

Brdjanin, D., Grumic, M., Banjac, G., Miscevic, M., Dujlovic, I., Kelec, A., Obradovic, N., Banjac, D., Volas, D., Maric, S.: Towards an Online Multilingual Tool for Automated Conceptual Database Design. IDC 2022. (presentation)

SpeeD

SpeeD is the first online web-based tool which enables conversion of a recorded speech into the conceptual database model represented by a UML class diagram.

Try SpeeD

For more details about the approach and SpeeD system, we refer to the following most representative references:

Brdjanin, D., Banjac, G., Babic, N., Golubovic, N.: Towards the Speech-driven Database Design. Telfor 2022. (presentation)

DBomnia

DBomnia is the first online web-based tool enabling automatic conceptual database models (CDM) derivation from a heterogeneous set of source artifacts. Currently supported source artifacts are business process models and textual specifications.

DBomnia employs other tools (AMADEOS and TexToData) to generate CDMs from specific source artifacts (AMADEOS derives CDM from BPMs, while TexToData derives CDM from textual specifications) and then integrates the generated CDMs into a single unified CDM.

Try DBomnia

For more details about the approach and DBomnia system, we refer to the following most representative references:

Banjac, G., Brdjanin, D., Banjac, D.: Towards Automatic Conceptual Database Design based on Heterogeneous Source Artifacts. MADEISD 2023.

REDBUL

REDBUL is the first online web-based tool for reverse database engineering, which uses the standard UML class diagram to represent database schema extracted from an existing database (IBM DB2, MariaDB, MS SQL, MySQL, Oracle, Postgre SQL).

Database schema extracted from an existing database is represented by standard UML class diagram.

Try REDBUL

For more details about the approach and REDBUL system, we refer to the following most representative references:

Reljic, S., Brdjanin, D., Banjac, G.: Reverse Engineering of Relational Database Schema based on Universal Metadata Queries. INFOTEH 2022, IEEE. (presentation)
Brdjanin, D., Vukovic, D., Banjac, G., Kelec, A., Dujlovic, I., Obradovic, N, Banjac, D.: REDBUL: An Online System for Reverse Engineering of Relational Databases. INISTA 2020, IEEE. (presentation)
Brdjanin, D., Maric, S., Spasic Pavkovic, Z.: On Suitability of Standard UML Notation for Relational Database Schema Representation. LNBIP, Vol. 248, pp. 399-413. Springer, 2016.