Partial Cube Materialization in a Dynamic Data Warehouse

Usman Ahmed 1
1 BD - Base de Données
LIRIS - Laboratoire d'InfoRmatique en Image et Systèmes d'information
Abstract : Many modern applications such as sensors based monitoring, or certain business applications, raise the need for real time analysis, and thus require OLAP multidimensional models to be adapted to these evolving environments. Indeed, the scheduled offline batch update strategy, and the prerequisite of having totally ordered dimensions in traditional data warehouses, are both no more suitable for these time critical applications. In this paper, we present a multidimensional model for real-time data warehousing in hierarchical multidimensional data space. We also propose a dynamic partial cube materialization and a tree storage structure that groups the multidimensional data in no-ordered data partitions called minimum bounding spaces. We use Star Schema Benchmark to compare the performance of our solution with existing dynamic indexing technique. Experimental study shows performance improvement in both insertion time and queries over the data space.
Document type :
Conference papers
Complete list of metadatas

https://hal.archives-ouvertes.fr/hal-01353007
Contributor : Équipe Gestionnaire Des Publications Si Liris <>
Submitted on : Wednesday, August 10, 2016 - 4:18:47 PM
Last modification on : Wednesday, November 20, 2019 - 3:09:00 AM

Identifiers

  • HAL Id : hal-01353007, version 1

Citation

Usman Ahmed. Partial Cube Materialization in a Dynamic Data Warehouse. Very Large Data Bases (VLDB)- PhD Program Track, Aug 2012, Istanbul, Turkey. ⟨hal-01353007⟩

Share

Metrics

Record views

86