Abstract
Although many proposals exist for extending Geographic Information Systems (GIS) with OLAP and data warehousing capabilities (a topic denoted SOLAP), only recently the importance of supporting continuous fields (i.e., phenomena that are perceived as having a value at each point in space and/or time) has been acknowledged. Examples of such phenomena include temperature, altitude, or land use. In this paper we discuss physical design issues arising when a spatial data warehouse includes a combination of spatial and non-spatial dimensions and measures, and spatio-temporal dimensions representing continuous fields. We give the syntax and semantics of the data types (and their operators) needed to support fields in SOLAP environments, and present an implementation of these types, on top of spatial-SQL. We also show how queries using the spatio-temporal operators for fields are written, parsed, and executed.
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
Preview
Unable to display preview. Download preview PDF.
References
Worboys, M.F., Duckham, M.: GIS: A Computing Perspective, 2nd edn. CRC Press, Second edn (2004)
Kimball, R.: The Data Warehouse Toolkit. J. Wiley and Sons, Inc., Chichester (1996)
Rivest, S., Bédard, Y., Marchand, P.: Toward better suppport for spatial decision making: Defining the characteristics of spatial on-line analytical processing (SOLAP). Geomatica 55, 539–555 (2001)
Bédard, Y., Rivest, S., Proulx, M.: Spatial online analytical processing (SOLAP): Concepts, architectures, and solutions from a geomatics engineering perspective. In: Wrembel-Koncilia (ed.) Data Warehouses and OLAP: Concepts, Architectures and Solutions, pp. 298–319. IRM Press (2007)
Paolino, L., Tortora, G., Sebillo, M., Vitiello, G., Laurini, R.: Phenomena: a visual query language for continuous fields. In: Proc. of ACM-GIS, pp. 147–153 (2003)
Vaisman, A.A., Zimányi, E.: A multidimensional model representing continuous fields in spatial data warehouses. In: Proc. of ACM-GIS, pp. 168–177 (2009)
Tomlin, D.: Geographic Information Systems and Cartographic Modelling. Prentice-Hall, Englewood Cliffs (1990)
Câmara, G., Palomo, D., de Souza, R.C.M., de Oliveira, D.: Towards a generalized map algebra: Principles and data types. In: Proc. of GeoInfo, pp. 66–81 (2005)
Cordeiro, J.P., Câmara, G., Moura, U.F., Barbosa, C.C., Almeida, F.: Algebraic formalism over maps. In: Proc. of GeoInfo., pp. 49–65 (2005)
Mennis, J., Viger, R., Tomlin, C.: Cubic map algebra functions for spatio-temporal analysis. Cartography and Geographic Information Science 32, 17–32 (2005)
Laurini, R., Paolino, L., Sebillo, M., Tortora, G., Vitiello, G.: A spatial SQL extension for continuous field querying. In: Proc. of COMPSAC Workshops, pp. 78–81 (2004)
Shanmugasundaram, J., Fayyad, U.M., Bradley, P.S.: Compressed data cubes for OLAP aggregate query approximation on continuous dimensions. In: Proc. of KDD, pp. 223–232 (1999)
Ahmed, T.O., Miquel, M.: Multidimensional structures dedicated to continuous spatiotemporal phenomena. In: Jackson, M., Nelson, D., Stirk, S. (eds.) BNCOD 2005. LNCS, vol. 3567, pp. 29–40. Springer, Heidelberg (2005)
Malinowski, E., Zimányi, E.: Advanced Data Warehouse Design: From Conventional to Spatial and Temporal Applications. Springer, Heidelberg (2008)
Open Geospatial Consortium Inc.: OpenGIS Abstract Specification: Topic 6: The Coverage Type and its Subtypes. OGC 07-011, Version 4 (2007)
Güting, R.H., Schneider, M.: Moving Objects Databases. Morgan Kaufmann, San Francisco (2005)
Klug, A.: Equivalence of relational algebra and relational calculus query languages having aggregate functions. Journal of the ACM 29, 699–717 (1982)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2010 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Gómez, L., Vaisman, A., Zimányi, E. (2010). Physical Design and Implementation of Spatial Data Warehouses Supporting Continuous Fields. In: Bach Pedersen, T., Mohania, M.K., Tjoa, A.M. (eds) Data Warehousing and Knowledge Discovery. DaWaK 2010. Lecture Notes in Computer Science, vol 6263. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-15105-7_3
Download citation
DOI: https://doi.org/10.1007/978-3-642-15105-7_3
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-15104-0
Online ISBN: 978-3-642-15105-7
eBook Packages: Computer ScienceComputer Science (R0)