Skip to main content

RDF Support in the Virtuoso DBMS

  • Chapter

Part of the Studies in Computational Intelligence book series (SCI,volume 221)

Abstract

This paper discusses RDF related work in the context of OpenLink Virtuoso, a general purpose relational / federated database and applications platform. The use cases are dual 1. large RDF repositories 2. making arbitrary relational data queriable with SPARQL and RDF by mapping on demand. We discuss adapting a relational engine for native RDF support with dedicated data types, bitmap indexing and SQL optimizer techniques. We discuss adaptations of the query engine for running on shared nothing clusters, providing virtually unbounded scalability for RDF or relational warehouses. We further discuss mapping existing relational data into RDF for SPARQL access without converting the data into physical triples. We present conclusions and metrics as well as a number of use cases, from DBpedia to bio informatics and collaborative web applications.

Keywords

  • Query Optimization
  • SPARQL Query
  • Triple Store
  • Bitmap Index
  • Federate Database

These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

This is a preview of subscription content, access via your institution.

Buying options

Chapter
USD   29.95
Price excludes VAT (Canada)
  • DOI: 10.1007/978-3-642-02184-8_2
  • Chapter length: 18 pages
  • Instant PDF download
  • Readable on all devices
  • Own it forever
  • Exclusive offer for individuals only
  • Tax calculation will be finalised during checkout
eBook
USD   189.00
Price excludes VAT (Canada)
  • ISBN: 978-3-642-02184-8
  • Instant PDF download
  • Readable on all devices
  • Own it forever
  • Exclusive offer for individuals only
  • Tax calculation will be finalised during checkout
Softcover Book
USD   269.00
Price excludes VAT (Canada)
Hardcover Book
USD   249.99
Price excludes VAT (Canada)

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Auer, S., Lehmann, J.: What Have Innsbruck and Leipzig in Common? Extracting Semantics from Wiki Content. In: Franconi, E., Kifer, M., May, W. (eds.) ESWC 2007. LNCS, vol. 4519, pp. 503–517. Springer, Heidelberg (2007)

    CrossRef  Google Scholar 

  2. Beckett, D.: Redland RDF Application Framework, http://librdf.org/

  3. Bizer, C., Cyganiak, R., Garbers, J., Maresch, O.: D2RQ: Treating Non-RDF Databases as Virtual RDF Graphs, http://sites.wiwiss.fu-berlin.de/suhl/bizer/D2RQ/

  4. Bizer, C., Heath, T., Ayers, D., Raimond, Y.: Interlinking Open Data on the Web. In: 4th European Semantic Web Conference, http://www.eswc2007.org/pdf/demo-pdf/LinkingOpenData.pdf

  5. Chen, H., Wang, Y., Wang, H., et al.: Towards a Semantic Web of Relational Databases: a Practical Semantic Toolkit and an In-Use Case from Traditional Chinese Medicine, http://iswc2006.semanticweb.org/items/Chen2006kx.pdf

  6. Erling O.: ISWC 2008: Billion Triples Challenge, http://www.openlinksw.com/dataspace/oerling/weblog/Orri%20Erling’s%20Blog/1478

  7. Erling, O.: Virtuoso Vs. MySQL: Setting the Berlin Record Straight, http://www.openlinksw.com/dataspace/oerling/weblog/Orri%20Erling’s%20Blog/1484

  8. Guo, Y., Pan, Z., Heflin, J.: LUBM: A Benchmark for OWL Knowledge Base Systems. Journal of Web Semantics 3(2), 158–182 (2005), http://www.websemanticsjournal.org/ps/pub/2005-16

    Google Scholar 

  9. Mikhailov, I.: Updating Relational Data Via SPARUL (Updatable RDF Views), http://esw.w3.org/topic/UpdatingRelationalDataViaSPARUL

  10. Prudhommeaux, E.: SPASQL: SPARQL Support in MySQL, http://xtech06.usefulinc.com/schedule/paper/156

  11. Ruttenberg, A.: Harnessing the Semantic Web to Answer Scientific Questions. In: 16th International World Wide Web Conference, http://www.w3.org/2007/Talks/www2007-AnsweringScientificQuestions-Ruttenberg.pdf

  12. 3store, an RDF triple store, http://sourceforge.net/projects/threestore

  13. Intellidimension RDF Gateway, http://www.intellidimension.com

  14. Jena Semantic Web Framework, http://jena.sourceforge.net/

  15. Northrop Grumman Corporation: Kowari Metastore, http://www.kowari.org/

  16. Oracle Semantic Technologies Center, http://www.oracle.com/technology/tech/semantic_technologies/index.html

  17. Semantically-Interlinked Online Communities, http://sioc-project.org/

  18. Getting Started with Freebase, http://www.freebase.com/view/guid/9202a8c04000641f8000000005b82619

  19. Wikipedia3: A Conversion of the English Wikipedia into RDF, http://labs.systemone.at/wikipedia3

  20. Extensible Business Reporting Language (XBRL) 2.1, http://www.xbrl.org/Specification/XBRL-RECOMMENDATION-2003-12-31+Corrected-Errata-2006-12-18.rtf

  21. About MusicBrainz, http://musicbrainz.org/doc/AboutMusicBrainz

  22. About Geonames, http://www.geonames.org/about.html

  23. Ping The Semantic Web, http://pingthesemanticweb.com/about.php

  24. Oracle Real Application Clusters, http://www.oracle.com/database/rac_home.html

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and Permissions

Copyright information

© 2009 Springer-Verlag Berlin Heidelberg

About this chapter

Cite this chapter

Erling, O., Mikhailov, I. (2009). RDF Support in the Virtuoso DBMS. In: Pellegrini, T., Auer, S., Tochtermann, K., Schaffert, S. (eds) Networked Knowledge - Networked Media. Studies in Computational Intelligence, vol 221. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-02184-8_2

Download citation

  • DOI: https://doi.org/10.1007/978-3-642-02184-8_2

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-642-02183-1

  • Online ISBN: 978-3-642-02184-8

  • eBook Packages: EngineeringEngineering (R0)