Analysis Framework for Reduced Data Warehouse
Abstract
Our aim is to define a framework supporting analysis in MDW with
reductions. Firstly, we describe a modeling solution for reducedMDW. 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.