Facilitate Effective Decision-Making by Warehousing Reduced Data: Is It Feasible?

Faten Atigui, Franck Ravat, Jiefu Song, Olivier Teste and Gilles Zurfluh
Additional contact information
Faten Atigui: Centre d'Etude et De Recherche en Informatique et Communications (CEDRIC), Conservatoire National des Arts et Métiers, Paris, France
Franck Ravat: Institut de Recherche en Informatique de Toulouse (IRIT), Université Toulouse I Capitole, Toulouse, France
Jiefu Song: Institut de Recherche en Informatique de Toulouse (IRIT), Université Toulouse I Capitole, Toulouse, France
Olivier Teste: Institut de Recherche en Informatique de Toulouse (IRIT), Université Toulouse II Jean Jaurès, Toulouse, France
Gilles Zurfluh: Institut de Recherche en Informatique de Toulouse (IRIT), Université Toulouse I Capitole, Toulouse, France

International Journal of Decision Support System Technology (IJDSST), 2015, vol. 7, issue 3, 36-64

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.

Date: 2015
References: Add references at CitEc
Citations:

Downloads: (external link)
http://services.igi-global.com/resolvedoi/resolve. ... 18/ijdsst.2015070103 (application/pdf)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:igg:jdsst0:v:7:y:2015:i:3:p:36-64

Access Statistics for this article

International Journal of Decision Support System Technology (IJDSST) is currently edited by Shaofeng Liu

More articles in International Journal of Decision Support System Technology (IJDSST) from IGI Global
Bibliographic data for series maintained by Journal Editor ().