文章基本信息

标题：The impact of indexes on data warehouse performance
本地全文：下载
作者：El Amin Aoulad Abdelouarit ; Mohamed El Merouani ; Abdellatif Medouri 等
期刊名称：International Journal of Computer Science Issues
印刷版ISSN：1694-0784
电子版ISSN：1694-0814
出版年度：2013
卷号：10
期号：5
出版社：IJCSI Press
摘要：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.
关键词：Data Warehouse DBMS; indexes; business intelligence.