Article

Towards a logical multidimensional model for spatial data warehousing and OLAP

Authors:

Marcus Costa Sampaio,

André Gomes de Sousa,

Cláudio de Souza BaptistaAuthors Info & Claims

DOLAP '06: Proceedings of the 9th ACM international workshop on Data warehousing and OLAP

Pages 83 - 90

https://doi.org/10.1145/1183512.1183528

Published: 10 November 2006 Publication History

Get Access

Abstract

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.

References

[1]

Bimonte, S., Tchounikine, A., and Miquel, M. Towards a Spatial Multidimensional Model. In Proceedings of the Data Warehousing and OLAP Conference (DOLAP'05), 2005, 39--46.

Digital Library

Google Scholar

[2]

Damiani, M.L., and Spaccapietra S. Spatial Data Warehouse Modeling. Processing and Managing Complex Data for Decision Support, Darmont, J. & Boussaid, O. (Eds), IDEA Group Publishing, 2006, 1--27.

Google Scholar

[3]

Goldstein J., and Larson P. Optimizing Queries Using Materialized Views: a Practical, Scalable Solution. In Proceedings of the ACM SIGMOD, 2001, 331--342.

Digital Library

Google Scholar

[4]

Guttman, A. R-trees: A Dynamic Index Structure for Spatial Searching. In Proceedings of the ACM SIGMOD, 1984, 47--57.

Digital Library

Google Scholar

[5]

Han, J., Stefanovik, N., and Kopersky, K. Selective Materialization: An Efficient Method for Spatial Data Cube Construction. In Proceedings of Research and Development in Knowledge Discovery and Data Mining, Second Pacific-Asia Conference (PAKDD'98), 1998, 55--61.

Digital Library

Google Scholar

[6]

Kimball, R., and Ross, M. The Data Warehouse Toolkit. John Wiley & Sons, 1996.

Digital Library

Google Scholar

[7]

Malinowski, E., and Zimanyi, E. Representing Spatiality in a Conceptual Multidimensional Model. In Proceedings of the 12th ACM International Symposium on Advances in Geographic Information Systems (ACM GIS 2004), 2004, 12--21.

Digital Library

Google Scholar

[8]

Open GIS Consortium (1999). OpenGIS Simple Features Specification for SQL. In URL: http://www.opengeospatial.org/docs/99-054.pdf.

Google Scholar

[9]

Oracle. Oracle® Database Concepts10g Release 2 (10.2), Oracle Corporation, 2005.

Google Scholar

[10]

Oracle. Oracle® Database Data Warehousing Guide 10g Release 2 (10.2), Oracle Corporation, 2005.

Google Scholar

[11]

Oracle. Oracle Oracle® Spatial User's Guide and Reference 10g Release 2 (10.2), Oracle Corporation, 2006.

Google Scholar

[12]

Zhang, L., Li, Y., Rao, F., Yu, X., Chen, Y., and Liu, D. An Approach to Enabling Spatial OLAP by Aggregating on Spatial Hierarchy. In Proceedings of the Data Warehousing and Knowledge Discovery Workshop (DAWAK'03), 2003, 35--44.

Crossref

Google Scholar

Cited By

View all

aissi SGouider MSboui TBen Said L(2015)Personnalisation OLAP et SIG : Etude comparative et perspectives de personnalisation SOLAPJournal of Decision Systems10.1080/12460125.2015.108104925:1(42-55)Online publication date: 19-Oct-2015
https://doi.org/10.1080/12460125.2015.1081049
Asrani DJain R(2014)Review of techniques used in data warehouse implementation: An initiative towards designing a frame work for effective data warehousing2014 International Conference on Advances in Engineering & Technology Research (ICAETR - 2014)10.1109/ICAETR.2014.7012954(1-5)Online publication date: Aug-2014
https://doi.org/10.1109/ICAETR.2014.7012954
Bimonte SVillanova-Oliver MGensel J(2013)A Multidimensional Model for Correct Aggregation of Geographic MeasuresGeographic Information Systems10.4018/978-1-4666-2038-4.ch023(377-398)Online publication date: 2013
https://doi.org/10.4018/978-1-4666-2038-4.ch023
Show More Cited By

Index Terms

Towards a logical multidimensional model for spatial data warehousing and OLAP

Recommendations

Towards a spatial multidimensional model
DOLAP '05: Proceedings of the 8th ACM international workshop on Data warehousing and OLAP

Data warehouses and OLAP systems help to interactively analyze huge volume of data. This data, extracted from transactional databases, frequently contains spatial information which is useful for decision-making process. Integration of spatial data in ...
When Spatial Analysis Meets OLAP: Multidimensional Model and Operators

Introducing spatial data into multidimensional models leads to the concept of Spatial OLAP SOLAP. Existing SOLAP models do not completely integrate the semantic component of geographic information alphanumeric attributes and relationships or the ...
Spatial hierarchy and OLAP-favored search in spatial data warehouse
DOLAP '03: Proceedings of the 6th ACM international workshop on Data warehousing and OLAP

Data warehouse and Online Analytical Processing(OLAP) play a key role in business intelligent systems. With the increasing amount of spatial data stored in business database, how to utilize these spatial information to get insight into business data ...

Comments

Information & Contributors

Information

Published In

DOLAP '06: Proceedings of the 9th ACM international workshop on Data warehousing and OLAP

November 2006

110 pages

ISBN:1595935304

DOI:10.1145/1183512

General Chair:
Il-Yeol Song
Drexel University
,
Program Chair:
Panos Vassiliadis
University of Ioannina, Greece

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 10 November 2006

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Author Tags

Qualifiers

Article

Conference

CIKM06

Sponsor:

CIKM06: Conference on Information and Knowledge Management

November 10, 2006

Virginia, Arlington, USA

Acceptance Rates

Overall Acceptance Rate 29 of 79 submissions, 37%

Upcoming Conference

CIKM '25

Sponsor:
sigir
sigir

The 34th ACM International Conference on Information and Knowledge Management

November 10 - 14, 2025

Seoul , Republic of Korea

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

16
Total Citations
View Citations
1,289
Total Downloads

Downloads (Last 12 months)1
Downloads (Last 6 weeks)0

Reflects downloads up to 01 Mar 2025

Other Metrics

View Author Metrics

Citations

Cited By

View all

aissi SGouider MSboui TBen Said L(2015)Personnalisation OLAP et SIG : Etude comparative et perspectives de personnalisation SOLAPJournal of Decision Systems10.1080/12460125.2015.108104925:1(42-55)Online publication date: 19-Oct-2015
https://doi.org/10.1080/12460125.2015.1081049
Asrani DJain R(2014)Review of techniques used in data warehouse implementation: An initiative towards designing a frame work for effective data warehousing2014 International Conference on Advances in Engineering & Technology Research (ICAETR - 2014)10.1109/ICAETR.2014.7012954(1-5)Online publication date: Aug-2014
https://doi.org/10.1109/ICAETR.2014.7012954
Bimonte SVillanova-Oliver MGensel J(2013)A Multidimensional Model for Correct Aggregation of Geographic MeasuresGeographic Information Systems10.4018/978-1-4666-2038-4.ch023(377-398)Online publication date: 2013
https://doi.org/10.4018/978-1-4666-2038-4.ch023
Bimonte S(2013)On Modeling and Analysis of Multidimensional Geographic DatabasesGeographic Information Systems10.4018/978-1-4666-2038-4.ch009(91-107)Online publication date: 2013
https://doi.org/10.4018/978-1-4666-2038-4.ch009
Boussaid OBertolotto MBimonte SGensel J(2012)Spatial OLAP and Map GeneralizationInternational Journal of Data Warehousing and Mining10.4018/jdwm.20120101028:1(24-51)Online publication date: 1-Jan-2012
https://dl.acm.org/doi/10.4018/jdwm.2012010102
Bimonte STchounikine AMiquel MPinet F(2012)When Spatial Analysis Meets OLAPExploring Advances in Interdisciplinary Data Mining and Analytics10.4018/978-1-61350-474-1.ch015(249-277)Online publication date: 2012
https://doi.org/10.4018/978-1-61350-474-1.ch015
Bimonte S(2012)A Web-Based Tool for Spatio-Multidimensional Analysis of Geographic and Complex DataNew Technologies for Constructing Complex Agricultural and Environmental Systems10.4018/978-1-4666-0333-2.ch003(32-58)Online publication date: 2012
https://doi.org/10.4018/978-1-4666-0333-2.ch003
Siqueira Tde Aguiar Ciferri CTimes VCiferri R(2012)Towards Vague Geographic Data WarehousesGeographic Information Science10.1007/978-3-642-33024-7_13(173-186)Online publication date: 2012
https://doi.org/10.1007/978-3-642-33024-7_13
Miquel MBimonte SPinet FTchounikine A(2010)When Spatial Analysis Meets OLAPInternational Journal of Data Warehousing and Mining10.4018/jdwm.20101001036:4(33-60)Online publication date: 1-Oct-2010
https://dl.acm.org/doi/10.4018/jdwm.2010100103
Bimonte S(2010)A Web-Based Tool for Spatio-Multidimensional Analysis of Geographic and Complex DataInternational Journal of Agricultural and Environmental Information Systems10.4018/jaeis.20100701031:2(42-67)Online publication date: 1-Jul-2010
https://doi.org/10.4018/jaeis.2010070103
Show More Cited By

View Options

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Get this Publication

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Abstract

References

Cited By

Index Terms

Recommendations

Towards a spatial multidimensional model

When Spatial Analysis Meets OLAP: Multidimensional Model and Operators

Spatial hierarchy and OLAP-favored search in spatial data warehouse

Comments

Information

Published In

Sponsors

Publisher

Publication History

Permissions

Check for updates

Author Tags

Qualifiers

Conference

Acceptance Rates

Upcoming Conference

Contributors

Other Metrics

Bibliometrics

Article Metrics

Other Metrics

Citations

Cited By

Login options

Full Access

View options

PDF

eReader

Share

Share this Publication link

Share on social media

Affiliations