A Web-Based Tool for Spatio-Multidimensional Analysis of Geographic and Complex Data

Abstract

Spatial OLAP (SOLAP) integrates spatial data into OLAP systems, and SOLAP models define spatial dimensions while measuring spatio-multidimensional operators. In this paper, the author presents the concepts of geographic and complex measures that allow integrating geographic and complex information as subjects of analysis in spatial data warehouses. The concept of geographic measure extends the concept of spatial measure to the semantic component of geographic information. The concept of complex measure allows introducing complex data as subjects of multidimensional analysis. To reduce the gap in flexibility between spatial and multidimensional analysis, this paper proposes a symmetrical representation of measures and dimensions. Additionally, the author presents a Web-based SOLAP prototype, GeWOlap, that enriches existing SOLAP tools by effectively and easily supporting symmetrical geographic/complex measures and dimensions for modeling and visualization. To validate this approach, the simulated environmental data concerning the pollution of the Venice lagoon is used.

Guaranteeing the quality of multidimensional analysis in data warehouses of simulation results: Application to pesticide transfer data produced by the MACRO model

“…Finally, this project has also highlighted the need for a tool for the automatic integration of data results into databases. Cartographic display support can also be required for georeferenced data (Bimonte, 2010).…”

“…We also plan to study the possibilities offered by spatial DW/OLAP Bimonte, 2010;Malinowski and Zimanyi, 2008). These recent tools are dedicated to displaying information that is stored in DWs by means of maps and can be useful for visualizing georeferenced environmental models.…”

When Spatial Analysis Meets OLAP

“…GeoCube has been implemented in the Webbased prototype GeWOlap (Bimonte, 2010). GeWOlap is based on a three-tier architecture composed of the spatial data warehouse tier implemented using Oracle, the ROLAP Server Mondrian, and the Web-based SOLAP client integrating the OLAP client JPivot and an applet defined with MapXtreme Java for cartographic visualization and interaction functionalities.…”

Using OCL to Model Constraints in Data Warehouses

“…Some proposals of formalization have been introduced to model spatial data warehouses i.e., warehouses that store geo-referenced information (Malinowski & Zimányi, 2008b;Pestana, da Silva, & Bedard, 2005). Several uses of spatial data warehouse are evocated (Bernier, Gosselin, Badard, & Bédard, 2009;Bimonte, 2010;Julien & Rivest, 2009;McHugh, Roche, & Bédard, 2009;Sboui, Salehi, & Bédard, 2010). This type of data warehouses allows displaying the calculated indicators on maps.…”

“…For example, a data warehouse containing economic, urban and environmental information will help decision-makers find the best place to establish a new infrastructure. The concept of the data warehouse has great potential for assessing the impact of actions, practices, scenarios and programs (Bimonte, 2010;Mahboubi, Bimonte, Faure, & Pinet, 2010;Nilakanta, Scheibe, & Rai, 2008;Schneider, 2008;Schulze, Spilke, & Lehner, 2007).…”