CAJ | 학술논문

为了进一步提高数据仓库的性能, 通过分析数据仓库中性能优化技术的特点, 提出了索引和物化视图耦合的性能优化技术。通过数据挖掘自动选择候选索引和物化视图, 减少查询的扫描范围; 然后研究在物化视图上建立索引的空间高效存储方法, 以提高查询速率; 最后利用成本模型对耦合情况进行分析, 验证了耦合方法可以极大提高单一索引查询或者物化视图的性能。
위료진일보제고수거창고적성능, 통과분석수거창고중성능우화기술적특점, 제출료색인화물화시도우합적성능우화기술。통과수거알굴자동선택후선색인화물화시도, 감소사순적소묘범위; 연후연구재물화시도상건립색인적공간고효존저방법, 이제고사순속솔; 최후이용성본모형대우합정황진행분석, 험증료우합방법가이겁대제고단일색인사순혹자물화시도적성능。
In order to further improve the performance of the data warehouse, by analyzing the characteristics of the data warehouse performance optimization techniques, this paper presented a performance optimization technique which was coupling indexes and materialized views. Firstly, it selected candidate indexes and materialized views automatically by data mining, and then researched the method of space efficient storage that indexing on materialized views. Lastly, experimental results verify that the coupling method can greatly raise the properties of a single index or a materialized view, by using the cost model to analyze the coupling.