Analysis Framework for Reduced Data WarehouseReport as inadecuate

Analysis Framework for Reduced Data Warehouse - Download this document for free, or read online. Document in PDF available to download.

1 IRIT - Institut de recherche en informatique de Toulouse

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.

Keywords : Multidimensional modelling OLAP Reduced data warehouse

Author: Franck Ravat - Jiefu Song - Olivier Teste -



Related documents