Skip to main content

Virtuoso: RDF Support in a Native RDBMS

  • Chapter
  • First Online:
Semantic Web Information Management

Abstract

RDF (Resource Description Framework) is seeing rapidly increasing adoption, for example, in the context of the Linked Open Data (LOD) movement and diverse life sciences data publishing and integration projects. This paper discusses how we have adapted OpenLink Virtuoso, a general purpose RDBMS, for this new type of workload. We discuss adapting Virtuoso’s relational engine for native RDF support with dedicated data types, bitmap indexing and SQL optimizer techniques. We further discuss scaling out by running on a cluster of commodity servers, each with local memory and disk. We look at how this impacts query planning and execution and how we achieve high parallel utilization of multiple CPU cores on multiple servers. We present comparisons with other RDF storage models as well as other approaches to scaling out on server clusters. We present conclusions and metrics as well as a number of use cases, from DBpedia to bio informatics and collaborative web applications.

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

Access this chapter

eBook
USD 16.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 109.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info
Hardcover Book
USD 109.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

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Abadi, D.J., Marcus, A., Madden, S., Hollenbach, K.J.: Scalable Semantic Web data management using vertical partitioning. In: VLDB (2007)

    Google Scholar 

  2. Auer, S., Lehmann, J.: What have Innsbruck and Leipzig in common? In: Extracting Semantics from Wiki Content 4th European Semantic Web Conference. http://www.informatik.uni-leipzig.de/~auer/publication/ExtractingSemantics.pdf

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

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

  5. Bizer, C., Schultz, A.: Berlin SPARQL Benchmark Results. http://www4.wiwiss.fu-berlin.de/bizer/BerlinSPARQLBenchmark/results/index.html

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

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

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

  9. Guo, Y., Pan, Z., Heflin, J.: LUBM: a benchmark for OWL knowledge base systems. J. Web Semant. 3(2), 158–182 (2005). Available via http://www.websemanticsjournal.org/ps/pub/2005-16

    Google Scholar 

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

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

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

  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 and HP smash world record for TPC-H 10 TB data warehousing benchmark. http://dssresources.com/news/316.php

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

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

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

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

  21. Vertica—Column-store based DBMS. http://www.vertica.com/

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

  23. About MusicBrainz. http://musicbrainz.org/doc/AboutMusicBrainz

  24. About Geonames. http://www.geonames.org/about.html

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

Download references

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Orri Erling .

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2010 Springer-Verlag Berlin Heidelberg

About this chapter

Cite this chapter

Erling, O., Mikhailov, I. (2010). Virtuoso: RDF Support in a Native RDBMS. In: de Virgilio, R., Giunchiglia, F., Tanca, L. (eds) Semantic Web Information Management. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-04329-1_21

Download citation

  • DOI: https://doi.org/10.1007/978-3-642-04329-1_21

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-642-04328-4

  • Online ISBN: 978-3-642-04329-1

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics