Skip to main content
SpringerLink
Log in

Relational Databases in RDF: Keys and Foreign Keys

  • Conference paper
Semantic Web, Ontologies and Databases (ODBIS 2007, SWDB 2007)

Part of the book series: Lecture Notes in Computer Science ((LNISA,volume 5005))

Abstract

Today, most of the data on the web resides in relational databases. To make the data available for the semantic web mappings into RDF can be used. Such mappings should preserve the information about the structure of keys and foreign keys, because otherwise important semantic information is lost. In this paper, we discuss several possible ways to map relational databases into an RDF graph. We discuss the problem of how to represent the original key and foreign key constraints in the resulting RDF graph and demonstrate, that different kinds of mappings require different solutions. We finally propose to explicitly represent the structure of keys and foreign keys by means of the vocabulary of a new RDF namespace.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Baader, F., Calvanese, D., McGuinness, D.L., Nardi, D., Patel-Schneider, P.F.: The Description Logic Handbook. Cambridge University Press, Cambridge (2003)

    MATH  Google Scholar 

  2. Berners-Lee, T.: Relational Databases on the Semantic Web (1998), http://www.w3.org/DesignIssues/RDB-RDF.html

  3. Biskup, J., Polle, T.: Adding inclusion dependencies to an object-oriented data model with uniqueness constraints. Acta Inf. 39(6-7) (2003)

    Google Scholar 

  4. Bizer, C.: D2R MAP - A Database to RDF Mapping Language. WWW (Posters) (2003)

    Google Scholar 

  5. Blakeley, C.: Mapping Relational Data to RDF with Virtuoso’s RDF Views. OpenLink Software (2007)

    Google Scholar 

  6. van Bommel, M.F., Weddell, G.E.: Reasoning about equations and functional dependencies on complex objects. IEEE ToKDE 6(3) (1994)

    Google Scholar 

  7. Calvanese, D., De Giacomo, G., Lembo, D., Lenzerini, M., Rosati, R.: Can OWL model football leagues?. In: OWLED 2007 (2007)

    Google Scholar 

  8. Chatterjee, N., Krishna, M.: Semantic Integration of Heterogeneous Databases on the Web. In: ICCTA 2007 (2007)

    Google Scholar 

  9. Chen, P.P.: The Entity-Relationship Model - Toward a Unified View of Data. ACM Trans. on Database Systems 1(1) (1976)

    Google Scholar 

  10. Fan, W., Libkin, L.: On XML integrity constraints in the presence of DTDs. J. ACM 49(3) (2002)

    Google Scholar 

  11. Kifer, M., Lausen, G., Wu, J.: Logical Foundations of Object-Oriented and Frame-Based Languages. J. ACM 42(4) (1995)

    Google Scholar 

  12. Krishna, M.: Retaining Semantics in Relational Databases by Mapping them to RDF. In: IAT Workshops 2006 (2006)

    Google Scholar 

  13. Lausen, G., Meier, M., Schmidt, M.: SPARQling Constraints for RDF. In: EDBT 2008 (to appear, 2008)

    Google Scholar 

  14. Lutz, C., Areces, C., Horrocks, I., Sattler, U.: Keys, Nominals, and Concrete Domains. J. Artif. Intell. Res. (JAIR) 23 (2005)

    Google Scholar 

  15. Motik, B., Horrocks, I., Sattler, U.: Bridging the Gap Between OWL and Relational Databases. In: WWW 2007 (2007)

    Google Scholar 

  16. Motik, B., Horrocks, I., Sattler, U.: Adding Integrity Constraints to OWL. In: OWLED 2007 (2007)

    Google Scholar 

  17. Staab, S., Studer, R. (eds.): Handbook on Ontologies. Springer, Heidelberg (2004)

    Google Scholar 

  18. OWL Web Ontology Language Reference. W3C (2004)

    Google Scholar 

  19. OWL 1.1 Web Ontology Language Overview. Editor’s Draft, April 6 (2007), http://webont.org/owl/1.1/overview.html

  20. OWL 1.1 Web Ontology Language Model-Theoretic Semantics. Editor’s Draft, April 6 (2007), http://webont.org/owl/1.1/semantics.html

  21. Resource Description Framework (RDF): Concepts and Abstract Syntax. W3C (2004)

    Google Scholar 

  22. RDF Semantics. W3C (2004)

    Google Scholar 

  23. SPARQL Query Language for RDF. W3C (2007)

    Google Scholar 

  24. XML Schema Part 0: Primer Second Edition. W3C (2004)

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Institute for Computer Science, University of Freiburg, Georges-Köhler-Allee, 79110, Freiburg, Germany

    Georg Lausen

Authors
  1. Georg Lausen
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Vassilis Christophides Martine Collard Claudio Gutierrez

Rights and permissions

Reprints and permissions

Copyright information

© 2008 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Lausen, G. (2008). Relational Databases in RDF: Keys and Foreign Keys. In: Christophides, V., Collard, M., Gutierrez, C. (eds) Semantic Web, Ontologies and Databases. ODBIS SWDB 2007 2007. Lecture Notes in Computer Science, vol 5005. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-70960-2_3

Download citation

  • DOI: https://doi.org/10.1007/978-3-540-70960-2_3

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-70959-6

  • Online ISBN: 978-3-540-70960-2

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation