spatial data warehouses and solap: a new gis technology geosciences, mapping day jean-paul kasprzyk,...
Post on 20-Dec-2015
220 views
TRANSCRIPT
![Page 1: Spatial data warehouses and SOLAP: a new GIS technology Geosciences, mapping day Jean-Paul KASPRZYK, phd student](https://reader035.vdocuments.us/reader035/viewer/2022062308/56649d4f5503460f94a2ea2e/html5/thumbnails/1.jpg)
Spatial data warehouses and SOLAP: a new GIS technology
Geosciences, mapping day
Jean-Paul KASPRZYK, phd student
![Page 2: Spatial data warehouses and SOLAP: a new GIS technology Geosciences, mapping day Jean-Paul KASPRZYK, phd student](https://reader035.vdocuments.us/reader035/viewer/2022062308/56649d4f5503460f94a2ea2e/html5/thumbnails/2.jpg)
JP Kasprzyk – Spatial data warehouses and SOLAP: a new GIS technology
October 2011
Introduction: GIS and SOLAP
• GIS : OnLine 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 OnLine 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
![Page 3: Spatial data warehouses and SOLAP: a new GIS technology Geosciences, mapping day Jean-Paul KASPRZYK, phd student](https://reader035.vdocuments.us/reader035/viewer/2022062308/56649d4f5503460f94a2ea2e/html5/thumbnails/3.jpg)
JP Kasprzyk – Spatial data warehouses and SOLAP: a new GIS technology
October 2011
Multidimensional approach
Fact: offence
Time: year
Time: month
Time: day
SerialOffender address
Commune
Province
Offence Place
Commune
Commune
Province
Offence Place
Commune
Offence Place
Snowflake schema of the criminal data
![Page 4: Spatial data warehouses and SOLAP: a new GIS technology Geosciences, mapping day Jean-Paul KASPRZYK, phd student](https://reader035.vdocuments.us/reader035/viewer/2022062308/56649d4f5503460f94a2ea2e/html5/thumbnails/4.jpg)
JP Kasprzyk – Spatial data warehouses and SOLAP: a new GIS technology
October 2011
SOLAP Architecture
ETL Data warehouse
Data cube
(SOLAP server)OLAP
SOLAP
Source data
![Page 5: Spatial data warehouses and SOLAP: a new GIS technology Geosciences, mapping day Jean-Paul KASPRZYK, phd student](https://reader035.vdocuments.us/reader035/viewer/2022062308/56649d4f5503460f94a2ea2e/html5/thumbnails/5.jpg)
JP Kasprzyk – Spatial data warehouses and SOLAP: a new GIS technology
October 2011
Data integration : ETL (extract transform load)
![Page 6: Spatial data warehouses and SOLAP: a new GIS technology Geosciences, mapping day Jean-Paul KASPRZYK, phd student](https://reader035.vdocuments.us/reader035/viewer/2022062308/56649d4f5503460f94a2ea2e/html5/thumbnails/6.jpg)
JP Kasprzyk – Spatial data warehouses and SOLAP: a new GIS technology
October 2011
OLAP interface : drill down Operation
drill down
![Page 7: Spatial data warehouses and SOLAP: a new GIS technology Geosciences, mapping day Jean-Paul KASPRZYK, phd student](https://reader035.vdocuments.us/reader035/viewer/2022062308/56649d4f5503460f94a2ea2e/html5/thumbnails/7.jpg)
JP Kasprzyk – Spatial data warehouses and SOLAP: a new GIS technology
October 2011
OLAP interface : drill through operation
drill through
![Page 8: Spatial data warehouses and SOLAP: a new GIS technology Geosciences, mapping day Jean-Paul KASPRZYK, phd student](https://reader035.vdocuments.us/reader035/viewer/2022062308/56649d4f5503460f94a2ea2e/html5/thumbnails/8.jpg)
JP Kasprzyk – Spatial data warehouses and SOLAP: a new GIS technology
October 2011
OLAP interface: slice operationSlice (time) Slice (serie)
![Page 9: Spatial data warehouses and SOLAP: a new GIS technology Geosciences, mapping day Jean-Paul KASPRZYK, phd student](https://reader035.vdocuments.us/reader035/viewer/2022062308/56649d4f5503460f94a2ea2e/html5/thumbnails/9.jpg)
JP Kasprzyk – Spatial data warehouses and SOLAP: a new GIS technology
October 2011
OLAP interface: graphic exports
![Page 10: Spatial data warehouses and SOLAP: a new GIS technology Geosciences, mapping day Jean-Paul KASPRZYK, phd student](https://reader035.vdocuments.us/reader035/viewer/2022062308/56649d4f5503460f94a2ea2e/html5/thumbnails/10.jpg)
JP Kasprzyk – Spatial data warehouses and SOLAP: a new GIS technology
October 2011
SOLAP Interface: spatial drill down (1)
MDX request
SELECT {[Measures].[offence]} ON COLUMNS,{[offence place].[province].members} ON ROWSFROM [offence]
![Page 11: Spatial data warehouses and SOLAP: a new GIS technology Geosciences, mapping day Jean-Paul KASPRZYK, phd student](https://reader035.vdocuments.us/reader035/viewer/2022062308/56649d4f5503460f94a2ea2e/html5/thumbnails/11.jpg)
JP Kasprzyk – Spatial data warehouses and SOLAP: a new GIS technology
October 2011
SOLAP interface: spatial drill down (2)
![Page 12: Spatial data warehouses and SOLAP: a new GIS technology Geosciences, mapping day Jean-Paul KASPRZYK, phd student](https://reader035.vdocuments.us/reader035/viewer/2022062308/56649d4f5503460f94a2ea2e/html5/thumbnails/12.jpg)
JP Kasprzyk – Spatial data warehouses and SOLAP: a new GIS technology
October 2011
SOLAP Interface :
![Page 13: Spatial data warehouses and SOLAP: a new GIS technology Geosciences, mapping day Jean-Paul KASPRZYK, phd student](https://reader035.vdocuments.us/reader035/viewer/2022062308/56649d4f5503460f94a2ea2e/html5/thumbnails/13.jpg)
JP Kasprzyk – Spatial data warehouses and SOLAP: a new GIS technology
October 2011
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
![Page 14: Spatial data warehouses and SOLAP: a new GIS technology Geosciences, mapping day Jean-Paul KASPRZYK, phd student](https://reader035.vdocuments.us/reader035/viewer/2022062308/56649d4f5503460f94a2ea2e/html5/thumbnails/14.jpg)
JP Kasprzyk – Spatial data warehouses and SOLAP: a new GIS technology
October 2011
Thank you for listening
Any question?