Proposal for a Mutual Conversion Relational Database-Ontology Approach

Full Text (PDF, 1504KB), PP.13-28

Views: 0 Downloads: 0


Leila Zemmouchi-Ghomari 1,* Abdelaali Djouambi 2 Cherifa Chabane 2

1. Ecole Nationale Supérieure de Technologie, ENST, Algiers, Algeria

2. Université des Sciences et des Technologies Houari Boumediene, USTHB, Algiers, Algeria

* Corresponding author.


Received: 11 May 2018 / Revised: 26 May 2018 / Accepted: 4 Jun. 2018 / Published: 8 Jul. 2018

Index Terms

Relational database, ontology, conversion approach, conversion tool


Whereas ontologies are formal knowledge representations, conveying a shared understanding of a given domain, databases are a mature technology that describes specifications for the storage, retrieval, organization, and processing of data in information systems to ensure data integrity. Ontologies offer the functionality of conceptual modeling while complying with the web constraints regarding publication, querying and annotation, as well as the capacity of formality and reasoning to enable data consistency and checking. Ontologies converted to databases could exploit the maturity of database technologies, and databases converted to ontologies could utilize ontology technologies to be more used in the context of the semantic web. This work aims to propose a generic approach that enables converting a relational database into an ontology and vice versa. A tool based on this approach has been implemented as a proof of a concept.

Cite This Paper

Leila Zemmouchi-Ghomari, Abdelaali Djouambi, Cherifa Chabane, " Proposal for a Mutual Conversion Relational Database-Ontology Approach", International Journal of Modern Education and Computer Science(IJMECS), Vol.10, No.7, pp. 13-28, 2018. DOI:10.5815/ijmecs.2018.07.02


