Towards OntoUML for Software Engineering: Evaluation of Constraints Performance in Relational Databases
Autoři
Rok
2026
Publikováno
Proceedings of the 14th International Conference on Model-Based Software and Systems Engineering - MODELSWARD. Setùbal: SciTePress, 2026. p. 362-370. ISSN 2184-4348. ISBN 978-989-758-798-6.
Typ
Stať ve sborníku
Pracoviště
Anotace
In the Model-Driven Development approach to software engineering, models of the software system are elaborated and are transformed to the final implementation. OntoUML is a conceptual modeling language suitable for this purpose, as it can be used to construct ontologically well-founded data models. Relational databases are commonly used for the storage of application data. In existing research, transformation of OntoUML to various relational databases was proposed, with focus on preserving the domain constraints captured by the conceptual model. It follows that a trade-off exists between the enforcement of constraints (therefore improved data integrity) and database performance. In this paper, we present a series of experiments and measurements of the performance impact of each type of constraint for various database sizes and in various relational database implementations. As a result, we provide empirical data that can be used to estimate the performance impact in concrete scenario s and decide between the trade-offs.
Towards OntoUML for Software Engineering: Transformation of Constraints into Various Relational Databases
Autoři
Rok
2025
Publikováno
Communication Papers of the 20th Conference on Computer Science and Intelligence Systems. Warsaw: Polskie Towarzystwo Informatyczne, 2025. p. 85-93. vol. 45. ISSN 2300-5963. ISBN 978-83-973291-9-5.
Typ
Stať ve sborníku
Pracoviště
Anotace
OntoUML is an ontologically well-founded conceptual modeling language that provides precise meaning to modeled elements. As a result, its usage is beneficial in the Model-Driven Development approach to software development. Relational databases are commonly used for storage of application data, and they offer support for the implementation of custom data constraints. In this paper, we discuss the realization of constraints that arise from OntoUML structural models in PostgreSQL, Microsoft SQL Server and MySQL, and provide a complete reference on how to implement these constraints so that only data conforming to the OntoUML model can be stored.