Spatial data warehouses and SOLAP a new GIS
- Slides: 14
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
- Spatial data vs non spatial data
- Data warehouses generalize and consolidate data in
- Gis data structure
- Keyboard entry in gis
- Chapter 13. business intelligence and data warehouses
- Introduction to databases and data warehouses
- Different olap architectures
- Udp to data warehouses
- Making spatial decisions using gis
- Businesses often call their stores and warehouses
- Spatial data and attribute data
- Spatial data and attribute data
- Data mashups and gis are data integration technologies.
- Data mashups and gis are data integration technologies.
- Warehouses reynosa