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
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
Abadi, D.J., Marcus, A., Madden, S., Hollenbach, K.J.: Scalable Semantic Web data management using vertical partitioning. In: VLDB (2007)
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
Beckett, D.: Redland RDF Application Framework. http://librdf.org/
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/
Bizer, C., Schultz, A.: Berlin SPARQL Benchmark Results. http://www4.wiwiss.fu-berlin.de/bizer/BerlinSPARQLBenchmark/results/index.html
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
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
Erling, O.: ISWC 2008: Billion Triples Challenge. http://www.openlinksw.com/dataspace/oerling/weblog/Orri%20Erling’s%20Blog/1478
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
Mikhailov, I.: Updating Relational Data Via SPARUL (Updatable RDF Views). http://esw.w3.org/topic/UpdatingRelationalDataViaSPARUL
Prudhommeaux, E.: SPASQL: SPARQL Support in MySQL. http://xtech06.usefulinc.com/schedule/paper/156
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
Intellidimension RDF Gateway. http://www.intellidimension.com
Jena Semantic Web Framework. http://jena.sourceforge.net/
Northrop Grumman Corporation: Kowari Metastore. http://www.kowari.org/
Oracle and HP smash world record for TPC-H 10 TB data warehousing benchmark. http://dssresources.com/news/316.php
Oracle Real Application Clusters. http://www.oracle.com/database/rac_home.html
Oracle Semantic Technologies Center. http://www.oracle.com/technology/tech/semantic_technologies/index.html
Semantically-Interlinked Online Communities. http://sioc-project.org/
Getting Started with Freebase. http://www.freebase.com/view/guid/9202a8c04000641f8000000005b82619
Vertica—Column-store based DBMS. http://www.vertica.com/
Extensible Business Reporting Language (XBRL) 2.1. http://www.xbrl.org/Specification/XBRL-RECOMMENDATION-2003-12-31+Corrected-Errata-2006-12-18.rtf
About MusicBrainz. http://musicbrainz.org/doc/AboutMusicBrainz
About Geonames. http://www.geonames.org/about.html
Ping The Semantic Web. http://pingthesemanticweb.com/about.php
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights 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)