50 likes | 67 Views
OLAP CUBE. ESPON 2013 DB Project Partner. Grids: a useful tool for rebuilding time series Towards an ESPON OLAP Cube. Maria José Ramos Roger Milego Agràs. Luxembourg, 6th May 2010. Methodology overview. Weighted by Population. Unemployment 2001 (Eurostat). Disaggregation.
E N D
OLAP CUBE ESPON 2013 DB Project Partner Grids: a useful tool for rebuilding time series Towards an ESPON OLAP Cube Maria José Ramos Roger Milego Agràs Luxembourg, 6th May 2010
Methodology overview Weighted by Population Unemployment 2001 (Eurostat) Disaggregation Population Grid 2001 (JRC) Ref. Grid 1km Integration Aggregation CLC 2000 (EEA) Integration OLAP CUBE
Methodology overview A “cocktail” of data MEASURES MEASURES - grams - ml - Area - Population - € OLAP CUBE INGREDIENTS DIMENSIONS Sugar Lime Fruit Rhum Ecological Background Corine Land Cover Nuts Maps Daikiri Graphics & Statistics
Let’s taste the “cocktail” • Combining data from different times • Combining data from different geometries (e.g. NUTS 2003, NUTS 2006) • Combining continuous data (e.g. CLC) with discrete data (e.g. NUTS3) • Complex combinations (…)
ESPON 2013 DB Project Partner Thank you very much for your attention! Merci bien pour votre attention! For further info: roger.milego@uab.cat mariajose.ramos@uab.cat