An extended query-driven framework for spatial multidimensional modeling

Abstract

The multidimensional conceptual model is an important artifact that fixes the role of the future data warehouse. Its design quality is indicated by the conformity rate with the requirements expressed by the decision makers and the end-users. Existing proposals for conceptual multidimensional modeling do not systematically take into consideration the end-users queries neither at the formal level nor at the requirement level for driving the data schema design of the future DW. The conformity of the Spatial DW is assured by both business constraints and spatial constraints that should be leveraged at a conceptual level to ease the design and be at a higher abstraction level in order not to be tied to a specific platform. Our extended framework encloses the user queries and the constraints at a conceptual level and gives a global approach for designing Spatial DW. It starts with a query-driven framework tailored for spatiality, and then transforms the Multidimensional Conceptual Model to a UML profile, which is enriched by business and spatial constraints using OCL. Finally, the user queries physical implementation is generated automatically using the OCL22SQL tool.