International Journal of Computer Applications |
Foundation of Computer Science (FCS), NY, USA |
Volume 79 - Number 7 |
Year of Publication: 2013 |
Authors: El Amin Aoulad Abdelouarit, Mohamed El Merouani, Abdelatif Medouri |
![]() |
El Amin Aoulad Abdelouarit, Mohamed El Merouani, Abdelatif Medouri . Data Warehouse Tuning: The Supremacy of Bitmap Index. International Journal of Computer Applications. 79, 7 ( October 2013), 7-10. DOI=10.5120/13751-1573
The data query is the only way to get information from a data warehouse, for that, the designer should consider it effectiveness while the selection of relevant indexes and their combination with materialized views, also the index selection is known as a NP-complete problem, as per the number of indexes is exponential in the total attributes in the database, This makes the choose of the suitable index type is a necessary step while the data warehouse design. In this paper we show that Bitmap index is more advantageous than the B-tree index, based on three factors, size of index, clustering factor and compression, with a real experiment.