Towards OntoUML for Software Engineering: Optimizing Kinds and Subkinds Transformed into Relational Databases

  • Zdeněk RybolaEmail author
  • Robert Pergl
Conference paper
Part of the Lecture Notes in Business Information Processing book series (LNBIP, volume 332)


Model-driven development approach to software engineering requires precise models defining as much of the system as possible. OntoUML is a conceptual modelling language based on UFO, which provides constructs to create ontologically well-founded and precise conceptual models. In the approach we utilize, OntoUML is used for making conceptual models of software application data. Such a model is then transformed into its proper realization in a relational database, preserving all the implicit constraints defined by various types of universals and relations in the original OntoUML model. In this paper, we discuss possible optimizations of the transformation of Kinds and Subkinds – rigid sortal universal types, a backbone of OntoUML models.


MDD OntoUML Optimization Relational database Transformation 


  1. 1.
    Aleksić, S., Ristić, S., Luković, I.: An approach to generating server implementation of the inverse referential integrity constraints. In: Proceedings of the 5th International Conference on Information Technologies, ICIT, May 2011Google Scholar
  2. 2.
    Aleksić, S., Ristić, S., Luković, I., Čeliković, M.: A design specification and a server implementation of the inverse referential integrity constraints. Comput. Sci. Inf. Syst. 10(1) (2013)Google Scholar
  3. 3.
    Andreeva, E., Poletaeva, T., Abdulrab, H., Babkin, E.: One solution for semantic data integration in logistics. In: Barjis, J., Pergl, R., Babkin, E. (eds.) EOMAS 2015. LNBIP, vol. 231, pp. 75–86. Springer, Cham (2015). Scholar
  4. 4.
    Benevides, A.B., Guizzardi, G., Braga, B.F.B., Almeida, J.P.A.: Assessing modal aspects of OntoUML conceptual models in alloy. In: Heuser, C.A., Pernul, G. (eds.) ER 2009. LNCS, vol. 5833, pp. 55–64. Springer, Heidelberg (2009). Scholar
  5. 5.
    Carolla, M., Spitta, T.: Methodological aspects of a data reference model for campus management systems. Working Paper (2014)Google Scholar
  6. 6.
    Carraretto, R.: Separating ontological and informational concerns: a model-driven approach for conceptual modeling. Master thesis, Federal University of Espirito Santo (2012)Google Scholar
  7. 7.
    Egea, M., Dania, C.: SQL-PL4OCL: an automatic code generator from OCL to SQL procedural language. Softw. Syst. Model., 1–23 (2017)Google Scholar
  8. 8.
    Ghezzi, C., Jazayeri, M., Mandrioli, D.: Fundamentals of Software Engineering, 2nd edn. Prentice Hall, Upper Saddle River (2002)zbMATHGoogle Scholar
  9. 9.
    Guizzardi, G.: Ontological Foundations for Structural Conceptual Models, vol. 015. University of Twente, Enschede (2005)zbMATHGoogle Scholar
  10. 10.
    Guizzardi, G.: Agent roles, qua individuals and the Counting Problem. In: Garcia, A., Choren, R., Lucena, C., Giorgini, P., Holvoet, T., Romanovsky, A. (eds.) SELMAS 2005. LNCS, vol. 3914, pp. 143–160. Springer, Heidelberg (2006). Scholar
  11. 11.
    Guizzardi, G.: The problem of transitivity of part-whole relations in conceptual modeling revisited. In: van Eck, P., Gordijn, J., Wieringa, R. (eds.) CAiSE 2009. LNCS, vol. 5565, pp. 94–109. Springer, Heidelberg (2009). Scholar
  12. 12.
    Guizzardi, G., Wagner, G.: A unified foundational ontology and some applications of it in business modeling. In: CAiSE Workshops, pp. 129–143 (2004)Google Scholar
  13. 13.
    Kuskorn, W., Lekcharoen, S.: An adaptive translation of class diagram to relational database. In: International Conference on Information and Multimedia Technology, ICIMT 2009, pp. 144–148, December 2009Google Scholar
  14. 14.
    Mellor, S.J., Clark, A.N., Futagami, T.: Model-driven development. IEEE Softw. 20(5), 14 (2003)CrossRefGoogle Scholar
  15. 15.
    OMG: UML 2.5, March 2015. Accessed 12 Mar 2018Google Scholar
  16. 16.
    Oriol, X., Teniente, E.: Incremental checking of OCL constraints through SQL queries. In: Proceedings of the 14th International Workshop on OCL and Textual Modelling, pp. 23–32 (2014)Google Scholar
  17. 17.
    Pergl, R., Sales, T.P., Rybola, Z.: Towards OntoUML for software engineering: from domain ontology to implementation model. In: Cuzzocrea, A., Maabout, S. (eds.) MEDI 2013. LNCS, vol. 8216, pp. 249–263. Springer, Heidelberg (2013). Scholar
  18. 18.
    Ramakrishnan, R., Gehrke, J.: Database Management Systems, 3rd edn. McGraw-Hill, Boston (2002)zbMATHGoogle Scholar
  19. 19.
    Rybola, Z., Pergl, R.: Towards OntoUML for software engineering: introduction to the transformation of OntoUML into relational databases. In: Pergl, R., Molhanec, M., Babkin, E., Fosso Wamba, S. (eds.) EOMAS 2016. LNBIP, vol. 272, pp. 67–83. Springer, Cham (2016). Scholar
  20. 20.
    Rybola, Z., Pergl, R.: Towards OntoUML for software engineering: transformation of anti-rigid sortal types into relational databases. In: Bellatreche, L., Pastor, Ó., Almendros Jiménez, J.M., Aït-Ameur, Y. (eds.) MEDI 2016. LNCS, vol. 9893, pp. 1–15. Springer, Cham (2016). Scholar
  21. 21.
    Rybola, Z., Pergl, R.: Towards OntoUML for software engineering: transformation of kinds and subkinds into relational databases. Comput. Sci. Inf. Syst. 14(3), 913–937 (2017)CrossRefGoogle Scholar
  22. 22.
    Rybola, Z., Richta, K.: Possible realizations of multiplicity constraints. Comput. Sci. Inf. Syst. 10(4), 1621–1646 (2013)CrossRefGoogle Scholar
  23. 23.
    Sobotka, P.: Transformation from OCL into SQL. Master thesis, Charles University, Prague, Czech Republic, May 2012Google Scholar
  24. 24.
    Zamborlini, V., Guizzardi, G.: On the representation of temporally changing information in OWL. In: 2010 14th IEEE International Enterprise Distributed Object Computing Conference Workshops (EDOCW), pp. 283–292. IEEE (2010)Google Scholar

Copyright information

© Springer Nature Switzerland AG 2018

Authors and Affiliations

  1. 1.Faculty of Information TechnologyCzech Technical University in PraguePragueCzech Republic

Personalised recommendations