Integrating Google Earth within OLAP Tools for Multidimensional Exploration and Analysis of Spatial Data

  • Sergio Di Martino
  • Sandro Bimonte
  • Michela Bertolotto
  • Filomena Ferrucci
Part of the Lecture Notes in Business Information Processing book series (LNBIP, volume 24)


Spatial OnLine Analytical Processing solutions are a type of Business Information Tool meant to support a Decision Maker in extracting hidden knowledge from data warehouses containing spatial data. To date, very few SOLAP tools are available, each presenting some drawbacks reducing their flexibility. To overcome these limitations, we have developed a web-based SOLAP tool, obtained by suitably integrating into an ad-hoc architecture the Geobrowser Google Earth with a freely available OLAP engine, namely Mondrian. As a consequence, a Decision Maker can perform exploration and analysis of spatial data both through the Geobrowser and a Pivot Table in a seamlessly fashion. In this paper, we illustrate the main features of the system we have developed, together with the underlying architecture, using a simulated case study.


Spatial OLAP Data Visualization Spatial Decision Support Systems Spatial Data Warehouses 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Andrienko, N., Andrienko, G., Gatalsky, P.: Exploratory Spatio-Temporal Visualization: an Analytical Review. Journal of Visual Languages and Computing 14 (2003)Google Scholar
  2. 2.
    Andrienko, N., Andrienko, G.: Exploratory Analysis of Spatial and Temporal Data – A Systematic Approach. Springer, Heidelberg (2005)Google Scholar
  3. 3.
    Bédard, Y.: Spatial OLAP. In: Proceedings of 2nd Forum annuel sur la R-D, Géomatique VI: Un monde accessible, Montréal, November 13-14 (1997)Google Scholar
  4. 4.
    Bédard, Y., Merrett, T., Han, J.: Fundaments of Spatial Data Warehousing for Geographic Knowledge Discovery. In: Geographic Data Mining and Knowledge Discovery. Taylor & Francis, London (2001)Google Scholar
  5. 5.
    Bédard, Y., Proulx, M., Rivest, S.: Enrichissement du OLAP pour l’analyse géographique: exemples de réalisation et différentes possibilités technologiques. R. Nouvelles Tech. de l’Inf., Entrepôts de données et l’Analyse en ligne 1-20 (2005)Google Scholar
  6. 6.
    Bédard, Y., Proulx, M., Rivest, S., et al.: Merging Hypermedia GIS with Spatial On-Line Analytical Processing: Towards Hypermedia SOLAP. In: Geographic Hypermedia: Concepts and Systems. Springer, Berlin (2006)Google Scholar
  7. 7.
    Bédard, Y., Rivest, S., Proulx, M.J. (Université Laval, Canada), Spatial On-Line Analytical Processing (SOLAP): Concepts, Architectures and Solutions from a Geomatics Engineering Perspective. In: Data Warehouses and OLAP: Concepts, Architectures and Solutions, ch. 13. IRM Press, Idea Group (2007)Google Scholar
  8. 8.
    Bimonte, S., Di Martino, S., Ferrucci, F., Tchounikine, A.: Supporting Geographical Measures Through A New Visualization Metaphor In Spatial OLAP. In: ICEIS 2007, Funchal, Portugal, INSTICC (2007) Google Scholar
  9. 9.
    Bimonte, S.: On Modelling and Analysis of Geographic Multidimensional Databases. In: Data Warehousing Design and Advanced Engineering Applications: Methods for Complex Construction, 2008. Idea Group Publishing (2008)Google Scholar
  10. 10.
    Bimonte, S., Tchounikine, A., Miquel, M.: Spatial OLAP: Open Issues and a Web Based Prototype. In: 10th AGILE International Conference on Geographic Information Science, Aalborg, Denmark, May 8-11 (2007)Google Scholar
  11. 11.
    Bleisch, S., Nebiker, S.: Connected 2D and 3D visualizations for the interactive exploration of spatial information. In: Proc. of 21th ISPRS Congress, Beijing, China (2008)Google Scholar
  12. 12.
    Compieta, P., Di Martino, S., Bertolotto, M., Ferrucci, F., Kechadi, T.: Exploratory spatio-temporal data mining and visualization. Journal of Visual Languages and Computing 18(3), 255–262 (2007)CrossRefGoogle Scholar
  13. 13.
    Costabile, M.F., Malerba, D. (ed.): Special Issue on Visual Data Mining. Journal of Visual Languages and Computing 14, 499–501 (2003)CrossRefGoogle Scholar
  14. 14.
    Franklin, C.: An Introduction to Geographic Information Systems: Linking Maps to databases. Database, 13–21 (1992)Google Scholar
  15. 15.
    Inmon, W.H.: Building the Data Warehouse, 2nd edn. Wiley, New York (1996)Google Scholar
  16. 16.
    JPivot 2008. The JPivot Project web site (2008), (last visited on December 07, 2008)
  17. 17.
    Keenan, P.: Using a GIS as a DSS Generator. In: Perspectives on Decision Support System. Grèce University of the Aegean, pp. 33–40 (1996)Google Scholar
  18. 18.
    KML 2008. The KML file format specifications (2008), (last visited on 1, 07, 2008)
  19. 19.
    Longley, P., Goodchild, M., Maguire, D., Rhind, D.: Geographic Information Systems and Science. John Wiley & Sons, New York (2001)Google Scholar
  20. 20.
    MacEachren, A., Gahegan, M., Pike, W., Brewer, I., Cai, G., Lengerich, E., Hardisty, F.: Geovisualization for Knowledge Construction and Decision Support. IEEE Computer graphics and application 24(1), 13–17 (2004)CrossRefGoogle Scholar
  21. 21.
    Mondrian 2008. The Mondrian Project web site (2008), (last visited on December 07, 2008)
  22. 22.
    Slingsby, A., Dykes, J., Wood, J., Foote, M., Blom, M.: The Visual Exploration of Insurance Data in Google Earth. In: Proceedings of Geographical Information Systems Research UK, Manchester, UK, pp. 24–32 (2007)Google Scholar
  23. 23.
    Wood, J., Dykes, J., Slingsby, A., Clarke, K.: Interactive visual exploration of a large spatio-temporal data set: reflections on a geovisualization mashup. IEEE Transactions on Visualization and Computer Graphics 13(6), 1176–1183 (2007)CrossRefGoogle Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2009

Authors and Affiliations

  • Sergio Di Martino
    • 1
  • Sandro Bimonte
    • 2
  • Michela Bertolotto
    • 3
  • Filomena Ferrucci
    • 4
  1. 1.University of Naples “Federico II”NapoliItaly
  2. 2.Cemagref, UR TSCFClermont-FerrandFrance
  3. 3.University College Dublin, BelfieldDublin 4Ireland
  4. 4.University of SalernoFisciano (SA)Italy

Personalised recommendations