Global Cube Evaluation EKAW14
From www.b-kaempgen.de
Contents
- 1 Info
- 2 Resources
- 3 Setup
- 4 Queries
- 4.1 Unemployment Fear and GDP Growth (UNEMPLOY)
- 4.2 Comparing EU 2020 - Indicators (EU2020a): 4 Datasets
- 4.3 Comparing EU 2020 - Indicators (EU2020b): 8 Datasets
- 4.4 GDP per Capita from Different Sources (GDP_CAP)
- 4.4.1 Correspondences (GDP_CAP)
- 4.4.2 Logical query plan (GDP_CAP)
- 4.4.3 Physical query plan (GDP_CAP)
- 4.4.4 Query times (GDP_CAP)
- 4.4.5 Output (GDP_CAP)
- 4.4.6 Prolog program for enumerating all possible derived datasets of GDP_CAP scenario (GDP_CAP)
- 4.4.7 Example prolog program with additional EUR2MIO correspondence leading to a cycle (GDP_CAP)
- 4.4.8 Program for computing the number of derived data cubes in case conversion correspondences are seen as merging correspondences and no cycles (repeated application of correspondences) are allowed
Info
On this page we collect information for the evaluation and analysis in the paper "Querying the Global Cube: Integration of Multidimensional Datasets from the Web" accepted at EKAW 2014.
Resources
- Olap4ld
- Tagged version for paper: global_cube_ekaw_v2 [1]
- Vocabularies
- Data
- All online, but dump can be downloaded from [4].
Setup
- VM Setup
-Xms512M -Xmx1524M -XX:PermSize=512M -XX:MaxPermSize=1000M
- OLAP4LD Setup
- Linked Data Engine: EmbeddedSesameEngine
- Directed Crawling includes (covering most of [5]; exceptions: dimension values, rdfs:seeAlso, owl:sameAs...)
- Normalization (covering most of [6])
- Integrity Constraint Checks (covering most of [7]; exceptions: quadratic checks)
- Reasoning: Duplication Approach using Equivalence Rules [8]
- Manually created links:
<http://lod.gesis.org/lodpilot/ALLBUS/geo.rdf#list> <http://www.w3.org/2002/07/owl#sameAs> <http://rdfdata.eionet.europa.eu/ramon/ontology/NUTSRegion>. <http://lod.gesis.org/lodpilot/ALLBUS/geo.rdf#00> <http://www.w3.org/2002/07/owl#sameAs> <http://estatwrap.ontologycentral.com/dic/geo#DE>. More at: http://people.aifb.kit.edu/bka/Public/cube_additionalRDF.rdf
Queries
Unemployment Fear and GDP Growth (UNEMPLOY)
Info:
- Performance test case: LDCX_Performance_Evaluation_DrillAcrossTest.executeDrillAcrossUnemploymentFearAndRealGDPGrowthRateGermany()
MDX query (UNEMPLOY)
SELECT /* $session: ldcx_performance_evaluation_testGdpEmployment */ {[httpXXX3AXXX2FXXX2FpurlYYYorgXXX2FlinkedZZZdataXXX2FsdmxXXX2F2009XXX2FmeasureXXX23obsValuehttpXXX3AXXX2FXXX2FlodYYYgesisYYYorgXXX2FlodpilotXXX2FALLBUSXXX2FZA4570v590YYYrdfXXX23dsAGGFUNCAVG], [httpXXX3AXXX2FXXX2FpurlYYYorgXXX2FlinkedZZZdataXXX2FsdmxXXX2F2009XXX2FmeasureXXX23obsValuehttpXXX3AXXX2FXXX2FestatwrapYYYontologycentralYYYcomXXX2FidXXX2Ftec00115XXX23dsAGGFUNCAVG]} ON COLUMNS, CrossJoin(Members([httpXXX3AXXX2FXXX2FpurlYYYorgXXX2FdcXXX2FtermsXXX2Fdate]),Members([httpXXX3AXXX2FXXX2FlodYYYgesisYYYorgXXX2FlodpilotXXX2FALLBUSXXX2FvocabYYYrdfXXX23geo])) ON ROWS FROM [httpXXX3AXXX2FXXX2FlodYYYgesisYYYorgXXX2FlodpilotXXX2FALLBUSXXX2FZA4570v590YYYrdfXXX23dsXXX2ChttpXXX3AXXX2FXXX2FestatwrapYYYontologycentralYYYcomXXX2FidXXX2Ftec00115XXX23ds] WHERE {[httpXXX3AXXX2FXXX2FlodYYYgesisYYYorgXXX2FlodpilotXXX2FALLBUSXXX2FgeoYYYrdfXXX2300]}
OLAP query (UNEMPLOY)
Drill-across(
Rollup (Slice (Dice (Projection (BaseCube (http://lod.gesis.org/lodpilot/ALLBUS/ZA4570v590.rdf#ds), {http://purl.org/linked-data/sdmx/2009/measure#obsValue}), (http://lod.gesis.org/lodpilot/ALLBUS/geo.rdf#list = http://lod.gesis.org/lodpilot/ALLBUS/geo.rdf#00)), {http://lod.gesis.org/lodpilot/ALLBUS/vocab.rdf#variable, http://ontologycentral.com/2009/01/eurostat/ns#geo}), {}),
Rollup (Slice (Dice (Projection (BaseCube (http://estatwrap.ontologycentral.com/id/tec00115#ds), {http://purl.org/linked-data/sdmx/2009/measure#obsValue}), (http://lod.gesis.org/lodpilot/ALLBUS/geo.rdf#list = http://lod.gesis.org/lodpilot/ALLBUS/geo.rdf#00)), {http://ontologycentral.com/2009/01/eurostat/ns#geo, http://ontologycentral.com/2009/01/eurostat/ns#unit}), {})
)
Physical query / SPARQL query (UNEMPLOY)
Execute logical query plan: Physical query plan: Nested-Loop over (
OLAP-2-SPARQL query (SparqlSesame): PREFIX dc: <http://purl.org/dc/elements/1.1/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX sdmx-measure: <http://purl.org/linked-data/sdmx/2009/measure#>
PREFIX skosclass: <http://ddialliance.org/ontologies/skosclass#>
PREFIX eus: <http://ontologycentral.com/2009/01/eurostat/ns#>
PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX qb: <http://purl.org/linked-data/cube#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX dcterms: <http://purl.org/dc/terms/>
select ?httplodgesisorglodpilotALLBUSvocabrdfgeo0 ?httppurlorgdctermsdate0 (GROUP_CONCAT(?httppurlorglinkeddatasdmx2009measureobsValue) as ?httppurlorglinkeddatasdmx2009measureobsValue_new ) where { ?obs qb:dataSet <http://lod.gesis.org/lodpilot/ALLBUS/ZA4570v590.rdf#ds>. ?obs ?httplodgesisorglodpilotALLBUSvocabrdfgeoDimension ?httplodgesisorglodpilotALLBUSvocabrdfgeo0. filter(?httplodgesisorglodpilotALLBUSvocabrdfgeoDimension = <http://lod.gesis.org/lodpilot/ALLBUS/vocab.rdf#geo>) ?obs ?httppurlorgdctermsdateDimension ?httppurlorgdctermsdate0. filter(?httppurlorgdctermsdateDimension = <http://purl.org/dc/terms/date>) FILTER (?httplodgesisorglodpilotALLBUSvocabrdfgeo0 = <http://lod.gesis.org/lodpilot/ALLBUS/geo.rdf#00>) ?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?httppurlorglinkeddatasdmx2009measureobsValue.} group by ?httplodgesisorglodpilotALLBUSvocabrdfgeo0 ?httppurlorgdctermsdate0 order by ?httplodgesisorglodpilotALLBUSvocabrdfgeo0 ?httppurlorgdctermsdate0 ,
OLAP-2-SPARQL query (SparqlSesame): PREFIX dc: <http://purl.org/dc/elements/1.1/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX sdmx-measure: <http://purl.org/linked-data/sdmx/2009/measure#>
PREFIX skosclass: <http://ddialliance.org/ontologies/skosclass#>
PREFIX eus: <http://ontologycentral.com/2009/01/eurostat/ns#>
PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX qb: <http://purl.org/linked-data/cube#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX dcterms: <http://purl.org/dc/terms/>
select ?httplodgesisorglodpilotALLBUSvocabrdfgeo0 ?httppurlorgdctermsdate0 (GROUP_CONCAT(?httppurlorglinkeddatasdmx2009measureobsValue) as ?httppurlorglinkeddatasdmx2009measureobsValue_new ) where { ?obs qb:dataSet <http://estatwrap.ontologycentral.com/id/tec00115#ds>. ?obs ?httplodgesisorglodpilotALLBUSvocabrdfgeoDimension ?httplodgesisorglodpilotALLBUSvocabrdfgeo0. filter(?httplodgesisorglodpilotALLBUSvocabrdfgeoDimension = <http://lod.gesis.org/lodpilot/ALLBUS/vocab.rdf#geo>) ?obs ?httppurlorgdctermsdateDimension ?httppurlorgdctermsdate0. filter(?httppurlorgdctermsdateDimension = <http://purl.org/dc/terms/date>) FILTER (?httplodgesisorglodpilotALLBUSvocabrdfgeo0 = <http://lod.gesis.org/lodpilot/ALLBUS/geo.rdf#00>) ?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?httppurlorglinkeddatasdmx2009measureobsValue.} group by ?httplodgesisorglodpilotALLBUSvocabrdfgeo0 ?httppurlorgdctermsdate0 order by ?httplodgesisorglodpilotALLBUSvocabrdfgeo0 ?httppurlorgdctermsdate0 )
Output (UNEMPLOY)
Output: | | | | | Observation | +--+------+--+-----+-------------------+ | | 1980 | | 00 | 1126 42 46 | | | | | | 1126 42 46 | | | 1991 | | 00 | 989 344 135 | | | | | | 989 344 135 | | | 1992 | | 00 | 1265 213 99 | | | | | | 1265 213 99 | | | 1994 | | 00 | 1388 209 111 | | | | | | 1388 209 111 | | | 1996 | | 00 | 1337 260 100 | | | | | | 1337 260 100 | | | 1998 | | 00 | 935 254 113 | | | | | | 935 254 113 | | | 2000 | | 00 | 1357 201 99 | | | | | | 1357 201 99 | | | 2004 | | 00 | 895 204 84 | | | | | | 895 204 84 | | | 2006 | | 00 | 1022 255 84 / 3.7 | | | | | | 1022 255 84 / 3.7 | | | 2008 | | 00 | 1144 160 80 / 1.1 | | | | | | 1144 160 80 / 1.1 | | | 2007 | | 00 | 3.3 | | | | | | 3.3 | | | 2009 | | 00 | -5.1 | | | | | | -5.1 | | | 2010 | | 00 | 4.0 | | | | | | 4.0 | | | 2011 | | 00 | 3.3 | | | | | | 3.3 | | | 2012 | | 00 | 0.7 | | | | | | 0.7 | | | 2013 | | 00 | 0.4 | | | | | | 0.4 | | | 1980 | | 00 | 1126 42 46 | | | | | | 1126 42 46 | | | 1991 | | 00 | 989 344 135 | | | | | | 989 344 135 | | | 1992 | | 00 | 1265 213 99 | | | | | | 1265 213 99 | | | 1994 | | 00 | 1388 209 111 | | | | | | 1388 209 111 | | | 1996 | | 00 | 1337 260 100 | | | | | | 1337 260 100 | | | 1998 | | 00 | 935 254 113 | | | | | | 935 254 113 | | | 2000 | | 00 | 1357 201 99 | | | | | | 1357 201 99 | | | 2004 | | 00 | 895 204 84 | | | | | | 895 204 84 | | | 2006 | | 00 | 1022 255 84 / 3.7 | | | | | | 1022 255 84 / 3.7 | | | 2008 | | 00 | 1144 160 80 / 1.1 | | | | | | 1144 160 80 / 1.1 | | | 2007 | | 00 | 3.3 | | | | | | 3.3 | | | 2009 | | 00 | -5.1 | | | | | | -5.1 | | | 2010 | | 00 | 4.0 | | | | | | 4.0 | | | 2011 | | 00 | 3.3 | | | | | | 3.3 | | | 2012 | | 00 | 0.7 | | | | | | 0.7 | | | 2013 | | 00 | 0.4 | | | | | | 0.4 |
Query times (UNEMPLOY)
Querytime | Query | Triples | Loading and validating dataset | Generating logical query plan | Executing logical query plan | Transmission
18:37:48.194 [main] INFO edu.kit.aifb.exrunner.ExperimentRun - paramSet={generatelogicalqueryplantime=3179, lookupscount=12, executemetadataqueriestime=5584, triplescount=3897, queryname= testGdpEmployment , loadvalidatedatasetstime=10895, generatephysicalqueryplantime=2803, executephysicalqueryplantime=38, executemetadataqueriescount=41, datasetscount=2, observationscount=362, querytime=Sep 21, 2014 6:29:54 PM } executionValues={}
18:37:48.496 [main] INFO edu.kit.aifb.exrunner.ExperimentRun - paramSet={generatelogicalqueryplantime=2402, lookupscount=12, executemetadataqueriestime=4924, triplescount=3897, queryname= testGdpEmployment , loadvalidatedatasetstime=10229, generatephysicalqueryplantime=2823, executephysicalqueryplantime=33, executemetadataqueriescount=41, datasetscount=2, observationscount=362, querytime=Sep 21, 2014 6:31:31 PM } executionValues={}
18:37:48.827 [main] INFO edu.kit.aifb.exrunner.ExperimentRun - paramSet={generatelogicalqueryplantime=3366, lookupscount=12, executemetadataqueriestime=5274, triplescount=3897, queryname= testGdpEmployment , loadvalidatedatasetstime=11826, generatephysicalqueryplantime=2745, executephysicalqueryplantime=38, executemetadataqueriescount=41, datasetscount=2, observationscount=362, querytime=Sep 21, 2014 6:30:17 PM } executionValues={}
18:37:49.186 [main] INFO edu.kit.aifb.exrunner.ExperimentRun - paramSet={generatelogicalqueryplantime=0, lookupscount=0, executemetadataqueriestime=0, triplescount=0, queryname=Default, loadvalidatedatasetstime=0, generatephysicalqueryplantime=0, executephysicalqueryplantime=2, executemetadataqueriescount=0, datasetscount=0, observationscount=0, querytime=Default} executionValues={}
18:37:49.503 [main] INFO edu.kit.aifb.exrunner.ExperimentRun - paramSet={generatelogicalqueryplantime=0, lookupscount=0, executemetadataqueriestime=0, triplescount=0, queryname=Default, loadvalidatedatasetstime=0, generatephysicalqueryplantime=0, executephysicalqueryplantime=4, executemetadataqueriescount=0, datasetscount=0, observationscount=0, querytime=Default} executionValues={}
- Triples: 16,989 vs. 3,897 (including duplicated due to reasoning, but apparently much less is crawled)
- Observations: 361 vs. 362
- Lookups: 14 vs. 12
- Loading and Validating: 9 vs. 11 (longer time since network bandwith worse)
- Metadata Query Time: 2 vs. 5
- Metadata Query Numbers: 28 vs. 41
- Generating Logical Qery Plan: 1 vs. 3
- Generating Physical Query Plan: 0.002 vs. 3 (done by LogicalToPhysical, is our new way, by depth first search after discussion with Andreas, may be slower than our previous approach, in any case, we are going through the logical query plan and create a physical query plan of iterators. Iterators are not initialised, yet. But includes the OLAP-to-SPARQL algorithm that translates OLAP to SPARQL.)
- Executing Physical Query Plan: 0.041 vs. 0.036
- Total: 12 vs. 22
Comparing EU 2020 - Indicators (EU2020a): 4 Datasets
Info:
- Performance test case: LDCX_Performance_Evaluation_DrillAcrossTest.executeDrillAcrossEu2020indicators4()
Datasets:
- Energy dependence: http://estatwrap.ontologycentral.com/id/tsdcc310 (2001-2012)
- Energy productivity: http://estatwrap.ontologycentral.com/id/t2020_rd310 (2000-2012)
- Energy intensity: http://estatwrap.ontologycentral.com/id/tsdec360 (2001-2012)
- Greenhouse gas emissions per capita: http://estatwrap.ontologycentral.com/id/t2020_rd300 (2000-2011)
MDX query (EU2020a)
SELECT
NON EMPTY {[httpXXX3AXXX2FXXX2FpurlYYYorgXXX2FlinkedZZZdataXXX2FsdmxXXX2F2009XXX2FmeasureXXX23obsValuehttpXXX3AXXX2FXXX2FestatwrapYYYontologycentralYYYcomXXX2FidXXX2Ftsdcc310XXX23dsAGGFUNCAVG], [httpXXX3AXXX2FXXX2FpurlYYYorgXXX2FlinkedZZZdataXXX2FsdmxXXX2F2009XXX2FmeasureXXX23obsValuehttpXXX3AXXX2FXXX2FestatwrapYYYontologycentralYYYcomXXX2FidXXX2Ft2020_rd310XXX23dsAGGFUNCAVG], [httpXXX3AXXX2FXXX2FpurlYYYorgXXX2FlinkedZZZdataXXX2FsdmxXXX2F2009XXX2FmeasureXXX23obsValuehttpXXX3AXXX2FXXX2FestatwrapYYYontologycentralYYYcomXXX2FidXXX2Ft2020_rd300XXX23dsAGGFUNCAVG], [httpXXX3AXXX2FXXX2FpurlYYYorgXXX2FlinkedZZZdataXXX2FsdmxXXX2F2009XXX2FmeasureXXX23obsValuehttpXXX3AXXX2FXXX2FestatwrapYYYontologycentralYYYcomXXX2FidXXX2Ftsdec360XXX23dsAGGFUNCAVG]} ON COLUMNS,
NON EMPTY {Members([httpXXX3AXXX2FXXX2FpurlYYYorgXXX2FdcXXX2FtermsXXX2Fdate])} ON ROWS
FROM [httpXXX3AXXX2FXXX2FestatwrapYYYontologycentralYYYcomXXX2FidXXX2Ftsdcc310XXX23dsXXX2ChttpXXX3AXXX2FXXX2FestatwrapYYYontologycentralYYYcomXXX2FidXXX2Ft2020_rd310XXX23dsXXX2ChttpXXX3AXXX2FXXX2FestatwrapYYYontologycentralYYYcomXXX2FidXXX2Ft2020_rd300XXX23dsXXX2ChttpXXX3AXXX2FXXX2FestatwrapYYYontologycentralYYYcomXXX2FidXXX2Ftsdec360XXX23ds]
OLAP query (EU2020a)
Drill-across(Drill-across(Drill-across(Rollup (Slice (Projection (BaseCube (http://estatwrap.ontologycentral.com/id/tsdcc310#ds), {http://purl.org/linked-data/sdmx/2009/measure#obsValuehttp://estatwrap.ontologycentral.com/id/tsdcc310#dsAGGFUNCAVG}), {http://lod.gesis.org/lodpilot/ALLBUS/vocab.rdf#geo, http://ontologycentral.com/2009/01/eurostat/ns#geo, http://ontologycentral.com/2009/01/eurostat/ns#indic_nrg, http://ontologycentral.com/2009/01/eurostat/ns#product, http://ontologycentral.com/2009/01/eurostat/ns#unit}), {}), Rollup (Slice (Projection (BaseCube (http://estatwrap.ontologycentral.com/id/t2020_rd310#ds), {http://purl.org/linked-data/sdmx/2009/measure#obsValuehttp://estatwrap.ontologycentral.com/id/t2020_rd310#dsAGGFUNCAVG}), {http://lod.gesis.org/lodpilot/ALLBUS/vocab.rdf#geo, http://ontologycentral.com/2009/01/eurostat/ns#geo, http://ontologycentral.com/2009/01/eurostat/ns#indic_na, http://ontologycentral.com/2009/01/eurostat/ns#unit}), {})), Rollup (Slice (Projection (BaseCube (http://estatwrap.ontologycentral.com/id/t2020_rd300#ds), {http://purl.org/linked-data/sdmx/2009/measure#obsValuehttp://estatwrap.ontologycentral.com/id/t2020_rd300#dsAGGFUNCAVG}), {http://lod.gesis.org/lodpilot/ALLBUS/vocab.rdf#geo, http://ontologycentral.com/2009/01/eurostat/ns#ai, http://ontologycentral.com/2009/01/eurostat/ns#geo, http://ontologycentral.com/2009/01/eurostat/ns#unit}), {})), Rollup (Slice (Projection (BaseCube (http://estatwrap.ontologycentral.com/id/tsdec360#ds), {http://purl.org/linked-data/sdmx/2009/measure#obsValuehttp://estatwrap.ontologycentral.com/id/tsdec360#dsAGGFUNCAVG}), {http://lod.gesis.org/lodpilot/ALLBUS/vocab.rdf#geo, http://ontologycentral.com/2009/01/eurostat/ns#geo, http://ontologycentral.com/2009/01/eurostat/ns#indic_en, http://ontologycentral.com/2009/01/eurostat/ns#product, http://ontologycentral.com/2009/01/eurostat/ns#unit}), {}))
Physical query plan (EU2020a)
Nested-Loop over (Nested-Loop over (Nested-Loop over (OLAP-2-SPARQL query (SparqlSesame): PREFIX dc: <http://purl.org/dc/elements/1.1/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX sdmx-measure: <http://purl.org/linked-data/sdmx/2009/measure#>
PREFIX skosclass: <http://ddialliance.org/ontologies/skosclass#>
PREFIX eus: <http://ontologycentral.com/2009/01/eurostat/ns#>
PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX qb: <http://purl.org/linked-data/cube#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX dcterms: <http://purl.org/dc/terms/>
select ?httppurlorgdctermsdate0 (avg(?httppurlorglinkeddatasdmx2009measureobsValue) as ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomidtsdcc310dsAGGFUNCAVG_new ) where { ?obs qb:dataSet <http://estatwrap.ontologycentral.com/id/tsdcc310#ds>. ?obs ?httppurlorgdctermsdateDimension ?httppurlorgdctermsdate0. filter(?httppurlorgdctermsdateDimension = <http://purl.org/dc/terms/date>) ?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?httppurlorglinkeddatasdmx2009measureobsValue.} group by ?httppurlorgdctermsdate0 order by ?httppurlorgdctermsdate0 ,OLAP-2-SPARQL query (SparqlSesame): PREFIX dc: <http://purl.org/dc/elements/1.1/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX sdmx-measure: <http://purl.org/linked-data/sdmx/2009/measure#>
PREFIX skosclass: <http://ddialliance.org/ontologies/skosclass#>
PREFIX eus: <http://ontologycentral.com/2009/01/eurostat/ns#>
PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX qb: <http://purl.org/linked-data/cube#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX dcterms: <http://purl.org/dc/terms/>
select ?httppurlorgdctermsdate0 (avg(?httppurlorglinkeddatasdmx2009measureobsValue) as ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomidt2020rd310dsAGGFUNCAVG_new ) where { ?obs qb:dataSet <http://estatwrap.ontologycentral.com/id/t2020_rd310#ds>. ?obs ?httppurlorgdctermsdateDimension ?httppurlorgdctermsdate0. filter(?httppurlorgdctermsdateDimension = <http://purl.org/dc/terms/date>) ?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?httppurlorglinkeddatasdmx2009measureobsValue.} group by ?httppurlorgdctermsdate0 order by ?httppurlorgdctermsdate0 ),OLAP-2-SPARQL query (SparqlSesame): PREFIX dc: <http://purl.org/dc/elements/1.1/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX sdmx-measure: <http://purl.org/linked-data/sdmx/2009/measure#>
PREFIX skosclass: <http://ddialliance.org/ontologies/skosclass#>
PREFIX eus: <http://ontologycentral.com/2009/01/eurostat/ns#>
PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX qb: <http://purl.org/linked-data/cube#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX dcterms: <http://purl.org/dc/terms/>
select ?httppurlorgdctermsdate0 (avg(?httppurlorglinkeddatasdmx2009measureobsValue) as ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomidt2020rd300dsAGGFUNCAVG_new ) where { ?obs qb:dataSet <http://estatwrap.ontologycentral.com/id/t2020_rd300#ds>. ?obs ?httppurlorgdctermsdateDimension ?httppurlorgdctermsdate0. filter(?httppurlorgdctermsdateDimension = <http://purl.org/dc/terms/date>) ?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?httppurlorglinkeddatasdmx2009measureobsValue.} group by ?httppurlorgdctermsdate0 order by ?httppurlorgdctermsdate0 ),OLAP-2-SPARQL query (SparqlSesame): PREFIX dc: <http://purl.org/dc/elements/1.1/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX sdmx-measure: <http://purl.org/linked-data/sdmx/2009/measure#>
PREFIX skosclass: <http://ddialliance.org/ontologies/skosclass#>
PREFIX eus: <http://ontologycentral.com/2009/01/eurostat/ns#>
PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX qb: <http://purl.org/linked-data/cube#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX dcterms: <http://purl.org/dc/terms/>
select ?httppurlorgdctermsdate0 (avg(?httppurlorglinkeddatasdmx2009measureobsValue) as ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomidtsdec360dsAGGFUNCAVG_new ) where { ?obs qb:dataSet <http://estatwrap.ontologycentral.com/id/tsdec360#ds>. ?obs ?httppurlorgdctermsdateDimension ?httppurlorgdctermsdate0. filter(?httppurlorgdctermsdateDimension = <http://purl.org/dc/terms/date>) ?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?httppurlorglinkeddatasdmx2009measureobsValue.} group by ?httppurlorgdctermsdate0 order by ?httppurlorgdctermsdate0 )
Sep 21, 2014 12:46:11 AM org.olap4j.driver.olap4ld.linkeddata.EmbeddedSesameEngine executeOlapQuery
INFO: Execute logical query plan: Generate physical query plan finished in 1833ms.
Sep 21, 2014 12:46:11 AM org.olap4j.driver.olap4ld.linkeddata.EmbeddedSesameEngine executeOlapQuery
INFO: Execute logical query plan: Execute physical query plan.
Sep 21, 2014 12:46:11 AM org.olap4j.driver.olap4ld.linkeddata.BaseCubeSparqlDerivedDatasetIterator sparql
INFO: SPARQL query: PREFIX dc: <http://purl.org/dc/elements/1.1/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX sdmx-measure: <http://purl.org/linked-data/sdmx/2009/measure#>
PREFIX skosclass: <http://ddialliance.org/ontologies/skosclass#>
PREFIX eus: <http://ontologycentral.com/2009/01/eurostat/ns#>
PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX qb: <http://purl.org/linked-data/cube#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX dcterms: <http://purl.org/dc/terms/>
select ?httplodgesisorglodpilotALLBUSvocabrdfgeo ?httpontologycentralcom200901eurostatnsgeo ?httpontologycentralcom200901eurostatnsindicnrg ?httpontologycentralcom200901eurostatnsproduct ?httpontologycentralcom200901eurostatnsunit ?httppurlorgdctermsdate?httppurlorglinkeddatasdmx2009measureobsValue ?httppurlorglinkeddatasdmx2009measureobsValue ?httppurlorglinkeddatasdmx2009measureobsValue ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomidtsdcc310ds ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomidtsdcc310ds ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomidtsdcc310ds ?httppurlorglinkeddatasdmx2009measureobsValue where { ?obs qb:dataSet <http://estatwrap.ontologycentral.com/id/tsdcc310#ds>. ?obs <http://lod.gesis.org/lodpilot/ALLBUS/vocab.rdf#geo> ?httplodgesisorglodpilotALLBUSvocabrdfgeo. ?obs <http://ontologycentral.com/2009/01/eurostat/ns#geo> ?httpontologycentralcom200901eurostatnsgeo. ?obs <http://ontologycentral.com/2009/01/eurostat/ns#indic_nrg> ?httpontologycentralcom200901eurostatnsindicnrg. ?obs <http://ontologycentral.com/2009/01/eurostat/ns#product> ?httpontologycentralcom200901eurostatnsproduct. ?obs <http://ontologycentral.com/2009/01/eurostat/ns#unit> ?httpontologycentralcom200901eurostatnsunit. ?obs <http://purl.org/dc/terms/date> ?httppurlorgdctermsdate. ?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?httppurlorglinkeddatasdmx2009measureobsValue.?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?httppurlorglinkeddatasdmx2009measureobsValue.?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?httppurlorglinkeddatasdmx2009measureobsValue.?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValuehttp://estatwrap.ontologycentral.com/id/tsdcc310#ds> ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomidtsdcc310ds.?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValuehttp://estatwrap.ontologycentral.com/id/tsdcc310#ds> ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomidtsdcc310ds.?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValuehttp://estatwrap.ontologycentral.com/id/tsdcc310#ds> ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomidtsdcc310ds.?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?httppurlorglinkeddatasdmx2009measureobsValue. }
Sep 21, 2014 12:46:11 AM org.olap4j.driver.olap4ld.linkeddata.BaseCubeSparqlDerivedDatasetIterator sparql
INFO: SPARQL query: PREFIX dc: <http://purl.org/dc/elements/1.1/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX sdmx-measure: <http://purl.org/linked-data/sdmx/2009/measure#>
PREFIX skosclass: <http://ddialliance.org/ontologies/skosclass#>
PREFIX eus: <http://ontologycentral.com/2009/01/eurostat/ns#>
PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX qb: <http://purl.org/linked-data/cube#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX dcterms: <http://purl.org/dc/terms/>
select ?httplodgesisorglodpilotALLBUSvocabrdfgeo ?httpontologycentralcom200901eurostatnsgeo ?httpontologycentralcom200901eurostatnsindicna ?httpontologycentralcom200901eurostatnsunit ?httppurlorgdctermsdate?httppurlorglinkeddatasdmx2009measureobsValue ?httppurlorglinkeddatasdmx2009measureobsValue ?httppurlorglinkeddatasdmx2009measureobsValue ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomidt2020rd310ds ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomidt2020rd310ds ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomidt2020rd310ds ?httppurlorglinkeddatasdmx2009measureobsValue where { ?obs qb:dataSet <http://estatwrap.ontologycentral.com/id/t2020_rd310#ds>. ?obs <http://lod.gesis.org/lodpilot/ALLBUS/vocab.rdf#geo> ?httplodgesisorglodpilotALLBUSvocabrdfgeo. ?obs <http://ontologycentral.com/2009/01/eurostat/ns#geo> ?httpontologycentralcom200901eurostatnsgeo. ?obs <http://ontologycentral.com/2009/01/eurostat/ns#indic_na> ?httpontologycentralcom200901eurostatnsindicna. ?obs <http://ontologycentral.com/2009/01/eurostat/ns#unit> ?httpontologycentralcom200901eurostatnsunit. ?obs <http://purl.org/dc/terms/date> ?httppurlorgdctermsdate. ?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?httppurlorglinkeddatasdmx2009measureobsValue.?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?httppurlorglinkeddatasdmx2009measureobsValue.?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?httppurlorglinkeddatasdmx2009measureobsValue.?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValuehttp://estatwrap.ontologycentral.com/id/t2020_rd310#ds> ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomidt2020rd310ds.?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValuehttp://estatwrap.ontologycentral.com/id/t2020_rd310#ds> ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomidt2020rd310ds.?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValuehttp://estatwrap.ontologycentral.com/id/t2020_rd310#ds> ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomidt2020rd310ds.?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?httppurlorglinkeddatasdmx2009measureobsValue. }
Sep 21, 2014 12:46:11 AM org.olap4j.driver.olap4ld.linkeddata.BaseCubeSparqlDerivedDatasetIterator sparql
INFO: SPARQL query: PREFIX dc: <http://purl.org/dc/elements/1.1/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX sdmx-measure: <http://purl.org/linked-data/sdmx/2009/measure#>
PREFIX skosclass: <http://ddialliance.org/ontologies/skosclass#>
PREFIX eus: <http://ontologycentral.com/2009/01/eurostat/ns#>
PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX qb: <http://purl.org/linked-data/cube#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX dcterms: <http://purl.org/dc/terms/>
select ?httplodgesisorglodpilotALLBUSvocabrdfgeo ?httpontologycentralcom200901eurostatnsai ?httpontologycentralcom200901eurostatnsgeo ?httpontologycentralcom200901eurostatnsunit ?httppurlorgdctermsdate?httppurlorglinkeddatasdmx2009measureobsValue ?httppurlorglinkeddatasdmx2009measureobsValue ?httppurlorglinkeddatasdmx2009measureobsValue ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomidt2020rd300ds ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomidt2020rd300ds ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomidt2020rd300ds ?httppurlorglinkeddatasdmx2009measureobsValue where { ?obs qb:dataSet <http://estatwrap.ontologycentral.com/id/t2020_rd300#ds>. ?obs <http://lod.gesis.org/lodpilot/ALLBUS/vocab.rdf#geo> ?httplodgesisorglodpilotALLBUSvocabrdfgeo. ?obs <http://ontologycentral.com/2009/01/eurostat/ns#ai> ?httpontologycentralcom200901eurostatnsai. ?obs <http://ontologycentral.com/2009/01/eurostat/ns#geo> ?httpontologycentralcom200901eurostatnsgeo. ?obs <http://ontologycentral.com/2009/01/eurostat/ns#unit> ?httpontologycentralcom200901eurostatnsunit. ?obs <http://purl.org/dc/terms/date> ?httppurlorgdctermsdate. ?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?httppurlorglinkeddatasdmx2009measureobsValue.?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?httppurlorglinkeddatasdmx2009measureobsValue.?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?httppurlorglinkeddatasdmx2009measureobsValue.?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValuehttp://estatwrap.ontologycentral.com/id/t2020_rd300#ds> ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomidt2020rd300ds.?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValuehttp://estatwrap.ontologycentral.com/id/t2020_rd300#ds> ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomidt2020rd300ds.?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValuehttp://estatwrap.ontologycentral.com/id/t2020_rd300#ds> ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomidt2020rd300ds.?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?httppurlorglinkeddatasdmx2009measureobsValue. }
Sep 21, 2014 12:46:11 AM org.olap4j.driver.olap4ld.linkeddata.BaseCubeSparqlDerivedDatasetIterator sparql
INFO: SPARQL query: PREFIX dc: <http://purl.org/dc/elements/1.1/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX sdmx-measure: <http://purl.org/linked-data/sdmx/2009/measure#>
PREFIX skosclass: <http://ddialliance.org/ontologies/skosclass#>
PREFIX eus: <http://ontologycentral.com/2009/01/eurostat/ns#>
PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX qb: <http://purl.org/linked-data/cube#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX dcterms: <http://purl.org/dc/terms/>
select ?httplodgesisorglodpilotALLBUSvocabrdfgeo ?httpontologycentralcom200901eurostatnsgeo ?httpontologycentralcom200901eurostatnsindicen ?httpontologycentralcom200901eurostatnsproduct ?httpontologycentralcom200901eurostatnsunit ?httppurlorgdctermsdate?httppurlorglinkeddatasdmx2009measureobsValue ?httppurlorglinkeddatasdmx2009measureobsValue ?httppurlorglinkeddatasdmx2009measureobsValue ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomidtsdec360ds ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomidtsdec360ds ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomidtsdec360ds ?httppurlorglinkeddatasdmx2009measureobsValue where { ?obs qb:dataSet <http://estatwrap.ontologycentral.com/id/tsdec360#ds>. ?obs <http://lod.gesis.org/lodpilot/ALLBUS/vocab.rdf#geo> ?httplodgesisorglodpilotALLBUSvocabrdfgeo. ?obs <http://ontologycentral.com/2009/01/eurostat/ns#geo> ?httpontologycentralcom200901eurostatnsgeo. ?obs <http://ontologycentral.com/2009/01/eurostat/ns#indic_en> ?httpontologycentralcom200901eurostatnsindicen. ?obs <http://ontologycentral.com/2009/01/eurostat/ns#product> ?httpontologycentralcom200901eurostatnsproduct. ?obs <http://ontologycentral.com/2009/01/eurostat/ns#unit> ?httpontologycentralcom200901eurostatnsunit. ?obs <http://purl.org/dc/terms/date> ?httppurlorgdctermsdate. ?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?httppurlorglinkeddatasdmx2009measureobsValue.?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?httppurlorglinkeddatasdmx2009measureobsValue.?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?httppurlorglinkeddatasdmx2009measureobsValue.?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValuehttp://estatwrap.ontologycentral.com/id/tsdec360#ds> ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomidtsdec360ds.?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValuehttp://estatwrap.ontologycentral.com/id/tsdec360#ds> ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomidtsdec360ds.?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValuehttp://estatwrap.ontologycentral.com/id/tsdec360#ds> ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomidtsdec360ds.?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?httppurlorglinkeddatasdmx2009measureobsValue. }
Query times (EU2020a)
Querytime | Query | Triples | Loading and validating dataset | Generating logical query plan | Executing logical query plan | Transmission
18:50:58.246 [main] INFO edu.kit.aifb.exrunner.ExperimentRun - paramSet={generatelogicalqueryplantime=5097, lookupscount=12, executemetadataqueriestime=14586, triplescount=19714, queryname= testEU2020-4 , loadvalidatedatasetstime=20038, generatephysicalqueryplantime=3444, executephysicalqueryplantime=96, executemetadataqueriescount=67, datasetscount=4, observationscount=2212, querytime=Sep 21, 2014 6:45:40 PM } executionValues={}
18:50:58.563 [main] INFO edu.kit.aifb.exrunner.ExperimentRun - paramSet={generatelogicalqueryplantime=2376, lookupscount=12, executemetadataqueriestime=13503, triplescount=19714, queryname= testEU2020-4 , loadvalidatedatasetstime=14921, generatephysicalqueryplantime=3582, executephysicalqueryplantime=86, executemetadataqueriescount=67, datasetscount=4, observationscount=2212, querytime=Sep 21, 2014 6:48:10 PM } executionValues={}
18:50:58.939 [main] INFO edu.kit.aifb.exrunner.ExperimentRun - paramSet={generatelogicalqueryplantime=0, lookupscount=0, executemetadataqueriestime=0, triplescount=0, queryname=Default, loadvalidatedatasetstime=0, generatephysicalqueryplantime=0, executephysicalqueryplantime=3, executemetadataqueriescount=0, datasetscount=0, observationscount=0, querytime=Default} executionValues={}
18:50:59.271 [main] INFO edu.kit.aifb.exrunner.ExperimentRun - paramSet={generatelogicalqueryplantime=2747, lookupscount=12, executemetadataqueriestime=17018, triplescount=19714, queryname= testEU2020-4 , loadvalidatedatasetstime=17910, generatephysicalqueryplantime=3400, executephysicalqueryplantime=112, executemetadataqueriescount=67, datasetscount=4, observationscount=2212, querytime=Sep 21, 2014 6:46:22 PM } executionValues={}
18:50:59.581 [main] INFO edu.kit.aifb.exrunner.ExperimentRun - paramSet={generatelogicalqueryplantime=2402, lookupscount=12, executemetadataqueriestime=13637, triplescount=19714, queryname= testEU2020-4 , loadvalidatedatasetstime=16662, generatephysicalqueryplantime=3513, executephysicalqueryplantime=91, executemetadataqueriescount=67, datasetscount=4, observationscount=2212, querytime=Sep 21, 2014 6:47:36 PM } executionValues={}
18:50:59.881 [main] INFO edu.kit.aifb.exrunner.ExperimentRun - paramSet={generatelogicalqueryplantime=0, lookupscount=0, executemetadataqueriestime=0, triplescount=0, queryname=Default, loadvalidatedatasetstime=0, generatephysicalqueryplantime=0, executephysicalqueryplantime=4, executemetadataqueriescount=0, datasetscount=0, observationscount=0, querytime=Default} executionValues={}
18:51:00.213 [main] INFO edu.kit.aifb.exrunner.ExperimentRun - paramSet={generatelogicalqueryplantime=2463, lookupscount=12, executemetadataqueriestime=13796, triplescount=19714, queryname= testEU2020-4 , loadvalidatedatasetstime=18249, generatephysicalqueryplantime=3491, executephysicalqueryplantime=86, executemetadataqueriescount=67, datasetscount=4, observationscount=2212, querytime=Sep 21, 2014 6:47:00 PM } executionValues={}
18:51:00.519 [main] INFO edu.kit.aifb.exrunner.ExperimentRun - paramSet={generatelogicalqueryplantime=0, lookupscount=0, executemetadataqueriestime=0, triplescount=0, queryname=Default, loadvalidatedatasetstime=0, generatephysicalqueryplantime=0, executephysicalqueryplantime=6, executemetadataqueriescount=0, datasetscount=0, observationscount=0, querytime=Default} executionValues={}
- Triples: 30,166 vs. 19,714 (including duplicated due to reasoning, but apparently much less is crawled)
- Observations: 1,886 vs. 2,212
- Lookups: 19 vs. 12
- Loading and Validating: 15 vs. 18 (longer time since network bandwith worse)
- Metadata Query Time: 7 vs. 15
- Metadata Query Numbers: 50 vs. 67
- Generating Logical Qery Plan: 3 vs. 3
- Generating Physical Query Plan: 0.005 vs. 3 (done by LogicalToPhysical, is our new way, by depth first search after discussion with Andreas, may be slower than our previous approach, in any case, we are going through the logical query plan and create a physical query plan of iterators. Iterators are not initialised, yet. But includes the OLAP-to-SPARQL algorithm that translates OLAP to SPARQL.)
- Executing Physical Query Plan: 0.099 vs. 0.094
- Total: 25 vs. 39
Output (EU2020a)
| | | | | Observation | Observation | Observation | Observation | +--+------+-------------+-------------+-------------+-------------+ | | 2005 | 285.65 | 10.98 | 5.25 | 40.06 | | | 2006 | 277.35 | 10.99 | 5.49 | 41.48 | | | 2007 | 265.56 | 10.93 | 5.78 | 42.27 | | | 2008 | 260.64 | 10.62 | 5.86 | 43.83 | | | 2009 | 256.38 | 9.78 | 5.87 | 42.52 | | | 2010 | 261.83 | 10.06 | 5.85 | 47.53 | | | 2011 | 255.4 | 9.75 | 6.22 | 43.07 | | | 2012 | 247.19 | 9.43 | 6.41 | 43.62 |
Comparing EU 2020 - Indicators (EU2020b): 8 Datasets
Info:
- Performance test case: LDCX_Performance_Evaluation_DrillAcrossTest.executeDrillAcrossEu2020indicators8()
Datasets:
- Energy dependence: http://estatwrap.ontologycentral.com/id/tsdcc310 (2001-2012)
- Energy productivity: http://estatwrap.ontologycentral.com/id/t2020_rd310 (2000-2012)
- Energy intensity: http://estatwrap.ontologycentral.com/id/tsdec360 (2001-2012)
- Greenhouse gas emissions per capita: http://estatwrap.ontologycentral.com/id/t2020_rd300 (2000-2011)
- Share of renewable energy: http://estatwrap.ontologycentral.com/id/t2020_31 (2004-2012)
- People at risk of poverty or social exclusion: http://estatwrap.ontologycentral.com/id/t2020_50 (2004-2012)
- People living in households with very low work intensity: http://estatwrap.ontologycentral.com/id/t2020_51 (2004 - 2012)
- People at risk of poverty after social transfers: http://estatwrap.ontologycentral.com/id/t2020_52 (2003-2012)
- (Severely materially deprived people: http://estatwrap.ontologycentral.com/id/t2020_53 (2003-2012))
MDX query (EU2020b)
SELECT /* $session: ldcx_performance_evaluation_testEU2020-8 */ NON EMPTY {[httpXXX3AXXX2FXXX2FpurlYYYorgXXX2FlinkedZZZdataXXX2FsdmxXXX2F2009XXX2FmeasureXXX23obsValuehttpXXX3AXXX2FXXX2FestatwrapYYYontologycentralYYYcomXXX2FidXXX2Ftsdcc310XXX23dsAGGFUNCAVG], [httpXXX3AXXX2FXXX2FpurlYYYorgXXX2FlinkedZZZdataXXX2FsdmxXXX2F2009XXX2FmeasureXXX23obsValuehttpXXX3AXXX2FXXX2FestatwrapYYYontologycentralYYYcomXXX2FidXXX2Ft2020_rd310XXX23dsAGGFUNCAVG], [httpXXX3AXXX2FXXX2FpurlYYYorgXXX2FlinkedZZZdataXXX2FsdmxXXX2F2009XXX2FmeasureXXX23obsValuehttpXXX3AXXX2FXXX2FestatwrapYYYontologycentralYYYcomXXX2FidXXX2Ft2020_rd300XXX23dsAGGFUNCAVG], [httpXXX3AXXX2FXXX2FpurlYYYorgXXX2FlinkedZZZdataXXX2FsdmxXXX2F2009XXX2FmeasureXXX23obsValuehttpXXX3AXXX2FXXX2FestatwrapYYYontologycentralYYYcomXXX2FidXXX2Ftsdec360XXX23dsAGGFUNCAVG], [httpXXX3AXXX2FXXX2FpurlYYYorgXXX2FlinkedZZZdataXXX2FsdmxXXX2F2009XXX2FmeasureXXX23obsValuehttpXXX3AXXX2FXXX2FestatwrapYYYontologycentralYYYcomXXX2FidXXX2Ft2020_31XXX23dsAGGFUNCAVG], [httpXXX3AXXX2FXXX2FpurlYYYorgXXX2FlinkedZZZdataXXX2FsdmxXXX2F2009XXX2FmeasureXXX23obsValuehttpXXX3AXXX2FXXX2FestatwrapYYYontologycentralYYYcomXXX2FidXXX2Ft2020_50XXX23dsAGGFUNCAVG], [httpXXX3AXXX2FXXX2FpurlYYYorgXXX2FlinkedZZZdataXXX2FsdmxXXX2F2009XXX2FmeasureXXX23obsValuehttpXXX3AXXX2FXXX2FestatwrapYYYontologycentralYYYcomXXX2FidXXX2Ft2020_51XXX23dsAGGFUNCAVG], [httpXXX3AXXX2FXXX2FpurlYYYorgXXX2FlinkedZZZdataXXX2FsdmxXXX2F2009XXX2FmeasureXXX23obsValuehttpXXX3AXXX2FXXX2FestatwrapYYYontologycentralYYYcomXXX2FidXXX2Ft2020_52XXX23dsAGGFUNCAVG]} ON COLUMNS, NON EMPTY {Members([httpXXX3AXXX2FXXX2FpurlYYYorgXXX2FdcXXX2FtermsXXX2Fdate])} ON ROWS FROM [httpXXX3AXXX2FXXX2FestatwrapYYYontologycentralYYYcomXXX2FidXXX2Ftsdcc310XXX23dsXXX2ChttpXXX3AXXX2FXXX2FestatwrapYYYontologycentralYYYcomXXX2FidXXX2Ft2020_rd310XXX23dsXXX2ChttpXXX3AXXX2FXXX2FestatwrapYYYontologycentralYYYcomXXX2FidXXX2Ft2020_rd300XXX23dsXXX2ChttpXXX3AXXX2FXXX2FestatwrapYYYontologycentralYYYcomXXX2FidXXX2Ftsdec360XXX23dsXXX2ChttpXXX3AXXX2FXXX2FestatwrapYYYontologycentralYYYcomXXX2FidXXX2Ft2020_31XXX23dsXXX2ChttpXXX3AXXX2FXXX2FestatwrapYYYontologycentralYYYcomXXX2FidXXX2Ft2020_50XXX23dsXXX2ChttpXXX3AXXX2FXXX2FestatwrapYYYontologycentralYYYcomXXX2FidXXX2Ft2020_51XXX23dsXXX2ChttpXXX3AXXX2FXXX2FestatwrapYYYontologycentralYYYcomXXX2FidXXX2Ft2020_52XXX23ds]
OLAP query (EU2020b)
Drill-across(Drill-across(Drill-across(Drill-across(Drill-across(Drill-across(Drill-across(Rollup (Slice (Projection (BaseCube (http://estatwrap.ontologycentral.com/id/tsdcc310#ds), {http://purl.org/linked-data/sdmx/2009/measure#obsValuehttp://estatwrap.ontologycentral.com/id/tsdcc310#dsAGGFUNCAVG}), {http://lod.gesis.org/lodpilot/ALLBUS/vocab.rdf#geo, http://ontologycentral.com/2009/01/eurostat/ns#geo, http://ontologycentral.com/2009/01/eurostat/ns#indic_nrg, http://ontologycentral.com/2009/01/eurostat/ns#product, http://ontologycentral.com/2009/01/eurostat/ns#unit}), {}), Rollup (Slice (Projection (BaseCube (http://estatwrap.ontologycentral.com/id/t2020_rd310#ds), {http://purl.org/linked-data/sdmx/2009/measure#obsValuehttp://estatwrap.ontologycentral.com/id/t2020_rd310#dsAGGFUNCAVG}), {http://lod.gesis.org/lodpilot/ALLBUS/vocab.rdf#geo, http://ontologycentral.com/2009/01/eurostat/ns#geo, http://ontologycentral.com/2009/01/eurostat/ns#indic_na, http://ontologycentral.com/2009/01/eurostat/ns#unit}), {})), Rollup (Slice (Projection (BaseCube (http://estatwrap.ontologycentral.com/id/t2020_rd300#ds), {http://purl.org/linked-data/sdmx/2009/measure#obsValuehttp://estatwrap.ontologycentral.com/id/t2020_rd300#dsAGGFUNCAVG}), {http://lod.gesis.org/lodpilot/ALLBUS/vocab.rdf#geo, http://ontologycentral.com/2009/01/eurostat/ns#ai, http://ontologycentral.com/2009/01/eurostat/ns#geo, http://ontologycentral.com/2009/01/eurostat/ns#unit}), {})), Rollup (Slice (Projection (BaseCube (http://estatwrap.ontologycentral.com/id/tsdec360#ds), {http://purl.org/linked-data/sdmx/2009/measure#obsValuehttp://estatwrap.ontologycentral.com/id/tsdec360#dsAGGFUNCAVG}), {http://lod.gesis.org/lodpilot/ALLBUS/vocab.rdf#geo, http://ontologycentral.com/2009/01/eurostat/ns#geo, http://ontologycentral.com/2009/01/eurostat/ns#indic_en, http://ontologycentral.com/2009/01/eurostat/ns#product, http://ontologycentral.com/2009/01/eurostat/ns#unit}), {})), Rollup (Slice (Projection (BaseCube (http://estatwrap.ontologycentral.com/id/t2020_31#ds), {http://purl.org/linked-data/sdmx/2009/measure#obsValuehttp://estatwrap.ontologycentral.com/id/t2020_31#dsAGGFUNCAVG}), {http://lod.gesis.org/lodpilot/ALLBUS/vocab.rdf#geo, http://ontologycentral.com/2009/01/eurostat/ns#geo, http://ontologycentral.com/2009/01/eurostat/ns#indic_eu, http://ontologycentral.com/2009/01/eurostat/ns#unit}), {})), Rollup (Slice (Projection (BaseCube (http://estatwrap.ontologycentral.com/id/t2020_50#ds), {http://purl.org/linked-data/sdmx/2009/measure#obsValuehttp://estatwrap.ontologycentral.com/id/t2020_50#dsAGGFUNCAVG}), {http://lod.gesis.org/lodpilot/ALLBUS/vocab.rdf#geo, http://ontologycentral.com/2009/01/eurostat/ns#age, http://ontologycentral.com/2009/01/eurostat/ns#geo, http://ontologycentral.com/2009/01/eurostat/ns#indic_eu, http://ontologycentral.com/2009/01/eurostat/ns#sex, http://ontologycentral.com/2009/01/eurostat/ns#unit}), {})), Rollup (Slice (Projection (BaseCube (http://estatwrap.ontologycentral.com/id/t2020_51#ds), {http://purl.org/linked-data/sdmx/2009/measure#obsValuehttp://estatwrap.ontologycentral.com/id/t2020_51#dsAGGFUNCAVG}), {http://lod.gesis.org/lodpilot/ALLBUS/vocab.rdf#geo, http://ontologycentral.com/2009/01/eurostat/ns#age, http://ontologycentral.com/2009/01/eurostat/ns#geo, http://ontologycentral.com/2009/01/eurostat/ns#indic_eu, http://ontologycentral.com/2009/01/eurostat/ns#sex, http://ontologycentral.com/2009/01/eurostat/ns#unit}), {})), Rollup (Slice (Projection (BaseCube (http://estatwrap.ontologycentral.com/id/t2020_52#ds), {http://purl.org/linked-data/sdmx/2009/measure#obsValuehttp://estatwrap.ontologycentral.com/id/t2020_52#dsAGGFUNCAVG}), {http://lod.gesis.org/lodpilot/ALLBUS/vocab.rdf#geo, http://ontologycentral.com/2009/01/eurostat/ns#age, http://ontologycentral.com/2009/01/eurostat/ns#geo, http://ontologycentral.com/2009/01/eurostat/ns#indic_eu, http://ontologycentral.com/2009/01/eurostat/ns#indic_il, http://ontologycentral.com/2009/01/eurostat/ns#sex, http://ontologycentral.com/2009/01/eurostat/ns#unit}), {}))
Output (EU2020b)
Output: | | | | | Observation | Observation | Observation | Observation | Observation | Observation | Observation | Observation | +--+------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+ | | 2006 | 2169.55 | 6676.42 | 13.45 | 5.49 | 41.48 | 10.99 | 277.35 | 4218.92 | | | 2007 | 1855.7 | 5789.61 | 14.0 | 5.78 | 42.27 | 10.93 | 265.56 | 4017.96 | | | 2008 | 1743.77 | 5694.92 | 14.67 | 5.86 | 43.83 | 10.62 | 260.64 | 4006.37 | | | 2009 | 1731.96 | 5617.93 | 16.3 | 5.87 | 42.52 | 9.78 | 256.38 | 3992.08 | | | 2010 | 2333.32 | 6934.33 | 16.65 | 5.85 | 47.53 | 10.06 | 261.83 | 4911.08 | | | 2011 | 2401.87 | 7182.86 | 17.2 | 6.22 | 43.07 | 9.75 | 255.4 | 5089.95 |
Query times (EU2020b)
Querytime | Query | Triples | Loading and validating dataset | Generating logical query plan | Executing logical query plan | Transmission
19:19:10.802 [main] INFO edu.kit.aifb.exrunner.ExperimentRun - paramSet={generatelogicalqueryplantime=0, lookupscount=0, executemetadataqueriestime=0, triplescount=0, queryname=Default, loadvalidatedatasetstime=0, generatephysicalqueryplantime=0, executephysicalqueryplantime=12, executemetadataqueriescount=0, datasetscount=0, observationscount=0, querytime=Default} executionValues={}
19:19:11.114 [main] INFO edu.kit.aifb.exrunner.ExperimentRun - paramSet={generatelogicalqueryplantime=0, lookupscount=0, executemetadataqueriestime=0, triplescount=0, queryname=Default, loadvalidatedatasetstime=0, generatephysicalqueryplantime=0, executephysicalqueryplantime=5, executemetadataqueriescount=0, datasetscount=0, observationscount=0, querytime=Default} executionValues={}
19:19:11.425 [main] INFO edu.kit.aifb.exrunner.ExperimentRun - paramSet={generatelogicalqueryplantime=7783, lookupscount=20, executemetadataqueriestime=38904, triplescount=38069, queryname= testEU2020-8 , loadvalidatedatasetstime=40700, generatephysicalqueryplantime=14236, executephysicalqueryplantime=140, executemetadataqueriescount=103, datasetscount=8, observationscount=3992, querytime=Sep 21, 2014 7:16:20 PM } executionValues={}
19:19:11.735 [main] INFO edu.kit.aifb.exrunner.ExperimentRun - paramSet={generatelogicalqueryplantime=6101, lookupscount=20, executemetadataqueriestime=41571, triplescount=38069, queryname= testEU2020-8 , loadvalidatedatasetstime=55352, generatephysicalqueryplantime=7752, executephysicalqueryplantime=170, executemetadataqueriescount=103, datasetscount=8, observationscount=3992, querytime=Sep 21, 2014 7:09:35 PM } executionValues={}
19:19:12.072 [main] INFO edu.kit.aifb.exrunner.ExperimentRun - paramSet={generatelogicalqueryplantime=0, lookupscount=0, executemetadataqueriestime=0, triplescount=0, queryname=Default, loadvalidatedatasetstime=0, generatephysicalqueryplantime=0, executephysicalqueryplantime=6, executemetadataqueriescount=0, datasetscount=0, observationscount=0, querytime=Default} executionValues={}
19:19:12.399 [main] INFO edu.kit.aifb.exrunner.ExperimentRun - paramSet={generatelogicalqueryplantime=0, lookupscount=0, executemetadataqueriestime=0, triplescount=0, queryname=Default, loadvalidatedatasetstime=0, generatephysicalqueryplantime=0, executephysicalqueryplantime=8, executemetadataqueriescount=0, datasetscount=0, observationscount=0, querytime=Default} executionValues={}
19:19:12.716 [main] INFO edu.kit.aifb.exrunner.ExperimentRun - paramSet={generatelogicalqueryplantime=4799, lookupscount=20, executemetadataqueriestime=39066, triplescount=38069, queryname= testEU2020-8 , loadvalidatedatasetstime=44297, generatephysicalqueryplantime=7257, executephysicalqueryplantime=142, executemetadataqueriescount=103, datasetscount=8, observationscount=3992, querytime=Sep 21, 2014 7:14:45 PM } executionValues={}
- Triples: 47,724 vs. 38,069 (including duplicated due to reasoning, but apparently much less is crawled)
- Observations: 3,570 vs. 3,992
- Lookups: 32 vs. 20
- Loading and Validating: 36 vs. 47 (longer time since network bandwith worse)
- Metadata Query Time: 19 vs. 40
- Metadata Query Numbers: 78 vs. 103
- Generating Logical Query Plan: 7 vs. 6
- Generating Physical Query Plan: 0.008 vs. 10 (done by LogicalToPhysical, is our new way, by depth first search after discussion with Andreas, may be slower than our previous approach, in any case, we are going through the logical query plan and create a physical query plan of iterators. Iterators are not initialised, yet. But includes the OLAP-to-SPARQL algorithm that translates OLAP to SPARQL.)
- Executing Physical Query Plan: 0.164 vs. 0.151
- Total: 94 vs. 103
GDP per Capita from Different Sources (GDP_CAP)
Info:
- Performance TestCase: LDCX_Performance_Evaluation_ConvertCubeTest.executeGDP_Per_Capita_Compared()
- Example queries: Example_QB_Datasets_ConvertCube_QueryTest - Example Queries in MDX with enabled conversion and merging correspondences for GDP_CAP query
Correspondences (GDP_CAP)
MIO2EUR Correspondence:
MIO2EUR =
({(estatwrap:unit, eurostat-unit:MIO EUR)}, {(estatwrap:unit,
eurostat-unit:EUR)}, f (x) = 1, 000, 000 · x)
COMPUTE GDP = ({(estat-
wrap:indic na, eurostat-indic na:B1G)}, {(estatwrap:indic na, eurost-
at-indic na:D21 M D31)}, {(estatwrap:indic na, eurostat-indic na:NG-
DP)}, f (x 1 , x 2 ) = x 1 + x 2 )
COMP GDP CAP = ({(estatwrap:indic na, eurostat-indic na:NGDP), (estat-
wrap:unit, eurostat-unit:EUR)}, {(estatwrap:sex, eurostat-sex:T), (es-
tatwrap:age, estatwrap-age:TOTAL)}, {(eurostat:indic na, eurostat-in-
dic na:NGDPH), (eurostat:unit, eurostat-unit:EUR HAB)}, f (x 1 , x 2 ) = x 1 /x 2 ).
Example SPARQL query
SPARQL CONSTRUCT query: PREFIX qb:<http://purl.org/linked-data/cube#> PREFIX olap4ld:<http://purl.org/olap4ld/>construct { _:outputcube <http://purl.org/linked-data/cube#dataSet> <http://localhost/deriveddataset/dataset-120936551/conversionfunction446064422> .
<http://localhost/deriveddataset/dataset-120936551/conversionfunction446064422> <http://purl.org/linked-data/cube#structure> ?dsd1 .
_:outputcube <http://ontologycentral.com/2009/01/eurostat/ns#unit> <http://estatwrap.ontologycentral.com/dic/unit#EUR> .
_:outputcube <http://lod.gesis.org/lodpilot/ALLBUS/vocab.rdf#geo> ?httplodgesisorglodpilotALLBUSvocabrdfgeo .
_:outputcube <http://ontologycentral.com/2009/01/eurostat/ns#geo> ?httpontologycentralcom200901eurostatnsgeo .
_:outputcube <http://ontologycentral.com/2009/01/eurostat/ns#indic_na> ?httpontologycentralcom200901eurostatnsindicna .
_:outputcube <http://purl.org/dc/terms/date> ?httppurlorgdctermsdate .
_:outputcube <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?outputvalue1 .
} where { { select ?dsd1 ?dsd2 ((1000000 * ?inputvalue1) as ?outputvalue1) ?httplodgesisorglodpilotALLBUSvocabrdfgeo ?dsd1 ?httppurlorgdctermsdate ?httpontologycentralcom200901eurostatnsindicna ?httpontologycentralcom200901eurostatnsgeo ?inputvalue1 where {?inputcube1 <http://purl.org/linked-data/cube#dataSet> <http://estatwrap.ontologycentral.com/id/nama_gdp_c#ds> .
<http://estatwrap.ontologycentral.com/id/nama_gdp_c#ds> <http://purl.org/linked-data/cube#structure> ?dsd1 .
?inputcube1 <http://ontologycentral.com/2009/01/eurostat/ns#unit> <http://estatwrap.ontologycentral.com/dic/unit#MIO_EUR> .
?inputcube1 <http://lod.gesis.org/lodpilot/ALLBUS/vocab.rdf#geo> ?httplodgesisorglodpilotALLBUSvocabrdfgeo .
?inputcube1 <http://ontologycentral.com/2009/01/eurostat/ns#geo> ?httpontologycentralcom200901eurostatnsgeo .
?inputcube1 <http://ontologycentral.com/2009/01/eurostat/ns#indic_na> ?httpontologycentralcom200901eurostatnsindicna .
?inputcube1 <http://purl.org/dc/terms/date> ?httppurlorgdctermsdate .
?inputcube1 <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?inputvalue1 .
} } }
Logical query plan (GDP_CAP)
See figure in paper.
Physical query plan (GDP_CAP)
Nested-Loop over (Merge-Cubes (Merge-Cubes (Convert-Cube (BaseCube (http://estatwrap.ontologycentral.com/id/nama_gdp_c#ds,PREFIX dc: <http://purl.org/dc/elements/1.1/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX sdmx-measure: <http://purl.org/linked-data/sdmx/2009/measure#>
PREFIX skosclass: <http://ddialliance.org/ontologies/skosclass#>
PREFIX eus: <http://ontologycentral.com/2009/01/eurostat/ns#>
PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX qb: <http://purl.org/linked-data/cube#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX dcterms: <http://purl.org/dc/terms/>
select ?httplodgesisorglodpilotALLBUSvocabrdfgeo ?httpontologycentralcom200901eurostatnsgeo ?httpontologycentralcom200901eurostatnsindicna ?httpontologycentralcom200901eurostatnsunit ?httppurlorgdctermsdate?httppurlorglinkeddatasdmx2009measureobsValue ?httppurlorglinkeddatasdmx2009measureobsValue ?httppurlorglinkeddatasdmx2009measureobsValue ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomidnamagdpcds ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomidnamagdpcds ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomidnamagdpcds ?httppurlorglinkeddatasdmx2009measureobsValue where { ?obs qb:dataSet <http://estatwrap.ontologycentral.com/id/nama_gdp_c#ds>. ?obs <http://lod.gesis.org/lodpilot/ALLBUS/vocab.rdf#geo> ?httplodgesisorglodpilotALLBUSvocabrdfgeo. ?obs <http://ontologycentral.com/2009/01/eurostat/ns#geo> ?httpontologycentralcom200901eurostatnsgeo. ?obs <http://ontologycentral.com/2009/01/eurostat/ns#indic_na> ?httpontologycentralcom200901eurostatnsindicna. ?obs <http://ontologycentral.com/2009/01/eurostat/ns#unit> ?httpontologycentralcom200901eurostatnsunit. ?obs <http://purl.org/dc/terms/date> ?httppurlorgdctermsdate. ?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?httppurlorglinkeddatasdmx2009measureobsValue.?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?httppurlorglinkeddatasdmx2009measureobsValue.?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?httppurlorglinkeddatasdmx2009measureobsValue.?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValuehttp://estatwrap.ontologycentral.com/id/nama_gdp_c#ds> ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomidnamagdpcds.?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValuehttp://estatwrap.ontologycentral.com/id/nama_gdp_c#ds> ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomidnamagdpcds.?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValuehttp://estatwrap.ontologycentral.com/id/nama_gdp_c#ds> ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomidnamagdpcds.?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?httppurlorglinkeddatasdmx2009measureobsValue. } ), Convert-Cube: {
?inputcube1 <http://purl.org/linked-data/cube#dataSet> <http://estatwrap.ontologycentral.com/id/nama_gdp_c#ds> .
<http://estatwrap.ontologycentral.com/id/nama_gdp_c#ds> <http://purl.org/linked-data/cube#structure> ?dsd1 .
?inputcube1 <http://ontologycentral.com/2009/01/eurostat/ns#unit> <http://estatwrap.ontologycentral.com/dic/unit#MIO_EUR> .
?inputcube1 <http://lod.gesis.org/lodpilot/ALLBUS/vocab.rdf#geo> ?httplodgesisorglodpilotALLBUSvocabrdfgeo .
?inputcube1 <http://ontologycentral.com/2009/01/eurostat/ns#geo> ?httpontologycentralcom200901eurostatnsgeo .
?inputcube1 <http://ontologycentral.com/2009/01/eurostat/ns#indic_na> ?httpontologycentralcom200901eurostatnsindicna .
?inputcube1 <http://purl.org/dc/terms/date> ?httppurlorgdctermsdate .
?inputcube1 <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?inputvalue7 .
?outputvalue7 <http://www.aifb.kit.edu/project/ld-retriever/qrl#bindas> "(1000000 * ?inputvalue7)" .
} => {
_:outputcube <http://purl.org/linked-data/cube#dataSet> <http://localhost/deriveddataset/dataset-120936551/conversionfunction446064422> .
<http://localhost/deriveddataset/dataset-120936551/conversionfunction446064422> <http://purl.org/linked-data/cube#structure> ?dsd1 .
_:outputcube <http://ontologycentral.com/2009/01/eurostat/ns#unit> <http://estatwrap.ontologycentral.com/dic/unit#EUR> .
_:outputcube <http://lod.gesis.org/lodpilot/ALLBUS/vocab.rdf#geo> ?httplodgesisorglodpilotALLBUSvocabrdfgeo .
_:outputcube <http://ontologycentral.com/2009/01/eurostat/ns#geo> ?httpontologycentralcom200901eurostatnsgeo .
_:outputcube <http://ontologycentral.com/2009/01/eurostat/ns#indic_na> ?httpontologycentralcom200901eurostatnsindicna .
_:outputcube <http://purl.org/dc/terms/date> ?httppurlorgdctermsdate .
_:outputcube <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?outputvalue7 .
} ), Convert-Cube (BaseCube (http://estatwrap.ontologycentral.com/id/nama_gdp_c#ds,PREFIX dc: <http://purl.org/dc/elements/1.1/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX sdmx-measure: <http://purl.org/linked-data/sdmx/2009/measure#>
PREFIX skosclass: <http://ddialliance.org/ontologies/skosclass#>
PREFIX eus: <http://ontologycentral.com/2009/01/eurostat/ns#>
PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX qb: <http://purl.org/linked-data/cube#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX dcterms: <http://purl.org/dc/terms/>
select ?httplodgesisorglodpilotALLBUSvocabrdfgeo ?httpontologycentralcom200901eurostatnsgeo ?httpontologycentralcom200901eurostatnsindicna ?httpontologycentralcom200901eurostatnsunit ?httppurlorgdctermsdate?httppurlorglinkeddatasdmx2009measureobsValue ?httppurlorglinkeddatasdmx2009measureobsValue ?httppurlorglinkeddatasdmx2009measureobsValue ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomidnamagdpcds ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomidnamagdpcds ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomidnamagdpcds ?httppurlorglinkeddatasdmx2009measureobsValue where { ?obs qb:dataSet <http://estatwrap.ontologycentral.com/id/nama_gdp_c#ds>. ?obs <http://lod.gesis.org/lodpilot/ALLBUS/vocab.rdf#geo> ?httplodgesisorglodpilotALLBUSvocabrdfgeo. ?obs <http://ontologycentral.com/2009/01/eurostat/ns#geo> ?httpontologycentralcom200901eurostatnsgeo. ?obs <http://ontologycentral.com/2009/01/eurostat/ns#indic_na> ?httpontologycentralcom200901eurostatnsindicna. ?obs <http://ontologycentral.com/2009/01/eurostat/ns#unit> ?httpontologycentralcom200901eurostatnsunit. ?obs <http://purl.org/dc/terms/date> ?httppurlorgdctermsdate. ?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?httppurlorglinkeddatasdmx2009measureobsValue.?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?httppurlorglinkeddatasdmx2009measureobsValue.?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?httppurlorglinkeddatasdmx2009measureobsValue.?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValuehttp://estatwrap.ontologycentral.com/id/nama_gdp_c#ds> ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomidnamagdpcds.?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValuehttp://estatwrap.ontologycentral.com/id/nama_gdp_c#ds> ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomidnamagdpcds.?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValuehttp://estatwrap.ontologycentral.com/id/nama_gdp_c#ds> ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomidnamagdpcds.?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?httppurlorglinkeddatasdmx2009measureobsValue. } ), Convert-Cube: {
?inputcube1 <http://purl.org/linked-data/cube#dataSet> <http://estatwrap.ontologycentral.com/id/nama_gdp_c#ds> .
<http://estatwrap.ontologycentral.com/id/nama_gdp_c#ds> <http://purl.org/linked-data/cube#structure> ?dsd1 .
?inputcube1 <http://ontologycentral.com/2009/01/eurostat/ns#unit> <http://estatwrap.ontologycentral.com/dic/unit#MIO_EUR> .
?inputcube1 <http://lod.gesis.org/lodpilot/ALLBUS/vocab.rdf#geo> ?httplodgesisorglodpilotALLBUSvocabrdfgeo .
?inputcube1 <http://ontologycentral.com/2009/01/eurostat/ns#geo> ?httpontologycentralcom200901eurostatnsgeo .
?inputcube1 <http://ontologycentral.com/2009/01/eurostat/ns#indic_na> ?httpontologycentralcom200901eurostatnsindicna .
?inputcube1 <http://purl.org/dc/terms/date> ?httppurlorgdctermsdate .
?inputcube1 <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?inputvalue7 .
?outputvalue7 <http://www.aifb.kit.edu/project/ld-retriever/qrl#bindas> "(1000000 * ?inputvalue7)" .
} => {
_:outputcube <http://purl.org/linked-data/cube#dataSet> <http://localhost/deriveddataset/dataset-120936551/conversionfunction446064422> .
<http://localhost/deriveddataset/dataset-120936551/conversionfunction446064422> <http://purl.org/linked-data/cube#structure> ?dsd1 .
_:outputcube <http://ontologycentral.com/2009/01/eurostat/ns#unit> <http://estatwrap.ontologycentral.com/dic/unit#EUR> .
_:outputcube <http://lod.gesis.org/lodpilot/ALLBUS/vocab.rdf#geo> ?httplodgesisorglodpilotALLBUSvocabrdfgeo .
_:outputcube <http://ontologycentral.com/2009/01/eurostat/ns#geo> ?httpontologycentralcom200901eurostatnsgeo .
_:outputcube <http://ontologycentral.com/2009/01/eurostat/ns#indic_na> ?httpontologycentralcom200901eurostatnsindicna .
_:outputcube <http://purl.org/dc/terms/date> ?httppurlorgdctermsdate .
_:outputcube <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?outputvalue7 .
} ), Convert-Cube: {
?inputcube1 <http://purl.org/linked-data/cube#dataSet> <http://localhost/deriveddataset/dataset-120936551/conversionfunction446064422> .
<http://localhost/deriveddataset/dataset-120936551/conversionfunction446064422> <http://purl.org/linked-data/cube#structure> ?dsd1 .
?inputcube2 <http://purl.org/linked-data/cube#dataSet> <http://localhost/deriveddataset/dataset-120936551/conversionfunction446064422> .
<http://localhost/deriveddataset/dataset-120936551/conversionfunction446064422> <http://purl.org/linked-data/cube#structure> ?dsd2 .
?inputcube1 <http://ontologycentral.com/2009/01/eurostat/ns#indic_na> <http://estatwrap.ontologycentral.com/dic/indic_na#B1G> .
?inputcube2 <http://ontologycentral.com/2009/01/eurostat/ns#indic_na> <http://estatwrap.ontologycentral.com/dic/indic_na#D21_M_D31> .
?inputcube1 <http://lod.gesis.org/lodpilot/ALLBUS/vocab.rdf#geo> ?httplodgesisorglodpilotALLBUSvocabrdfgeo .
?inputcube2 <http://lod.gesis.org/lodpilot/ALLBUS/vocab.rdf#geo> ?httplodgesisorglodpilotALLBUSvocabrdfgeo .
?inputcube1 <http://ontologycentral.com/2009/01/eurostat/ns#geo> ?httpontologycentralcom200901eurostatnsgeo .
?inputcube2 <http://ontologycentral.com/2009/01/eurostat/ns#geo> ?httpontologycentralcom200901eurostatnsgeo .
?inputcube1 <http://ontologycentral.com/2009/01/eurostat/ns#unit> ?httpontologycentralcom200901eurostatnsunit .
?inputcube2 <http://ontologycentral.com/2009/01/eurostat/ns#unit> ?httpontologycentralcom200901eurostatnsunit .
?inputcube1 <http://purl.org/dc/terms/date> ?httppurlorgdctermsdate .
?inputcube2 <http://purl.org/dc/terms/date> ?httppurlorgdctermsdate .
?inputcube1 <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?input1value1 .
?inputcube2 <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?input2value1 .
?outputvalue1 <http://www.aifb.kit.edu/project/ld-retriever/qrl#bindas> "(?input1value1 + ?input2value1)" .
} => {
_:outputcube <http://purl.org/linked-data/cube#dataSet> <http://localhost/deriveddataset/dataset666074368/conversionfunction-270137444> .
<http://localhost/deriveddataset/dataset666074368/conversionfunction-270137444> <http://purl.org/linked-data/cube#structure> ?dsd1 .
_:outputcube <http://ontologycentral.com/2009/01/eurostat/ns#indic_na> <http://estatwrap.ontologycentral.com/dic/indic_na#NGDP> .
_:outputcube <http://lod.gesis.org/lodpilot/ALLBUS/vocab.rdf#geo> ?httplodgesisorglodpilotALLBUSvocabrdfgeo .
_:outputcube <http://ontologycentral.com/2009/01/eurostat/ns#geo> ?httpontologycentralcom200901eurostatnsgeo .
_:outputcube <http://ontologycentral.com/2009/01/eurostat/ns#unit> ?httpontologycentralcom200901eurostatnsunit .
_:outputcube <http://purl.org/dc/terms/date> ?httppurlorgdctermsdate .
_:outputcube <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?outputvalue1 .
} ), BaseCube (http://estatwrap.ontologycentral.com/id/demo_pjan#ds,PREFIX dc: <http://purl.org/dc/elements/1.1/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX sdmx-measure: <http://purl.org/linked-data/sdmx/2009/measure#>
PREFIX skosclass: <http://ddialliance.org/ontologies/skosclass#>
PREFIX eus: <http://ontologycentral.com/2009/01/eurostat/ns#>
PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX qb: <http://purl.org/linked-data/cube#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX dcterms: <http://purl.org/dc/terms/>
select ?httplodgesisorglodpilotALLBUSvocabrdfgeo ?httpontologycentralcom200901eurostatnsage ?httpontologycentralcom200901eurostatnsgeo ?httpontologycentralcom200901eurostatnssex ?httppurlorgdctermsdate?httppurlorglinkeddatasdmx2009measureobsValue ?httppurlorglinkeddatasdmx2009measureobsValue ?httppurlorglinkeddatasdmx2009measureobsValue ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomiddemopjands ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomiddemopjands ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomiddemopjands ?httppurlorglinkeddatasdmx2009measureobsValue where { ?obs qb:dataSet <http://estatwrap.ontologycentral.com/id/demo_pjan#ds>. ?obs <http://lod.gesis.org/lodpilot/ALLBUS/vocab.rdf#geo> ?httplodgesisorglodpilotALLBUSvocabrdfgeo. ?obs <http://ontologycentral.com/2009/01/eurostat/ns#age> ?httpontologycentralcom200901eurostatnsage. ?obs <http://ontologycentral.com/2009/01/eurostat/ns#geo> ?httpontologycentralcom200901eurostatnsgeo. ?obs <http://ontologycentral.com/2009/01/eurostat/ns#sex> ?httpontologycentralcom200901eurostatnssex. ?obs <http://purl.org/dc/terms/date> ?httppurlorgdctermsdate. ?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?httppurlorglinkeddatasdmx2009measureobsValue.?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?httppurlorglinkeddatasdmx2009measureobsValue.?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?httppurlorglinkeddatasdmx2009measureobsValue.?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValuehttp://estatwrap.ontologycentral.com/id/demo_pjan#ds> ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomiddemopjands.?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValuehttp://estatwrap.ontologycentral.com/id/demo_pjan#ds> ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomiddemopjands.?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValuehttp://estatwrap.ontologycentral.com/id/demo_pjan#ds> ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomiddemopjands.?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?httppurlorglinkeddatasdmx2009measureobsValue. } ),
Convert-Cube: {
?inputcube1 <http://purl.org/linked-data/cube#dataSet> <http://localhost/deriveddataset/dataset666074368/conversionfunction-270137444> .
<http://localhost/deriveddataset/dataset666074368/conversionfunction-270137444> <http://purl.org/linked-data/cube#structure> ?dsd1 .
?inputcube2 <http://purl.org/linked-data/cube#dataSet> <http://estatwrap.ontologycentral.com/id/demo_pjan#ds> .
<http://estatwrap.ontologycentral.com/id/demo_pjan#ds> <http://purl.org/linked-data/cube#structure> ?dsd2 .
?inputcube1 <http://ontologycentral.com/2009/01/eurostat/ns#indic_na> <http://estatwrap.ontologycentral.com/dic/indic_na#NGDP> .
?inputcube1 <http://ontologycentral.com/2009/01/eurostat/ns#unit> <http://estatwrap.ontologycentral.com/dic/unit#EUR> .
?inputcube2 <http://ontologycentral.com/2009/01/eurostat/ns#sex> <http://estatwrap.ontologycentral.com/dic/sex#T> .
?inputcube2 <http://ontologycentral.com/2009/01/eurostat/ns#age> <http://estatwrap.ontologycentral.com/dic/age#TOTAL> .
?inputcube1 <http://lod.gesis.org/lodpilot/ALLBUS/vocab.rdf#geo> ?httplodgesisorglodpilotALLBUSvocabrdfgeo .
?inputcube2 <http://lod.gesis.org/lodpilot/ALLBUS/vocab.rdf#geo> ?httplodgesisorglodpilotALLBUSvocabrdfgeo .
?inputcube1 <http://ontologycentral.com/2009/01/eurostat/ns#geo> ?httpontologycentralcom200901eurostatnsgeo .
?inputcube2 <http://ontologycentral.com/2009/01/eurostat/ns#geo> ?httpontologycentralcom200901eurostatnsgeo .
?inputcube1 <http://purl.org/dc/terms/date> ?httppurlorgdctermsdate .
?inputcube2 <http://purl.org/dc/terms/date> ?httppurlorgdctermsdate .
?inputcube1 <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?input1value1 .
?inputcube2 <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?input2value1 .
?outputvalue1 <http://www.aifb.kit.edu/project/ld-retriever/qrl#bindas> "(?input1value1 / ?input2value1)" .
} => {
_:outputcube <http://purl.org/linked-data/cube#dataSet> <http://localhost/deriveddataset/dataset1974913310/conversionfunction-2005164347> .
<http://localhost/deriveddataset/dataset1974913310/conversionfunction-2005164347> <http://purl.org/linked-data/cube#structure> ?dsd1 .
_:outputcube <http://ontologycentral.com/2009/01/eurostat/ns#indic_na> <http://estatwrap.ontologycentral.com/dic/indic_na#NGDPH> .
_:outputcube <http://ontologycentral.com/2009/01/eurostat/ns#unit> <http://estatwrap.ontologycentral.com/dic/unit#EUR_HAB> .
_:outputcube <http://lod.gesis.org/lodpilot/ALLBUS/vocab.rdf#geo> ?httplodgesisorglodpilotALLBUSvocabrdfgeo .
_:outputcube <http://ontologycentral.com/2009/01/eurostat/ns#geo> ?httpontologycentralcom200901eurostatnsgeo .
_:outputcube <http://purl.org/dc/terms/date> ?httppurlorgdctermsdate .
_:outputcube <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?outputvalue1 .
} ),
OLAP-2-SPARQL query (SparqlSesame): PREFIX dc: <http://purl.org/dc/elements/1.1/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX sdmx-measure: <http://purl.org/linked-data/sdmx/2009/measure#>
PREFIX skosclass: <http://ddialliance.org/ontologies/skosclass#>
PREFIX eus: <http://ontologycentral.com/2009/01/eurostat/ns#>
PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX qb: <http://purl.org/linked-data/cube#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX dcterms: <http://purl.org/dc/terms/>
select ?httplodgesisorglodpilotALLBUSvocabrdfgeo0 ?httpontologycentralcom200901eurostatnsgeo0 ?httpontologycentralcom200901eurostatnsindicna0 ?httpontologycentralcom200901eurostatnsunit0 ?httppurlorgdctermsdate0 (GROUP_CONCAT(?httppurlorglinkeddatasdmx2009measureobsValue) as ?httppurlorglinkeddatasdmx2009measureobsValue_new ) where { ?obs qb:dataSet <http://estatwrap.ontologycentral.com/id/nama_aux_gph#ds>. ?obs ?httplodgesisorglodpilotALLBUSvocabrdfgeoDimension ?httplodgesisorglodpilotALLBUSvocabrdfgeo0. filter(?httplodgesisorglodpilotALLBUSvocabrdfgeoDimension = <http://lod.gesis.org/lodpilot/ALLBUS/vocab.rdf#geo>) ?obs ?httpontologycentralcom200901eurostatnsgeoDimension ?httpontologycentralcom200901eurostatnsgeo0. filter(?httpontologycentralcom200901eurostatnsgeoDimension = <http://ontologycentral.com/2009/01/eurostat/ns#geo>) ?obs ?httpontologycentralcom200901eurostatnsindicnaDimension ?httpontologycentralcom200901eurostatnsindicna0. filter(?httpontologycentralcom200901eurostatnsindicnaDimension = <http://ontologycentral.com/2009/01/eurostat/ns#indic_na>) ?obs ?httpontologycentralcom200901eurostatnsunitDimension ?httpontologycentralcom200901eurostatnsunit0. filter(?httpontologycentralcom200901eurostatnsunitDimension = <http://ontologycentral.com/2009/01/eurostat/ns#unit>) ?obs ?httppurlorgdctermsdateDimension ?httppurlorgdctermsdate0. filter(?httppurlorgdctermsdateDimension = <http://purl.org/dc/terms/date>) ?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?httppurlorglinkeddatasdmx2009measureobsValue.} group by ?httplodgesisorglodpilotALLBUSvocabrdfgeo0 ?httpontologycentralcom200901eurostatnsgeo0 ?httpontologycentralcom200901eurostatnsindicna0 ?httpontologycentralcom200901eurostatnsunit0 ?httppurlorgdctermsdate0 order by ?httplodgesisorglodpilotALLBUSvocabrdfgeo0 ?httpontologycentralcom200901eurostatnsgeo0 ?httpontologycentralcom200901eurostatnsindicna0 ?httpontologycentralcom200901eurostatnsunit0 ?httppurlorgdctermsdate0 )
Sep 21, 2014 1:32:00 AM org.olap4j.driver.olap4ld.linkeddata.EmbeddedSesameEngine executeOlapQuery
INFO: Execute logical query plan: Generate physical query plan finished in 67284ms.
Sep 21, 2014 1:32:00 AM org.olap4j.driver.olap4ld.linkeddata.EmbeddedSesameEngine executeOlapQuery
INFO: Execute logical query plan: Execute physical query plan.
Sep 21, 2014 1:32:00 AM org.olap4j.driver.olap4ld.linkeddata.BaseCubeSparqlDerivedDatasetIterator sparql
INFO: SPARQL query: PREFIX dc: <http://purl.org/dc/elements/1.1/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX sdmx-measure: <http://purl.org/linked-data/sdmx/2009/measure#>
PREFIX skosclass: <http://ddialliance.org/ontologies/skosclass#>
PREFIX eus: <http://ontologycentral.com/2009/01/eurostat/ns#>
PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX qb: <http://purl.org/linked-data/cube#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX dcterms: <http://purl.org/dc/terms/>
select ?httplodgesisorglodpilotALLBUSvocabrdfgeo ?httpontologycentralcom200901eurostatnsgeo ?httpontologycentralcom200901eurostatnsindicna ?httpontologycentralcom200901eurostatnsunit ?httppurlorgdctermsdate?httppurlorglinkeddatasdmx2009measureobsValue ?httppurlorglinkeddatasdmx2009measureobsValue ?httppurlorglinkeddatasdmx2009measureobsValue ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomidnamagdpcds ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomidnamagdpcds ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomidnamagdpcds ?httppurlorglinkeddatasdmx2009measureobsValue where { ?obs qb:dataSet <http://estatwrap.ontologycentral.com/id/nama_gdp_c#ds>. ?obs <http://lod.gesis.org/lodpilot/ALLBUS/vocab.rdf#geo> ?httplodgesisorglodpilotALLBUSvocabrdfgeo. ?obs <http://ontologycentral.com/2009/01/eurostat/ns#geo> ?httpontologycentralcom200901eurostatnsgeo. ?obs <http://ontologycentral.com/2009/01/eurostat/ns#indic_na> ?httpontologycentralcom200901eurostatnsindicna. ?obs <http://ontologycentral.com/2009/01/eurostat/ns#unit> ?httpontologycentralcom200901eurostatnsunit. ?obs <http://purl.org/dc/terms/date> ?httppurlorgdctermsdate. ?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?httppurlorglinkeddatasdmx2009measureobsValue.?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?httppurlorglinkeddatasdmx2009measureobsValue.?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?httppurlorglinkeddatasdmx2009measureobsValue.?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValuehttp://estatwrap.ontologycentral.com/id/nama_gdp_c#ds> ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomidnamagdpcds.?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValuehttp://estatwrap.ontologycentral.com/id/nama_gdp_c#ds> ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomidnamagdpcds.?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValuehttp://estatwrap.ontologycentral.com/id/nama_gdp_c#ds> ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomidnamagdpcds.?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?httppurlorglinkeddatasdmx2009measureobsValue. }
Sep 21, 2014 1:32:00 AM org.olap4j.driver.olap4ld.linkeddata.ConvertSparqlDerivedDatasetIterator init
INFO: Execute logical query plan: Create and load derived dataset.
Sep 21, 2014 1:32:00 AM org.olap4j.driver.olap4ld.linkeddata.ConvertSparqlDerivedDatasetIterator executeSPARQLConstructQuery
INFO: SPARQL CONSTRUCT query: PREFIX qb:<http://purl.org/linked-data/cube#> PREFIX olap4ld:<http://purl.org/olap4ld/>construct { _:outputcube <http://purl.org/linked-data/cube#dataSet> <http://localhost/deriveddataset/dataset-120936551/conversionfunction446064422> .
<http://localhost/deriveddataset/dataset-120936551/conversionfunction446064422> <http://purl.org/linked-data/cube#structure> ?dsd1 .
_:outputcube <http://ontologycentral.com/2009/01/eurostat/ns#unit> <http://estatwrap.ontologycentral.com/dic/unit#EUR> .
_:outputcube <http://lod.gesis.org/lodpilot/ALLBUS/vocab.rdf#geo> ?httplodgesisorglodpilotALLBUSvocabrdfgeo .
_:outputcube <http://ontologycentral.com/2009/01/eurostat/ns#geo> ?httpontologycentralcom200901eurostatnsgeo .
_:outputcube <http://ontologycentral.com/2009/01/eurostat/ns#indic_na> ?httpontologycentralcom200901eurostatnsindicna .
_:outputcube <http://purl.org/dc/terms/date> ?httppurlorgdctermsdate .
_:outputcube <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?outputvalue7 .
} where { { select ?dsd1 ?dsd2 ((1000000 * ?inputvalue7) as ?outputvalue7) ?httplodgesisorglodpilotALLBUSvocabrdfgeo ?dsd1 ?httppurlorgdctermsdate ?httpontologycentralcom200901eurostatnsindicna ?httpontologycentralcom200901eurostatnsgeo ?inputvalue7 where {?inputcube1 <http://purl.org/linked-data/cube#dataSet> <http://estatwrap.ontologycentral.com/id/nama_gdp_c#ds> .
<http://estatwrap.ontologycentral.com/id/nama_gdp_c#ds> <http://purl.org/linked-data/cube#structure> ?dsd1 .
?inputcube1 <http://ontologycentral.com/2009/01/eurostat/ns#unit> <http://estatwrap.ontologycentral.com/dic/unit#MIO_EUR> .
?inputcube1 <http://lod.gesis.org/lodpilot/ALLBUS/vocab.rdf#geo> ?httplodgesisorglodpilotALLBUSvocabrdfgeo .
?inputcube1 <http://ontologycentral.com/2009/01/eurostat/ns#geo> ?httpontologycentralcom200901eurostatnsgeo .
?inputcube1 <http://ontologycentral.com/2009/01/eurostat/ns#indic_na> ?httpontologycentralcom200901eurostatnsindicna .
?inputcube1 <http://purl.org/dc/terms/date> ?httppurlorgdctermsdate .
?inputcube1 <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?inputvalue7 .
} } }
Sep 21, 2014 1:32:04 AM org.olap4j.driver.olap4ld.linkeddata.ConvertSparqlDerivedDatasetIterator init
INFO: Execute logical query plan: Create and load derived dataset finished in 4061ms.
Sep 21, 2014 1:32:08 AM org.olap4j.driver.olap4ld.linkeddata.ConvertSparqlDerivedDatasetIterator init
INFO: Execute logical query plan: Create and load derived dataset.
Sep 21, 2014 1:32:08 AM org.olap4j.driver.olap4ld.linkeddata.ConvertSparqlDerivedDatasetIterator executeSPARQLConstructQuery
INFO: SPARQL CONSTRUCT query: PREFIX qb:<http://purl.org/linked-data/cube#> PREFIX olap4ld:<http://purl.org/olap4ld/>construct { _:outputcube <http://purl.org/linked-data/cube#dataSet> <http://localhost/deriveddataset/dataset666074368/conversionfunction-270137444> .
<http://localhost/deriveddataset/dataset666074368/conversionfunction-270137444> <http://purl.org/linked-data/cube#structure> ?dsd1 .
_:outputcube <http://ontologycentral.com/2009/01/eurostat/ns#indic_na> <http://estatwrap.ontologycentral.com/dic/indic_na#NGDP> .
_:outputcube <http://lod.gesis.org/lodpilot/ALLBUS/vocab.rdf#geo> ?httplodgesisorglodpilotALLBUSvocabrdfgeo .
_:outputcube <http://ontologycentral.com/2009/01/eurostat/ns#geo> ?httpontologycentralcom200901eurostatnsgeo .
_:outputcube <http://ontologycentral.com/2009/01/eurostat/ns#unit> ?httpontologycentralcom200901eurostatnsunit .
_:outputcube <http://purl.org/dc/terms/date> ?httppurlorgdctermsdate .
_:outputcube <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?outputvalue1 .
} where { { select ?dsd1 ?dsd2 ((?input1value1 + ?input2value1) as ?outputvalue1) ?httplodgesisorglodpilotALLBUSvocabrdfgeo ?dsd2 ?httppurlorgdctermsdate ?httpontologycentralcom200901eurostatnsunit ?httpontologycentralcom200901eurostatnsgeo ?input2value1 where {?inputcube1 <http://purl.org/linked-data/cube#dataSet> <http://localhost/deriveddataset/dataset-120936551/conversionfunction446064422> .
<http://localhost/deriveddataset/dataset-120936551/conversionfunction446064422> <http://purl.org/linked-data/cube#structure> ?dsd1 .
?inputcube2 <http://purl.org/linked-data/cube#dataSet> <http://localhost/deriveddataset/dataset-120936551/conversionfunction446064422> .
<http://localhost/deriveddataset/dataset-120936551/conversionfunction446064422> <http://purl.org/linked-data/cube#structure> ?dsd2 .
?inputcube1 <http://ontologycentral.com/2009/01/eurostat/ns#indic_na> <http://estatwrap.ontologycentral.com/dic/indic_na#B1G> .
?inputcube2 <http://ontologycentral.com/2009/01/eurostat/ns#indic_na> <http://estatwrap.ontologycentral.com/dic/indic_na#D21_M_D31> .
?inputcube1 <http://lod.gesis.org/lodpilot/ALLBUS/vocab.rdf#geo> ?httplodgesisorglodpilotALLBUSvocabrdfgeo .
?inputcube2 <http://lod.gesis.org/lodpilot/ALLBUS/vocab.rdf#geo> ?httplodgesisorglodpilotALLBUSvocabrdfgeo .
?inputcube1 <http://ontologycentral.com/2009/01/eurostat/ns#geo> ?httpontologycentralcom200901eurostatnsgeo .
?inputcube2 <http://ontologycentral.com/2009/01/eurostat/ns#geo> ?httpontologycentralcom200901eurostatnsgeo .
?inputcube1 <http://ontologycentral.com/2009/01/eurostat/ns#unit> ?httpontologycentralcom200901eurostatnsunit .
?inputcube2 <http://ontologycentral.com/2009/01/eurostat/ns#unit> ?httpontologycentralcom200901eurostatnsunit .
?inputcube1 <http://purl.org/dc/terms/date> ?httppurlorgdctermsdate .
?inputcube2 <http://purl.org/dc/terms/date> ?httppurlorgdctermsdate .
?inputcube1 <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?input1value1 .
?inputcube2 <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?input2value1 .
} } }
Sep 21, 2014 1:36:59 AM org.olap4j.driver.olap4ld.linkeddata.ConvertSparqlDerivedDatasetIterator init
INFO: Execute logical query plan: Create and load derived dataset finished in 290599ms.
Sep 21, 2014 1:36:59 AM org.olap4j.driver.olap4ld.linkeddata.BaseCubeSparqlDerivedDatasetIterator sparql
INFO: SPARQL query: PREFIX dc: <http://purl.org/dc/elements/1.1/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX sdmx-measure: <http://purl.org/linked-data/sdmx/2009/measure#>
PREFIX skosclass: <http://ddialliance.org/ontologies/skosclass#>
PREFIX eus: <http://ontologycentral.com/2009/01/eurostat/ns#>
PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX qb: <http://purl.org/linked-data/cube#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX dcterms: <http://purl.org/dc/terms/>
select ?httplodgesisorglodpilotALLBUSvocabrdfgeo ?httpontologycentralcom200901eurostatnsage ?httpontologycentralcom200901eurostatnsgeo ?httpontologycentralcom200901eurostatnssex ?httppurlorgdctermsdate?httppurlorglinkeddatasdmx2009measureobsValue ?httppurlorglinkeddatasdmx2009measureobsValue ?httppurlorglinkeddatasdmx2009measureobsValue ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomiddemopjands ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomiddemopjands ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomiddemopjands ?httppurlorglinkeddatasdmx2009measureobsValue where { ?obs qb:dataSet <http://estatwrap.ontologycentral.com/id/demo_pjan#ds>. ?obs <http://lod.gesis.org/lodpilot/ALLBUS/vocab.rdf#geo> ?httplodgesisorglodpilotALLBUSvocabrdfgeo. ?obs <http://ontologycentral.com/2009/01/eurostat/ns#age> ?httpontologycentralcom200901eurostatnsage. ?obs <http://ontologycentral.com/2009/01/eurostat/ns#geo> ?httpontologycentralcom200901eurostatnsgeo. ?obs <http://ontologycentral.com/2009/01/eurostat/ns#sex> ?httpontologycentralcom200901eurostatnssex. ?obs <http://purl.org/dc/terms/date> ?httppurlorgdctermsdate. ?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?httppurlorglinkeddatasdmx2009measureobsValue.?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?httppurlorglinkeddatasdmx2009measureobsValue.?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?httppurlorglinkeddatasdmx2009measureobsValue.?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValuehttp://estatwrap.ontologycentral.com/id/demo_pjan#ds> ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomiddemopjands.?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValuehttp://estatwrap.ontologycentral.com/id/demo_pjan#ds> ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomiddemopjands.?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValuehttp://estatwrap.ontologycentral.com/id/demo_pjan#ds> ?httppurlorglinkeddatasdmx2009measureobsValuehttpestatwrapontologycentralcomiddemopjands.?obs <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?httppurlorglinkeddatasdmx2009measureobsValue. }
Sep 21, 2014 1:36:59 AM org.olap4j.driver.olap4ld.linkeddata.ConvertSparqlDerivedDatasetIterator init
INFO: Execute logical query plan: Create and load derived dataset.
Sep 21, 2014 1:36:59 AM org.olap4j.driver.olap4ld.linkeddata.ConvertSparqlDerivedDatasetIterator executeSPARQLConstructQuery
INFO: SPARQL CONSTRUCT query: PREFIX qb:<http://purl.org/linked-data/cube#> PREFIX olap4ld:<http://purl.org/olap4ld/>construct { _:outputcube <http://purl.org/linked-data/cube#dataSet> <http://localhost/deriveddataset/dataset1974913310/conversionfunction-2005164347> .
<http://localhost/deriveddataset/dataset1974913310/conversionfunction-2005164347> <http://purl.org/linked-data/cube#structure> ?dsd1 .
_:outputcube <http://ontologycentral.com/2009/01/eurostat/ns#indic_na> <http://estatwrap.ontologycentral.com/dic/indic_na#NGDPH> .
_:outputcube <http://ontologycentral.com/2009/01/eurostat/ns#unit> <http://estatwrap.ontologycentral.com/dic/unit#EUR_HAB> .
_:outputcube <http://lod.gesis.org/lodpilot/ALLBUS/vocab.rdf#geo> ?httplodgesisorglodpilotALLBUSvocabrdfgeo .
_:outputcube <http://ontologycentral.com/2009/01/eurostat/ns#geo> ?httpontologycentralcom200901eurostatnsgeo .
_:outputcube <http://purl.org/dc/terms/date> ?httppurlorgdctermsdate .
_:outputcube <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?outputvalue1 .
} where { { select ?dsd1 ?dsd2 ((?input1value1 / ?input2value1) as ?outputvalue1) ?httplodgesisorglodpilotALLBUSvocabrdfgeo ?dsd2 ?httppurlorgdctermsdate ?httpontologycentralcom200901eurostatnsgeo ?input2value1 where {?inputcube1 <http://purl.org/linked-data/cube#dataSet> <http://localhost/deriveddataset/dataset666074368/conversionfunction-270137444> .
<http://localhost/deriveddataset/dataset666074368/conversionfunction-270137444> <http://purl.org/linked-data/cube#structure> ?dsd1 .
?inputcube2 <http://purl.org/linked-data/cube#dataSet> <http://estatwrap.ontologycentral.com/id/demo_pjan#ds> .
<http://estatwrap.ontologycentral.com/id/demo_pjan#ds> <http://purl.org/linked-data/cube#structure> ?dsd2 .
?inputcube1 <http://ontologycentral.com/2009/01/eurostat/ns#indic_na> <http://estatwrap.ontologycentral.com/dic/indic_na#NGDP> .
?inputcube1 <http://ontologycentral.com/2009/01/eurostat/ns#unit> <http://estatwrap.ontologycentral.com/dic/unit#EUR> .
?inputcube2 <http://ontologycentral.com/2009/01/eurostat/ns#sex> <http://estatwrap.ontologycentral.com/dic/sex#T> .
?inputcube2 <http://ontologycentral.com/2009/01/eurostat/ns#age> <http://estatwrap.ontologycentral.com/dic/age#TOTAL> .
?inputcube1 <http://lod.gesis.org/lodpilot/ALLBUS/vocab.rdf#geo> ?httplodgesisorglodpilotALLBUSvocabrdfgeo .
?inputcube2 <http://lod.gesis.org/lodpilot/ALLBUS/vocab.rdf#geo> ?httplodgesisorglodpilotALLBUSvocabrdfgeo .
?inputcube1 <http://ontologycentral.com/2009/01/eurostat/ns#geo> ?httpontologycentralcom200901eurostatnsgeo .
?inputcube2 <http://ontologycentral.com/2009/01/eurostat/ns#geo> ?httpontologycentralcom200901eurostatnsgeo .
?inputcube1 <http://purl.org/dc/terms/date> ?httppurlorgdctermsdate .
?inputcube2 <http://purl.org/dc/terms/date> ?httppurlorgdctermsdate .
?inputcube1 <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?input1value1 .
?inputcube2 <http://purl.org/linked-data/sdmx/2009/measure#obsValue> ?input2value1 .
} } }
Querytime | Query | Triples | Loading and validating dataset | Generating logical query plan | Executing logical query plan | Transmission
13:43:52.812 [main] INFO edu.kit.aifb.exrunner.ExperimentRun - paramSet={generatelogicalqueryplantime=0, lookupscount=22, executemetadataqueriestime=-370969, triplescount=2031356, queryname=Default, loadvalidatedatasetstime=370969, generatephysicalqueryplantime=346003, executephysicalqueryplantime=622827, executemetadataqueriescount=0, datasetscount=1, observationscount=252702, querytime=Default} executionValues={}
13:43:53.175 [main] INFO edu.kit.aifb.exrunner.ExperimentRun - paramSet={generatelogicalqueryplantime=0, lookupscount=16, executemetadataqueriestime=-208770, triplescount=1017763, queryname=Default, loadvalidatedatasetstime=208770, generatephysicalqueryplantime=110576, executephysicalqueryplantime=120417, executemetadataqueriescount=0, datasetscount=1, observationscount=126351, querytime=Default} executionValues={}
13:43:53.519 [main] INFO edu.kit.aifb.exrunner.ExperimentRun - paramSet={generatelogicalqueryplantime=0, lookupscount=15, executemetadataqueriestime=-230100, triplescount=1453273, queryname=Default, loadvalidatedatasetstime=230100, generatephysicalqueryplantime=293680, executephysicalqueryplantime=1483963, executemetadataqueriescount=0, datasetscount=1, observationscount=188573, querytime=Default} executionValues={}
13:43:53.832 [main] INFO edu.kit.aifb.exrunner.ExperimentRun - paramSet={generatelogicalqueryplantime=0, lookupscount=17, executemetadataqueriestime=-259226, triplescount=1530459, queryname=Default, loadvalidatedatasetstime=259226, generatephysicalqueryplantime=167589, executephysicalqueryplantime=257351, executemetadataqueriescount=0, datasetscount=1, observationscount=190480, querytime=Default} executionValues={}
13:43:54.193 [main] INFO edu.kit.aifb.exrunner.ExperimentRun - paramSet={generatelogicalqueryplantime=0, lookupscount=19, executemetadataqueriestime=-290835, triplescount=1535898, queryname=Default, loadvalidatedatasetstime=290835, generatephysicalqueryplantime=195303, executephysicalqueryplantime=446349, executemetadataqueriescount=0, datasetscount=1, observationscount=191047, querytime=Default} executionValues={}
13:43:54.540 [main] INFO edu.kit.aifb.exrunner.ExperimentRun - paramSet={generatelogicalqueryplantime=0, lookupscount=16, executemetadataqueriestime=-220834, triplescount=1513130, queryname=Default, loadvalidatedatasetstime=220834, generatephysicalqueryplantime=139870, executephysicalqueryplantime=263165, executemetadataqueriescount=0, datasetscount=1, observationscount=188006, querytime=Default} executionValues={}
Query times (GDP_CAP)
Querytime | Query | Triples | Loading and validating dataset | Generating logical query plan | Executing logical query plan | Transmission
18:04:07.934 [main] INFO edu.kit.aifb.exrunner.ExperimentRun - paramSet={generatelogicalqueryplantime=0, lookupscount=10, executemetadataqueriestime=-110464, triplescount=1015044, queryname=Default, loadvalidatedatasetstime=110464, generatephysicalqueryplantime=15961, executephysicalqueryplantime=112101, executemetadataqueriescount=0, datasetscount=1, observationscount=126351, querytime=Default} executionValues={}
18:04:08.238 [main] INFO edu.kit.aifb.exrunner.ExperimentRun - paramSet={generatelogicalqueryplantime=0, lookupscount=10, executemetadataqueriestime=-110813, triplescount=1015044, queryname=Default, loadvalidatedatasetstime=110813, generatephysicalqueryplantime=15623, executephysicalqueryplantime=116301, executemetadataqueriescount=0, datasetscount=1, observationscount=126351, querytime=Default} executionValues={}
18:04:08.537 [main] INFO edu.kit.aifb.exrunner.ExperimentRun - paramSet={generatelogicalqueryplantime=0, lookupscount=10, executemetadataqueriestime=-118556, triplescount=1015044, queryname=Default, loadvalidatedatasetstime=118556, generatephysicalqueryplantime=15773, executephysicalqueryplantime=110860, executemetadataqueriescount=0, datasetscount=1, observationscount=126351, querytime=Default} executionValues={}
18:04:08.835 [main] INFO edu.kit.aifb.exrunner.ExperimentRun - paramSet={generatelogicalqueryplantime=0, lookupscount=10, executemetadataqueriestime=-112206, triplescount=1015044, queryname=Default, loadvalidatedatasetstime=112206, generatephysicalqueryplantime=15250, executephysicalqueryplantime=112399, executemetadataqueriescount=0, datasetscount=1, observationscount=126351, querytime=Default} executionValues={}
18:04:09.356 [main] INFO edu.kit.aifb.exrunner.ExperimentRun - paramSet={generatelogicalqueryplantime=0, lookupscount=10, executemetadataqueriestime=-150921, triplescount=1015044, queryname=Default, loadvalidatedatasetstime=150921, generatephysicalqueryplantime=17143, executephysicalqueryplantime=103849, executemetadataqueriescount=0, datasetscount=1, observationscount=126351, querytime=Default} executionValues={}
18:04:09.655 [main] INFO edu.kit.aifb.exrunner.ExperimentRun - paramSet={generatelogicalqueryplantime=0, lookupscount=10, executemetadataqueriestime=-109350, triplescount=1015044, queryname=Default, loadvalidatedatasetstime=109350, generatephysicalqueryplantime=15467, executephysicalqueryplantime=110211, executemetadataqueriescount=0, datasetscount=1, observationscount=126351, querytime=Default} executionValues={}
- Triples: 885,072 vs. 1,015,044 (including duplicated due to reasoning)
- Observations: 123,869 vs. 126,351
- Lookups: 16 vs. 10
- Loading and Validating: 128 vs. 119
- Generating Physical Query Plan: 0.008 vs. 16 (done by LogicalToPhysical, is our new way, by depth first search after discussion with Andreas, may be slower than our previous approach, in any case, we are going through the logical query plan and create a physical query plan of iterators. Iterators are not initialised, yet. But includes the OLAP-to-SPARQL algorithm that translates OLAP to SPARQL.)
- Executing Physical Query Plan: 152 vs. 111
- Generating and storing derived datasets (found by logging "Create and load derived dataset"): 117 vs. (2510+63977+16911)+(1956+71453+18220)+(1912+71635+17363)+(1759+72327+17270)+(1960+75804+18225)+(1800+69633+19471) / 6 = 90698 = 91sec
- Total: vs. 246
Output (GDP_CAP)
- Too many items...
Example:
http://estatwrap.ontologycentral.com/dic/geo#UK; http://estatwrap.ontologycentral.com/dic/geo#UK; http://estatwrap.ontologycentral.com/dic/indic_na#NGDPH; http://estatwrap.ontologycentral.com/dic/unit#EUR_HAB; 2010; 27704.423967820803 / 27800;
Prolog program for enumerating all possible derived datasets of GDP_CAP scenario (GDP_CAP)
- XSB Prolog
- Calling
- xsb
- [euro2mio].
- ? :- dataset(X), writeln(X), fail.
:- auto_table. /* Datasets */ dataset(gdppercapita). dimension(gdppercapita, geo). dimension(gdppercapita, unit). dimension(gdppercapita, date). dimension(gdppercapita, indicna). dataset(gdpcomponents). dimension(gdpcomponents, geo). dimension(gdpcomponents, unit). dimension(gdpcomponents, date). dimension(gdpcomponents, indicna). dataset(population). dimension(population, geo). dimension(population, date). dimension(population, sex). dimension(population, age). /* mio2eur */ /* The generation of the dataset */ dataset(mio2eur(X)) :- dataset(X), dimension(X,unit), ( \+ dimensionmember(X,unit,Z); dimensionmember(X,unit,mioeur) ). /* Copying over of dimension members */ dimensionmember(mio2eur(X), Y, V) :- dataset(X), dimension(X,unit), ( \+ dimensionmember(X,unit,Z); dimensionmember(X,unit,mioeur) ), dimensionmember(X,Y,V), \+ dimensionmember(X, unit, mioeur). /* Setting the new dimension member */ dimensionmember(mio2eur(X), unit, eur) :- dataset(X), dimension(X,unit), ( \+ dimensionmember(X,unit,Z); dimensionmember(X,unit,mioeur) ). /* Copying over of dimensions (of first cube in case of merging correspondence */ dimension(mio2eur(X), Y) :- dataset(X), dimension(X,unit), ( \+ dimensionmember(X,unit,Z); dimensionmember(X,unit,mioeur) ), dimension(X,Y). /* compgdp */ dataset(compgdp(X,Y)) :- dataset(X), dimension(X,indicna), ( \+ dimensionmember(X,indicna,Z); dimensionmember(X,indicna,b1g) ), dataset(Y), dimension(Y,indicna), ( \+ dimensionmember(Y,indicna,V); dimensionmember(Y,indicna,d21md31) ). dimension(compgdp(X,Y), W) :- dataset(X), dimension(X,indicna), ( \+ dimensionmember(X,indicna,Z); dimensionmember(X,indicna,b1g) ), dataset(Y), dimension(Y,indicna), ( \+ dimensionmember(Y,indicna,V); dimensionmember(Y,indicna,d21md31) ), dimension(X,W). dimensionmember(compgdp(X,Y), W, U) :- dataset(X), dimension(X,indicna), ( \+ dimensionmember(X,indicna,Z); dimensionmember(X,indicna,b1g) ), dataset(Y), dimension(Y,indicna), ( \+ dimensionmember(Y,indicna,V); dimensionmember(Y,indicna,d21md31) ), dimensionmember(X,W,U), \+ dimensionmember(X,indicna,b1g). dimensionmember(compgdp(X,Y), indicna, ngdp) :- dataset(X), dimension(X,indicna), ( \+ dimensionmember(X,indicna,Z); dimensionmember(X,indicna,b1g) ), dataset(Y), dimension(Y,indicna), ( \+ dimensionmember(Y,indicna,V); dimensionmember(Y,indicna,d21md31) ). /* compgdppercapita */ dataset(compgdppercap(X,Y)) :- dataset(X), dimension(X,unit), ( \+ dimensionmember(X,unit,Z); dimensionmember(X,unit,eur) ), dimension(X,indicna), ( \+ dimensionmember(X,indicna,Z); dimensionmember(X,indicna,ngdp) ), dataset(Y), dimension(Y,sex), ( \+ dimensionmember(Y,sex,V); dimensionmember(Y,sex,t) ), dimension(Y,age), ( \+ dimensionmember(Y,age,U); dimensionmember(Y,age,total) ). dimension(compgdppercap(X,Y), W) :- dataset(X), dimension(X,unit), ( \+ dimensionmember(X,unit,Z); dimensionmember(X,unit,eur) ), dimension(X,indicna), ( \+ dimensionmember(X,indicna,Z); dimensionmember(X,indicna,ngdp) ), dataset(Y), dimension(Y,sex), ( \+ dimensionmember(Y,sex,V); dimensionmember(Y,sex,t) ), dimension(Y,age), ( \+ dimensionmember(Y,age,U); dimensionmember(Y,age,total) ), dimension(X, W). dimensionmember(compgdppercap(X,Y),W,U) :- dataset(X), dimension(X,unit), ( \+ dimensionmember(X,unit,Z); dimensionmember(X,unit,eur) ), dimension(X,indicna), ( \+ dimensionmember(X,indicna,Z); dimensionmember(X,indicna,ngdp) ), dataset(Y), dimension(Y,sex), ( \+ dimensionmember(Y,sex,V); dimensionmember(Y,sex,t) ), dimension(Y,age), ( \+ dimensionmember(Y,age,U); dimensionmember(Y,age,total) ), dimensionmember(X,W,U), \+ dimensionmember(X,unit,eur), \+ dimensionmember(X,indicna,ngdp). dimensionmember(compgdppercap(X,Y), unit, eurhab) :- dataset(X), dimension(X,unit), ( \+ dimensionmember(X,unit,Z); dimensionmember(X,unit,eur) ), dimension(X,indicna), ( \+ dimensionmember(X,indicna,Z); dimensionmember(X,indicna,ngdp) ), dataset(Y), dimension(Y,sex), ( \+ dimensionmember(Y,sex,V); dimensionmember(Y,sex,t) ), dimension(Y,age), ( \+ dimensionmember(Y,age,U); dimensionmember(Y,age,total) ). dimensionmember(compgdppercap(X,Y), indicna, ngdph) :- dataset(X), dimension(X,unit), ( \+ dimensionmember(X,unit,Z); dimensionmember(X,unit,eur) ), dimension(X,indicna), ( \+ dimensionmember(X,indicna,Z); dimensionmember(X,indicna,ngdp) ), dataset(Y), dimension(Y,sex), ( \+ dimensionmember(Y,sex,V); dimensionmember(Y,sex,t) ), dimension(Y,age), ( \+ dimensionmember(Y,age,U); dimensionmember(Y,age,total) ). /* This way, also the following dataset should be generated: compgdppercap(compgdp(mio2eur(gdpcomponents),mio2eur(gdpcomponents)),population) */
Returns (? :- dataset(X), writeln(X), fail.):
compgdppercap(compgdp(mio2eur(gdpcomponents),mio2eur(gdpcomponents)),population) compgdppercap(compgdp(mio2eur(gdpcomponents),mio2eur(gdppercapita)),population) compgdppercap(compgdp(mio2eur(gdpcomponents),gdpcomponents),population) compgdppercap(compgdp(mio2eur(gdpcomponents),gdppercapita),population) compgdppercap(compgdp(mio2eur(gdppercapita),mio2eur(gdpcomponents)),population) compgdppercap(compgdp(mio2eur(gdppercapita),mio2eur(gdppercapita)),population) compgdppercap(compgdp(mio2eur(gdppercapita),gdpcomponents),population) compgdppercap(compgdp(mio2eur(gdppercapita),gdppercapita),population) compgdppercap(compgdp(gdpcomponents,mio2eur(gdpcomponents)),population) compgdppercap(compgdp(gdpcomponents,mio2eur(gdppercapita)),population) compgdppercap(compgdp(gdpcomponents,gdpcomponents),population) compgdppercap(compgdp(gdpcomponents,gdppercapita),population) compgdppercap(compgdp(gdppercapita,mio2eur(gdpcomponents)),population) compgdppercap(compgdp(gdppercapita,mio2eur(gdppercapita)),population) compgdppercap(compgdp(gdppercapita,gdpcomponents),population) compgdppercap(compgdp(gdppercapita,gdppercapita),population) compgdppercap(mio2eur(compgdp(gdpcomponents,mio2eur(gdpcomponents))),population) compgdppercap(mio2eur(compgdp(gdpcomponents,mio2eur(gdppercapita))),population) compgdppercap(mio2eur(compgdp(gdpcomponents,gdpcomponents)),population) compgdppercap(mio2eur(compgdp(gdpcomponents,gdppercapita)),population) compgdppercap(mio2eur(compgdp(gdppercapita,mio2eur(gdpcomponents))),population) compgdppercap(mio2eur(compgdp(gdppercapita,mio2eur(gdppercapita))),population) compgdppercap(mio2eur(compgdp(gdppercapita,gdpcomponents)),population) compgdppercap(mio2eur(compgdp(gdppercapita,gdppercapita)),population) compgdppercap(mio2eur(gdpcomponents),population) compgdppercap(mio2eur(gdppercapita),population) compgdppercap(gdpcomponents,population) compgdppercap(gdppercapita,population) compgdp(mio2eur(gdpcomponents),mio2eur(gdpcomponents)) compgdp(mio2eur(gdpcomponents),mio2eur(gdppercapita)) compgdp(mio2eur(gdpcomponents),gdpcomponents) compgdp(mio2eur(gdpcomponents),gdppercapita) compgdp(mio2eur(gdppercapita),mio2eur(gdpcomponents)) compgdp(mio2eur(gdppercapita),mio2eur(gdppercapita)) compgdp(mio2eur(gdppercapita),gdpcomponents) compgdp(mio2eur(gdppercapita),gdppercapita) compgdp(gdpcomponents,mio2eur(gdpcomponents)) compgdp(gdpcomponents,mio2eur(gdppercapita)) compgdp(gdpcomponents,gdpcomponents) compgdp(gdpcomponents,gdppercapita) compgdp(gdppercapita,mio2eur(gdpcomponents)) compgdp(gdppercapita,mio2eur(gdppercapita)) compgdp(gdppercapita,gdpcomponents) compgdp(gdppercapita,gdppercapita) mio2eur(compgdp(gdpcomponents,mio2eur(gdpcomponents))) mio2eur(compgdp(gdpcomponents,mio2eur(gdppercapita))) mio2eur(compgdp(gdpcomponents,gdpcomponents)) mio2eur(compgdp(gdpcomponents,gdppercapita)) mio2eur(compgdp(gdppercapita,mio2eur(gdpcomponents))) mio2eur(compgdp(gdppercapita,mio2eur(gdppercapita))) mio2eur(compgdp(gdppercapita,gdpcomponents)) mio2eur(compgdp(gdppercapita,gdppercapita)) mio2eur(gdpcomponents) mio2eur(gdppercapita) population gdpcomponents gdppercapita
Example prolog program with additional EUR2MIO correspondence leading to a cycle (GDP_CAP)
:- auto_table. /* Datasets */ dataset(gdppercapita). dimension(gdppercapita, geo). dimension(gdppercapita, unit). dimension(gdppercapita, date). dimension(gdppercapita, indicna). dataset(gdpcomponents). dimension(gdpcomponents, geo). dimension(gdpcomponents, unit). dimension(gdpcomponents, date). dimension(gdpcomponents, indicna). dataset(population). dimension(population, geo). dimension(population, date). dimension(population, sex). dimension(population, age). /* mio2eur */ /* The generation of the dataset */ dataset(mio2eur(X)) :- dataset(X), dimension(X,unit), ( \+ dimensionmember(X,unit,Z); dimensionmember(X,unit,mioeur) ). /* Copying over of dimension members */ dimensionmember(mio2eur(X), Y, V) :- dataset(X), dimension(X,unit), ( \+ dimensionmember(X,unit,Z); dimensionmember(X,unit,mioeur) ), dimensionmember(X,Y,V), \+ dimensionmember(X, unit, mioeur). /* Setting the new dimension member */ dimensionmember(mio2eur(X), unit, eur) :- dataset(X), dimension(X,unit), ( \+ dimensionmember(X,unit,Z); dimensionmember(X,unit,mioeur) ). /* Copying over of dimensions (of first cube in case of merging correspondence */ dimension(mio2eur(X), Y) :- dataset(X), dimension(X,unit), ( \+ dimensionmember(X,unit,Z); dimensionmember(X,unit,mioeur) ), dimension(X,Y). /* eur2mio */ /* The generation of the dataset */ dataset(eur2mio(X)) :- dataset(X), dimension(X,unit), ( \+ dimensionmember(X,unit,Z); dimensionmember(X,unit,eur) ). /* Copying over of dimension members */ dimensionmember(eur2mio(X), Y, V) :- dataset(X), dimension(X,unit), ( \+ dimensionmember(X,unit,Z); dimensionmember(X,unit,eur) ), dimensionmember(X,Y,V), \+ dimensionmember(X, unit, eur). /* Setting the new dimension member */ dimensionmember(eur2mio(X), unit, mioeur) :- dataset(X), dimension(X,unit), ( \+ dimensionmember(X,unit,Z); dimensionmember(X,unit,eur) ). /* Copying over of dimensions (of first cube in case of merging correspondence */ dimension(eur2mio(X), Y) :- dataset(X), dimension(X,unit), ( \+ dimensionmember(X,unit,Z); dimensionmember(X,unit,eur) ), dimension(X,Y). /* Here, the program should not stop since there is a cycle in the definitions of correspondences */
Program for computing the number of derived data cubes in case conversion correspondences are seen as merging correspondences and no cycles (repeated application of correspondences) are allowed
- See function and test case in OLAP4LD: testExample_QB_Datasets_ConvertCube_QueryTestnumberForMergeChildren() at [9].
/**
*
* The ordering of Merge-Cubes is relevant but every Merge-Cube may only be
* used once in a query plan (no cycles).
*
* Implementation for GlobalCube paper: noc(dp,ds,mc)
*
* @param dp
* Depth of query plan
* @param ds
* Number of datasets (converted or not converted)
* @param mc
* Number of merge-cubes
* @return Number of query plans
*/
public static int numberForMergeChildren(int dp, int ds, int mc) {
if (dp == 0) {
return ds;
}
int no = 0;
// Both same depth
no += mc * mc * numberForMergeChildren(dp - 1, ds, mc - 1)
* numberForMergeChildren(dp - 1, ds, mc - 1);
// Left
for (int i = 0; i < dp - 1; i++) {
no += mc * mc * numberForMergeChildren(dp - 1, ds, mc - 1)
* numberForMergeChildren(i, ds, mc - 1);
}
// Right
for (int i = 0; i < dp - 1; i++) {
no += mc * mc * numberForMergeChildren(dp - 1, ds, mc - 1)
* numberForMergeChildren(i, ds, mc - 1);
}
return no;
}
