Skip to main content
SpringerLink
Log in
Book cover

Materializing the Web of Linked Data pp 73–102Cite as

Creating Linked Data from Relational Databases

  • Chapter

Abstract

In this Chapter, we consider relational databases as a data source for the generation of Linked Data, given that they constitute one of the most popular data storage media, containing huge data volumes that feed the vast majority of information systems worldwide. In this context, we review the related literature and reveal the main motivations that fuel the relevant approaches, and the benefits that arise from their application. We present a categorization of approaches that map relational databases to the Semantic Web and identify tool implementations that extract RDF graphs from relational database instances. We also sketch a proof-of-concept use case scenario regarding how a repository with scholarly information can be converted to a Linked Data endpoint. The Chapter ends with a discussion of the open issues and future outlook for the problem of RDF generation from relational databases.

This is a preview of subscription content, 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 EPUB and 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
Hardcover Book
USD   54.99
Price excludes VAT (USA)
  • Durable hardcover 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

Learn about institutional subscriptions

Notes

  1. 1.

    RDF Views in Oracle DBMS: docs.oracle.com/database/121/RDFRM/sem_relational_views.htm#RDFRM555

  2. 2.

    Europeana: www.europeana.eu

  3. 3.

    DRIVER: www.driver-repository.eu

  4. 4.

    OpenAIRE: www.openaire.eu

  5. 5.

    Europeana Data Model: pro.europeana.eu/edm-documentation

  6. 6.

    R2RML Parser: www.w3.org/2001/sw/wiki/R2RML_Parser

  7. 7.

    DSpace: www.dspace.org

References

  • An Y, Borgida A, Mylopoulos J (2006) Discovering the semantics of relational tables through mappings. J Data Semantics 7:1–32

    Google Scholar 

  • An Y, Borgida A, Miller RJ et al (2007) A semantic approach to discovering schema mapping expressions. In: Chirkova R, Oria V (eds) Proceedings of 2007 IEEE 23rd international conference on data engineering (ICDE 2007), Istanbul, Turkey, April 2007. IEEE, pp 206–215

    Google Scholar 

  • An Y, Hu X, Song IY (2008) Round-trip engineering for maintaining conceptual-relational mappings. In: Bellahsène Z, Léonard M (eds) Advanced information systems engineering: 20th international conference (CAiSE 2008), Montpellier, France, June 2008. Lecture notes in computer science, vol. 5074. Springer, Heidelberg, pp 296–311

    Google Scholar 

  • Auer S, Dietzold S, Lehmann J et al (2009) Triplify—Light-weight linked data publication from relational databases. In: WWW’09, Proceedings of the 18th international conference on World Wide Web, New York, NY, USA, pp 621–630

    Google Scholar 

  • Barrasa J, Corcho O, Gómez-Pérez A (2004) R2O, an extensible and semantically based database-to-ontology mapping language. Second international workshop on semantic web and databases (SWDB 2004), 29–30 August 2004, Toronto, Canada

    Google Scholar 

  • Barrasa-Rodriguez J, Gómez-Pérez A (2006) Upgrading relational legacy data to the semantic web. In: WWW’06, Proceedings of the 15th international conference on World Wide Web, Edinburgh, Scotland, April 2006. ACM, New York, pp 1069–1070

    Google Scholar 

  • Beckett D, Grant J (2003) SWAD-Europe Deliverable 10.2: mapping semantic web data with RDBMSes. http://www.w3.org/2001/sw/Europe/reports/scalable_rdbms_mapping_report/. Accessed 26 Dec 2014

  • Ben Necib C, Freytag JC (2005) Semantic query transformation using ontologies. In: Desai BC, Vossen G (eds) Proceedings of 9th international database engineering & application symposium (IDEAS 2005), Montreal, Canada, July 2005. IEEE, pp 187–199

    Google Scholar 

  • Berners-Lee T (1998) Relational databases on the semantic Web. http://www.w3.org/DesignIssues/RDB-RDF.html. Accessed 26 Dec 2014.

  • Biblioteca Nacional De Espana (2012) Linked data at Spanish National Library. http://www.bne.es/en/Catalogos/DatosEnlazados/index.html. Accessed 26 Dec 2014

  • Bizer C, Seaborne A (2004) D2RQ—Treating non-RDF databases as virtual RDF graphs. Poster presented at the 3rd international semantic web conference (ISWC 2004), Hiroshima, Japan

    Google Scholar 

  • Bizer C, Cyganiak R (2006) D2R Server—Publishing relational databases on the semantic web. Poster presented at the 5th international semantic web conference (ISWC 2006), Athens, Georgia, USA

    Google Scholar 

  • Blakeley C (2007) Virtuoso RDF views getting started guide. http://www.openlinksw.co.uk/virtuoso/Whitepapers/pdf/Virtuoso_SQL_to_RDF_Mapping.pdf. Accessed 26 Dec 2014

  • British Library (2012) Linked data at the British Library. http://www.bl.uk/bibliographic/datafree.html. Accessed 26 Dec 2014

  • Buccella A, Penabad MR, Rodriguez FR et al (2004) From relational databases to OWL ontologies. In: Proceedings of 6th Russian conference on digital libraries (RCDL 2004), Pushchino, Russia

    Google Scholar 

  • Byrne K (2008) Having triplets—holding cultural data as RDF. In: Larson M, Fernie K, Oomen J et al (eds) Proceedings of the ECDL 2008 workshop on information access to cultural heritage. Aarhus, Denmark

    Google Scholar 

  • Chebotko A, Lu S, Fotouhi F (2009) Semantics preserving SPARQL-to-SQL translation. Data & Knowledge Eng 68(10):973–1000

    Article  Google Scholar 

  • Curé O, Squelbut R (2005) A database trigger strategy to maintain knowledge bases developed via data migration. In: Bento C, Cardoso A, Dias G (eds) Progress in artificial intelligence: 12th Portuguese conference on artificial intelligence (EPIA 2005), Covilha, Portugal, December 2005. Lecture notes in computer science, vol 3808. Springer, Heidelberg, pp 206–217

    Google Scholar 

  • Cyganiak R (2005) A relational algebra for SPARQL. Hewlett Packard. http://www.hpl.hp.com/techreports/2005/HPL-2005-170.pdf. Accessed 26 Dec 2014

  • Das S, Srinivasan J (2009) Database technologies for RDF. In: Tessaris S, Franconi E, Eiter T et al (eds.) Reasoning web. Semantic technologies for information systems: 5th international summer school 2009. Lecture notes in computer science, vol 5689. Springer, Heidelberg, pp 205–221

    Google Scholar 

  • Deutsche National Bibliothek (2012) The linked data service of the German National Library. http://www.dnb.de/EN/Service/DigitaleDienste/LinkedData/linkeddata_node.html. Accessed 26 Dec 2014

  • Dragut E, Lawrence R (2004) Composing mappings between schemas using a reference ontology. In: Meersman R, Tari Z (eds) On the move to meaningful internet systems 2004: CoopIS, DOA, and ODBASE. Lecture notes in computer science, vol 3290. Springer, Heidelberg, pp 783–800

    Google Scholar 

  • Eisenberg V, Kanza Y (2012) D2RQ/Update: updating relational data via virtual RDF. In: Proceedings of the 21st international conference companion on World Wide Web (WWW’12 Companion), Lyon, France, April 2012. ACM, New York, pp 497–498

    Google Scholar 

  • Elliott B, Cheng E, Thomas-Ogbuji C et al (2009) A complete translation from SPARQL into efficient SQL. In: Desai BC (ed) Proceedings of the thirteenth international database engineering & applications symposium (IDEAS’09), Calabria, Italy, September 2009. CM, New York, USA, pp 31–42

    Google Scholar 

  • Elmasri R, Navathe SB (2010) Fundamentals of database systems. The Benjamin/Cummings, San Francisco

    Google Scholar 

  • Garrote A, Moreno García MN (2011) RESTful writable APIs for the web of linked data using relational storage solutions. In: Bizer C, Heath T, Berners-Lee T et al (eds) Proceedings of the 4th linked data on the web wWorkshop (LDOW 2011), Hyderabad, India. CEUR Workshop Proceedings, vol 813

    Google Scholar 

  • Geller J, Chun SA, An YJ (2008) Toward the semantic deep web. Computer 41(9):95–97

    Article  Google Scholar 

  • Ghawi R, Cullot N (2007) Database-to-ontology mapping generation for semantic interoperability. Paper presented at the 3rd international workshop on database interoperability (InterDB 2007), held in conjunction with VLDB 2007, Vienna

    Google Scholar 

  • Gómez-Pérez A, Corcho-Garcia O, Fernandez-Lopez M (2003) Ontological engineering. Springer-Verlag, New York

    Google Scholar 

  • Heath T, Bizer C (2011) Linked data: evolving the web into a global data space. Morgan & Claypool, San Rafael

    Google Scholar 

  • Hellmann S, Unbehauen J, Zaveri A et al (2011) Report on knowledge extraction from structured sources. LOD2 Project. http://static.lod2.eu/Deliverables/deliverable-3.1.1.pdf. Accessed 26 Dec 2014

  • Hendler J (2008) Web 3.0: chicken farms on the semantic web. IEEE Computer 41(1):106–108

    Article  Google Scholar 

  • Hert M, Ghezzi G, Würsch M et al (2011) How to “Make a Bridge to the New Town” using ontoaccess. In: Aroyo L, Welty C, Alani H et al (eds) The semantic web—ISWC 2011, Proceedings of the 10th international semantic web conference, part II, Bonn, Germany, October 2011. Lecture notes in computer science, vol 7032. Springer, Heidelberg, pp 112–127

    Google Scholar 

  • Knoth P, Robotka V, Zdrahal Z (2011) Connecting repositories in the open access domain using text mining and semantic data. In: Gradmann S, Borri F, Meghini C et al (eds) Research and advanced technology for digital libraries, Proceedings of the international conference on theory and practice of digital libraries 2011 (TPDL 2011), Berlin, Germany, September 2011. Lecture notes in computer science, vol 6966. Springer, Heidelberg, pp 483–487

    Google Scholar 

  • Konstantinou N, Spanos DE, Mitrou N (2008) Ontology and database mapping: a survey of current implementations and future directions. J Web Eng 7(1):1–24

    Google Scholar 

  • Konstantinou N, Spanos DE, Stavrou P et al (2010) Technically approaching the semantic web bottleneck. Int J Web Eng Technol 6(1):83–111

    Article  Google Scholar 

  • Konstantinou N, Houssos N, Manta A (2013) Exposing bibliographic information as linked open data using standards-based mappings: methodology and results. 3rd international conference on integrated information (IC-ININFO ’13), Elsevier, Prague, Czech Republic

    Google Scholar 

  • Konstantinou N, Spanos DE, Mitrou N (2013) Transient and persistent RDF views over relational databases in the context of digital repositories. In: Garoufallou E, Greenberg J (eds) Metadata and semantics research. Proceedings of the 7th MTSR conference, Thessaloniki, Greece, November 2013. Communications in Computer and Information Science, vol 390. Springer, Heidelberg, pp 342–354

    Google Scholar 

  • Konstantinou N, Spanos DE, Houssos N et al (2014a) Exposing scholarly information as linked open data: RDFizing DSpace contents. Electronic Library 32(6):834–851

    Article  Google Scholar 

  • Konstantinou N, Kouis D, Mitrou N (2014b) Incremental export of relational database contents into RDF graphs. In: Akerkar R, Bassiliades N, Davies J et al (eds) Proceedings of the 4th international conference on web intelligence, mining and semantics (WIMS ’14), June 2014, Thessaloniki, Greece. ACM, New York

    Google Scholar 

  • Lu J, Cao F, Ma L et al (2007) An effective SPARQL support over relational databases. In: Christophides V, Collard M, Gutierrez C (eds) Semantic web, ontologies and databases: VLDB workshop (SWDB-ODBIS 2007), Vienna, Austria, September 2007. Lecture notes in computer science, vol 5005. Springer, Heidelberg, pp 57–76

    Google Scholar 

  • Mulwad V, Finin T, Syed Z et al (2010) Using linked data to interpret tables. In: Hartig O, Harth A, Sequeda J (eds) Proceedings of the first international workshop on consuming linked data (COLD 2010), Shanghai, China, November 2010. CEUR workshop proceedings. vol 667

    Google Scholar 

  • Poggi A, Lembo D, Calvanese D et al (2008) Linking data to ontologies. J Data Semantics 10:133–173

    Google Scholar 

  • Priyatna F, Corcho O, Sequeda J (2014) Formalisation and experiences of R2RML-based SPARQL to SQL query translation using morph. In: Proceedings of the 23rd international conference on World Wide Web (WWW’14), Seoul, Republic of Korea. ACM, New York, USA, pp 479–490

    Google Scholar 

  • Ramanujam S, Khadilkar V, Khan L et al (2010) Update-enabled triplification of relational data into virtual RDF stores. Int J Semantic Comput 4(4):423–451

    Article  Google Scholar 

  • Rodriguez-Muro M, Kontchakov R, Zakharyaschev M (2013) Ontology-based data access: ontop of databases. In: Alani H, Kagal L, Fokoue A et al (eds) The semantic web—ISWC 2013, Proceedings of the 12th international semantic web conference, October 2013, Sydney, Australia. Lecture notes in computer science, vol 8218. Springer, Heidelberg, pp 558–573

    Google Scholar 

  • Sahoo S, Halb W, Hellmann S et al (2009) A survey of current approaches for mapping of relational databases to RDF. World wide web consortium. http://www.w3.org/2005/Incubator/rdb2rdf/RDB2RDF_SurveyReport.pdf. Accessed 26 Dec 2014

  • Sequeda JF, Tirmizi SH, Corcho O et al (2009) Direct mapping SQL databases to the semantic web: a survey. University of Texas, Austin, Department of Computer Sciences. ftp://ftp.cs.utexas.edu/pub/techreports/tr09-04.pdf. Accessed 26 Dec 2014

  • Sequeda JF, Miranker DP (2013) Ultrawrap: SPARQL execution on relational data. J Web Semantics 22:19–39

    Article  Google Scholar 

  • Sheth AP, Larson JA (1990) Federated database systems for managing distributed, heterogeneous, and autonomous databases. ACM Computing Surveys 22(3):183–236

    Article  Google Scholar 

  • Spanos DE, Stavrou P, Mitrou N (2012) Bringing relational databases into the semantic web: a survey. Semantic Web J 3(2):169–209

    Google Scholar 

  • Stevenson A (2011) Linked data—the future for open repositories? Presentation at the open repositories (OR 2011) conference, Austin, TX

    Google Scholar 

  • Tirmizi SH, Sequeda JF, Miranker DP (2008) Translating SQL applications to the semantic web. In: Bhowmick SS, Küng J, Wagner R (eds) Database and expert systems applications: 19th international conference (DEXA 2008), Turin, Italy, September 2008. Lecture notes in computer science, vol 5181. Springer, Heidelberg, pp 450–464

    Google Scholar 

  • Volz J, Bizer C, Gaedke M et al (2009) Discovering and maintaining links on the web of data. In: Bernstein A, Karger DR, Heath T et al (eds.) The semantic web—ISWC 2009: Proceedings of the 8th international semantic web conference, Washington DC, October 2009. Lecture notes in computer science, vol 5823. Springer, Heidelberg, pp 650–665

    Google Scholar 

  • Volz R, Handschuh S, Staab S et al (2004) Unveiling the hidden bride: deep annotation for mapping and migrating legacy data to the semantic web. J Web Semantics 1(2):187–206

    Article  Google Scholar 

  • Wache H, Vögele T, Visser U et al (2001) Ontology-based integration of information—a survey of existing approaches. In: Gómez-Pérez A, Gruninger M, Stuckenschmidt H et al (eds) Proceedings of the IJCAI-01 workshop on ontologies and information sharing, Seattle, USA, August 2001. CEUR Workshop Proceedings,, vol 47, pp 108–117

    Google Scholar 

  • Zhao S, Chang E (2007) From database to semantic web ontology: an overview. In: Meersman R, Tari Z, Herrero P (eds) On the move to meaningful internet systems: OTM 2007 Workshops. Lecture notes in computer science, vol 4806. Springer, Heidelberg, pp 1205–1214

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. National Technical University of Athens, Athens, Greece

    Nikolaos Konstantinou & Dimitrios-Emmanuel Spanos

Authors
  1. Nikolaos Konstantinou
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Dimitrios-Emmanuel Spanos
    View author publications

    You can also search for this author in PubMed Google Scholar

Rights and permissions

Reprints and permissions

Copyright information

© 2015 Springer International Publishing Switzerland

About this chapter

Cite this chapter

Konstantinou, N., Spanos, DE. (2015). Creating Linked Data from Relational Databases. In: Materializing the Web of Linked Data. Springer, Cham. https://doi.org/10.1007/978-3-319-16074-0_4

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-16074-0_4

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-319-16073-3

  • Online ISBN: 978-3-319-16074-0

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation