Bringing relational databases into the Semantic Web: A survey

Relational databases are considered one of the most popular storage solutions for various kinds of data and they have been recognized as a key factor in generating huge amounts of data for Semantic Web applications. Ontologies, on the other hand, are one of the key concepts and main vehicle of knowledge in the Semantic Web research area. The problem of bridging the gap between relational databases and ontologies has attracted the interest of the Semantic Web community, even from the early years of its existence and is commonly referred to as the database-to-ontology mapping problem. However, this term has been used interchangeably for referring to two distinct problems: namely, the creation of an ontology from an existing database instance and the discovery of mappings between an existing database instance and an existing ontology. In this paper, we clearly define these two problems and present the motivation, benefits, challenges and solutions for each one of them. We attempt to gather the most notable approaches proposed so far in the literature, present them concisely in tabular format and group them under a classification scheme. We finally explore the perspectives and future research steps for a seamless and meaningful integration of databases into the Semantic Web.

[1]  Satya S. Sahoo,et al.  A Survey of Current Approaches for Mapping of Relational Databases to RDF , 2009 .

[2]  Asunción Gómez-Pérez,et al.  R2O, an extensible and semantically based database-to-ontology mapping language , 2004 .

[3]  Tom Heath,et al.  Linked Data: Evolving the Web into a Global Data Space , 2011, Linked Data.

[4]  Marco A. Casanova,et al.  Interoperability by design using the StdTrip tool: an a priori approach , 2010, I-SEMANTICS '10.

[5]  Steffen Staab,et al.  Unveiling the hidden bride: deep annotation for mapping and migrating legacy data to the Semantic Web , 2004, J. Web Semant..

[6]  Jens Lehmann,et al.  LOD 2 Deliverable D 3 . 1 . 1 : Report on Knowledge Extraction from Structured Sources , 2013 .

[7]  Nadine Cullot,et al.  Database-to-Ontology Mapping Generation for Semantic Interoperability , 2007 .

[8]  Stefan Conrad,et al.  Database to Semantic Web Mapping Using RDF Query Languages , 2006, ER.

[9]  Eero Hyvönen,et al.  from relational databases to ontologies , .

[10]  Diego Calvanese,et al.  Unifying Class-Based Representation Formalisms , 2011, J. Artif. Intell. Res..

[11]  Diego Calvanese,et al.  The description logic handbook: theory , 2003 .

[12]  Diego Calvanese,et al.  Linking Data to Ontologies , 2008, J. Data Semant..

[13]  M. Laclavik.  RDB 2 Onto : Relational Database Data to Ontology Individuals Mapping , 2006 .

[14]  Reda Alhajj.  Extracting the extended entity-relationship model from a legacy relational database , 2003, Inf. Syst..

[15]  Gerald Reif,et al.  A comparison of RDB-to-RDF mapping languages , 2011, I-Semantics '11.

[16]  SWAD-Europe Deliverable 10.2: Mapping Semantic Web Data with RDBMSes , 2004 .

[17]  Nicola Guarino,et al.  Formal Ontology and Information Systems , 1998 .

[18]  Ryutaro Ichise,et al.  Automated Mapping Generation for Converting Databases into Linked Data , 2010, ISWC Posters&Demos.

[19]  Georg Lausen,et al.  Relational Databases in RDF: Keys and Foreign Keys , 2008, SWDB-ODBIS.

[20]  Jean-Yves Lafaye,et al.  MDE for Publishing Data on the Semantic Web , 2008, TWOMDE@MoDELS.

[21]  Iadh Ounis,et al.  Can RDB2RDF Tools Feasibily Expose Large Science Archives for Data Integration? , 2009, ESWC.

[22]  Georg Lausen,et al.  SP2Bench: A SPARQL Performance Benchmark , 2008, Semantic Web Information Management.

[23]  Hussein Zedan,et al.  Generating OWL Ontology for Database Integration , 2009, 2009 Third International Conference on Advances in Semantic Processing.

[24]  Athman Bouguettaya.  Ontologies and Databases , 1999, Springer US.

[25]  Souripriya Das,et al.  Database Technologies for RDF , 2009, Reasoning Web.

