No Size Fits All -- Running the Star Schema Benchmark with SPARQL and RDF Aggregate Views

Presented at: 10th ESWC 2013 (ESWC2013)

by Benedikt Kämpgen, Andreas Harth

Statistics published as Linked Data promise efficient extraction, transformation and loading (ETL) into a database for decision support. The predominant way to implement analytical query capabilities in industry are specialised engines that translate OLAP queries to SQL queries on a relational database using a star schema (ROLAP). A more direct approach than ROLAP is to load Statistical Linked Data into an RDF store and to answer OLAP queries using SPARQL. However, we assume that general-purpose triple stores -- just as typical relational databases -- are no perfect fit for analytical workloads and need to be complemented by OLAP-to-SPARQL engines. To give an empirical argument for the need of such an engine, we first compare our generated SPARQL to ROLAP SQL queries in terms of performance. Second, we measure the performance gain of RDF aggregate views that, similar to aggregate tables in ROLAP, materialise part of the data cube.

Keywords: Aggregate Views, Linked Data, OLAP, Star Schema Benchmark

Resource URI on the dog food server:

Explore this resource elsewhere: