Ravat, Franck, Song, Jiefu and Teste, Olivier (2015) Analysis Framework for Reduced Data Warehouse. In: 11e Journées Francophones sur les Entrepôts de Données et l'Analyse en ligne (EDA 2015).

Preview

Text Download (515kB) | Preview

Abstract

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.