[26]  Ivan Jelínek,et al.  Benchmarking RDF Production Tools , 2007, DEXA.

[27]  Martin Gaedke,et al.  Discovering and Maintaining Links on the Web of Data , 2009, SEMWEB.

[28]  Deborah L. McGuinness,et al.  Semantic Scientific Knowledge Integration , 2008, AAAI Spring Symposium: Semantic Scientific Knowledge Integration.

[29]  N. Korda,et al.  Rule-Based Transformation of SQL Relational Databases to OWL Ontologies , 2007 .

[30]  Boris Motik,et al.  Bridging the gap between OWL and relational databases , 2007, WWW '07.

[31]  James A. Hendler.  Web 3.0: Chicken Farms on the Semantic Web , 2008, Computer.

[32]  Eric Prud'hommeaux,et al.  Interpreting relational databases in the RDF domain , 2011, K-CAP '11.

[33]  Marko Banek,et al.  Uncovering the Deep Web: Transferring Relational Database Content and Metadata to OWL Ontologies , 2008, KES.

[34]  Isabelle Comyn-Wattiau,et al.  Extracting generalization hierarchies from relational databases: A reverse engineering approach , 2007, Data Knowl. Eng..

[35]  Pierre-Antoine Champin,et al.  Cross: An OWL Wrapper for Reasoning on Relational Databases , 2007, ER.

[36]  Klaus R. Dittrich,et al.  On the Migration of Relational Schemas and Data to Object-OrientedDatabase Systems , 1997 .

[37]  Vipul Kashyap,et al.  Design and Creation of Ontologies for Environmental Information Retrieval1 , 1999 .

[38]  John Mylopoulos,et al.  Discovering the Semantics of Relational Tables Through Mappings , 2006, J. Data Semant..

[39]  Nikolas Mitrou,et al.  Technically approaching the semantic web bottleneck , 2010, Int. J. Web Eng. Technol..

[40]  Martine Collard,et al.  Semantic Web, Ontologies and Databases, VLDB Workshop, SWDB-ODBIS 2007, Vienna, Austria, September 24, 2007, Revised Selected Papers , 2008, SWDB-ODBIS.

[41]  Z. Meral Özsoyoglu,et al.  A complete translation from SPARQL into efficient SQL , 2009, IDEAS '09.

[42]  Nikolas Mitrou,et al.  Ontology and Database Mapping: A Survey of Current Implementations and Future Directions , 2008, J. Web Eng..

[43]  Georg Lausen,et al.  SPARQLing constraints for RDF , 2008, EDBT '08.

[44]  Diego Calvanese,et al.  The Description Logic Handbook: Theory, Implementation, and Applications , 2003, Description Logic Handbook.

[45]  Carlo Curino,et al.  Accessing and Documenting Relational Databases through OWL Ontologies , 2009, FQAS.

[46]  Dmitry V. Levshin.  Mapping Relational Databases to the Semantic Web with Original Meaning , 2009, Int. J. Softw. Informatics.

[47]  Xiaoyong Du,et al.  A Semi-automatic Ontology Acquisition Method for the Semantic Web , 2005, WAIM.

[48]  Siegfried Handschuh,et al.  Reasoning Web. Semantic Technologies for Information Systems, 5th International Summer School 2009, Brixen-Bressanone, Italy, August 30 - September 4, 2009, Tutorial Lectures , 2009, Reasoning Web.

[49]  Boris Motik,et al.  On the Properties of Metamodeling in OWL , 2005, J. Log. Comput..

[50]  Jan L. Top,et al.  From Relational Data to RDFS Models , 2004, ICWE.

[51]  Brigitte Mathiak,et al.  Handling Changes of Database Schemas and Corresponding Ontologies , 2006, ER.

[52]  Bhavani M. Thuraisingham,et al.  Update-Enabled Triplification of Relational Data into Virtual RDF Stores , 2010, Int. J. Semantic Comput..

[53]  Steffen Staab,et al.  Ontology Learning for the Semantic Web , 2002, IEEE Intell. Syst..

