CAJ | 학술논문

检索性能的优劣在数据仓库应用中是至关重要的,位图索引在性能优化中起关键作用之一,并且它和传统的B树索引是不同的.通过实例描述了位图索引的构成原理,即:位图索引是由一系列有序的位向量组成;详细阐述了位图索引的特性(包括优点和缺点)以及其使用条件.最后文章结论指出合理地使用位图索引可以极大地改善大型系统的检索效率和减少系统资源.
검색성능적우렬재수거창고응용중시지관중요적,위도색인재성능우화중기관건작용지일,병차타화전통적B수색인시불동적.통과실례묘술료위도색인적구성원리,즉:위도색인시유일계렬유서적위향량조성;상세천술료위도색인적특성(포괄우점화결점)이급기사용조건.최후문장결론지출합리지사용위도색인가이겁대지개선대형계통적검색효솔화감소계통자원.
Query performance is critical in data warehouse applications, and bitmap indexes, which are quite different from the traditional B-tree indexes, play one of the important roles in performance tuning. The paper describes the principle of bitmap in?dexes through examples, i.e. a bitmap index is made up of an ordered series of bits, states detailedly the features (including advan?tages and disadvantages) and the usage conditions of bitmap indexes. Finally the paper concludes that using bitmap indexes proper?ly can greatly improve query efficiency and reduce system resources in large systems.