Spatial Data Warehouses And Solap 2q2n6z
This document was ed by and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this report form. Report 3i3n4
Overview 26281t
& View Spatial Data Warehouses And Solap as PDF for free.
More details 6y5l6z
- Words: 438
- Pages: 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 : 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 (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].} 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
• 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? [email protected]
October 2011
JP Kasprzyk – Spatial data warehouses and SOLAP: a new GIS technology
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 (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].} 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
• 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? [email protected]
October 2011
Related Documents 3h463d
Spatial Data Warehouses And Solap 2q2n6z
November 2019 45
Bing Spatial Data Services 6lm4o
November 2019 55
Spatial Dynamics And Multidimensional Perception 2sl34
November 2019 31
Unit 4 Mining Object Spatial Multimedia Text And Web Data 4t4j4k
August 2021 0
Spatial Hearing 3o2m4n
July 2021 0
Introduction To Warehouses k85u
October 2019 61More Documents from "Er Mahendra Gangurde" 411e3d
Spatial Data Warehouses And Solap 2q2n6z
November 2019 45
Jira Tutorial.ppt 1j632f
November 2022 0
Tax Applicable (tax Deducted/collected At Source From) (0021)non-company Deductees (0020)company a6h2t
December 2019 51
Laporan Alat Berat 52y3b
April 2020 27
A Tutorial Ex1 6t271o
October 2019 89