Partial Cube Materialization in a Dynamic Data Warehouse - Archive ouverte HAL Access content directly
Conference Papers Year : 2012

Partial Cube Materialization in a Dynamic Data Warehouse

Usman Ahmed
  • Function : Author
  • PersonId : 987431


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.
Not file

Dates and versions

hal-01353007 , version 1 (10-08-2016)


  • HAL Id : hal-01353007 , version 1


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


Gmail Facebook Twitter LinkedIn More