[1]L. Zemmouchi-Ghomari, “Cohabitation of Relational Databases and Domain Ontologies in the Semantic Web Context”, Journal of Systems Integration, Vol.9, No.1, pp. 42-57, 2018.
[2]C. Coronel and S. Morris, Database Systems: Design, Implementation, and Management, 1978.
[3]M. Dadjoo and E. Kheirkhah, “An approach for transforming of relational databases to OWL ontology”. arXiv preprint arXiv:1502.05844, 2015.
[4]T. R Gruber, “A translation approach to portable ontology specifications”, Knowledge acquisition, Vol.5, No.2, pp.199-220, 1993.
[5]C. Bizer, “D2R MAP - a database to RDF mapping language”, in Proceedings of the 12th International World Wide Web Conference, Budapest, Hungary, 2003.
[6]N. Konstantinou, D. Spanos, M. Chalas, E. Solidakis and N. Mitrou, “VisAVis: An Approach to an Intermediate Layer between Ontologies and Relational Database Contents”, in Proceedings of Workshops and Doctoral Consortium, the 18th International Conference on Advanced Information Systems Engineering - Trusted Information Systems, Luxembourg, Luxembourg, 2006.
[7]C. P. De Laborda and S. Conrad, “Relational.OWL: a data and schema representation format based on OWL”, in Proceedings of the 2nd Asia-Pacific conference on Conceptual modelling. Newcastle, Australia, 2005.
[8]M. R. C. Louhdi, H. Behja and S. O. El Alaoui, “Transformation rules for building owl ontologies from relational databases”, in Second International Conference on Advanced Information Technologies and Applications, pp. 271-283, 2013.
[9]S. M. Benslimane, M. Malki and D. Bouchiha, “Deriving Conceptual Schema from Domain Ontology: A Web Application Reverse Engineering Approach”, International Arab Journal of Information Technology, Vol.7, No.2, pp.167-176, 2010.
[10]H. El-Ghalayini, M. Odeh, R. McClatchey and T. Solomonides, “Reverse Engineering Domain Ontology to Conceptual Data Models”, in Proceedings of the 23rd IASTED International Conference on Databases and Applications (DBA), Innsbruck, Austria, pp. 222-227, 2005.
[11]A. Humaira, N. Tabbasum, S. Ayesha, “A Survey on Automatic Mapping of Ontology to Relational Database Schema”, Research Journal of Recent Sciences, Vol.4, pp.66-70, 2015.
[12]A. Gali, C. X. Chen, K. T. Claypool and R. Uceda-Sosa, “From ontology to relational databases”, in International Conference on Conceptual Modeling. Springer, Berlin, Heidelberg, pp.278-289, 2004.
[13]B. Motik and R. Studer, “KAON2–a scalable reasoning tool for the Semantic Web”, in Proceedings of the 2nd European Semantic Web Conference, ESWC’05, Heraklion, Greece, 2005.
[14]O. Curé and R. Squelbut, “Integrating data into an OWL Knowledge Base via the DBOM Protégé plug-in”, in Proceedings of the 9th International Protégé conference, Stanford, California, US, 2006.
[15]E. Vyšniauskas and L. Nemuraite, “Transforming Ontology Representation from OWL to Relational Database”, Information Technology and Control, Vol.35, No.3, pp. 333-343, 2006.
[16]C. Nyulas, M. O’Connor and S. Tu, “DataMaster a Plug-in for Importing Schemas and Data from Relational Databases into Protégé”, in Proceedings of 10th International Protégé Conference, Budapest, Hungary, 2007.
[17]N. Cullot, R. Ghawi and K. Yétongnon, “DB2OWL: A Tool for Automatic Database-to-Ontology Mapping”, in proceedings of the 15th Italian Symposium on Advanced Database Systems, Ginosa, Italy, 2007.
[18]J. Trinkunas and O. Vasilecas, “Building ontologies from relational databases using reverse engineering methods”, in Proceedings of the international conference on Computer systems and technologies, Rousse, Bulgaria, 2007.
[19]M. Laclavık, “RDB2Onto: Relational database data to ontology individuals mapping”, in: Tools for Acquisition, Organisation and Presenting of Information and Knowledge, pp.86–89, 2006.
[20]A. Poggi, M. Rodriguez and M. Ruzzi, “Ontology-based database access with DIG-Mastro and the OBDA Plugin for Protégé, in proceedings of the 4th Int. Workshop on OWL: Experiences and Directions (OWLED 2008 DC), Vol.496, Karlsruhe, Germany, 2008.
[21]F. Cerbah, “Learning highly structured semantic repositories from relational databases”, in European Semantic Web Conference, pp. 777-781, San Jose, California, USA, 2008.
[22]S. H. Tirmizi, J. Sequeda and D. Miranker, “Translating SQL applications to the semantic web”, in International Conference on Database and Expert Systems Applications, pp. 450-464, Turin, Italy, 2008.
[23]D. De Brum Saccol, T. de Campos Andrade and E. K. Piveta, “Mapping owl ontologies to relational schemas”, in Information Reuse and Integration (IRI), Las Vegas, NV, USA, 2011.
[24]E. Vyšniauskas, L. Nemuraitė, R. Butleris and B. Paradauskas, “Reversible lossless transformation from OWL 2 ontologies into relational databases”, Information Technology and Control, Vol. 40, No.4, pp. 293-306, 2011.
[25]H. Afzal, M. Waqasa and T. Naz, “OWLMap: Fully Automatic Mapping of Ontology into Relational Database Schema”, International journal of advanced computer science and applications, Vol.7, No.11, pp. 7-15, 2016.
[26]V. Jain and M. Singh,"Ontology Development and Query Retrieval using Protégé Tool", International Journal of Intelligent Systems and Applications(IJISA), Vol.5, No.9, pp .67-75, 2013.
[27]H. Abbes and F. Gargouri, "MongoDB-Based Modular Ontology Building for Big Data Integration", Journal on Data Semantics, Vol.7, No.1, pp1-27, 2018.
[28]S. Zhao, Q. Qian, "Ontology based heterogeneous materials database integration and semantic query", AIP Advances, Vol.7,No.10, 105325, 2017.
[29]L. Zemmouchi-Ghomari, A. R. Ghomari, L. Adjir and L. Belaala, “Integrating an ontology into a software system”, Journal of Systems Integration, Vol.8, No.3, pp.27-39, 2017.
[30]N. S. Ougouti, H. Belbachir and Y. Amghar, “A new owl2 based approach for relational database description”, International Journal of Information Technology and Computer Science, Vol.7, No.1, pp. pp.48-53, 2015.
[31]G. Yang and J. Feng, “Database Semantic Interoperability based on Information Flow Theory and Formal Concept Analysis”, International journal of information technology and computer science, Vol.7, pp.33-42, 2012.
[32]K. Zarour and N. Zarour, "Data Center Strategy to Increase Medical Information Sharing in Hospital Information Systems", International Journal of Information Engineering and Electronic Business, Vol. 1, pp. 33-39, 2013.
[33]E. Ong, Z. Xiang, Z., Zheng, J. Smith and Y. He, "Ontobull and BFOConvert: Web-based Programs to Support Automatic Ontology Conversion", In International Conference on Biological Ontology and BioCreative, Corvallis, OR, USA, 2016.
[34]M. Mohamed Hamri and S. M. Benslimane, "Building an Ontology for the Metamodel ISO/IEC24744 using MDA Process", International Journal of Modern Education and Computer Science, Vol.7, No.8, pp.48-60, 2015.