[54]  Maurizio Lenzerini,et al.  Data integration: a theoretical perspective , 2002, PODS.

[55]  Irina Astrova,et al.  Reverse Engineering of Relational Databases to Ontologies , 2004, ESWS.

[56]  G. G. Stokes.  "J." , 1890, The New Yale Book of Quotations.

[57]  Asunción Gómez-Pérez,et al.  Upgrading relational legacy data to the semantic web , 2006, WWW '06.

[58]  Timothy W. Finin,et al.  Using Linked Data to Interpret Tables , 2010, COLD.

[59]  Mike Dean,et al.  Use of OWL and SWRL for Semantic Relational Database Translation , 2008, OWLED.

[60]  Diego Calvanese,et al.  The Description Logic Handbook , 2007 .

[61]  Georg Lausen,et al.  SP^2Bench: A SPARQL Performance Benchmark , 2008, 2009 IEEE 25th International Conference on Data Engineering.

[62]  Sergio Tessaris,et al.  Automatic Extraction of Ontologies Wrapping Relational Data Sources , 2009, DEXA.

[63]  José Francisco Aldana Montes,et al.  A Survey on Disk Oriented Querying and Reasoning on the Semantic Web , 2006, 22nd International Conference on Data Engineering Workshops (ICDEW'06).

[64]  Shichao Zhang,et al.  Mapping between Relational Database Schema and OWL Ontology for Deep Annotation , 2006, 2006 IEEE/WIC/ACM International Conference on Web Intelligence (WI 2006 Main Conference Proceedings)(WI'06).

[65]  Claudio Gutiérrez,et al.  The Expressive Power of SPARQL , 2008, SEMWEB.

[66]  Paolo Atzeni,et al.  Ontologies And Databases: Going Back And Forth , 2008, ODBIS.

[67]  Jiao Tao,et al.  Towards Integrity Constraints in OWL , 2009, OWLED.

[68]  Stefan Conrad,et al.  Relational.OWL - A Data and Schema Representation Format Based on OWL , 2005, APCCM.

[69]  Gerald Reif,et al.  Updating relational data via SPARQL/update , 2010, EDBT '10.

[70]  Jens Lehmann,et al.  Triplify: light-weight linked data publication from relational databases , 2009, WWW '09.

[71]  José F. Aldana-Montes,et al.  A Survey on Disk Oriented Querying and Reasoning on the Semantic Web , 2006, ICDE 2006.

[72]  Günther Pernul,et al.  Database and expert systems applications: 18th international conference; proceedings / DEXA 2007, Regensburg, Germany, September 3-7, 2007 , 2007 .

[73]  Christian Bizer,et al.  The Berlin SPARQL Benchmark , 2009, Int. J. Semantic Web Inf. Syst..

[74]  Raphael Volz,et al.  Migrating data-intensive web sites into the Semantic Web , 2002, SAC '02.

[75]  Muhammad Fahad,et al.  ER2OWL: Generating OWL Ontology from ER Diagram , 2008, Intelligent Information Processing.

[76]  Johann-Christoph Freytag,et al.  Semantic query transformation using ontologies , 2005, 9th International Database Engineering & Application Symposium (IDEAS'05).

[77]  Reda Alhajj,et al.  RDB2ONT: A Tool for Generating OWL Ontologies From Relational Database Systems , 2006, Advanced Int'l Conference on Telecommunications and Int'l Conference on Internet and Web Applications and Services (AICT-ICIW'06).

[78]  Daniel P. Miranker,et al.  Ultrawrap : Using SQL Views for RDB 2 RDF , 2009 .

[79]  John Mylopoulos,et al.  A Semantic Approach to Discovering Schema Mapping Expressions , 2007, 2007 IEEE 23rd International Conference on Data Engineering.

[80]  Olivier Curé,et al.  A Database Trigger Strategy to Maintain Knowledge Bases Developed Via Data Migration , 2005, EPIA.

[81]  Yuzhong Qu,et al.  Discovering Simple Mappings Between Relational Database Schemas and Ontologies , 2007, ISWC/ASWC.

[82]  Raghu Ramakrishnan,et al.  Database Management Systems , 1976 .

[83]  James R. Cordy,et al.  Information Capacity Preserving Translations of Relational Schemas Using Structural Transformation , 1995 .

[84]  Daniel P. Miranker,et al.  Translating SQL Applications to the Semantic Web , 2008, DEXA.

[85]  Sharifullah Khan,et al.  R2O transformation system: relation to ontology transformation for scalable data integration , 2008, IDEAS '08.

[86]  Amit P. Sheth,et al.  Amicalola report: database and information systems research challenges and opportunities in semantic web and enterprises , 2002, SGMD.

[87]  Man Lung Yiu,et al.  Proceedings of the 22nd International Conference on Data Engineering, ICDE 2006 , 2006, ICDE 2006.

[88]  Nikolas Mitrou,et al.  VisAVis: An Approach to an Intermediate Layer between Ontologies and Relational Database Contents , 2006, WISM.

[89]  Catherine Dolbear,et al.  Ontological Bridge Building - Using Ontologies to Merge Spatial Datasets , 2008, AAAI Spring Symposium: Semantic Scientific Knowledge Integration.

[90]  Mariano Fernández-López,et al.  Ontological Engineering , 2003, Encyclopedia of Database Systems.

[91]  Pericles A. Mitkas,et al.  RDOTE - Transforming Relational Databases into Semantic Web Data , 2010, ISWC Posters&Demos.

[92]  Yannis Kalfoglou,et al.  Ontology mapping: the state of the art , 2003, The Knowledge Engineering Review.

[93]  N. Guarino,et al.  Formal Ontology in Information Systems : Proceedings of the First International Conference(FOIS'98), June 6-8, Trento, Italy , 1998 .

[94]  Irina Astrova.  Rules for Mapping SQL Relational Databases to OWL Ontologies , 2007, MTSR.

[95]  Soon Ae Chun,et al.  Toward the Semantic Deep Web , 2008, Computer.

[96]  Julia E. Hodges,et al.  Extraction of object-oriented structures from existing relational databases , 1997, SGMD.

[97]  Laurian M. Chirica,et al.  The entity-relationship model: toward a unified view of data , 1975, SIGF.

[98]  Samson W. Tu,et al.  DataMaster – a Plug-in for Importing Schemas and Data from Relational Databases into Protégé , 2007 .

[99]  Shiyong Lu,et al.  Semantics preserving SPARQL-to-SQL translation , 2009, Data Knowl. Eng..

[100]  Tim Berners-Lee,et al.  Linked data , 2020, Semantic Web for the Working Ontologist.

[101]  Karlis Cerans,et al.  RDB2OWL: a practical approach for transforming RDB data into RDF/OWL , 2010, I-SEMANTICS '10.

[102]  Marguerite C. Murphy,et al.  Mapping ER Schemas to OWL Ontologies , 2009, 2009 IEEE International Conference on Semantic Computing.

[103]  Thomas R. Gruber,et al.  Toward principles for the design of ontologies used for knowledge sharing? , 1995, Int. J. Hum. Comput. Stud..

[104]  Antonella Poggi,et al.  Ontology-based database access with DIG-Mastro and the OBDA Plugin for Protégé (Demo Description) , 2008, OWLED.

[105]  Yisheng Dong,et al.  Formal Approach and Automated Tool for Translating ER Schemata into OWL Ontologies , 2004, PAKDD.

[106]  Ramez Elmasri,et al.  Fundamentals of Database Systems , 1989 .

[107]  Edgar H. Sibley,et al.  Translating relational & Object-Relational Database models into OWL models , 2009, 2009 IEEE International Conference on Information Reuse & Integration.

[108]  Stathes Hadjiefthymiades,et al.  RONTO: relational to ontology schema matching , 2006 .

[109]  Heiner Stuckenschmidt,et al.  Ontology-Based Integration of Information - A Survey of Existing Approaches , 2001, OIS@IJCAI.

[110]  William J. Premerlani,et al.  An approach for reverse engineering of relational databases , 1993, [1993] Proceedings Working Conference on Reverse Engineering.

[111]  Huajun Chen,et al.  Browser-based Semantic Mapping Tool for Linked Data in Semantic Web , 2008, LDOW.

[112]  Niladri Chatterjee,et al.  Semantic Integration of Heterogeneous Databases on the Web , 2007, 2007 International Conference on Computing: Theory and Applications (ICCTA'07).

[113]  Daniel P. Miranker,et al.  Direct Mapping Sql Databases to the Semantic Web: a Survey , 2009 .

[114]  Christian Bizer,et al.  D2R Server - Publishing Relational Databases on the Semantic Web , 2004 .

[115]  Xiaodong Zhu,et al.  Research on the Rules of Mapping from Relational Model to OWL , 2006, OWLED.

[116]  Z. Hasan.  A Survey on Shari’Ah Governance Practices in Malaysia, GCC Countries and the UK , 2011 .

[117]  SpanosDimitrios-Emmanuel,et al.  Bringing relational databases into the semantic web , 2012 .

[118]  Vassilios Peristeras,et al.  Re-using Cool URIs: Entity Reconciliation Against LOD Hubs , 2011, LDOW.

[119]  Huajun Chen,et al.  RDF/RDFS-based Relational Database Integration , 2006, 22nd International Conference on Data Engineering (ICDE'06).

[120]  Xiaohua Hu,et al.  Round-Trip Engineering for Maintaining Conceptual-Relational Mappings , 2008, CAiSE.

[121]  Stefan Conrad.  RDQuery - Querying Relational Databases on-the-fly with RDF-QL , 2006 .

[122]  Jos de Bruijn,et al.  D4.2.1 State-of-the-art survey on Ontology Merging and Aligning V1 , 2004 .

[123]  Paul Johannesson,et al.  A method for transforming relational schemas into conceptual schemas , 1989, Proceedings of 1994 IEEE 10th International Conference on Data Engineering.

[124]  Huajun Chen,et al.  DartGrid: a semantic infrastructure for building database Grid applications , 2006, Concurr. Comput. Pract. Exp..

[125]  Diego Calvanese,et al.  The MASTRO system for ontology-based data access , 2011, Semantic Web.

[126]  Veda C. Storey,et al.  Reverse Engineering of Relational Databases: Extraction of an EER Model from a Relational Database , 1994, Data Knowl. Eng..

[127]  Richard Cyganiak,et al.  A relational algebra for SPARQL , 2005 .

[128]  Abraham Bernstein,et al.  The Semantic Web - ISWC 2009, 8th International Semantic Web Conference, ISWC 2009, Chantilly, VA, USA, October 25-29, 2009. Proceedings , 2009, SEMWEB.

[129]  Li Ma,et al.  An Effective SPARQL Support over Relational Databases , 2008, SWDB-ODBIS.

[130]  P. Sreenivasa Kumar,et al.  ERONTO: a tool for extracting ontologies from extended E/R diagrams , 2005, SAC '05.

[131]  Michael Schneider,et al.  Reasoning in the OWL 2 Full Ontology Language Using First-Order Automated Theorem Proving , 2011, CADE.

[132]  Eduard Constantin Dragut,et al.  Composing Mappings Between Schemas Using a Reference Ontology , 2004, CoopIS/DOA/ODBASE.

[133]  Farid Cerbah.  Mining the Content of Relational Databases to Learn Ontologies with Deeper Taxonomies , 2008, 2008 IEEE/WIC/ACM International Conference on Web Intelligence and Intelligent Agent Technology.

[134]  Kate Byrne.  Having Triplets – Holding Cultural Data as RDF , 2008 .

[135]  F. E..  A Relational Model of Data Large Shared Data Banks , 2000 .

[136]  Elizabeth Chang,et al.  From Database to Semantic Web Ontology: An Overview , 2007, OTM Workshops.

[137]  Miriam Baglioni,et al.  Building Geospatial Ontologies from Geographical Databases , 2007, GeoS.

[138]  Boris Motik,et al.  On the Properties of Metamodeling in OWL , 2007, J. Log. Comput..

[139]  Serge Abiteboul,et al.  Foundations of Databases , 1994 .