Business Intelligence

A Maintenance Approach of a BJI Index Configuration

Free registration required

Executive Summary

In data warehousing domain, OLAP (On Line Analytical Processing) queries are complex since they use several tables with huge cardinalities. Several optimization techniques have been studied in the literature as materialized views and Bitmap Join Indexes (BJI). BJI indexes are useful to pre-calculate star joins in order to reduce the execution cost. Current approaches for the selection of BJI define a configuration that optimizes a beforehand definite workload of queries. However, this workload can evolve in time and is likely to make obsolete the configuration of index created. In order to take into account the evolution of a workload of queries, the authors propose, in this paper, a maintenance approach for the recommendation of a new configuration of indexes.

  • Format: PDF
  • Size: 286.73 KB