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.
- W3C OWL Working Group. OWL 2 Web ontology language document overview. W3C Recommendation 27 October 2009, http://www.w3.org/TR/owl2-overview/.Google Scholar
- D2R Server. Publishing Relational Databases on the Semantic Webriptsize http://www4.wiwiss.fu-berlin.de/bizer/d2r-server/.Google Scholar
- S. Abiteboul, R. Hull, and V. Vianu. Foundations of Databases. Addison-Wesley, 1995. Google ScholarDigital Library
- R. Angles and C. Gutierrez. The expressive power of sparql. In ISWC, pages 114--129, 2008. Google ScholarDigital Library
- M. Arenas, A. Bertails, E. Prud'hommeaux, and J. Sequeda. Direct mapping of relational data to RDF. W3C Working Draft 20 September 2011, http://www.w3.org/TR/rdb-direct-mapping/.Google Scholar
- A. Bertails, and E. Prud'hommeaux. Interpreting relational databases in the RDF domain In K-CAP, pages 129--136, 2011. Google ScholarDigital Library
- D. Calvanese, G. D. Giacomo, D. Lembo, M. Lenzerini, and R. Rosati. Eql-lite: Effective first-order query processing in description logics. In IJCAI, pages 274--279, 2007. Google ScholarDigital Library
- F. Cerbah. Mining the Content of Relational Databases to Learn Ontologies with Deeper Taxonomies In Web Intelligence, pages 553--557, 2008. Google ScholarDigital Library
- F. Donini, M. Lenzerini, D. Nardi, W. Nutt, and A. Schaerf. An epistemic operator for description logics. Artif. Intell., 100(1--2):225--274, 1998. Google ScholarDigital Library
- F. M. Donini, D. Nardi, and R. Rosati. Description logics of minimal knowledge and negation as failure. ACM TOCL, 3(2):177--225, 2002. Google ScholarDigital Library
- S. Grimm and B. Motik. Closed world reasoning in the semantic web through epistemic operators. In OWLED, 2005.Google Scholar
- S. Harris and A. Seaborne. SPARQL 1.1 query language. W3C Working Draft 12 May 2011, http://www.w3.org/TR/sparql11-query/.Google Scholar
- B. He, M. Patel, Z. Zhang, and K. C.-C. Chang. Accessing the deep web. Commun. ACM, 50:94--101, May 2007. Google ScholarDigital Library
- A. Mehdi, S. Rudolph, and S. Grimm. Epistemic querying of OWL knowledge bases. In ESWC (1), pages 397--409, 2011. Google ScholarDigital Library
- B. Motik, I. Horrocks, and U. Sattler. Bridging the gap between OWL and relational databases. J. Web Sem., 7(2):74--89, 2009. Google ScholarDigital Library
- J. Pérez, M. Arenas, and C. Gutierrez. Semantics and complexity of SPARQL. ACM Trans. Database Syst., 34(3), 2009. Google ScholarDigital Library
- E. Prud'hommeaux and A. Seaborne. SPARQL query language for RDF. W3C Recommendation 15 January 2008, http://www.w3.org/TR/rdf-sparql-query/.Google Scholar
- R. Reiter. On integrity constraints. In TARK, pages 97--111, 1988. Google ScholarDigital Library
- J. F. Sequeda, M. Arenas, and D. P. Miranker. On Directly Mapping Relational Databases to RDF and OWL(Extended Version). arXiv:1202.3667 {cs.DB} (February 2012), http://arxiv.org/abs/1202.3667.Google Scholar
- J. F. Sequeda, S. H. Tirmizi, O. Corcho, and D. P. Miranker. Survey of directly mapping sql databases to the semantic web. Knowledge Eng. Review, 26(4): 445--486 (2011) Google ScholarDigital Library
- I. Seylan, E. Franconi, and J. De Bruijn. Effective query rewriting with ontologies over DBoxes. In IJCAI, pages 923--929, 2009. Google ScholarDigital Library
- J. Tao, E. Sirin, J. Bao, and D. L. McGuinness. Integrity constraints in OWL. In AAAI, 2010.Google ScholarDigital Library
- S. H. Tirmizi, J. Sequeda, and D. P. Miranker. Translating SQL Applications to the Semantic Web. In DEXA, pages 450--464, 2008. Google ScholarDigital Library
Index Terms
- On directly mapping relational databases to RDF and OWL
Recommendations
Ultrawrap: SPARQL execution on relational data
The Semantic Web's promise of web-wide data integration requires the inclusion of legacy relational databases, i.e. the execution of SPARQL queries on RDF representation of the legacy relational data. We explore a hypothesis: existing commercial ...
Relational database to RDF mapping patterns
WOP'12: Proceedings of the 3rd International Conference on Ontology Patterns - Volume 929In order to integrate relational databases into Semantic Web applications, relational databases need to be mapped to RDF. The W3C RDB2RDF Working Group is in the process of ratifying two standards to map relational databases to RDF: Direct Mapping and ...
Mapping of SQL relational shemata to OWL otologies
AIC'06: Proceedings of the 6th WSEAS International Conference on Applied Informatics and CommunicationsA novel approach is proposed. This approach maps a relational database defined by a relational schema to an ontology. The ontology has a hierarchical structure, and it is no longer "impaired" by optimization and bad database design of the relational ...
Comments