OATAO - Open Archive Toulouse Archive Ouverte Open Access Week

Facilitate effective decision-making by warehousing reduced data: is it feasible?

Atigui, Faten and Ravat, Franck and Song, Jiefu and Teste, Olivier and Zurfluh, Gilles Facilitate effective decision-making by warehousing reduced data: is it feasible? (2015) International Journal of Decision Support System Technology, 7 (3). 36-64. ISSN 1941-6296

[img] (Document in English)

PDF (Author's version) - Depositor and staff only - Requires a PDF viewer such as GSview, Xpdf or Adobe Acrobat Reader
890kB

Official URL: http://dx.doi.org/10.4018/ijdsst.2015070103

Abstract

The authors' aim is to provide a solution for multidimensional data warehouse's reduction based on analysts' needs which will specify aggregated schema applicable over a period of time as well as retain only useful data for decision support. Firstly, they describe a conceptual modeling for multidimensional data warehouse. A multidimensional data warehouse's schema is composed of a set of states. Each state is defined as a star schema composed of one fact and its related dimensions. The derivation between states is carried out through combination of reduction operators. Secondly, they present a meta-model which allows managing different states of multidimensional data warehouse. The definition of reduced and unreduced multidimensional data warehouse schema can be carried out by instantiating the meta-model. Finally, they describe their experimental assessments and discuss their results. Evaluating their solution implies executing different queries in various contexts: unreduced single fact table, unreduced relational star schema, reduced star schema and reduced snowflake schema. The authors show that queries are more efficiently calculated within a reduced star schema.

Item Type:Article
Additional Information:The original PDF of the article can be found at International Journal of Decision Support System Technology (ISSN 1941-6296) website : http://www.igi-global.com/article/facilitate-effective-decision-making-by-warehousing-reduced-data/133850
Audience (journal):International peer-reviewed journal
Uncontrolled Keywords:
Institution:Other partners > Conservatoire National des Arts et Métiers - CNAM (FRANCE)
French research institutions > Centre National de la Recherche Scientifique - CNRS (FRANCE)
Université de Toulouse > Institut National Polytechnique de Toulouse - Toulouse INP (FRANCE)
Université de Toulouse > Université Toulouse III - Paul Sabatier - UT3 (FRANCE)
Université de Toulouse > Université Toulouse - Jean Jaurès - UT2J (FRANCE)
Université de Toulouse > Université Toulouse 1 Capitole - UT1 (FRANCE)
Laboratory name:
Statistics:download
Deposited On:30 Jun 2016 14:05

Repository Staff Only: item control page