# 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 ;
    .