Abstract
In this paper, we propose a generalized approach for mapping a relational database into ontology. This proposed approach is composed of two main phases. The first one consists of generating the ontology from the relational database, based on a direct mapping process by using R2RML language. The second one is devoted to evaluating the correctness of the generated ontology, with regards to two validation criteria, Information preservation, and Query preservation. In addition, we evaluate the computational performance of the proposed mapping process in terms of storage space and execution time.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Similar content being viewed by others
References
De Giacomo, G., Lembo, D., Lenzerini, M., Poggi, A., Rosati, R.: Using ontologies for semantic data integration. In: A Comprehensive Guide Through the Italian Database Research Over the Last 25 Years, pp. 187–202. Springer (2018)
Spanos, D.-E., Stavrou, P., Mitrou, N.: Bringing relational databases into the semantic web: a survey. Semant. Web 3, 169–209 (2012)
Touma, R., Romero, O., Jovanovic, P.: Supporting data integration tasks with semi-automatic ontology construction. In: Proceedings of the ACM Eighteenth International Workshop on Data Warehousing and OLAP, pp. 89–98. ACM (2015)
Myroshnichenko, I., Murphy, M.C.: Mapping ER schemas to OWL ontologies. In: 2009 IEEE International Conference on Semantic Computing, ICSC 2009, pp. 324–329. IEEE (2009)
Arenas, M., Bertails, A., Prud’hommeaux, E., Sequeda, J.: A direct mapping of relational data to RDF. W3C Recomm. 27 (2012)
de Medeiros, L.F., Priyatna, F., Corcho, O.: MIRROR: automatic R2RML mapping generation from relational databases. In: International Conference on Web Engineering, pp. 326–343. Springer (2015)
Suchanek, F.M., Kasneci, G., Weikum, G.: Yago: a large ontology from wikipedia and wordnet. Web Semant.: Sci. Serv. Agents World Wide Web 6, 203–217 (2008)
Bountouri, L., Gergatsoulis, M.: The semantic mapping of archival metadata to the CIDOC CRM ontology. J. Arch. Organ. 9, 174–207 (2011)
Swartz, A.: Musicbrainz: a semantic web service. IEEE Intell. Syst. 17, 76–77 (2002)
Dadjoo, M., Kheirkhah, E.: An approach for transforming of relational databases to OWL ontology. arXiv preprint arXiv:1502.05844 (2015)
Sedighi, S.M., Javidan, R.: A novel method for improving the efficiency of automatic construction of ontology from a relational database. Int. J. Phys. Sci. 7, 2085–2092 (2012)
Cullot, N., Ghawi, R., Yétongnon, K.: DB2OWL: a tool for automatic database-to-ontology mapping. In: SEBD, pp. 491–494 (2007)
Sane, S.S., Shirke, A.: Generating OWL ontologies from a relational databases for the semantic web. In: Proceedings of the International Conference on Advances in Computing, Communication and Control, pp. 157–162. ACM (2009)
Buccella, A., Penabad, M.R., Rodriguez, F.J., Farina, A., Cechich, A.: From relational databases to OWL ontologies. In: Proceedings of the 6th National Russian Research Conference (2004)
Zhang, H., Diao, X., Yuan, Z., Chun, J., Huang, Y.: EVis: a system for extracting and visualizing ontologies from databases with web interfaces. In: 2012 International Symposium on Information Science and Engineering (ISISE), pp. 408–411. IEEE (2012)
Tirmizi, S.H., Sequeda, J., Miranker, D.: Translating SQL applications to the semantic web. In: International Conference on Database and Expert Systems Applications, pp. 450–464. Springer (2008)
Kyzirakos, K., Vlachopoulos, I., Savva, D., Manegold, S., Koubarakis, M.: GeoTriples: a tool for publishing geospatial data as RDF graphs using R2RML mappings. In: TC/SSN@ ISWC, pp. 33–44 (2014)
Vidal, V.M.P., Casanova, M.A., Neto, L.E.T., Monteiro, J.M.: A semi-automatic approach for generating customized R2RML mappings. In: Proceedings of the 29th Annual ACM Symposium on Applied Computing, pp. 316–322. ACM (2014)
Hazber, M.A., Li, R., Xu, G., Alalayah, K.M.: An approach for automatically generating R2RML-based direct mapping from relational databases. In: International Conference of Young Computer Scientists, Engineers and Educators, pp. 151–169. Springer (2016)
Hert, M., Reif, G., Gall, H.C.: A comparison of RDB-to-RDF mapping languages. In: Proceedings of the 7th International Conference on Semantic Systems, pp. 25–32. ACM (2011)
Tarasowa, D., Lange, C., Auer, S.: Measuring the quality of relational-to-RDF mappings. In: International Conference on Knowledge Engineering and the Semantic Web, pp. 210–224. Springer (2015)
Sequeda, J.F., Arenas, M., Miranker, D.P.: On directly mapping relational databases to RDF and OWL. In: Proceedings of the 21st International Conference on World Wide Web, pp. 649–658. ACM (2012)
Richard Cyganiak, D.: R2RML: RDB to RDF mapping language (2012)
Priyatna, F., Corcho, O., Sequeda, J.: Formalisation and experiences of R2RML-based SPARQL to SQL query translation using morph. In: Proceedings of the 23rd International Conference on World wide web, pp. 479–490. ACM (2014)
Konstantinou, N., Kouis, D., Mitrou, N.: Incremental export of relational database contents into RDF graphs. In: Proceedings of the 4th International Conference on Web Intelligence, Mining and Semantics (WIMS14), p. 33. ACM (2014)
Rodriguez-Muro, M., Kontchakov, R., Zakharyaschev, M.: Ontology-based data access: ontop of databases. In: International Semantic Web Conference, pp. 558–573. Springer (2013)
Sequeda, J.F.: Integrating Relational Databases with the Semantic Web. IOS Press (2016)
Harris, S., Gibbins, N.: 3store: efficient bulk RDF storage (2003)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2019 Springer Nature Switzerland AG
About this paper
Cite this paper
Benmahria, B., Chaker, I., Zahi, A. (2019). Validation and Evaluation of the Mapping Process for Generating Ontologies from Relational Databases. In: Rocha, Á., Adeli, H., Reis, L., Costanzo, S. (eds) New Knowledge in Information Systems and Technologies. WorldCIST'19 2019. Advances in Intelligent Systems and Computing, vol 930. Springer, Cham. https://doi.org/10.1007/978-3-030-16181-1_32
Download citation
DOI: https://doi.org/10.1007/978-3-030-16181-1_32
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-030-16180-4
Online ISBN: 978-3-030-16181-1
eBook Packages: Intelligent Technologies and RoboticsIntelligent Technologies and Robotics (R0)