The impact of indexes on data warehouse performance
A data warehouse designer should consider the effectiveness of data query, this depends on the selection of relevant indexes and their combination with the materialized views, note that the index selection is a NP-complete problem, because the number of indexes is exponential in the total number of attributes in the database, So, it is necessary to provide, while the data warehouse design, the suitable type of index for this data warehouse.
This paper presents, in some steps, a comparative study between the index B-tree and Bitmap type, their advantages and disadvantages, with a real experiment based on two factors: size of index and clustering factor, this shows that the Bitmap index is more advantageous than the B-tree one.
Keywords: Data Warehouse DBMS, indexes, business intelligence.
Download Full-Text
ABOUT THE AUTHORS
El Amin Aoulad Abdelouarit
Database Administrator in Tanger Med Port - Morocco, has Master in Software Quality from Sciences Faculty of Abdelmalek Essaadi University in Tetouan, Morocco.
Mohamed El Merouani
Professor / Researcher at the Abdelmalek Essaadi University - Disciplinary poly Faculty of Tetouan, PhD in Mathematics in 1995 from the University of Granada - SPAIN, Specialty Probability and Statistics
Abdellatif Medouri
Professor / Researcher at the Abdelmalek Essaadi University - Disciplinary poly Faculty of Tetouan, PhD in physics in 1993 from the University of Granada - SPAIN, Specialty Telecommunications.
El Amin Aoulad Abdelouarit
Database Administrator in Tanger Med Port - Morocco, has Master in Software Quality from Sciences Faculty of Abdelmalek Essaadi University in Tetouan, Morocco.
Mohamed El Merouani
Professor / Researcher at the Abdelmalek Essaadi University - Disciplinary poly Faculty of Tetouan, PhD in Mathematics in 1995 from the University of Granada - SPAIN, Specialty Probability and Statistics
Abdellatif Medouri
Professor / Researcher at the Abdelmalek Essaadi University - Disciplinary poly Faculty of Tetouan, PhD in physics in 1993 from the University of Granada - SPAIN, Specialty Telecommunications.
