More Web Proxy on the site http://driver.im/

research-article

On directly mapping relational databases to RDF and OWL

Authors:

Juan F. Sequeda,

Marcelo Arenas,

Daniel P. MirankerAuthors Info & Claims

WWW '12: Proceedings of the 21st international conference on World Wide Web

Pages 649 - 658

https://doi.org/10.1145/2187836.2187924

Published: 16 April 2012 Publication History

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.

References

[1]

W3C OWL Working Group. OWL 2 Web ontology language document overview. W3C Recommendation 27 October 2009, http://www.w3.org/TR/owl2-overview/.

[2]

D2R Server. Publishing Relational Databases on the Semantic Webriptsize http://www4.wiwiss.fu-berlin.de/bizer/d2r-server/.

[3]

S. Abiteboul, R. Hull, and V. Vianu. Foundations of Databases. Addison-Wesley, 1995.

Digital Library

[4]

R. Angles and C. Gutierrez. The expressive power of sparql. In ISWC, pages 114--129, 2008.

Digital Library

[5]

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/.

[6]

A. Bertails, and E. Prud'hommeaux. Interpreting relational databases in the RDF domain In K-CAP, pages 129--136, 2011.

Digital Library

[7]

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.

Digital Library

[8]

F. Cerbah. Mining the Content of Relational Databases to Learn Ontologies with Deeper Taxonomies In Web Intelligence, pages 553--557, 2008.

Digital Library

[9]

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.

Digital Library

[10]

F. M. Donini, D. Nardi, and R. Rosati. Description logics of minimal knowledge and negation as failure. ACM TOCL, 3(2):177--225, 2002.

Digital Library

[11]

S. Grimm and B. Motik. Closed world reasoning in the semantic web through epistemic operators. In OWLED, 2005.

[12]

S. Harris and A. Seaborne. SPARQL 1.1 query language. W3C Working Draft 12 May 2011, http://www.w3.org/TR/sparql11-query/.

[13]

B. He, M. Patel, Z. Zhang, and K. C.-C. Chang. Accessing the deep web. Commun. ACM, 50:94--101, May 2007.

Digital Library

[14]

A. Mehdi, S. Rudolph, and S. Grimm. Epistemic querying of OWL knowledge bases. In ESWC (1), pages 397--409, 2011.

Digital Library

[15]

B. Motik, I. Horrocks, and U. Sattler. Bridging the gap between OWL and relational databases. J. Web Sem., 7(2):74--89, 2009.

Digital Library

[16]

J. Pérez, M. Arenas, and C. Gutierrez. Semantics and complexity of SPARQL. ACM Trans. Database Syst., 34(3), 2009.

Digital Library

[17]

E. Prud'hommeaux and A. Seaborne. SPARQL query language for RDF. W3C Recommendation 15 January 2008, http://www.w3.org/TR/rdf-sparql-query/.

[18]

R. Reiter. On integrity constraints. In TARK, pages 97--111, 1988.

Digital Library

[19]

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.

[20]

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)

Digital Library

[21]

I. Seylan, E. Franconi, and J. De Bruijn. Effective query rewriting with ontologies over DBoxes. In IJCAI, pages 923--929, 2009.

Digital Library

[22]

J. Tao, E. Sirin, J. Bao, and D. L. McGuinness. Integrity constraints in OWL. In AAAI, 2010.

Digital Library

[23]

S. H. Tirmizi, J. Sequeda, and D. P. Miranker. Translating SQL Applications to the Semantic Web. In DEXA, pages 450--464, 2008.

Digital Library

Cited By

Belmehdi CKhiat AKeskes N(2024)Predicting an Optimal Virtual Data Model for Uniform Access to Large Heterogeneous DataData Intelligence10.1162/dint_a_002166:2(504-530)Online publication date: 1-May-2024
https://doi.org/10.1162/dint_a_00216
Rabbani KLissandrini MBonifati AHose K(2024)Transforming RDF Graphs to Property Graphs using Standardized SchemasProceedings of the ACM on Management of Data10.1145/36988172:6(1-25)Online publication date: 20-Dec-2024
https://doi.org/10.1145/3698817
Seifer PHernández DLämmel RStaab SChua TNgo CKa-Wei Lee RKumar RLauw H(2024)From Shapes to Shapes: Inferring SHACL Shapes for Results of SPARQL CONSTRUCT QueriesProceedings of the ACM Web Conference 202410.1145/3589334.3645550(2064-2074)Online publication date: 13-May-2024
https://dl.acm.org/doi/10.1145/3589334.3645550
Show More Cited By

Index Terms

On directly mapping relational databases to RDF and OWL
1. Information systems
  1. Data management systems
    1. Information integration
      1. Extraction, transformation and loading
  2. World Wide Web
    1. Web applications
    2. Web services
2. Software and its engineering
  1. Software organization and properties
    1. Extra-functional properties
      1. Interoperability

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 929

