Wednesday 20th of September 2017
 

The impact of indexes on data warehouse performance


El Amin Aoulad Abdelouarit, Mohamed El Merouani and Abdellatif Medouri

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.


IJCSI Published Papers Indexed By:

 

 

 

 
About IJCSI

IJCSI is a refereed open access international journal for scientific papers dealing in all areas of computer science research...

Learn more »
Join Us
FAQs

Read the most frequently asked questions about IJCSI.

Frequently Asked Questions (FAQs) »
Get in touch

Phone: +230 911 5482
Email: info@ijcsi.org

More contact details »