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

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.

[1]  Yvan Bédard,et al.  Merging Hypermedia GIS with Spatial On-Line Analytical Processing: Towards Hypermedia SOLAP , 2006 .

[2]  Filomena Ferrucci,et al.  Supporting Geographical Measures through a New Visualization Metaphor in Spatial OLAP , 2007, ICEIS.

[3]  Michela Bertolotto,et al.  Exploratory spatio-temporal data mining and visualization , 2007, J. Vis. Lang. Comput..

[4]  Yvan Bédard,et al.  Enrichissement du OLAP pour l'analyse géographique : exemples de réalisation et différentes possibilités technologiques , 2005, EDA.

[5]  Sandro Bimonte,et al.  Spatial OLAP : Open Issues and a Web Based Prototype , 2007 .

[6]  Jiawei Han,et al.  Fundamentals of spatial data warehousing for geographic knowledge discovery , 2001 .

[7]  Keith C. Clarke,et al.  Interactive Visual Exploration of a Large Spatio-temporal Dataset: Reflections on a Geovisualization Mashup. , 2007, IEEE Transactions on Visualization and Computer Graphics.

[8]  Jiawei Han,et al.  Geographic Data Mining and Knowledge Discovery , 2001 .

[9]  Mark Gahegan,et al.  Geovisualization for knowledge construction and decision support , 2004, IEEE Computer Graphics and Applications.

[10]  Carl Franklin,et al.  An Introduction to Geographic Information Systems: Linking Maps to Databases [and] Maps for the Rest of Us: Affordable and Fun. , 1992 .

[11]  W. H. Inmon,et al.  Building the data warehouse , 1992 .

[12]  Jason Dykes,et al.  The Visual Exploration of Insurance Data in Google Earth , 2008 .

[13]  Gennady L. Andrienko,et al.  Exploratory analysis of spatial and temporal data - a systematic approach , 2005 .

[14]  Susanne Bleisch,et al.  Connected 2D and 3D visualizations for the interactive exploration of spatial information , 2008 .

[15]  M. Goodchild,et al.  Geographic Information Systems and Science (second edition) , 2001 .

[16]  W. H. Inmon,et al.  Building the data warehouse (2nd ed.) , 1996 .

[17]  Gennady L. Andrienko,et al.  Exploratory spatio-temporal visualization: an analytical review , 2003, J. Vis. Lang. Comput..

[18]  Emmanuel Stefanakis Geographic Hypermedia : Concepts and Systems , 2006 .