Definition
The data warehouseis an alternative form of data storage from the conventional relational database. It is oriented towards a view of data that is subject-oriented, rather than application-oriented. It receives data from one or multiple relational databases, stores large or massive amounts of data, and emphasizes permanent storage of data received over periods of time. Data warehouses can be spatially enabled in several ways. The data in the warehouse can have spatial attributes, supporting mapping. Mapping functions are built into some data warehouse packages. Online analytical processing (OLAP) “slicing and dicing” and what-if functions are performed on the data in the warehouse, and may include spatial characteristics. Furthermore, the data warehouse can be linked to geographical information systems (GIS), data mining and other software packages for more spatial and numerical analysis. Data warehouses...
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Bimonte S, Tchounikine A, Miquel M (2005) Towards a spatial multidimensional model. In: Proceedings of the 8th ACM international workshop on data warehousing and OLAP, Bremen, 4–5 Nov, pp 39–46
Codd EF (1995) Twelve rules for on-line analytic processing. Computerworld 29:84–87
Gray P (2006) Manager’s guide to making decisions about information systems. John Wiley, New York
Gray P, Watson H (1998) Decision support in the data warehouse. Prentice Hall, Upper Saddle River
Inmon WH (1990) Building the data warehouse. John Wiley, New York
Jukic N (2006) Modeling strategies and alternatives for data warehousing projects. Commun ACM 49(4):83–88
Malinowski E, Zimanyi E (2003) Representing spatiality in a conceptual multidimensional model. In: Proceedings of the 12th annual ACM international workshop on geographic information systems. ACM, Washington, DC, pp 12–22
Marchand P, Brisebois A, Bedard Y, Edwards G (2003) Implementation and evaluation of a hypercube-based method for spatiotemporal exploration and analysis. J Int Soc Photogramm Remote Sens 59:6–20
Oracle (2006) Oracle data warehousing. Available at www.oracle.com
Pick JB, Viswanathan N, Hettrick WJ (2000) A dual census geographical information system in the context of data warehousing. In: Proceedings of the Americas conference on information systems. Association for Information Systems, Atlanta, pp 265–278
Reid H (2006) Applying Oracle spatial to a very large insurance problem. Location Intelligence, 20 June. Available at www.locationintelligence.net
Rittman M (2006) An introduction to Oracle warehouse builder 10g. DBAzine.com. 19 Aug. Available at www.dbazine.com
Rittman M (2006) GIS-enabling your Oracle data warehouse. DBAzine.com. 18 Apr. Available at www.dbazine.com
SQL Server Magazine (2002) City of Portland Tames massive SQL server data warehouse. 27 June. Available at www.sqlmag.com
Viswanathan N, Pick JB, Hettrick WJ, Ellsworth E (2005) An analysis of commonality in the twin metropolitan areas of San Diego, California and Tijuana, Mexico. J Soc Plan Sci 39:57–79
Recommended Reading
Tan P-N, Steinbach M, Kumar V (2005) Introduction to data mining. Addison Wesley, Upper Saddle River
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2017 Springer International Publishing AG
About this entry
Cite this entry
Pick, J.B. (2017). Data Warehouses and GIS. In: Shekhar, S., Xiong, H., Zhou, X. (eds) Encyclopedia of GIS. Springer, Cham. https://doi.org/10.1007/978-3-319-17885-1_254
Download citation
DOI: https://doi.org/10.1007/978-3-319-17885-1_254
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-17884-4
Online ISBN: 978-3-319-17885-1
eBook Packages: Computer ScienceReference Module Computer Science and Engineering