Analysis Framework for Reduced Data Warehouse

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).

[img]
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.

Item Type: Conference or Workshop Item (Paper)
Language: English
Date: 2015
Uncontrolled Keywords: Multidimensional modelling - OLAP - Reduced data warehouse
Subjects: H- INFORMATIQUE
Divisions: Institut de Recherche en Informatique de Toulouse
Site: UT1
Date Deposited: 26 Mar 2019 13:33
Last Modified: 26 Mar 2019 13:33
URI: http://publications.ut-capitole.fr/id/eprint/29610

Actions (login required)

View Item View Item

Downloads

Downloads per month over past year