Analysis Framework for Reduced Data Warehouse

Franck Ravat (1, 2) , Jiefu Song (1) , Olivier Teste (1, 3)

1 IRIT-SIG - Systèmes d’Informations Généralisées
2 UT Capitole - Université Toulouse Capitole
3 UT2J - Université Toulouse - Jean Jaurès

Our aim is to define a framework supporting analysis in MDW with reductions. Firstly, we describe a modeling solution for reduced MDW. A schema of reduced MDW is composed of states. Each state is defined as a star schema composed of one fact and its related dimensions valid for a certain period of time. Secondly, we present a multi-state analysis framework. Extensions of classical drilldown and rollup operators are defined to support multi-states analyses. Finally we present a prototype of our framework aiming to prove the feasibility of concept. By implementing our extended operators, the prototype automatically generates appropriate SQL queries over metadata and reduced data.

Mots clés: Reduced data warehouse; OLAP; Multidimensional modelling

Domaines: Théorie de l'information [cs.IT]; Recherche d'information [cs.IR]

Franck Ravat, Jiefu Song, Olivier Teste. Analysis Framework for Reduced Data Warehouse. 11e Journées Francophones sur les Entrepôts de Données et l'Analyse en ligne (EDA 2015), Apr 2015, Bruxelles, Belgium. pp. 81-96. ⟨hal-01360874⟩