On Modeling and Analysis of Multidimensional Geographic Databases

Data warehouse and OLAP systems are tools to support decision-making. Geographic information systems (GISs) allow memorizing, analyzing and visualizing geographic data. In order to exploit the complex nature of geographic data, a new kind of decision support system has been developed: spatial OLAP (SOLAP). Spatial OLAP redefines main OLAP concepts: dimension, measure and multidimensional operators. SOLAP systems integrate OLAP and GIS functionalities into a unique interactive and flexible framework. Several research tools have been proposed to explore and the analyze spatio-multidimensional databases. This chapter presents a panorama of SOLAP models and an analytical review of research SOLAP tools. Moreover, the authors describe their Web-based system: GeWOlap. GeWOlap is an OLAP-GIS integrated solution implementing drill and cut spatio-multidimensional operators, and it supports some new spatio-multidimensional operators which change dynamically the structure of the spatial hypercube thanks to spatial analysis operators.

[1]  Sandro Bimonte.  Intégration de l'information géographique dans les entrepôts de données et l'analyse en ligne : de la modélisation à la visualisation , 2007 .

[2]  Panos Kalnis,et al.  Indexing spatio-temporal data warehouses , 2002, Proceedings 18th International Conference on Data Engineering.

[3]  J. Moura-Pires,et al.  Spatial On-Line Analytical Processing (SOLAP): A Tool the to Analyze the Emission of Pollutants in Industrial Installations , 2005, 2005 portuguese conference on artificial intelligence.

[4]  Brian N. Hilton.  Emerging spatial information systems and applications , 2006 .

[5]  Maryvonne Miquel,et al.  Multidimensional Structures Dedicated to Continuous Spatiotemporal Phenomena , 2005, BNCOD.

[6]  Alex Pang,et al.  Visualizing Uncertainty in Natural Hazards , 2008 .

[7]  Pat Hanrahan,et al.  Multiscale Visualization Using Data Cubes , 2003, IEEE Trans. Vis. Comput. Graph..

[8]  John Wang Montclair.  Data Warehousing and Mining : Concepts , Methodologies , Tools , and Applications , 2008 .

[9]  Zubair A. Opeyemi,et al.  Harnessing Nigeria's Investment in Satellite Technology for Sustainable Agriculture and Food Security , 2012, Int. J. Appl. Geospat. Res..

[10]  Yvan Bédard,et al.  SOLAP technology: Merging business intelligence with geospatial technology for interactive spatio-temporal exploration and analysis of data , 2005 .

[11]  C. Tomlin.  Geographic information systems and cartographic modeling , 1990 .

[12]  Bambang Parmanto,et al.  Development of SOVAT: A numerical-spatial decision support system for community health assessment research , 2006, Int. J. Medical Informatics.

[13]  Hassan A. Karimi,et al.  Handbook of Research on Geoinformatics , 2008 .

[14]  Esteban Zimányi,et al.  Logical Representation of a Conceptual Model for Spatial Data Warehouses , 2007, GeoInformatica.

[15]  Jiawei Han,et al.  GeoMiner: a system prototype for spatial data mining , 1997, SIGMOD '97.

[16]  Michela Bertolotto,et al.  Towards a framework for mining and analysing spatio‐temporal datasets , 2007, Int. J. Geogr. Inf. Sci..

[17]  E. Heller.  An international journal. , 1968, Canadian Medical Association journal.

[18]  Bart Kuijpers,et al.  Piet: a GIS-OLAP implementation , 2007, DOLAP '07.

[19]  Jiawei Han,et al.  Object-Based Selective Materialization for Efficient Implementation of Spatial Data Cubes , 2000, IEEE Trans. Knowl. Data Eng..

[20]  Ranga Raju Vatsavai,et al.  Map cube: A visualization tool for spatial data warehouses , 2001 .

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

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

[23]  Aijun Chen,et al.  Sharing of Distributed Geospatial Data through Grid Technology , 2009 .

[24]  Cláudio de Souza Baptista,et al.  Towards a logical multidimensional model for spatial data warehousing and OLAP , 2006, DOLAP '06.

[25]  Sandro Bimonte.  Des entrepôts de données, l’analyse en ligne et l’information géographique , 2008, J. Decis. Syst..

[26]  O. A. Khan,et al.  Geographic Information Systems and Health Applications , 2002 .

[27]  Arnaud Giacometti,et al.  A personalization framework for OLAP queries , 2005, DOLAP '05.

[28]  Shichao Zhang,et al.  Group Pattern Discovery Systems for Multiple Data Sources , 2005 .

[29]  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.

[30]  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 .

[31]  Karine Zeitouni.  A survey of spatial data mining methods databases and statistics point of views , 2000, IRMA Conference.

[32]  Michael Leitner,et al.  Using Hierarchical Nearest Neighbor Analysis and Animation to Investigate the Spatial and Temporal Patterns of Raccoon Rabies in West Virginia , 2003 .

[33]  Karim Mohraz.  Geographical analysis in SAP business information warehouse , 2000, GIS '00.

[34]  Pedro Furtado,et al.  Efficient and Robust Node-Partitioned Data Warehouses , 2009, Database Technologies: Concepts, Methodologies, Tools, and Applications.

[35]  James B. Pick.  Geographic Information Systems in Business , 2005 .

[36]  Xiaofeng Meng,et al.  An OLAP system for network-constrained moving objects , 2007, SAC '07.

[37]  Colleen Allen.  Campaign '92: The campaign library from Mead Data Central , 1992 .

[38]  Clayton J. Whitesides,et al.  Estimating Fractional Snow Cover in Mountain Environments with Fuzzy Classification , 2012, Int. J. Appl. Geospat. Res..

[39]  Kamil Matousek,et al.  On Data Warehouse and GIS Integration , 2000, DEXA.

[40]  Panos Vassiliadis,et al.  A Presentation Model & Non-Traditional Visualization for OLAP , 2005, Int. J. Data Warehous. Min..

[41]  Sandro Bimonte,et al.  GeWOlap: A Web Based Spatial OLAP Proposal , 2006, OTM Workshops.

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

[43]  Esteban Zimányi,et al.  Representing spatiality in a conceptual multidimensional model , 2004, GIS '04.

[44]  Valéria Cesário Times,et al.  An open source and web based framework for geographic and multidimensional processing , 2006, SAC '06.

[45]  Robert Wrembel,et al.  Data Warehouses And Olap: Concepts, Architectures And Solutions , 2006 .

[46]  Elaheh Pourabbas,et al.  A pictorial query language for querying geographic databases using positional and OLAP operators , 2002, SGMD.

[47]  Geoffrey Edwards,et al.  Implementation and evaluation of a hypercube-based method for spatiotemporal exploration and analysis , 2004 .

[48]  George Towers.  Cultural Dasymetric Population Mapping with Historical GIS: A Case Study from the Southern Appalachians , 2011, Int. J. Appl. Geospat. Res..

[49]  M. Malek,et al.  Towards a Global Real-Time Enterprise , 2007 .

[50]  Yvan Bédard,et al.  Toward better support for spatial decision making: Defining the characteristics of spatial on-line analytical processing (SOLAP) , 2001 .

[51]  Philip Calvert,et al.  Encyclopedia of Data Warehousing and Mining , 2006 .

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

[53]  Renzo Orsini,et al.  Spatio-temporal Aggregations in Trajectory Data Warehouses , 2007, DaWaK.

[54]  Alan M. MacEachren,et al.  Exploratory cartographic visualization: advancing the agenda , 1997 .