Managing Reduction in Multidimensional Databases - Université Toulouse 1 Capitole Accéder directement au contenu
Communication Dans Un Congrès Année : 2018

Managing Reduction in Multidimensional Databases

Résumé

Dealing with large amount of data has always been a key focus of the Data Warehouse (DW) community, especially in the current era when data volume increases more and more rapidly. In this paper, we first describe a conceptual modeling solution allowing reducing data in DWs. Specifically, a DW is modeled with multiple states. Each state is valid during a period of time. Detailed information is aggregated and then deleted in old states over time according to decision-makers' needs. Secondly, we describe several relational modeling alternatives: (i) the flat modeling integrates all states into one single table, (ii) the horizontal modeling converts each state into a fact table and some dimension tables associated with a temporal interval and (iii) the vertical modeling breaks down a reduced DW into separate tables, each table includes data from one or several states. At last, we evaluate query execution efficiency in DWs with and without data reduction. The result shows data reduction is an interesting solution, since it significantly decreases execution costs by 98.96% and it saves up to 95.75% of runtime during our experimental assessments.
Fichier principal
Vignette du fichier
Ravat_22256.pdf (644.96 Ko) Télécharger le fichier
Origine : Fichiers produits par l'(les) auteur(s)
Loading...

Dates et versions

hal-02548087 , version 1 (20-04-2020)

Identifiants

  • HAL Id : hal-02548087 , version 1
  • OATAO : 22256

Citer

Franck Ravat, Jiefu Song, Olivier Teste. Managing Reduction in Multidimensional Databases. International Conference on Current Trends in Theory and Practice of Computer Science (SOFSEM, 2018), Jan 2018, Krems an der Donau, Austria. pp.653-666. ⟨hal-02548087⟩
65 Consultations
68 Téléchargements

Partager

Gmail Facebook X LinkedIn More