Abstract
OnLine Analytical Processing (OLAP) tools act as support systems for Decision Makers to discover new knowledge hidden within data warehouses. In the spatial domain this capability is crucial. However, notwithstanding the pressing need for Spatial OLAP (SOLAP) tools, only very few are currently available. Such tools present several limitations in terms of their flexibility in the functionality and the analytical properties they provide. To overcome these limitations, we have developed a web-based SOLAP tool, which relies on the integration of a standard Geobrowser (Google Earth) with a freely available OLAP engine, namely Mondrian. Our system allows a Decision Maker to 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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Anselin, L.: What Is Special about Spatial Data? Alternative Perspectives on Spatial. Data Analysis, Technical Report 89-94, National Center for Geographic Information and Analysis, Santa Barbara, CA (1989)
Andrienko, N., Andrienko, G., Jankowski, P., et al.: Geovisual analytics for spatial decision support: Setting the research agenda. Int. J. Geographical Inf. Sci. 21(8), 839–857 (2007)
Andrienko, N., Andrienko, G., Wrobel, S.: Visual analytics tools for analysis of movement data. SIGKDD Explor. 9(2), 38–46 (2007)
Bédard, Y.: Spatial OLAP. In: Proc. of 2nd Forum annuel sur la R-D, Géomatique VI: Un monde accessible, Montréal, Canada, 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 enligne, 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)
Bertin, J., Bonin, S.: La graphique et le traitement graphique de l’information. Flammarion, Paris (1992)
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)
Bimonte, S.: On Modelling and Analysis of Geographic Multidimensional Databases. In: Data Warehousing Design and Advanced Engineering Applications: Methods for Complex Construction. Idea Group Publishing, Hershey (2008)
Bimonte, S.: Des entrepôts de données, l’analyse en ligne et l’information géographique. J. of Decis. Syst. 17(4), 463–486
Bimonte, S., Tchounikine, A., Miquel, M.: Spatial OLAP: Open Issues and a Web Based Prototype. In: Proc. of 10th AGILE International Conference on Geographic Information Science, Aalborg, Denmark, May 8-11 (2007)
Compieta, P., Di Martino, S., Bertolotto, M., et al.: Exploratory spatio-temporal data mining and visualization. J. Vis. Lang. and Comp. 18(3), 255–272 (2007)
Caron, P.: Étude du potentiel de OLAP pour supporter l’analyse spatio-temporelle. Université Laval, Laval (1998)
Escribano, A., Gomez, L., Kuijpers, B., et al.: Piet: a GIS-OLAP implementation. In: Proc. of the ACM 10th International Workshop on Data Warehousing and OLAP, pp. 73–80. ACM Press, New York (2007)
Franklin, C.: An Introduction to Geographic Information Systems: Linking Maps to databases. In: Database (1992)
Girardin, F., Calabrese, F., Dal Fiore, F., et al.: Digital footprinting: Uncovering tourists with user-generated content. IEEE Pervasive Comp. 7(4), 36–43 (2008)
Goodchild, M., Densham, P.: Spatial Decision Support Systems. Scientific Report for the Specialist Meeting, TR-90-5. National Center for Geographic Information and Analysis, Santa Barbara, California, USA (1990)
Hägerstrand, T.: What About People in Regional Science? Regional Science Association 24, 7–21 (1970)
Hernandez, V., Voss, A., Göhring, W., et al.: Sustainable decision support by the use of multi-level and multi-criteria spatial analysis on the Nicaragua Development Gateway. In: Proc. of From pharaohs to geoinformatics Proceedings of FIG Working Week 2005 and 8th International Conference on the Global Spatial Data Infrastructure, Le Caire, Egypte (2005)
Inmon, W.: Building the Data Warehouse. Wiley, New York (1996)
JPivot, The JPivot Project web site (2008), http://jpivot.sourceforge.net/ (last visited on December 07, 2008)
KML, The KML file format specifications (2008), http://code.google.com/intl/en/apis/kml/documentation/ (last visited on December 07, 2008)
Keim, D., Mansmann, F., Schneidewind, J., et al.: Challenges in Visual Data Analysis. In: Proc. of Information Visualization Symposium, pp. 9–16. IEEE, New York (2006)
Longley, P., Goodchild, M., Maguire, D., Rhind, D.: Geographic Information Systems and Science. John Wiley & Sons, New York (2001)
MacEachren, A., Kraak, M.: Research challenges in geovisualization, Cartography and Geographic. Inf. Syst. 6(1), 3–12 (2001)
MacEachren, A., Gahegan, M., Pike, W., et al.: Geovisualization for Knowledge Construction and Decision Support. IEEE Comput. graphics and appl. 24(1), 13–17 (2004)
Malinowski, E., Zimányi, E.: Logical Representation of a Conceptual Model for Spatial Data Warehouses. In: Geoinformatica. Springer, Berlin (2007)
Mitchell, A.: The ESRI Guide to GIS Analysis. Spatial Measurements and Statistics, vol. 2. ESRI Press, Redlands (2005)
Mondrian, The Mondrian Project web site (2008), http://mondrian.pentaho.org/ (last visited on December 07, 2008)
Pérez, J., Lavori, R., Cabo, M., et al.: R-Cubes: OLAP Cubes Contextualized with Documents. In: Proc. of International Conference on Data Engineering, pp. 1477–1478. IEEE, New York (2007)
Rafanelli, M.: Operators for Multidimensional Aggregate Data. In: Multidimensional databases: problems and solutions. IGI Publishing, Hershey (2003)
Rivest, S., Bédard, Y., Marchand, P.: Towards better support for spatial decision-making: defining the characteristics of Spatial On-Line Analytical Processing. J. of the Canadian Inst. of Geomatics 55(4), 539–555 (2001)
Rivest, S., Bédard, Y., Proulx, M., et al.: SOLAP: Merging Business Intelligence with Technology for Interactive Spatio-Temporal Exploration and Analysis of Data. J. Int. Soc. for Photogrammetry and Remote Sensing 60(1), 17–33 (2005)
Scotch, M., Parmanto, B.: Development of SOVAT: a numerical-spatial decision support system for community health assessment research. Int. J. Med. Infor. 34(10), 771–784 (2006)
Shneiderman, B.: The eyes have it: A task by data type taxonomy for information visualizations. In: Proc. of IEEE Symposium on Visual Languages. IEEE, New York (1996)
Slingsby, A., Dykes, J., Wood, J., et al.: The Visual Exploration of Insurance Data in Google Earth. In: Proc. of Geographical Information Systems Research, UK, Manchester, pp. 24–32 (2007)
Stolte, C., Tang, D., Hanrahan, P.: Polaris: A System for Query, Analysis and Visualization of Multi-dimensional Relational Databases. IEEE Trans. on Vis. and Comp. Graphics 8(1), 52–65 (2002)
Tobler, W.: A computer movie simulating urban growth in the Detroit region. Econ. Geogr. 46, 234–240 (1970)
Zhe-Ping, S.: Geovisualization of Disaster Potential Evaluation on Hillside Areas Around Taipei. In: Proc. of Asian Association of Remote Sensing (2007)
Wood, J., Dykes, J., Slingsby, A., et al.: Interactive visual exploration of a large spatio-temporal data set: reflections on a geovisualization mashup. IEEE Trans. on Vis. and Comp. Graphics 13(6), 1176–1183 (2007)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2011 Springer-Verlag Berlin Heidelberg
About this chapter
Cite this chapter
Di Martino, S., Bimonte, S., Bertolotto, M., Ferrucci, F., Leano, V. (2011). Spatial OnLine Analytical Processing of Geographic Data through the Google Earth Interface. In: Murgante, B., Borruso, G., Lapucci, A. (eds) Geocomputation, Sustainability and Environmental Planning. Studies in Computational Intelligence, vol 348. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-19733-8_10
Download citation
DOI: https://doi.org/10.1007/978-3-642-19733-8_10
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-19732-1
Online ISBN: 978-3-642-19733-8
eBook Packages: EngineeringEngineering (R0)