Welcome to the InfoSci Platform
Reference Hub1
Facilitate Effective Decision-Making by Warehousing Reduced Data: Is It Feasible?

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

Faten Atigui, Franck Ravat, Jiefu Song, Olivier Teste, Gilles Zurfluh
Copyright: © 2015 |Volume: 7 |Issue: 3 |Pages: 29
ISSN: 1941-6296|EISSN: 1941-630X|EISBN13: 9781466677234|DOI: 10.4018/ijdsst.2015070103
Cite Article Cite Article

MLA

Atigui, Faten, et al. "Facilitate Effective Decision-Making by Warehousing Reduced Data: Is It Feasible?." IJDSST vol.7, no.3 2015: pp.36-64. http://doi.org/10.4018/ijdsst.2015070103

APA

Atigui, F., Ravat, F., Song, J., Teste, O., & Zurfluh, G. (2015). Facilitate Effective Decision-Making by Warehousing Reduced Data: Is It Feasible?. International Journal of Decision Support System Technology (IJDSST), 7(3), 36-64. http://doi.org/10.4018/ijdsst.2015070103

Chicago

Atigui, Faten, et al. "Facilitate Effective Decision-Making by Warehousing Reduced Data: Is It Feasible?," International Journal of Decision Support System Technology (IJDSST) 7, no.3: 36-64. http://doi.org/10.4018/ijdsst.2015070103

Export Reference

Mendeley
Favorite Full-Issue Download

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.

Request Access

You do not own this content. Please login to recommend this title to your institution's librarian or purchase it from the IGI Global bookstore.