A Model Driven Process for Spatial Data Sources and Spatial Data Warehouses Reconcilation

Since the data warehouse integrates the information provided by data sources, it is crucial to reconcile these sources with the information requirements of decision makers. It is specially true when novel types of data and metadata are stored in the data sources, e.g. spatial issues. In this way, spatial requirements have to be conformed with the available spatial metadata in order to obtain a data warehouse that, at the same time, satisfies decision maker spatial needs and do not attempt against the available metadata stored in the data sources. Therefore, in this paper, we have based on multidimensional forms and some spatial and geometric considerations to define a set of Query/View/Transformation (QVT) relations to formally define a set of rules that help designers in this tedious and prone-to-fail task. The novelty of our approach is to consider an hybrid viewpoint to develop spatial data warehouses (SDW), i.e., we firstly obtain the conceptual schema of the SDW from user requirements and then we verify its correctness against spatial data sources by using automatic transformations. Finally, the designer could take decisions to overcome the absence or incompactibility of certain spatial data by using our Eclipse CASE tool.

[1]  Luca Cabibbo,et al.  A Logical Approach to Multidimensional Databases , 1998, EDBT.

[2]  Erhard Rahm,et al.  A survey of approaches to automatic schema matching , 2001, The VLDB Journal.

[3]  Jose-Norberto Mazón,et al.  A Set of QVT Relations to Assure the Correctness of Data Warehouses by Using Multidimensional Normal Forms , 2006, ER.

[4]  Gottfried Vossen,et al.  Conceptual data warehouse modeling , 2000, DMDW.

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

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

[7]  Stephen J. Mellor,et al.  MDA Distilled Principles Of Model-Driven Architecture , 2004 .

[8]  Anjana Gosain,et al.  Informational Scenarios for Data Warehouse Requirements Elicitation , 2004, ER.

[9]  Hongjun Lu,et al.  Conceptual Modeling – ER 2004 , 2004, Lecture Notes in Computer Science.

[10]  Juan Trujillo,et al.  Designing Data Warehouses for Geographic OLAP Querying by Using MDA , 2009, ICCSA.

[11]  Paolo Giorgini,et al.  Goal-oriented requirement analysis for data warehouse design , 2005, DOLAP '05.

[12]  Robert Winter,et al.  A method for demand-driven information requirements analysis in data warehousing projects , 2003, 36th Annual Hawaii International Conference on System Sciences, 2003. Proceedings of the.

[13]  Gottfried Vossen,et al.  Multidimensional normal forms for data warehouse design , 2003, Inf. Syst..

[14]  David W. Embley,et al.  Conceptual Modeling - ER 2006, 25th International Conference on Conceptual Modeling, Tucson, AZ, USA, November 6-9, 2006, Proceedings , 2006, ER.

[15]  Jose Zubcoff,et al.  A model driven framework for geographic knowledge discovery , 2009, 2009 17th International Conference on Geoinformatics.

[16]  Matteo Golfarelli,et al.  The Dimensional Fact Model: A Conceptual Model for Data Warehouses , 1998, Int. J. Cooperative Inf. Syst..

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