Email this article 
Open Access
Subscription or Fee Access
Mapping of Relational Databases to Ontology A Survey
Abstract
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.
Keywords
References
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
Refbacks
- There are currently no refbacks.
This work is licensed under a Creative Commons Attribution 3.0 License.