[ACM Press the 9th ACM international workshop - Arlington, Virginia, USA (2006.11.10-2006.11.10)] Proceedings of the 9th ACM international workshop on Data warehousing and OLAP - DOLAP '06 - Towards a logical multidimensional model for spatial data warehousing and OLAP

✍ Scribed by Sampaio, Marcus Costa; de Sousa, André Gomes; Baptista, Cláudio de Souza

• Book ID: 118251087
• Publisher: ACM Press
• Year: 2006
• Weight: 585 KB
• Volume: 0
• Category: Article
• ISBN-13: 9781595935304
• DOI: 10.1145/1183512.1183528

✦ Synopsis

Decision support systems (DSS) may be enhanced qualitatively if they are able to also deal with spatial dimensions and measures. Regardless the evident importance of using data warehousing and OLAP in DSS, the incorporation of spatial dimensions and measures enables to locate more efficiently tendencies in a given application domain, by using dynamic maps with zooming, panning, aggregation and other spatial functionalities. Therefore, it is necessary to converge two relatively consolidated technologies: Data Warehousing and Geographical Information Systems. This integration gives raise to a new research area called Spatial Data Warehousing (SDW), which introduces new research challenges. This paper proposes a novel logical multidimensional model suitable for SDW, which is implemented on the top of an object-relational database system with support for spatial data. Moreover, the paper addresses query optimization techniques to enhance performance and it describes a prototype, which has been built to validate the proposed ideas.