skip to main content
10.1145/1999676.1999699acmconferencesArticle/Chapter ViewAbstractPublication Pagesk-capConference Proceedingsconference-collections
research-article

Interpreting relational databases in the RDF domain

Published: 26 June 2011 Publication History

Abstract

The W3C's "Direct Mapping of Relational Data to RDF" defines a simple, practical and intuitive interpretation of SQL database tables as RDF graphs. This document specifies the formal data models for RDB (Relational DataBase) and RDF and defines a denotational semantics of RDB in the RDF domain. We show how this mapping treats all of the important features of SQL tables, like cardinality and NULLs, and yields an RDF graph which preserves the relational information.

References

[1]
Mapping sql data to rdf. http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VOSSQL2RDF.
[2]
Wikipedia article: Relational model. http://en.wikipedia.org/wiki/Relational_model.
[3]
Iso/iec 9075 part 1: Sql/framework. 2006.
[4]
Iso/iec 9075 part 2: Sql/foundation. 2006.
[5]
M. Arenas, E. Prud'hommeaux, and J. Sequeda. A direct mapping of relational data to rdf. 2010. http://www.w3.org/TR/2010/WD-rdb-direct-mapping-20101118/.
[6]
S. Auer, S. Dietzold, J. Lehmann, S. Hellmann, and D. Aumueller. Triplify -- light-weight linked data publication from relational databases. WWW2009.
[7]
D. Beckett and T. Berners-Lee. Turtle - terse rdf triple language. 2008. http://www.w3.org/TeamSubmission/2008/SUBM-turtle-20080114/.
[8]
F. Belleau, M.-A. Nolin, N. Tourigny, P. Rigault, and J. Morissette. Towards a mashup to build bioinformatics knowledge systems. Journal of Biomedical Informatics, 41:706--716, 2008.
[9]
T. Berners-Lee. Linked data - design issues. 2010. http://www.w3.org/DesignIssues/LinkedData.
[10]
C. Bizer and A. Seaborne. D2rq - treating non-rdf databases as virtual rdf graphs. ISWC2004 (posters), November 2004.
[11]
A. Chebotko, S. Lu, H. M. Jamil, and F. Fotouhi. Semantics preserving sparql-to-sql query translation for optional graph patterns. Technical report, 2006.
[12]
E. F. Codd. The relational model for database management. 1990.
[13]
R. Cyganiak. A relational algebra for sparql. Technical report, 2005.
[14]
B. Elliott1, E. Cheng, C. Thomas-Ogbuji, and Z. M. Ozsoyoglu. A complete translation from sparql into efficient sql.
[15]
D. Eynard, J. Recker, and C. Sayers. An imap plugin for squirrelrdf. Technical report. http://www.hpl.hp.com/techreports/2007/HPL-2007-161.pdf.
[16]
B. He, M. Patel, Z. Zhang, and K. Chang. Accessing the deep web. Communications of the ACM, 50(5):94--101, 2007.
[17]
A. Jentzsch, J. Zhao, O. Hassanzadeh, K.-H. Cheung, M. Samwald, and B. Andersson. Linking open drug data. 2009.
[18]
G. Klyne and J. J. Carroll. Resource description framework (rdf): Concepts and abstract syntax. 2004. http://www.w3.org/TR/2004/REC-rdf-concepts-20040210/.
[19]
E. Prud'hommeaux. Spasql: Sparql support in mysql. http://www.w3.org/2005/05/22-SPARQL-MySQL/XTech.
[20]
E. Prud'hommeaux, M. Hausenblas, S. Auer, L. Feigenbaum, D. Miranker, A. Fogarolli, and J. Sequeda. Use cases and requirements for mapping relational databases to rdf. 2010. http://www.w3.org/TR/2010/WD-rdb2rdf-ucr-20100608/.
[21]
E. Prud'hommeaux and A. Seaborne. Sparql query language for rdf. 2008. http://www.biopax.org/release/biopax-level3-documentation.pdf.
[22]
D. Raggett, A. L. Hors, and I. Jacobs. Html 4.01 specification. 1999. http://www.w3.org/TR/html401/interact/forms.html#h-17.13.4.1.
[23]
D. Steer. Squirrelrdf. 2006. http://jena.sourceforge.net/SquirrelRDF/.

Cited By

View all
  • (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
  • (2017)EpiK: A Knowledge Base for Epidemiological Modeling and Analytics of Infectious DiseasesJournal of Healthcare Informatics Research10.1007/s41666-017-0010-91:2(260-303)Online publication date: 6-Nov-2017
  • (2015)An Approach for Mapping Relational Database into OntologyProceedings of the 2015 12th Web Information System and Application Conference (WISA)10.1109/WISA.2015.25(120-125)Online publication date: 11-Sep-2015
  • Show More Cited By

Recommendations

Comments

Information & Contributors

Information

Published In

cover image ACM Conferences
K-CAP '11: Proceedings of the sixth international conference on Knowledge capture
June 2011
212 pages
ISBN:9781450303965
DOI:10.1145/1999676
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

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 26 June 2011

Permissions

Request permissions for this article.

Check for updates

Author Tags

  1. RDF
  2. SQL
  3. denotational semantics
  4. relational database
  5. semantic web

Qualifiers

  • Research-article

Conference

K-CAP '2011
Sponsor:
K-CAP '2011: Knowledge Capture Conference
June 26 - 29, 2011
Alberta, Banff, Canada

Acceptance Rates

Overall Acceptance Rate 55 of 198 submissions, 28%

Contributors

Other Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

  • Downloads (Last 12 months)9
  • Downloads (Last 6 weeks)2
Reflects downloads up to 13 Jan 2025

Other Metrics

Citations

Cited By

View all
  • (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
  • (2017)EpiK: A Knowledge Base for Epidemiological Modeling and Analytics of Infectious DiseasesJournal of Healthcare Informatics Research10.1007/s41666-017-0010-91:2(260-303)Online publication date: 6-Nov-2017
  • (2015)An Approach for Mapping Relational Database into OntologyProceedings of the 2015 12th Web Information System and Application Conference (WISA)10.1109/WISA.2015.25(120-125)Online publication date: 11-Sep-2015
  • (2015)Semantic SPARQL Query in a Relational Database Based on Ontology ConstructionProceedings of the 2015 11th International Conference on Semantics, Knowledge and Grids (SKG)10.1109/SKG.2015.14(25-32)Online publication date: 19-Aug-2015
  • (2015)Measuring the Quality of Relational-to-RDF MappingsKnowledge Engineering and Semantic Web10.1007/978-3-319-24543-0_16(210-224)Online publication date: 30-Oct-2015
  • (2014)Understanding fish behavior during typhoon events in real-life underwater environmentsMultimedia Tools and Applications10.1007/s11042-012-1101-570:1(199-236)Online publication date: 1-May-2014
  • (2012)Bringing relational databases into the Semantic WebSemantic Web10.5555/2590194.25901993:2(169-209)Online publication date: 1-Apr-2012
  • (2012)Bringing relational databases into the semantic webSemantic Web10.5555/2512659.25126643:2(169-209)Online publication date: 1-Apr-2012
  • (2012)On directly mapping relational databases to RDF and OWLProceedings of the 21st international conference on World Wide Web10.1145/2187836.2187924(649-658)Online publication date: 16-Apr-2012

View Options

Login options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Media

Figures

Other

Tables

Share

Share

Share this Publication link

Share on social media