The Impact of Partitioned Fact Tables and Bitmap Index on Data Warehouse Performance

Abstract

The design process is the most considered task of a data warehouse designer, this because of its performance criticality while going to production. Even if technology has developed in term of memory volume and speed, storage… the fact to minimize the execution time and the storage space still being a preoccupation for data warehousing specialists. This papers shows that using bitmap index and partitioned fact tables in data warehouse based on a star schema is more advantageous based on compression.