Physical Design and Implementation of Spatial Data Warehouses Supporting Continuous Fields

  • Leticia Gómez
  • Alejandro Vaisman
  • Esteban Zimányi
Part of the Lecture Notes in Computer Science book series (LNCS, volume 6263)


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.


Query Language Data Warehouse Physical Design Fact Table Land Plot 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Worboys, M.F., Duckham, M.: GIS: A Computing Perspective, 2nd edn. CRC Press, Second edn (2004)Google Scholar
  2. 2.
    Kimball, R.: The Data Warehouse Toolkit. J. Wiley and Sons, Inc., Chichester (1996)Google Scholar
  3. 3.
    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)Google Scholar
  4. 4.
    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)Google Scholar
  5. 5.
    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)Google Scholar
  6. 6.
    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)Google Scholar
  7. 7.
    Tomlin, D.: Geographic Information Systems and Cartographic Modelling. Prentice-Hall, Englewood Cliffs (1990)Google Scholar
  8. 8.
    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)Google Scholar
  9. 9.
    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)Google Scholar
  10. 10.
    Mennis, J., Viger, R., Tomlin, C.: Cubic map algebra functions for spatio-temporal analysis. Cartography and Geographic Information Science 32, 17–32 (2005)CrossRefGoogle Scholar
  11. 11.
    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)Google Scholar
  12. 12.
    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)Google Scholar
  13. 13.
    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)CrossRefGoogle Scholar
  14. 14.
    Malinowski, E., Zimányi, E.: Advanced Data Warehouse Design: From Conventional to Spatial and Temporal Applications. Springer, Heidelberg (2008)zbMATHGoogle Scholar
  15. 15.
    Open Geospatial Consortium Inc.: OpenGIS Abstract Specification: Topic 6: The Coverage Type and its Subtypes. OGC 07-011, Version 4 (2007)Google Scholar
  16. 16.
    Güting, R.H., Schneider, M.: Moving Objects Databases. Morgan Kaufmann, San Francisco (2005)zbMATHGoogle Scholar
  17. 17.
    Klug, A.: Equivalence of relational algebra and relational calculus query languages having aggregate functions. Journal of the ACM 29, 699–717 (1982)CrossRefzbMATHGoogle Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2010

Authors and Affiliations

  • Leticia Gómez
    • 1
  • Alejandro Vaisman
    • 2
  • Esteban Zimányi
    • 3
  1. 1.Instituto Tecnológico de Buenos AiresArgentina
  2. 2.Universidad de Buenos AiresArgentina
  3. 3.Université Libre de BruxellesBelgium

Personalised recommendations