Conceptual model for spatial data cubes: A UML profile and its automatic implementation

The increasing availability of geo-referenced data has increased the need to enrich OLAP with spatial analysis, leading to the concept of Spatial OLAP (SOLAP). The conceptual modelling of spatial data cubes requires the definition of two kinds of metadata: (i) warehouse metadata that model data structures that maintain integrated data from multiple data sources and (ii) aggregation11In this paper, the term "aggregation" does not refer to UML aggregation associations. In the text of our article, "aggregation" is used in the sense of calculating a result (as in the field of databases) - the terms "aggregation level" and "aggregating relationship" refer to OLAP aggregations. metadata that specify how the warehoused data should be aggregated to meet the analysis goals of decision makers.In this paper we provide a review of existing conceptual spatial data cube models. We highlight some limits of these models concerning the aggregation model design, and their implementation in existing CASE tools and SOLAP architectures.Firstly, we propose a new UML (Unified Modeling Language) profile for modelling complex Spatial Data Warehouses and aggregations. Our profile is implemented in the MagicDraw CASE tool.Secondly, we propose a tool for the automatic implementation of conceptual spatial data cube models, designed using our profile, in a SOLAP architecture. In particular, our solution allows: (i) generating different logical representations of the SDW (Spatial Data Warehouse) model (star schema and snow-flake schema) and (ii) implementing complex SOLAP analysis indicators using MDX (MultiDimensional eXpressions language). The paper presents a state of art of conceptual models for Spatial Data WarehousesThe paper details a new UML profile for modeling complex Spatial OLAP applicationsThe implementation in a commercial CASE tool is presentedIts automatic implementation in a classical ROLAP architecture is shown

[1]  Il-Yeol Song,et al.  An analysis of additivity in OLAP systems , 2004, DOLAP '04.

[2]  Sandro Bimonte,et al.  When Spatial Analysis Meets OLAP: Multidimensional Model and Operators , 2010, Int. J. Data Warehous. Min..

[3]  Alexandre Mota,et al.  Towards a more straightforward and more expressive metamodel for SDW modeling , 2011, DOLAP '11.

[4]  Alberto Abelló Gamazo.  YAM^2: a multidimensional conceptual model , 2002 .

[5]  Jose-Norberto Mazón,et al.  WITHDRAWN: Designing OLAP schemata for data warehouses from conceptual models with MDA , 2010, DSS 2010.

[6]  Markus Schneider,et al.  BigCube: A Metamodel for Managing Multidimensional Data , 2010, SEDE.

[7]  François Pinet,et al.  A Unified Object Constraint Model for Designing and Implementing Multidimensional Systems , 2009, J. Data Semant..

[8]  Mehrdad Salehi,et al.  Developing a model and a language to identify and specify the integrity constraints in spatial datacubes , 2009 .

[9]  Yvan Bédard,et al.  A FORMAL CONCEPTUAL MODEL AND DEFINITIONAL FRAMEWORK FOR SPATIAL DATACUBES , 2010 .

[10]  Matteo Golfarelli,et al.  QBX: A CASE Tool for Data Mart Design , 2011, ER Workshops.

[11]  Jacky Akoka,et al.  Representation of Aggregation Knowledge in OLAP Systems , 2010, ECIS.

[12]  Jordi Cabot,et al.  Specifying Aggregation Functions in Multidimensional Models with OCL , 2010, ER.

[13]  Barbara Dinter,et al.  Extending the E/R Model for the Multidimensional Paradigm , 1998, ER Workshops.

[14]  Il-Yeol Song,et al.  A UML profile for multidimensional modeling in data warehouses , 2006, Data Knowl. Eng..

[15]  Valéria Cesário Times,et al.  Modelling and querying geographical data warehouses , 2010, Inf. Syst..

[16]  Stefano Spaccapietra,et al.  Spatio-temporal conceptual models: data structures + space + time , 1999, GIS '99.

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

[18]  François Pinet,et al.  Precise design of environmental data warehouses , 2010, Oper. Res..

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

[20]  Leticia I. Gómez,et al.  A generic data model and query language for spatiotemporal OLAP cube analysis , 2012, EDBT '12.

[21]  Torben Bach Pedersen,et al.  Multidimensional data modeling for location-based services , 2002, GIS '02.

[22]  Sandro Bimonte,et al.  The use of UML to design agricultural data warehouses , 2010 .

[23]  Juan Trujillo,et al.  An MDA Approach for the Development of Spatial Data Warehouses , 2008, DaWaK.

[24]  Nectaria Tryfona,et al.  starER: a conceptual model for data warehouse design , 1999, DOLAP '99.

[26]  Arie Shoshani,et al.  Summarizability in OLAP and statistical data bases , 1997, Proceedings. Ninth International Conference on Scientific and Statistical Database Management (Cat. No.97TB100150).

[27]  Riccardo Torlone.  Conceptual Multidimensional Models , 2003, Multidimensional Databases.

[28]  Bart Kuijpers,et al.  Spatial aggregation: Data model and implementation , 2007, Inf. Syst..

[29]  Markus Schneider,et al.  On the Requirements for User-Centric Spatial Data Warehousing and SOLAP , 2011, DASFAA Workshops.

[30]  Olivier Teste,et al.  Top_Keyword: An Aggregation Function for Textual Document OLAP , 2008, DaWaK.

[31]  Ralph Kimball,et al.  The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling , 1996 .

[32]  Esteban Zimányi,et al.  Advanced Data Warehouse Design: From Conventional to Spatial and Temporal Applications , 2010 .

[33]  Matteo Golfarelli,et al.  Conceptual design of data warehouses from E/R schemes , 1998, Proceedings of the Thirty-First Hawaii International Conference on System Sciences.

[34]  Stefano Spaccapietra,et al.  Spatial Data Warehouse Modelling , 2006 .

[35]  Carsten Sapia,et al.  Automatically generating OLAP schemata from conceptual graphical models , 2000, DOLAP '00.

[36]  Sandro Bimonte,et al.  Definition and Analysis of New Agricultural Farm Energetic Indicators Using Spatial OLAP , 2012, ICCSA.

[37]  Yvan Bédard,et al.  Spatial Online Analytical Processing (SOLAP): Concepts, Architectures, and Solutions from a Geomatics Engineering Perspective , 2007 .