计算机应用研究2013，Vol.30Issue(3)：835-837,3.DOI:10.3969/j.issn.1001-3695.2013.03.049
数据仓库性能优化之索引和物化视图耦合方法
Coupling method of indexes and materialized views about data warehouse performance optimization
摘要
Abstract
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.关键词
索引/耦合/物化视图/成本模型/数据仓库Key words
index/ coupling/ materialized view/ cost model/ data warehouse分类
信息技术与安全科学引用本文复制引用
马莹莹,戴牡红..数据仓库性能优化之索引和物化视图耦合方法[J].计算机应用研究,2013,30(3):835-837,3.基金项目
湖南省自然科学基金资助项目(2011FJ3034) （2011FJ3034）
