Spatial data warehouses and SOLAP a new GIS

Spatial data warehouses and SOLAP: a new GIS technology Geosciences, mapping day Jean-Paul KASPRZYK, phd student

JP Kasprzyk – Spatial data warehouses and SOLAP: a new GIS technology Introduction: GIS and SOLAP • GIS : On. Line Transactional Processing (OLTP) – Daily management of spatial data • Easy update, integrity and no redundancy of the data – Based on transactional databases • Entity association approach • Easy access to data • SOLAP : Spatial On. Line Analytical Processing (Bédard, 1997) – Decision support (Business intelligence) • Archiving temporal dimension – Based on data warehouses • Multidimensional approach • Easy exploration of the data at different aggregation levels • Integration of large amount of heterogeneous data October 2011

JP Kasprzyk – Spatial data warehouses and SOLAP: a new GIS technology Multidimensional approach Time: day Province Commune Time: month Offence Place Time: year Fact: offence Offender address Serial Commune Snowflake schema of the criminal data Province October 2011

JP Kasprzyk – Spatial data warehouses and SOLAP: a new GIS technology SOLAP Architecture ETL Data warehouse Source data OLAP Data cube (SOLAP server) SOLAP October 2011

JP Kasprzyk – Spatial data warehouses and SOLAP: a new GIS technology Data integration : ETL (extract transform load) October 2011

JP Kasprzyk – Spatial data warehouses and SOLAP: a new GIS technology OLAP interface : drill down Operation drill down October 2011

JP Kasprzyk – Spatial data warehouses and SOLAP: a new GIS technology OLAP interface : drill through operation drill through October 2011

JP Kasprzyk – Spatial data warehouses and SOLAP: a new GIS technology OLAP interface: slice operation Slice (time) Slice (serie) October 2011

JP Kasprzyk – Spatial data warehouses and SOLAP: a new GIS technology OLAP interface: graphic exports October 2011

JP Kasprzyk – Spatial data warehouses and SOLAP: a new GIS technology SOLAP Interface: spatial drill down (1) MDX request SELECT {[Measures]. [offence]} ON COLUMNS, {[offence place]. [province]. members} ON ROWS FROM [offence] October 2011

JP Kasprzyk – Spatial data warehouses and SOLAP: a new GIS technology SOLAP interface: spatial drill down (2) October 2011

JP Kasprzyk – Spatial data warehouses and SOLAP: a new GIS technology SOLAP Interface : October 2011

JP Kasprzyk – Spatial data warehouses and SOLAP: a new GIS technology Conclusion • Advantages of SOLAP – Integration and exploration of large amounts of heterogeneous data – Simple interface – Quick requests – Ideal for decision support • Spatial OLAP = new technologies – spatial operations can still be improved • Example: buffer operation through the data cube October 2011

JP Kasprzyk – Spatial data warehouses and SOLAP: a new GIS technology Thank you for listening Any question? Jp. kasprzyk@ulg. ac. be October 2011