Skip to main content

Virtuoso: RDF Support in a Native RDBMS

  • Chapter
  • First Online:
Semantic Web Information Management


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

Subscribe and save

Springer+ Basic
EUR 32.99 /Month
  • Get 10 units per month
  • Download Article/Chapter or eBook
  • 1 Unit = 1 Article or 1 Chapter
  • Cancel anytime
Subscribe now

Buy Now

USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
USD 84.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


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Similar content being viewed by others


  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.

  3. Beckett, D.: Redland RDF Application Framework.

  4. Bizer, C., Cyganiak, R., Garbers, J., Maresch, O.: D2RQ: Treating Non-RDF Databases as Virtual RDF Graphs.

  5. Bizer, C., Schultz, A.: Berlin SPARQL Benchmark Results.

  6. Bizer, C., Heath, T., Ayers, D., Raimond, Y.: Interlinking open data on the web. In: 4th European Semantic Web Conference.

  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.

  8. Erling, O.: ISWC 2008: Billion Triples Challenge.’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

    Google Scholar 

  10. Mikhailov, I.: Updating Relational Data Via SPARUL (Updatable RDF Views).

  11. Prudhommeaux, E.: SPASQL: SPARQL Support in MySQL.

  12. Ruttenberg, A.: Harnessing the Semantic Web to answer scientific questions. In: 16th International World Wide Web Conference.

  13. Intellidimension RDF Gateway.

  14. Jena Semantic Web Framework.

  15. Northrop Grumman Corporation: Kowari Metastore.

  16. Oracle and HP smash world record for TPC-H 10 TB data warehousing benchmark.

  17. Oracle Real Application Clusters.

  18. Oracle Semantic Technologies Center.

  19. Semantically-Interlinked Online Communities.

  20. Getting Started with Freebase.

  21. Vertica—Column-store based DBMS.

  22. Extensible Business Reporting Language (XBRL) 2.1.

  23. About MusicBrainz.

  24. About Geonames.

  25. Ping The Semantic Web.

Download references

Author information

Authors and Affiliations


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.

Download citation

  • DOI:

  • 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