On Directly Mapping Relational Databases to RDF and OWL

Juan F. Sequeda, Marcelo Arenas and Daniel P. Miranker

Proc. of the World Wide Web Conference (WWW 2012). 2012. To appear.

Abstract: 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.

Extended Version which includes all proofs:
Technical Report TR-11-28, University of Texas at Austin, Department of Computer Science, June 2011
Download from arXiv: http://arxiv.org/abs/1202.3667