Sandro Bimonte, Anne Tchounikine, Sergio Di Martino, Filomena Ferrucci



Pivot tables are the de-facto standard paradigm for the visualization of data in the context of multidimensional OLAP analysis. However it is recognized that they are not suited, in their original definition, to support spatio-temporal data analysis (and in particular geographical measures). In this paper, we propose the GeOlaPivot Table, a visual metaphor intended as an extension of the pivot tables specifically conceived to assist decision makers in analyzing geographical measures in spatial data warehouses. In order to show the analysis capabilities of our metaphor we describe it using an example concerning the supervision of infectious diseases in Italy. This approach represents a first effort in adapting advanced geovisualization techniques to SOLAP ones, in order to create a specific visual paradigm for Spatial OLAP able to effectively support and fully exploit spatial multidimensional analysis process. Moreover, we present an architecture for a web-based environment able to support geographical measures in SOLAP analyses exploiting the GeOlaPivot Table visual metaphor.


  1. Andrienko N., Andrienko G., 2005. Exploratory Analysis of Spatial and Temporal Data A Systematic Approach Approx. Springer-Verlag,
  2. Bédard, Y. 1997. Spatial OLAP. 2ème Forum annuel sur la R-D, Géomatique VI: Un monde accessible, 13-14 novembre 1997, Montréal, Conférencier invité
  3. Bédard, Y., Merrett, T., and Han, 2001. Journal of Fundaments of Spatial Data Warehousing for Geographic Knowledge Discovery. Geographic Data Mining and Knowledge Discovery. Taylor & Francis, London, 53-73.
  4. Bimonte S., Tchounikine A., Miquel M., 2005. Towards a Spatial Multidimensional Model, In Proceedings of the 8th International Workshop on Data Warehousing and OLAP (DOLAP 2005), ACM Press, New York, USA, 39-46.
  5. Bimonte S.,Wehrle, P., Tchounikine, A., Miquel, M. GeWOlap: a Web Based Spatial OLAP Proposal, Second International Workshop on Semantic-based Geographical Information Systems (SeBGIS'06), Montpellier, France, 29-30 October, 2006
  6. Brunet R., 1980. La composition des modèles dans l'analyse spatiale». L'Espace géographique, 4, 253- 265.
  7. Franklin, C., 1992 An Introduction to Geographic Information Systems: Linking Maps to databases. Database. 13-21.
  8. ESRI 2006. Web site of bout/overview.html. Last visited on December, 07, 2006
  9. Gatalsky P., Andrienko N., and Andrienko G., 2004. Interactive Analysis of Event Data Using Space-Time
  10. Hägerstrand T., 1970. What about people in regional science? Papers, Regional Science Association, 24, 7- 21.
  11. Hernandez, V. Voss A. Göhring, W. Hopmann, C. 2005. Sustainable decision support by the use of multi-level and multi-criteria spatial analysis on the Nicaragua Development Gateway. In: From pharaohs to geoinformatics Proceedings of FIG Working Week 2005 and 8th International Conference on the Global Spatial Data Infrastructure, Cairo, Egypt,
  12. Inmon W. H., 1992. Building the data warehouse. Edition John Wiley and sons.
  13. JPivot 2006. The JPivot Project web site: Last visited on December, 07, 2006
  14. Kouba Z., Matoušek K., and Mikšovský P., 2000. On Data Warehouse and GIS integration. In Proceedings of the 11th Int. Conf. and Workshop on Database and Expert Systems Applications, Greenwich, UK.
  15. Laurini R., Milleret-Raffort F., Lopez K. 2006. "A Primer of Geographic Databases Based on Chorems". In proceedings of the SebGIS Conference, Montpellier, Published by Springer Verlag LNCS 4278.
  16. MacEachren, A. M., 2001. An evolving cognitive-semiotic approach to geographic visualization and knowledge construction. Information Design Journal, 10(1), 26- 36, 2001
  17. Malinowski, E., Zimányi, E. 2004. Representing spatiality in a conceptual multidimensional model. In Proceedings of the 12th annual ACM International workshop on Geographic information systems. (Washington DC, New York, USA, 2004), ACM Press, 12-22.
  18. Malinowsky, E. and E., 2005. Spatial Hierarchies and Topological Relationships in SpatialMultiDimER model. In Proceedings of the 22th British National Conference on Databases (Sunderland UK, July 2005), LNCS 3567, Springer, 17-28
  19. Mondrian 2006. The Mondrian Project web site: Last visited on December, 07, 2006
  20. Pendse, 2005.
  21. Rivest, S., Bédard Y., and Marchand P. 2001. Toward Better Support for Spatial Decision Making: Defining the Characteristics of Spatial On-Line Analytical Processing (SOLAP). Geomatica, 55, 4 (2001), 539- 555.
  22. Rivest, S., Y. Bédard, M.-J. Proulx, M. Nadeau, F. Hubert & J. Pastor, 2005, SOLAP: Merging Business Intelligence with Geospatial Technology for Interactive Spatio-Temporal Exploration and Analysis of Data, Journal of International Society for Photogrammetry and Remote Sensing (ISPRS) "Advances in spatio-temporal analysis and representation, Vol. 60, No. 1, pp. 17-33
  23. Scotch, M. and B. Parmanto, 2005. “SOVAT: Spatial OLAP Visualization and Analysis Tool.” In Proceedings of HICSS-38. Waikoloa, HI: IEEE.
  24. Stefanovic, N., Han, J., and Koperski K., 2000. ObjectBased Selective Materialization for Efficient Implementation of Spatial Data Cubes. IEEE TKDE, 12, 6 (2000), 938-958.
  25. Stolte C., Tang D., Hanrahan P., 2002. Polaris: A System for Query, Analysis and Visualization of Multidimensional Relational Databases (extended paper) IEEE Transactions on Visualization and Computer Graphics, Vol. 8, No. 1, January 2002
  26. Tchounikine, A., Miquel M., Laurini, E., Ahmed, T., Bimonte, S. and Baillot, V. 2005. Panorama de travaux autour de l'intégration de données spatiotemporelles dans les hypercubes. Revue des Nouvelles Technologies de l'Information (RNTI), Editions Cepaduès, numéro spécial.
  27. Thomsen C., Torben B., 2005. A Survey of Open Source Tools for Business Intelligence. DaWaK 2005: 74-84

Paper Citation

in Harvard Style

Bimonte S., Tchounikine A., Di Martino S. and Ferrucci F. (2007). SUPPORTING GEOGRAPHICAL MEASURES THROUGH A NEW VISUALIZATION METAPHOR IN SPATIAL OLAP . In Proceedings of the Ninth International Conference on Enterprise Information Systems - Volume 5: ICEIS, ISBN 978-972-8865-92-4, pages 19-26. DOI: 10.5220/0002371100190026

in Bibtex Style

author={Sandro Bimonte and Anne Tchounikine and Sergio Di Martino and Filomena Ferrucci},
booktitle={Proceedings of the Ninth International Conference on Enterprise Information Systems - Volume 5: ICEIS,},

in EndNote Style

JO - Proceedings of the Ninth International Conference on Enterprise Information Systems - Volume 5: ICEIS,
SN - 978-972-8865-92-4
AU - Bimonte S.
AU - Tchounikine A.
AU - Di Martino S.
AU - Ferrucci F.
PY - 2007
SP - 19
EP - 26
DO - 10.5220/0002371100190026