科技报告详细信息
Performance of Multi-Level and Multi-Component Compressed Bitmap Indexes.
Wu, K. ; Stockinger, K. ; Shoshani, A.
Technical Information Center Oak Ridge Tennessee
关键词: Compressing;    Indexing;    Database management;    Information retrieval;    Performance;   
RP-ID  :  DE2007920347
学科分类:工程和技术(综合)
美国|英语
来源: National Technical Reports Library
PDF
【 摘 要 】

Bitmap indexes are known as the most effective indexing methods for range queries on append-only data, especially for low cardinality attributes. Recently, bitmap indexes were also shown to be just as effective for high cardinality attributes when certain compression methods are applied. There are many different bitmap indexes in the literature but no definite comparison among them has been made, largely because there is no accurate prediction of their index sizes and search time. This paper presents a systematic evaluation of two large subsets of compressed bitmap indexes that use multi-component and multi-level encodings. We combine extensive analyses with ample experimental results to confirm them, whereas earlier studies of these indexes are either empirical or for uncompressed indexes only. Our analyses provide highly accurate predictions that agree with test measurements. These analyses not only identify the best methods in terms of index size and query processing cost, but also reveal new ways of using multi-level methods that significantly improve their performance. Using the best parameters obtained through analyses, we produce three two-level indexes with the optimal computational complexity. Furthermore, the fastest two-level indexes are predicted and observed to be 5 to 10 times faster than other well-known indexes.

【 预 览 】
附件列表
Files Size Format View
DE2007920347.pdf 403KB PDF download
  文献评价指标  
  下载次数:17次 浏览次数:42次