RDF Support in the Virtuoso DBMS

  • Orri Erling
  • Ivan Mikhailov
Part of the Studies in Computational Intelligence book series (SCI, volume 221)


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.


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.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 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)CrossRefGoogle Scholar
  2. 2.
    Beckett, D.: Redland RDF Application Framework,
  3. 3.
    Bizer, C., Cyganiak, R., Garbers, J., Maresch, O.: D2RQ: Treating Non-RDF Databases as Virtual RDF Graphs,
  4. 4.
    Bizer, C., Heath, T., Ayers, D., Raimond, Y.: Interlinking Open Data on the Web. In: 4th European Semantic Web Conference,
  5. 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,
  6. 6.
  7. 7.
    Erling, O.: Virtuoso Vs. MySQL: Setting the Berlin Record Straight,’s%20Blog/1484
  8. 8.
    Guo, Y., Pan, Z., Heflin, J.: LUBM: A Benchmark for OWL Knowledge Base Systems. Journal of Web Semantics 3(2), 158–182 (2005), Google Scholar
  9. 9.
    Mikhailov, I.: Updating Relational Data Via SPARUL (Updatable RDF Views),
  10. 10.
    Prudhommeaux, E.: SPASQL: SPARQL Support in MySQL,
  11. 11.
    Ruttenberg, A.: Harnessing the Semantic Web to Answer Scientific Questions. In: 16th International World Wide Web Conference,
  12. 12.
    3store, an RDF triple store,
  13. 13.
    Intellidimension RDF Gateway,
  14. 14.
    Jena Semantic Web Framework,
  15. 15.
    Northrop Grumman Corporation: Kowari Metastore,
  16. 16.
  17. 17.
    Semantically-Interlinked Online Communities,
  18. 18.
  19. 19.
    Wikipedia3: A Conversion of the English Wikipedia into RDF,
  20. 20.
  21. 21.
  22. 22.
  23. 23.
  24. 24.
    Oracle Real Application Clusters,

Copyright information

© Springer-Verlag Berlin Heidelberg 2009

Authors and Affiliations

  • Orri Erling
    • 1
  • Ivan Mikhailov
    • 2
  1. 1.OpenLink SoftwareBurlingtonU.S.A
  2. 2.OpenLink Software 

Personalised recommendations