Skip to Main content Skip to Navigation
Conference papers

Reducing Multidimensional Data

Abstract : Our aim is to elaborate a multidimensional database reduction process which will specify aggregated schema applicable over a period of time as well as retains useful data for decision support. Firstly, we describe a multi-dimensional database schema composed of a set of states. Each state is defined as a star schema composed of one fact and its related dimensions. Each reduced state is defined through reduction operators. Secondly, we describe our experi-ments and discuss their results. Evaluating our solution implies executing different requests in various contexts: unreduced single fact table, unreduced re-lational star schema, reduced star schema or reduced snowflake schema. We show that queries are more efficiently calculated within a reduced star schema.
Complete list of metadata

Cited literature [13 references]  Display  Hide  Download

https://hal.archives-ouvertes.fr/hal-01141433
Contributor : Open Archive Toulouse Archive Ouverte (oatao) <>
Submitted on : Monday, April 13, 2015 - 8:51:07 AM
Last modification on : Wednesday, June 9, 2021 - 10:00:32 AM
Long-term archiving on: : Monday, September 14, 2015 - 7:22:54 AM

File

Atigui_13214.pdf
Files produced by the author(s)

Identifiers

  • HAL Id : hal-01141433, version 1
  • OATAO : 13214

Citation

Faten Atigui, Franck Ravat, Jiefu Song, Gilles Zurfluh. Reducing Multidimensional Data. International Conference on Data Warehousing and Knowledge Discovery - DaWaK 2014, Sep 2014, Munich, Germany. pp. 208-220. ⟨hal-01141433⟩

Share

Metrics

Record views

201

Files downloads

393