Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # Example SSB dataset for olap4ld testing
- # Author: Benedikt Kämpgen
- @prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> .
- @prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .
- @prefix owl: <http://www.w3.org/2002/07/owl#> .
- @prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
- @prefix skos: <http://www.w3.org/2004/02/skos/core#> .
- @prefix void: <http://rdfs.org/ns/void#> .
- @prefix dct: <http://purl.org/dc/terms/> .
- @prefix foaf: <http://xmlns.com/foaf/0.1/> .
- @prefix org: <http://www.w3.org/ns/org#> .
- @prefix admingeo: <http://data.ordnancesurvey.co.uk/ontology/admingeo/> .
- @prefix interval: <http://reference.data.gov.uk/def/intervals/> .
- @prefix qb: <http://purl.org/linked-data/cube#> .
- @prefix qb4o: <http://purl.org/olap#> .
- @prefix sdmx: <http://purl.org/linked-data/sdmx#> .
- @prefix sdmx-concept: <http://purl.org/linked-data/sdmx/2009/concept#> .
- @prefix sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#> .
- @prefix sdmx-attribute: <http://purl.org/linked-data/sdmx/2009/attribute#> .
- @prefix sdmx-measure: <http://purl.org/linked-data/sdmx/2009/measure#> .
- @prefix sdmx-metadata: <http://purl.org/linked-data/sdmx/2009/metadata#> .
- @prefix sdmx-code: <http://purl.org/linked-data/sdmx/2009/code#> .
- @prefix sdmx-subject: <http://purl.org/linked-data/sdmx/2009/subject#> .
- @prefix : <http://pastebin.com/raw.php?i=839G2u72#> .
- # -- Data Set --------------------------------------------
- :ds
- a qb:DataSet ;
- rdfs:label "Pastebin Example Star Schema Dataset"@en ;
- qb:structure :dsd.
- # -- Data structure definition ----------------------------
- :dsd
- rdfs:label "Example Star Schema Benchmark Datastructuredefinition"@en ;
- a qb:DataStructureDefinition ;
- qb:component
- [ qb:dimension :lo_orderdate ],
- [ qb:dimension :lo_custkey ],
- [ qb:dimension :lo_partkey ],
- [ qb:dimension :lo_suppkey ];
- qb:component
- [ qb:measure :lo_quantity; qb4o:hasAggregateFunction qb4o:sum ],
- [ qb:measure :lo_discount; qb4o:hasAggregateFunction qb4o:avg ],
- [ qb:measure :lo_extendedprice; qb4o:hasAggregateFunction qb4o:sum ],
- [ qb:measure :lo_revenue; qb4o:hasAggregateFunction qb4o:sum ],
- [ qb:measure :lo_supplycost; qb4o:hasAggregateFunction qb4o:sum ];
- .
- # -- Dimensions and measures -----------------------------
- :lo_orderdate a rdf:Property, qb:DimensionProperty;
- rdfs:label "Dates"@en ;
- rdfs:range skos:Concept ;
- qb:codeList :lo_orderdateCodeList ;
- .
- :lo_custkey a rdf:Property, qb:DimensionProperty;
- rdfs:label "Customers"@en ;
- rdfs:range skos:Concept ;
- qb:codeList :lo_custkeyCodeList ;
- .
- :lo_partkey a rdf:Property, qb:DimensionProperty;
- rdfs:label "Products"@en ;
- rdfs:range skos:Concept ;
- qb:codeList :lo_partkeyCodeList ;
- .
- :lo_suppkey a rdf:Property, qb:DimensionProperty;
- rdfs:label "Suppliers"@en ;
- rdfs:range skos:Concept ;
- qb:codeList :lo_suppkeyCodeList ;
- .
- :lo_quantity a rdf:Property, qb:MeasureProperty;
- rdfs:label "quantity"@en ;
- rdfs:subPropertyOf sdmx-measure:obsValue;
- rdfs:range xsd:decimal ;
- .
- :lo_discount a rdf:Property, qb:MeasureProperty;
- rdfs:label "discount"@en ;
- rdfs:subPropertyOf sdmx-measure:obsValue;
- rdfs:range xsd:decimal ;
- .
- :lo_extendedprice a rdf:Property, qb:MeasureProperty ;
- rdfs:label "extendedprice"@en ;
- rdfs:subPropertyOf sdmx-measure:obsValue ;
- rdfs:range xsd:decimal ;
- .
- :lo_revenue a rdf:Property, qb:MeasureProperty;
- rdfs:label "revenue"@en ;
- rdfs:subPropertyOf sdmx-measure:obsValue;
- rdfs:range xsd:decimal ;
- .
- :lo_supplycost a rdf:Property, qb:MeasureProperty;
- rdfs:label "supplycost"@en ;
- rdfs:subPropertyOf sdmx-measure:obsValue;
- rdfs:range xsd:decimal ;
- .
- # -- Code lists -------------------------------------------
- :lo_orderdateCodeList a skos:ConceptScheme, sdmx:CodeList;
- rdfs:label "Dates"@en ;
- skos:hasTopConcept :date_19940101;
- skos:hasTopConcept :date_19940601;
- .
- :lo_custkeyCodeList a skos:ConceptScheme, sdmx:CodeList;
- rdfs:label "Customers"@en ;
- skos:hasTopConcept :customer_1;
- skos:hasTopConcept :customer_2;
- skos:hasTopConcept :customer_3;
- .
- :lo_partkeyCodeList a skos:ConceptScheme, sdmx:CodeList;
- rdfs:label "Products"@en ;
- skos:hasTopConcept :part_1;
- skos:hasTopConcept :part_2;
- skos:hasTopConcept :part_3;
- .
- :lo_suppkeyCodeList a skos:ConceptScheme, sdmx:CodeList;
- rdfs:label "Suppliers"@en ;
- skos:hasTopConcept :supplier_1;
- skos:hasTopConcept :supplier_2;
- .
- # -- Concepts -----------------------------------------
- :date_19940101 a skos:Concept;
- skos:inScheme :lo_orderdateCodeList
- .
- :date_19940601 a skos:Concept;
- skos:inScheme :lo_orderdateCodeList
- .
- :customer_1 a skos:Concept;
- skos:inScheme :lo_custkeyCodeList
- .
- :customer_2 a skos:Concept;
- skos:inScheme :lo_custkeyCodeList
- .
- :customer_3 a skos:Concept;
- skos:inScheme :lo_custkeyCodeList
- .
- :part_1 a skos:Concept;
- skos:inScheme :lo_partkeyCodeList
- .
- :part_2 a skos:Concept;
- skos:inScheme :lo_partkeyCodeList
- .
- :part_3 a skos:Concept;
- skos:inScheme :lo_partkeyCodeList
- .
- :supplier_1 a skos:Concept;
- skos:inScheme :lo_suppkeyCodeList
- .
- :supplier_2 a skos:Concept;
- skos:inScheme :lo_suppkeyCodeList
- .
- # -- Observations -----------------------------------------
- :lineorder_1_1
- a :lineorder ;
- a qb:Observation ;
- qb:dataSet :ds ;
- :lo_orderdate :date_19940101 ;
- :lo_custkey :customer_1 ;
- :lo_partkey :part_1 ;
- :lo_suppkey :supplier_1 ;
- :lo_quantity 17 ;
- :lo_discount 100 ;
- :lo_extendedprice 2471035e0 ;
- :lo_supplycost 87213 ;
- :lo_revenue 2372193 ;
- .
- :lineorder_1_2
- a :lineorder ;
- a qb:Observation ;
- qb:dataSet :ds ;
- :lo_orderdate :date_19940101 ;
- :lo_custkey :customer_2 ;
- :lo_partkey :part_1 ;
- :lo_suppkey :supplier_1 ;
- :lo_quantity 17 ;
- :lo_discount 4e0 ;
- :lo_extendedprice 2471035e0 ;
- :lo_supplycost 87213 ;
- :lo_revenue 2372193 ;
- .
- :lineorder_1_3
- a :lineorder ;
- a qb:Observation ;
- qb:dataSet :ds ;
- :lo_orderdate :date_19940101 ;
- :lo_custkey :customer_1 ;
- :lo_partkey :part_3 ;
- :lo_suppkey :supplier_1 ;
- :lo_quantity 17 ;
- :lo_discount 4e0 ;
- :lo_extendedprice 2471035e0 ;
- :lo_supplycost 87213 ;
- :lo_revenue 2372193 ;
- .
- :lineorder_1_4
- a :lineorder ;
- a qb:Observation ;
- qb:dataSet :ds ;
- :lo_orderdate :date_19940101 ;
- :lo_custkey :customer_2 ;
- :lo_partkey :part_1 ;
- :lo_suppkey :supplier_2 ;
- :lo_quantity 17 ;
- :lo_discount 4e0 ;
- :lo_extendedprice 2471035e0 ;
- :lo_supplycost 87213 ;
- :lo_revenue 2372193 ;
- .
- :lineorder_1_5
- a :lineorder ;
- a qb:Observation ;
- qb:dataSet :ds ;
- :lo_orderdate :date_19940101 ;
- :lo_custkey :customer_2 ;
- :lo_partkey :part_3 ;
- :lo_suppkey :supplier_2 ;
- :lo_quantity 17 ;
- :lo_discount 100 ;
- :lo_extendedprice 2471035e0 ;
- :lo_supplycost 87213 ;
- :lo_revenue 2372193 ;
- .
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement