Database Reference
In-Depth Information
@prefix sdmx-dimension:
<
http://purl.org/linked-data/sdmx/2009/dimension#
>
.
@prefix skos:
<
http://www.w3.org/2004/02/skos/core#
>
.
@prefix db:
<
http://dbpedia.org/resource/
>
.
Dimensions are defined using the property
qb:DimensionProperty
as follows:
nw:Employee a rdf:Property, qb:DimensionProperty ; rdfs:label
''
Employee
''
@en .
nw:OrderDate a rdf:Property, qb:DimensionProperty ; rdfs:label
''
Order Date
''
@en ;
rdfs:subPropertyOf sdmx-dimension:refPeriod ;
qb:concept sdmx-concept:refPeriod .
nw:DueDate a rdf:Property, qb:DimensionProperty ; rdfs:label
''
Due Date
''
@en ;
rdfs:subPropertyOf sdmx-dimension:refPeriod ;
qb:concept sdmx-concept:refPeriod .
nw:ShippedDate a rdf:Property, qb:DimensionProperty ;
rdfs:label
''
Shipped Date
''
@en ; rdfs:subPropertyOf sdmx-dimension:refPeriod ;
qb:concept sdmx-concept:refPeriod .
nw:Product a rdf:Property, qb:DimensionProperty ; rdfs:label
''
Product
''
@en .
nw:Order a rdf:Property, qb:DimensionProperty ; rdfs:label
''
Order
''
@en .
nw:Shipper a rdf:Property, qb:DimensionProperty ; rdfs:label
''
Shipper
''
@en .
nw:Customer a rdf:Property, qb:DimensionProperty ; rdfs:label
''
Customer
''
@en .
nw:Supplier a rdf:Property, qb:DimensionProperty ; rdfs:label
''
Suppliers
''
@en .
A cube is defined using the property
qb:DataStructureDefinition
, and its
dimensions are defined using the property
qb4o:level
, as follows:
nw:Northwind a qb:DataStructureDefinition ;
qb:component [qb4o:level nw:Employee] ;
qb:component [qb4o:level nw:OrderDate] ;
qb:component [qb4o:level nw:DueDate] ;
qb:component [qb4o:level nw:ShippedDate] ;
qb:component [qb4o:level nw:Product] ;
qb:component [qb4o:level nw:Order] ;
qb:component [qb4o:level nw:Shipper] ;
qb:component [qb4o:level nw:Supplier] ;
qb:component [qb4o:level nw:Customer] ;
Measures are defined using the property
qb:measure
, where the aggre-
gate function associated with each measure is defined using the property
qb4o:hasAggregateFunction
:
qb:component [qb:measure nw:Quantity ;
qb4o:hasAggregateFunction qb4o:sum] ;
qb:component [qb:measure nw:UnitPrice ;
qb4o:hasAggregateFunction qb4o:avg] ;
qb:component [qb:measure nw:Discount ;
qb4o:hasAggregateFunction qb4o:avg] ;
qb:component [qb:measure nw:SalesAmount ;
qb4o:hasAggregateFunction qb4o:sum] ;
qb:component [qb:measure nw:Freight ;
qb4o:hasAggregateFunction qb4o:sum] ;
qb:component [qb:measure nw:NetAmount ;
qb4o:hasAggregateFunction qb4o:sum] .
Search WWH ::
Custom Search