Open Access Open Access  Restricted Access Subscription or Fee Access

Mapping of Relational Databases to Ontology A Survey

C. Ramathilagam, Dr.M.L. Valarmathi


Ontologies, the explicit and formal specification of a conceptualization, increase rapidly with the growth of the Semantic Web. However, most of data on the Web are still stored in Relational Databases (RDB). It is important to develop ways for representation of this information or to establish interoperability between RDBs and Ontologies in the Semantic Web to allow intelligent information retrieval. An effective way to achieve interoperability is finding mappings between RDB schemas and Ontologies. This paper surveys various techniques, tools and applications for mapping between RDBs and the Ontology based on certain classifications. The classifications mentioned denotes the purpose of the mapping process or the necessity to relate RDB with Ontology. This paper also reviews the discussed works with two parameters which helps to identify the purpose of the work. Apart from these classifications and given parameters there are several other parameters that can be considered in the mapping approaches.


Ontology, Owl, RDF, Schema, Semantics, Mapping, Semantic Web

Full Text:



Satya S.Sahoo et al., “A Survey of Current Approaches for Mapping of Relational Databases to RDF”, W3C RDB2RDF Incubator Group

Raji Ghawi and Nadine Cullot,“Database-to-Ontology mapping generation for Semantic Interoperability”, VLDB’07, ACM 978-1-59593-649-3/07/09

Zhuoming Xu, Shichao Zhang and Yisheng Dong, ”Mapping between Relational Database Schema and OWL Ontology for Deep Annotation”, International Conference on Web Intelligence, IEEE Computer Society Washington, USA 2006, ACM Digital Library

Wei Hu and Yuzhong Qu, “Discovering simple mappings between Relational Database Schemas and Ontologies work”, K. Aberer et al. (Eds.): ISWC/ASWC 2007, LNCS 4825, pp. 225–238, 2007 ©_Springer-Verlag Berlin Heidelberg 2007

Dmitry V.Levshin, “Mapping Relational Databases to the Semantic Web with Original Meaning”, International Journal of Software and Informatics, Vol4, No.1 March 2010, pp 23-37 ISSN 1673-7288

Ernestas Vysniauskas, Lina Nemuraite and Algirdas Sukys, “A hybrid approach for relating OWL2 Ontologies and Relational Databases”, LNBIP 64, pp 86-101 2010, ©_Springer-Verlag Berlin Heidelberg 2010

Irina Astrova,,”Rules for mapping SQL relational databases to OWL Ontologies, Metadata and Semantics”, Publisher: Springer, Pages: 415-424, ISBN: 9780387777443

Nadine Cullot, Raji Ghawi, and Kokou Yétongnon, “DB2OWL: A Tool for Automatic Database-to-Ontology Mapping,” CiteSeerX 2007

J.Barrasa, O, Corcho and Gomez-Perez, “R2O : An Extensible and Semantically Based Database-to-Ontology Mapping Language”, Second Workshop on Semantic Web and Databases (SWDB 2004) Springer-Verlag ISBN:978-3-540-24576-6Volume:3372

Quang Trinh, Ken Barker, Reda Alhaj, “RDB2ONT: A Tool for Generating OWL Ontologies From Relational Database Systems”, Proceeding AICT-ICIW '06, IEEE Computer Society Washington, DC, USA ©2006 ACM Digital Library

Tim Kraska_ Uwe R¨ohm. “Genea: Schema-Aware Mapping of Ontologies into Relational Databases”, Intl Conf. on Management of Data, 2006 - COMAD 2006, Delhi, India, December 14–16, 2006, © Computer Society of India, 2006 CiteSeerX

Saurabh Kejriwal N. S. Narayanaswamy, “TRANS: Schema-Aware Mapping of OWL Ontologies into Relational Databases”, 15th International Conference on Management of Data COMAD 2009, December 9–12, 2009 © Computer Society of India, 2009

Green, J., Dolbear, C., Hart, G., Engelbrecht, P., Goodwin, J , “Creating a Semantic Integration System using Spatial Data”, International Semantic Web Conference 2008

Miriam Baglioni, Maria Vittoria Masserotti, Chiara Renso and Laura Spinsanti, “Building Geospatial Ontologies from Geographical Databases” LNCS 4853, pp 195-209 Srpinger-Verlag Berlin Heidelberg 2007

Tian Zhao, Chuanrong Zhang, Mingzhen Wei and Zhong-Ren Peng ,“Ontology-Based Geospatial Data Query and Integration”, GIScience 2008, LNCS 5266, pp 370-392, Srpinger-Verlag Berlin Heidelberg 2008

Damires Souza, Ana Carolina Salgado and Patricia Tedesco, “Towards a Context Ontology for Geospatial Data Integration”, OTM Workshop 2006, LNCS 4278, pp 1576-1585, Srpinger-Verlag Berlin Heidelberg 2006

Ernestas Vysniauskas, Lina Nemuraite, “Transforming Ontology Representation From Owl To Relational Database“,Lithuanian State Science and Studies Foundation according to Eureka programme project, ISSN 1392 – 124X Information Technology And Control, 2006, Vol.35, No.3A

Ernestas Vyšniauskas, Lina Nemurait_, Rimantas Butleris, Bronius Paradauskas, “Reversible Lossless Transformation From Owl 2 Ontologies Into Relational Databases”, ISSN 1392 – 124X Information Technology And Control, Vol. 40, No.4, 2011

Yi Hong, Monika Solanki, Lin Foxhall, Alessandro Quercia, “A Framework for Transforming Archaeological Databases to Linked Ontological Datasets “,Proceedings of the 38th Conference on Computer

Applications and Quantitative Methods in Archaeology 1 Granada, Spain, April 2010

Irina Astrova1, Nahum Korda2, and Ahto Kalja1,”Rule-Based Transformation of SQL Relational Databases to OWL Ontologies”, In Proceedings of the 2nd International Conference on Metadata & Semantics Research, CiteseerX 2007

Konstantinos N. Vavliakis1;2, Theofanis K. Grollios1, and Pericles A. Mitkas,” RDOTE - Transforming Relational Databases into Semantic Web Data”, © 2010 The 9th International Semantic Web Conference (ISWC2010)

Heru Agus Santoso, Su-Cheng Haw, Ziyad. T. Abdul-Mehdi. ”Ontology extraction from relational database: Concept hierarchy as background knowledge”, ACM DIGITAL LIBRARY, Journal Knowledge based systems, volume 24, issue 3, April 2011

Liu Yuzhao , Du Dongxia , “ RDB-Based Approach to Domain Ontology for Contingency Plan” , Third International Conference Knowledge Discovery and Data Mining, 2010. WKDD '10.2010

L. Lubyte, S. Tessaris, “Extracting Ontologies from Relational Databases“, KRDB Research Centre Technical Report:, Italy, KRDB07-04, 2007

Ben Abacha and Zweigenbaum, “Automatic extraction of semantic relations between medical entities: a rule based approach”, Journal of Biomedical Semantics 2011

Man Li, Xiao-Yong Du, Shan Wang,” Learning Ontology From Relational Database”, Proceedings of the Fourth International Conference on Machine Learning and Cybernetics, Guangzhou, 18-21 August 2005 IEEE

Gil, R. -Bautista, M.J. ; Contreras, L. ,”Applying an Ontology Learning Methodology to a Relational Database: University Case Study “,Semantic Computing (ICSC), 2010 IEEE Fourth International Conference on 2010

Farid Cerbah, “Learning Highly Structured Semantic Repositories from Relational Databases: The RDBToOnto Tool”, Springer , The Semantic Web: Research and Applications Lecture Notes in Computer Science, 2008, Volume 5021/2008, 777-781

Maedche,A.Staab,S.,”Ontology learning for the Semantic Web”, Intelligent Systems, IEEE, 2001, Volume: 16 , Issue: 2

