On directly mapping relational databases to RDF and OWL

Mapping relational databases to RDF is a fundamental problem for the development of the Semantic Web. We present a solution, inspired by draft methods defined by the W3C where relational databases are directly mapped to RDF and OWL. Given a relational database schema and its integrity constraints, this direct mapping produces an OWL ontology, which, provides the basis for generating RDF instances. The semantics of this mapping is defined using Datalog. Two fundamental properties are information preservation and query preservation. We prove that our mapping satisfies both conditions, even for relational databases that contain null values. We also consider two desirable properties: monotonicity and semantics preservation. We prove that our mapping is monotone and also prove that no monotone mapping, including ours, is semantic preserving. We realize that monotonicity is an obstacle for semantic preservation and thus present a non-monotone direct mapping that is semantics preserving.

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

[2]  Werner Nutt,et al.  An Epistemic Operator for Description Logics , 1998, Artif. Intell..

[3]  Claudio Gutiérrez,et al.  Subqueries in SPARQL , 2011, AMW.

[4]  E. Prud hommeaux,et al.  SPARQL query language for RDF , 2011 .

[5]  J. Bruijn,et al.  Effective query rewriting with ontologies over DBoxes , 2009, IJCAI 2009.

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

[7]  Mitesh Patel,et al.  Accessing the deep web , 2007, CACM.

[8]  Diego Calvanese,et al.  EQL-Lite: Effective First-Order Query Processing in Description Logics , 2007, IJCAI.

[9]  Jiao Tao,et al.  Integrity Constraints in OWL , 2010, AAAI.

[10]  Raymond Reiter,et al.  On Integrity Constraints , 1988, TARK.

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

[12]  Daniel P. Miranker,et al.  Survey of directly mapping SQL databases to the Semantic Web , 2011, The Knowledge Engineering Review.

[13]  Boris Motik,et al.  Closed World Reasoning in the Semantic Web through Epistemic Operators , 2005, OWLED.

[14]  Francesco M. Donini,et al.  Description logics of minimal knowledge and negation as failure , 2002, TOCL.

[15]  Sebastian Rudolph,et al.  Epistemic Querying of OWL Knowledge Bases , 2011, ESWC.

[16]  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.

[17]  Marcelo Arenas,et al.  Semantics and complexity of SPARQL , 2006, TODS.

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

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

[20]  Claudio Gutiérrez,et al.  SQL Nested Queries in SPARQL , 2010, AMW.