Example QB Datasets

Olap4ld shall allow to analyse instances of qb:DataSets, complying to the RDF Data Cube Vocabulary.

Sources for datasets

• PlanetData wiki datasets: http://wiki.planet-data.eu/web/Datasets
• For a list of implementations, see [1].

List of example datasets

We give a list of example datasets that can be analysed using olap4ld. Also we link to sources for more datasets.

Estatwrap: Eurostat Wrapper

• DS:
• Measures: obs value (but actually: average gdp growth rate,...)
• Dimensions: geo, year, sex...
• Problems
  • On Estatwrap, the ds URI is not easily given (in TOC?)

Edgar Wrap

• DS:
• Measures: (there are two possibilities: 1) Every subject is published as an own measure 2) Subject is added as a dimension. When do you do what? If you want to have different aggregation functions depending on the subject, use measure. If you want to have derived measures from combinations of subjects, use measure. If certain measure has certain unit, use measure dimension approach of QB or attach unit directly to measure.
• Dimension: Issuer, Period, (Subject), Segment...
• COSTCO WHOLESALE CORP /NEW - 909832/0001193125-10-230379
• PD: http://wiki.planet-data.eu/web/COSTCO_WHOLESALE_CORP_/NEW_-_909832/0001193125-10-230379
• http://edgarwrap.ontologycentral.com/archive/909832/0001193125-10-230379#ds
• Problems: No code lists.

SMART-DB Wrapper: Location AD0514 Analysis object Q Dataset

• Watch out, we need to refresh our access
• DS: http://smartdbwrap.appspot.com/id/locationdataset/AD0514/Q
• DSD (in Dropedia): http://agkwebserver2.agk.uni-karlsruhe.de/~dropedia/index.php/Special:URIResolver/SMART-2DDB-2DDSD
• Measure: We probably want different measures for different "analysis objects". This way, it cannot happen that we average over different analysis objects (e.g., Ph-value and precipitation, which oes not make sense)
• Dimension:
• Problem: No code lists. DSD only gives us direct neighbours.

Yahoo! Finance Wrapper: Yahoo! Finance Stock Market Information for Bank of America Corporation on 2012-12-12

• http://yahoofinancewrap.appspot.com/archive/BAC/2012-12-12#ds
• http://yahoofinancewrap.appspot.com/archive/BAC/2012-12-12#dsd
• Problems: No code lists.

Cumulated German General Social Survey (aggregated)

• DS (http://lod.gesis.org/lodpilot/ALLBUS/ZA4570v590.rdf#ds)
• DSD (http://lod.gesis.org/lodpilot/ALLBUS/za4570dsd.rdf#dsd)

Corruption Perceptions Index 2011

• http://transparency.270a.info/dataset/corruption-perceptions-index/2011
• Problems: No observations

FURCHT: STELLUNGSVERLUST, ARBEITNEHMER

• DS: http://lod.gesis.org/lodpilot/ALLBUS/ZA4570v590.rdf#ds
• DSD: http://lod.gesis.org/lodpilot/ALLBUS/za4570dsd.rdf#dsd
• Code list: e.g., geo http://lod.gesis.org/lodpilot/ALLBUS/geo.rdf#list
• Problems: Dimensions do not have a range (maybe explicit: skos:Concept)

Health Status

• DS: http://oecd.270a.info/dataset/HEALTH_STAT
• DSD: http://oecd.270a.info/structure/HEALTH_STAT

Dataset: Utilities consumption data

• DS: http://cofog01.data.scotland.gov.uk/id/dataset/golspie/utilities
• DSD: no dsd
• Problem: no dsd, no access to observations via Linked Data (only SPARQL endpoint)

SSB Dataset

• DS: http://olap4ld.googlecode.com/git/OLAP4LD-trunk/tests/ssb001/ttl/lineorder_qb.ttl#ds
• DSD: http://olap4ld.googlecode.com/git/OLAP4LD-trunk/tests/ssb001/ttl/dsd.ttl#dsd

ITUA-Imputed (Web Foundation; Web Index; RDF Data Cube Dataset)

• http://wiki.planet-data.eu/web/ITUA-Imputed_(Web_Foundation;_Web_Index;_RDF_Data_Cube_Dataset)
• DS: http://data.webfoundation.org/webindex/dataset/ITUA-Imputed
• DSD: http://data.webfoundation.org/webindex/dsd/ITUA-Imputed
• Problem: Linked Data as published by Pubby. Blank node components cannot be resolved