In 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 Communications

A 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

Please enable JavaScript to view thecomments powered by Disqus.

Information & Contributors

Information

Published In

cover image ACM Other conferences

WWW '12: Proceedings of the 21st international conference on World Wide Web

April 2012

1078 pages

ISBN:9781450312295

DOI:10.1145/2187836

General Chairs:
Alain Mille
Université de Lyon, France
,
Fabien Gandon
INRIA, France
,
Jacques Misselis
HP, France
,
Program Chairs:
Michael Rabinovich
Case Western Reserve University, USA
,
Steffen Staab
University of Koblenz-Landau, Germany

Copyright © 2012 ACM.

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Sponsors

Univ. de Lyon: Universite de Lyon

In-Cooperation

SIGWEB: ACM Special Interest Group on Hypertext, Hypermedia, and Web

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 16 April 2012

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Author Tags

Qualifiers

Research-article

Conference

WWW 2012

Sponsor:

Univ. de Lyon

WWW 2012: 21st World Wide Web Conference 2012

April 16 - 20, 2012

Lyon, France

Acceptance Rates

Overall Acceptance Rate 1,899 of 8,196 submissions, 23%

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

89
Total Citations
View Citations
837
Total Downloads

Downloads (Last 12 months)57
Downloads (Last 6 weeks)2

Reflects downloads up to 24 Dec 2024

Other Metrics

View Author Metrics

Citations

Cited By

Belmehdi CKhiat AKeskes N(2024)Predicting an Optimal Virtual Data Model for Uniform Access to Large Heterogeneous DataData Intelligence10.1162/dint_a_002166:2(504-530)Online publication date: 1-May-2024
https://doi.org/10.1162/dint_a_00216
Rabbani KLissandrini MBonifati AHose K(2024)Transforming RDF Graphs to Property Graphs using Standardized SchemasProceedings of the ACM on Management of Data10.1145/36988172:6(1-25)Online publication date: 20-Dec-2024
https://doi.org/10.1145/3698817
Seifer PHernández DLämmel RStaab SChua TNgo CKa-Wei Lee RKumar RLauw H(2024)From Shapes to Shapes: Inferring SHACL Shapes for Results of SPARQL CONSTRUCT QueriesProceedings of the ACM Web Conference 202410.1145/3589334.3645550(2064-2074)Online publication date: 13-May-2024
https://dl.acm.org/doi/10.1145/3589334.3645550
Mekrache AKsentini AVerikoukis C(2024)Machine Learning in FCAPS: Toward Enhanced Beyond 5G Network ManagementIEEE Communications Surveys & Tutorials10.1109/COMST.2024.339541426:4(2769-2797)Online publication date: Dec-2025
https://doi.org/10.1109/COMST.2024.3395414
Manouvrier MBelhajjame K(2024)PG-FD: Mapping Functional Dependencies to the Future Property Graph Schema StandardAdvances in Databases and Information Systems10.1007/978-3-031-70626-4_4(45-59)Online publication date: 28-Aug-2024
https://dl.acm.org/doi/10.1007/978-3-031-70626-4_4
Adrees MHusnain MSandhu MAslam MMartinez-Enriquez AJahangeer AAsghar D(2024)Identification of Hidden Inheritance Patterns in a Relational Database Based on OntologiesIntelligent Systems and Applications10.1007/978-3-031-66329-1_20(279-295)Online publication date: 31-Jul-2024
https://doi.org/10.1007/978-3-031-66329-1_20
Yan LHu HMa Z(2023)Construction of RDF Knowledge Graph with MongoDBTENCON 2023 - 2023 IEEE Region 10 Conference (TENCON)10.1109/TENCON58879.2023.10322493(371-376)Online publication date: 31-Oct-2023
https://doi.org/10.1109/TENCON58879.2023.10322493
Tomaszuk DSzeremeta ŁKorniłowicz A(2023)MMLKG: Knowledge Graph for Mathematical Definitions, Statements and ProofsScientific Data10.1038/s41597-023-02681-310:1Online publication date: 10-Nov-2023
https://doi.org/10.1038/s41597-023-02681-3
Vaganov DShikov ELysenko AAndreeva P(2023)Ontological model identification based on data from heterogeneous sourcesProcedia Computer Science10.1016/j.procs.2023.12.032229(305-314)Online publication date: 2023
https://doi.org/10.1016/j.procs.2023.12.032
Xiao YZheng SShi JDu XHong J(2023)Knowledge graph-based manufacturing process planning: A state-of-the-art reviewJournal of Manufacturing Systems10.1016/j.jmsy.2023.08.00670(417-435)Online publication date: Oct-2023
https://doi.org/10.1016/j.jmsy.2023.08.006
Show More Cited By

View Options

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Get this Publication

View options

PDF

View or Download as a PDF file.

eReader

View online with eReader.

Media

Figures

Other

Tables

View Table of Contents