When Spatial Analysis Meets OLAP: Multidimensional Model and Operators

International Journal of Data Warehousing and Mining (IJDWM), Volume 6, Issue 4, pp. 33-60, 2010

Sandro Bimonte; Maryvonne Miquel

“Introducing spatial data into multidimensional models leads to the concept of Spatial OLAP (SOLAP). Existing SOLAP models do not completely integrate the semantic component of geographic information (alphanumeric attributes and relationships) or the flexibility of spatial analysis into multidimensional analysis. In this paper, the authors propose the GeoCube model and its associated operators to overcome these limitations. GeoCube enriches the SOLAP concepts of spatial measure and spatial dimension and take into account the semantic component of geographic information. The authors define geographic measures and dimensions as geographic and/or complex objects belonging to hierarchy schemas. GeoCube’s algebra extends SOLAP operators with five new operators, i.e., Classify, Specialize, Permute, OLAP-Buffer and OLAP-Overlay. In addition to classical drill-and-slice OLAP operators, GeoCube provides two operators for navigating the hierarchy of the measures, and two spatial analysis operators that dynamically modify the structure of the geographic hypercube. Finally, to exploit the symmetrical representation of dimensions and measures, GeoCube provides an operator capable of permuting dimension and measure. In this paper, GeoCube is presented using environmental data on the pollution of the Venetian Lagoon.”