R.J. Gil , M.J. Martin-Bautista.” A novel integrated knowledge support system based on ontology learning: Model specification and a case study”, Dept. of Computer Science and Artificial Intelligence, University of Granada, Granada, Spain, 2012

Dervin, C,Haemmerle O.Thomopoulos R, Buche P ,”Fuzzy querying of incomplete, imprecise, and heterogeneously structured data in the relational model using ontologies and rules “, Fuzzy Systems, IEEE Transactions on June 2005,

Ayesha Banu1 , Syeda Sameen Fatima2 and Khaleel Ur Rahman Khan,” Semantic – Based Querying Using Ontology in Relational Database of Library Management System “, International Journal of Web & Semantic Technology (IJWesT) Vol.2, No.4, October 2011, DOI : 10.5121/ijwest.2011.2402 21

E. Vysniauskas, L. Nemuraite, B. Paradauskas,” Hybrid Method for Storing and Querying Ontologies in Databases”. Electronics And Electrical Engineering journal Issn 1392 – 1215 2011. No. 9(115) Automation, Robotics

Dejing Dou, Paea LePendu,” Ontology based Integration for Relational Databases, Computer and Information Science, SAC’06 April 2327, 2006, Dijon, France, Copyright 2006 ACM 1595931082/

Soren Auer_ Zachary G. Ives,”Integrating Ontologies and Relational Data”, ”, Department of Computer & Information Science Technical Reports (CIS), University of Pennsylvania Year 2007, Copyright 200X ACM

Juan F. Sequeda, Syed H. Tirmizi,”A Bootstrapping Architecture for Integration of Relational Databases to the Semantic Web”, Proceedings of the Seventh International Semantic Web Conference, 2008

Dr. Marwan Sabbouh, Dr. Joseph K. DeRosa,”Using Semantic Web Technologies to Integrate Software Components”, Proceedings of the ISWC 2004 Workshop on Semantic Web Services. Ceur-Ws/Vol-119, CiteseerX 2004

Maruf Pasha, Abdul Sattar,” Building Domain Ontologies From Relational Database Using Mapping Rules”, International Journal of Intelligent Engineering & Systems, Vol.5, No.1, 2012

Lina Lubyte and Sergio Tessaris,”Automatic Extraction of Ontologies Wrapping Relational Data Sources”, KRDB Research Centre for Knowledge and Data – Free University of Bozen-Bolzano, International Conference on Database and Expert Systems Applications

Jia Chen , Chengdu, Yue Wu ; Ming Li ; Shuquan Li ; Jing You “Rules Driven Object-Relational Databases Ontology Learning”, Interoperability for Enterprise Software and Applications IESA '09. International Conference on Date of Conference: 21-22, 2009

Hyun Jung Lee, Mye Sohn, “DB schema based ontology construction for efficient RDB query”, Proceedings of the 4th Asian conference on Intelligent Information and Database Systems Volume part II, Springer-Verlag Berlin, Heidelberg ©2012

Stéphane Jean, Yamine Aït-Ameur, Guy Pierra,”Querying Ontology Based Database Using OntoQL (An Ontology Query Language)”, Lecture Notes in Computer Science Volume 4275, 2006, pp 704-721 , Springer-Verlag Berlin, Heidelberg ©2006

Anastasios Kementsietsidis, Lipyeow Lim, Min Wang ,”Supporting Ontology-based Keyword Search over Medical Databases” , AMIA 2008 Symposium Proceedings, USA.

Vijayan Sugumaran , Veda C. Storey ,”The Role of Domain Ontologies in Database Design: An Ontology Management and Conceptual Modeling Environment”, ACM Transactions on Database Systems, Vol. V. No. N, 2006

Huajun Chen et al., “From Legacy Relational Databases to the Semantic Web: an In-Use Application for Traditional Chinese Medicine”, Fifth International Semantic Web Conference, CiteseerX 2006


  • There are currently no refbacks.

Creative Commons License
This work is licensed under a Creative Commons Attribution 3.0 License.