Discovering Simple Mappings Between Relational Database Schemas and Ontologies

Ontologies proliferate with the growth of the Semantic Web. However, most of data on the Web are still stored in relational databases. Therefore, it is important to establish interoperability between relational databases and ontologies for creating a Web of data. An effective way to achieve interoperability is finding mappings between relational database schemas and ontologies. In this paper, we propose a new approach to discovering simple mappings between a relational database schema and an ontology. It exploits simple mappings based on virtual documents, and eliminates incorrect mappings via validating mapping consistency. Additionally, it also constructs a special type of semantic mappings, called contextual mappings, which is useful for practical applications. Experimental results demonstrate that our approach performs well on several data sets from real world domains.

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

[2]  Peishen Qi,et al.  Integrating Databases into the Semantic Web through an Ontology-Based Framework , 2006, 22nd International Conference on Data Engineering Workshops (ICDEW'06).

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

[4]  Stefano Spaccapietra.  Journal on Data Semantics IV , 2005, Journal on Data Semantics IV.

[5]  Henryk Rybinski,et al.  On first-order-logic databases , 1987, TODS.

[6]  Wendy Hall,et al.  Creating a Science of the Web , 2006, Science.

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

[8]  Thomas R. Gruber,et al.  A translation approach to portable ontology specifications , 1993, Knowl. Acquis..

[9]  Yuzhong Qu,et al.  Constructing virtual documents for ontology matching , 2006, WWW '06.

[10]  Stefanos D. Kollias,et al.  A String Metric for Ontology Alignment , 2005, SEMWEB.

[11]  Zhaohui Wu,et al.  Towards a Semantic Web of Relational Databases: A Practical Semantic Toolkit and an In-Use Case from Traditional Chinese Medicine , 2006, SEMWEB.

[12]  Stéphane Bressan,et al.  Efficiency and Effectiveness of XML Tools and Techniques and Data Integration over the Web , 2003, Lecture Notes in Computer Science.

[13]  Mitesh Patel,et al.  Structured databases on the web: observations and implications , 2004, SGMD.

[14]  Yun Peng,et al.  Finding and Ranking Knowledge on the Semantic Web , 2005, SEMWEB.

[15]  Dean Allemang,et al.  The Semantic Web - ISWC 2006, 5th International Semantic Web Conference, ISWC 2006, Athens, GA, USA, November 5-9, 2006, Proceedings , 2006, SEMWEB.

[16]  John Mylopoulos,et al.  Inferring Complex Semantic Mappings Between Relational Tables and Ontologies from Simple Correspondences , 2005, OTM Conferences.

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

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

[19]  Wenfei Fan,et al.  Putting context into schema matching , 2006, VLDB.

[20]  Christoph Bussler,et al.  Semantic Web and Databases, Second International Workshop, SWDB 2004, Toronto, Canada, August 29-30, 2004, Revised Selected Papers , 2005, SWDB.

[21]  Enrico Motta,et al.  The Semantic Web - ISWC 2005, 4th International Semantic Web Conference, ISWC 2005, Galway, Ireland, November 6-10, 2005, Proceedings , 2005, SEMWEB.

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

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

[24]  Michael McGill,et al.  Introduction to Modern Information Retrieval , 1983 .

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

[26]  Jérôme Euzenat,et al.  A Survey of Schema-Based Matching Approaches , 2005, J. Data Semant..

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

[28]  Erhard Rahm,et al.  COMA - A System for Flexible Combination of Schema Matching Approaches , 2002, VLDB.