Definition
Business intelligence (BI) systems collect large amounts of data, transform them to a form that can be used to analyze organizational behavior, and store them in a common repository called a data warehouse (DW). A DW is usually designed following the multidimensional model, which represents data as facts that can be analyzed along a collection of dimensions, composed of levels conforming aggregation hierarchies.
Over the years, spatial data have been increasingly used in many application domains, like public administration, transportation networks, environmental systems, and public health, among others. Spatial data can represent geographic objects (e.g., mountains, cities), geographic phenomena (e.g., temperature, precipitation), and even data located in other spatial frames such as a human body or a house.
Similarly to conventional databases, spatial databases are typically used for operational applications, rather than to support data analysis tasks. Spatial DWs (SDWs)...
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsRecommended Reading
Ahmed TO, Miquel M. Multidimensional structures dedicated to continuous spatiotemporal phenomena. In: Proceedings of the 22nd British National Conference on Databases; 2005. p. 29–40.
Bédard Y, Merrett T, Han J. Fundaments of spatial data warehousing for geographic knowledge discovery. In: Miller H, Han J, editors, Geographic data mining and knowledge discovery. London: Taylor & Francis; 2001. p. 53–73.
Bimonte S, Miquel M. When spatial analysis meets OLAP: multidimensional model and operators. Int J Data Wareh Min. 2010;6(4):33–60.
Bimonte S, Tchounikine A, Miquel M. Towards a spatial multidimensional model. In: Proceedings of the 8th ACM International Workshop on Data Warehousing and OLAP; 2005. p. 39–46.
Gómez L, Gómez S, Vaisman A. Analyzing continuous fields with OLAP cubes. In: Proceedings of the 14th ACM International Workshop on Data Warehousing and OLAP; 2011. p. 89–94.
Gómez L, Gómez S, Vaisman A. A generic data model and query language for spatiotemporal OLAP cube analysis. In: Proceedings of the 15th International Conference on Extending Database Technology; 2012. p. 300–11.
Gómez L, Gómez S, Vaisman A. Modeling and querying continuous fields with OLAP cubes. Int J Data Wareh Min. 2013;9(3):22–45.
Gómez L, Vaisman A, Zimányi E. Physical design and implementation of spatial data warehouses supporting continuous fields. In: Proceedings of the 12th International Conference on Data Warehousing and Knowledge Discovery; 2010. p. 25–39.
Jensen CS, Klygis A, Pedersen TB, Timko I. Multidimensional data modeling for location-based services. In: Proceedings of the 10th ACM Symposium on Advances in Geographic Information Systems; 2002. p. 55–61.
Malinowski E, Zimányi E. Representing spatiality in a conceptual multidimensional model. In: Proceedings of the 12th ACM Symposium on Advances in Geographic Information Systems; 2004. p. 12–21.
Malinowski E, Zimányi E. Logical representation of a conceptual model for spatial data warehouses. GeoInformatica 2007;11(4):431–57.
Malinowski E, Zimányi E. Advanced data warehouse design: from conventional to spatial and temporal applications. Berlin/Heidelberg: Springer; 2008.
Mendelzon A, Vaisman A. Time in multidimensional databases. In: Rafanelli M, editor. Multidimensional databases: problems and solutions. Hershey: Idea Group; 2003. p. 166–99.
Parent C, Spaccapietra S, Zimányi E. Conceptual modeling for traditional and spatio-temporal applications: the MADS approach. Berlin: Springer; 2006.
Pedersen T, Jensen C, Dyreson C. A foundation for capturing and querying complex multidimensional data. Inf Syst. 2001;26(5):383–423.
Rivest S, Bédard Y, Marchand P. Toward better support for spatial decision making: defining the characteristics of spatial on-line analytical processing (SOLAP). Geomatica 2001;55(4):539–55.
Shanmugasundaram J, Fayyad U, Bradley P. Compressed data cubes for OLAP aggregate query approximation on continuous dimensions. In: Proceedings of the 5th ACM SIGKDD International Conference on Knowledge Discovery and Data Mining; 1999. p. 223–32.
Stefanovic N, Han J, Koperski K. Object-based selective materialization for efficient implementation of spatial data cubes. IEEE Trans Knowl Data Eng. 2000;12(6):938–58.
Vaisman A, Zimányi E. A multidimensional model representing continuous fields in spatial data warehouses. In: Proceedings of the 17th ACM SIGSPATIAL Symposium on Advances in Geographic Information Systems; 2009. p. 168–77.
Vaisman A, Zimányi E. Data warehouses: next challenges. In: Aufare MA, Zimányi E, editors. Tutorial Lectures of the First European Business Intelligence Summer School, eBISS 2011; Paris. Lecture Notes in Business Information Processing 96. Springer; 2011. p. 1–26.
Vaisman A, Zimányi E. Trajectory data warehouses. In: Renso C, Spaccapietra S, Zimányi E, editors. Mobility data: modeling, management, and understanding. New York: Cambridge University Press; 2013. p. 62–82.
Vaisman A, Zimányi E. Data warehouse systems: design and implementation. Berlin: Springer; 2014.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2018 Springer Science+Business Media, LLC, part of Springer Nature
About this entry
Cite this entry
Vaisman, A.A., Zimányi, E. (2018). Spatial Datawarehousing. In: Liu, L., Özsu, M.T. (eds) Encyclopedia of Database Systems. Springer, New York, NY. https://doi.org/10.1007/978-1-4614-8265-9_80810
Download citation
DOI: https://doi.org/10.1007/978-1-4614-8265-9_80810
Published:
Publisher Name: Springer, New York, NY
Print ISBN: 978-1-4614-8266-6
Online ISBN: 978-1-4614-8265-9
eBook Packages: Computer ScienceReference Module Computer Science and Engineering