International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
|
Volume 79 - Issue 7 |
Published: October 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
@article{ 10.5120/13751-1573, author = { El Amin Aoulad Abdelouarit,Mohamed El Merouani,Abdelatif Medouri }, title = { Data Warehouse Tuning: The Supremacy of Bitmap Index }, journal = { International Journal of Computer Applications }, year = { 2013 }, volume = { 79 }, number = { 7 }, pages = { 7-10 }, doi = { 10.5120/13751-1573 }, publisher = { Foundation of Computer Science (FCS), NY, USA } }
%0 Journal Article %D 2013 %A El Amin Aoulad Abdelouarit %A Mohamed El Merouani %A Abdelatif Medouri %T Data Warehouse Tuning: The Supremacy of Bitmap Index%T %J International Journal of Computer Applications %V 79 %N 7 %P 7-10 %R 10.5120/13751-1573 %I Foundation of Computer Science (FCS), NY, USA
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.