Logo PTI Logo FedCSIS

Communication Papers of the 20th Conference on Computer Science and Intelligence Systems (FedCSIS)

Annals of Computer Science and Information Systems, Volume 45

Towards OntoUML for Software Engineering: Transformation of Constraints into Various Relational Databases

, ,

DOI: http://dx.doi.org/10.15439/2025F7149

Citation: Communication Papers of the 20th Conference on Computer Science and Intelligence Systems (FedCSIS), M. Bolanowski, M. Ganzha, L. Maciaszek, M. Paprzycki, D. Ślęzak (eds). ACSIS, Vol. 45, pages 85–93 ()

Full text

Abstract. 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.

References

  1. M. Fowler, UML Distilled: A Brief Guide to the Standard Object Modeling Language, 3rd ed. Boston: Addison-Wesley, Sep. 2003. ISBN 978-0-321-19368-1
  2. G. Guizzardi, A. Botti Benevides, C. Morais Fonseca, D. Porello, J. P. A. Almeida, and T. Prince Sales, “UFO: Unified Foundational Ontology,” Applied Ontology, vol. 17, no. 1, pp. 167–210, Mar. 2022. https://dx.doi.org/10.3233/AO-210256
  3. DB-Engines. Ranking per database model category. Accessed Apr. 2025. [Online]. Available: https://db-engines.com/en/ranking_categories
  4. Z. Rybola, “Towards OntoUML for Software Engineering: Transformation of OntoUML into Relational Databases,” Ph.D. dissertation, Czech Technical University in Prague, Prague, Aug. 2017.
  5. G. Guizzardi, G. Wagner, J. P. A. Almeida, and R. S. Guizzardi, “Towards Ontological Foundations for Conceptual Modeling: The Unified Foundational Ontology (UFO) Story,” Applied Ontology, vol. 10, no. 3-4, pp. 259–271, Dec. 2015. https://dx.doi.org/10.3233/AO-150157
  6. G. Guizzardi, “Ontological Foundations for Structural Conceptual Models,” Ph.D. dissertation, University of Twente, Enschede, 2005.
  7. G. Guizzardi, C. Morais Fonseca, A. B. Benevides, J. P. A. Almeida, D. Porello, and T. P. Sales, “Endurant Types in Ontology-Driven Conceptual Modeling: Towards OntoUML 2.0,” in Conceptual Modeling. Cham: Springer, 2018, vol. 11157, pp. 136–150.
  8. G. Guizzardi, C. Morais Fonseca, J. P. A. Almeida, T. P. Sales, A. B. Benevides, and D. Porello, “Types and Taxonomic Structures in Conceptual Modeling: A Novel Ontological Theory and Engineering Support,” Data & Knowledge Engineering, vol. 134, p. 101891, Jul. 2021. https://dx.doi.org/10.1016/j.datak.2021.101891
  9. G. Guizzardi and G. Wagner, “What’s in a Relationship: An Ontological Analysis,” in Conceptual Modeling - ER 2008. Berlin: Springer, 2008, vol. 5231, pp. 83–97. ISBN 978-3-540-87877-3
  10. G. Guizzardi, T. P. Sales, J. P. A. Almeida, and G. Poels, “Automated Conceptual Model Clustering: A Relator-Centric Approach,” Software and Systems Modeling, vol. 21, no. 4, pp. 1363–1387, Aug. 2022. https://dx.doi.org/10.1007/s10270-021-00919-5
  11. L. Liu and M. T. Özsu, Encyclopedia of Database Systems. New York: Springer, 2018. ISBN 978-1-4614-8265-9
  12. I. O. for Standardization, “Database Language SQL — Part 1: Framework,” Geneva, Jun. 2023.
  13. J. Jabůrek, “Implementation of the Transformation of an OntoUML Model in OpenPonk into Its Realization in a Relational Database,” Master’s thesis, Czech Technical University in Prague, Prague, May 2024.
  14. Z. Rybola and R. Pergl, “Towards OntoUML for Software Engineering: Transformation of Kinds and Subkinds into Relational Databases,” Computer Science and Information Systems, vol. 14, no. 3, pp. 913–937, 2017. https://dx.doi.org/10.2298/CSIS170109035R
  15. DB-Engines. Ranking of Relational DBMS. Accessed Apr. 2025. [Online]. Available: https://db-engines.com/en/ranking/relational+dbms
  16. Z. Rybola and R. Pergl, “Towards OntoUML for Software Engineering: Transformation of Anti-Rigid Sortal Types into Relational Databases,” in Model and Data Engineering. Cham: Springer, 2016, vol. 9893, pp. 1–15. ISBN 978-3-319-45547-1