Abstract
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.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
Andrienko, N., Andrienko, G., Gatalsky, P.: Exploratory Spatio-Temporal Visualization: an Analytical Review. Journal of Visual Languages and Computing 14 (2003)
Andrienko, N., Andrienko, G.: Exploratory Analysis of Spatial and Temporal Data – A Systematic Approach. Springer, Heidelberg (2005)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
Costabile, M.F., Malerba, D. (ed.): Special Issue on Visual Data Mining. Journal of Visual Languages and Computing 14, 499–501 (2003)
Franklin, C.: An Introduction to Geographic Information Systems: Linking Maps to databases. Database, 13–21 (1992)
Inmon, W.H.: Building the Data Warehouse, 2nd edn. Wiley, New York (1996)
JPivot 2008. The JPivot Project web site (2008), http://jpivot.sourceforge.net/ (last visited on December 07, 2008)
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)
KML 2008. The KML file format specifications (2008), http://code.google.com/intl/en/apis/kml/ (last visited on 1, 07, 2008)
Longley, P., Goodchild, M., Maguire, D., Rhind, D.: Geographic Information Systems and Science. John Wiley & Sons, New York (2001)
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)
Mondrian 2008. The Mondrian Project web site (2008), http://mondrian.pentaho.org/ (last visited on December 07, 2008)
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)
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)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2009 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Di Martino, S., Bimonte, S., Bertolotto, M., Ferrucci, F. (2009). Integrating Google Earth within OLAP Tools for Multidimensional Exploration and Analysis of Spatial Data. In: Filipe, J., Cordeiro, J. (eds) Enterprise Information Systems. ICEIS 2009. Lecture Notes in Business Information Processing, vol 24. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-01347-8_78
Download citation
DOI: https://doi.org/10.1007/978-3-642-01347-8_78
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-01346-1
Online ISBN: 978-3-642-01347-8
eBook Packages: Computer ScienceComputer Science (R0)