Coupling method of indexes and materialized views about datawarehouse performance optimization
数据仓库性能优化之索引和物化视图耦合方法

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.