Towards Ontology Engineering Based on Transformation of Conceptual Models and Spreadsheet Data: A Case Study

  • Nikita O. Dorodnykh
  • Aleksandr Yu. YurinEmail author
Conference paper
Part of the Advances in Intelligent Systems and Computing book series (AISC, volume 1046)


The ontology engineering is a complex and time-consuming process. In this regard, methods for automated formation of ontologies based on various information sources (e.g., databases, spreadsheets data, and text documents, etc.) are being actively developed. This paper presents a case study for the domain ontology engineering based on analysis and transformation of conceptual models and spreadsheet data. The analysis of conceptual models, which are serialized using XML, provides the opportunity to develop content ontology design patterns. The specific concepts for filling obtained ontology design patterns are resulted from the transformation of spreadsheet data in the CSV format. In this paper, we present statement of the problem and the approach for its solution. The illustrative example describes ontology engineering for the industrial safety inspection tasks.


Ontology engineering Ontology design patterns OWL Conceptual models Spreadsheets Transformations Industrial safety inspection 



The contribution of this work was supported by the Russian Science Foundation under Grant No. 18-71-10001.


  1. 1.
    Guarino, N.: Formal ontology in information systems. In: The First International Conference on Formal Ontology in Information Systems (FOIS 1998), vol. 46, pp. 3–15 (1998)Google Scholar
  2. 2.
    Starr, R.R., de Oliveira, J.M.P.: Concept maps as the first step in an ontology construction method. Inf. Syst. 38, 771–783 (2013). Scholar
  3. 3.
    Herrero-Zazo, M., Segura-Bedmar, I., Martínez, P.: Conceptual models of drug-drug interactions: a summary of recent efforts. Knowl.-Based Syst. 114, 99–107 (2016). Scholar
  4. 4.
    Berman, A.F., Dorodnykh, N.O., Nikolaychuk, O.A., Pavlov, N.Y., Yurin, A.Yu.: Fishbone diagrams for the development of knowledge bases. In: The 41st International Convention on Information and Communication Technology, Electronics and Microelectronics (MIPRO 2018), pp. 967–972 (2018).
  5. 5.
    Shigarov, A.O., Mikhailov, A.A.: Rule-based spreadsheet data transformation from arbitrary to relational tables. Inf. Syst. 71, 123–136 (2017). Scholar
  6. 6.
    Tijerino, Y.A., Embley, D.W., Lonsdale, D.W., Ding, Y., Nagy, G.: Towards ontology generation from tables. World Wide Web 8(3), 261–285 (2005). Scholar
  7. 7.
    Hitzler, P., Gangemi, A., Janowicz, K., Krisnadhi, A.A., Presutti, V.: Ontology Engineering with Ontology Design Patterns: Foundations and Applications. Studies on the Semantic Web. IOS Press/AKA, Amsterdam (2016)Google Scholar
  8. 8.
    Association for ontology design & patterns (ODPA). Accessed 18 Mar 2019
  9. 9.
    Milanović, M., Gašević, D., Giurca, A., Wagner, G., Devedžić, V.: Bridging concrete and abstract syntaxes in model-driven engineering: a case of rule languages. Soft. Pract. Exp. 39(16), 1313–1346 (2009). Scholar
  10. 10.
    Zedlitz, J., Luttenberger, N.: Conceptual modelling in UML and OWL-2. Int. J. Adv. Softw. 7(1), 182–196 (2014)Google Scholar
  11. 11.
    Bohring, H., Auer, S.: Mapping XML to OWL ontologies. In: Leipziger Informatik-Tage, vol. 72, pp. 147–156 (2005)Google Scholar
  12. 12.
    Rodrigues, T., Rosa, P., Cardoso, J.: Moving from syntactic to semantic organizations using JXML2OWL. Comput. Ind. 59(8), 808–819 (2008). Scholar
  13. 13.
    O’Connor, M.J., Das, A.K.: Acquiring OWL ontologies from XML documents. In: The 6th International Conference on Knowledge Capture (K-CAP 2011), pp. 17–24 (2011).
  14. 14.
    Bedini, I., Matheus, C., Patel-Schneider, P.F., Boran, A., Nguyen, B.: Transforming XML schema to OWL using patterns. In: The 2011 IEEE Fifth International Conference on Semantic Computing, pp. 102–109 (2011).
  15. 15.
    Gleaning resource descriptions from dialects of languages (GRDDL). Accessed 18 Mar 2019
  16. 16.
    Lange, C.: Krextor - an extensible framework for contributing content math to the web of data. In: International Conference on Intelligent Computer Mathematics, pp. 304–306 (2011). Scholar
  17. 17.
    Bischof, S., Decker, S., Krennwallner, T., Lopes, N., Polleres, A.: Mapping between RDF and XML with XSPARQL. J. Data Semant. 1(3), 147–185 (2012). Scholar
  18. 18.
    Dorodnykh, N.O.: Web-based software for automating development of knowledge bases on the basis of transformation of conceptual models. Open Semant. Technol. Intell. Syst. 1, 145–150 (2017)Google Scholar
  19. 19.
    Dorodnykh, N.O., Yurin, A.Yu.: A domain-specific language for transformation models. In: CEUR Workshop Proceedings. Information Technologies: Algorithms, Models, Systems (ITAMS 2018), vol. 2221, pp. 70–75 (2018)Google Scholar
  20. 20.
    Mauro, N., Esposito, F., Ferilli, S.: Finding critical cells in web tables with SRL: trying to uncover the devil’s tease. In: Proceedings of the 12th International Conference on Document Analysis and Recognition, pp. 882–886 (2013).
  21. 21.
    Adelfio, M., Samet, H.: Schema extraction for tabular data on the web. Proc. VLDB Endow. 6(6), 421–432 (2013). Scholar
  22. 22.
    Chen, Z., Cafarella, M.: Integrating spreadsheet data via accurate and low-effort extraction. In: Proceedings of the 20th ACM SIGKDD International Conference Knowledge Discovery and Data Mining, pp. 1126–1135 (2014).
  23. 23.
    Embley, D.W., Krishnamoorthy, M.S., Nagy, G., Seth, S.: Converting heterogeneous statistical tables on the web to searchable databases. Int. J. Doc. Anal. Recogn. 19(2), 119–138 (2016). Scholar
  24. 24.
    Kandel, S., Paepcke, A., Hellerstein, J., Heer, J.: Wrangler: interactive visual specification of data transformation scripts. In: Proceedings of the SIGCHI Conference Human Factors in Computing Systems, pp. 3363–3372 (2011).
  25. 25.
    Hung, V., Benatallah, B., Saint-Paul, R.: Spreadsheet-based complex data transformation. In: Proceedings of the 20th ACM International Conference on Information and Knowledge Management, pp. 1749–1754 (2011).
  26. 26.
    Harris, W., Gulwani, S.: Spreadsheet table transformations from examples. ACM SIGPLAN Not. 46(6), 317–328 (2011). Scholar
  27. 27.
    O’Connor, M.J., Halaschek-Wiener, C., Musen, M.A.: Mapping master: a flexible approach for mapping spreadsheets to OWL. In: The Semantic Web – ISWC 2010. LNCS, pp. 194–208 (2010). Scholar
  28. 28.
    Mulwad, V., Finin, T., Joshi, A.: A domain independent framework for extracting linked semantic data from tables. In: Search Computing, pp. 16–33 (2012). Scholar
  29. 29.
    Da Silva, A.R.: Model-driven engineering: a survey supported by the unified conceptual model. Comput. Lang. Syst. Struct. 43, 139–155 (2015). Scholar
  30. 30.
    Berman, A.F., Nikolaichuk, O.A., Yurin, A.Y., Kuznetsov, K.A.: Support of decision-making based on a production approach in the performance of an industrial safety review. Chem. Pet. Eng. 50(1–2), 730–738 (2015). Scholar
  31. 31.
    Yurin, A.H., Dorodnykh, N.O., Nikolaychuk, O.A., Berman, A.F., Pavlov, A.I.: ISI models, mendeley data, v1 (2019).
  32. 32.
  33. 33.
    Dorodnykh, N.O., Yurin, A.Yu., Stolbov A.B.: Ontology driven development of rule-based expert systems. In: The 3rd Russian-Pacific Conference on Computer Technology and Applications (RPC 2018), pp. 1–6 (2018).
  34. 34.
    Grishenko, M.A., Dorodnykh, N.O., Nikolaychuk, O.A., Yurin, A.Yu.: Designing rule-based expert systems with the aid of the model-driven development approach. Expert Syst. 35(5), 1–23 (2018). Scholar

Copyright information

© Springer Nature Switzerland AG 2019

Authors and Affiliations

  1. 1.Matrosov Institute for System Dynamics and Control TheorySiberian Branch of the Russian Academy of SciencesIrkutskRussia
  2. 2.Irkutsk National Research Technical UniversityIrkutskRussia

Personalised recommendations