%0 Journal Article %T Coupling method of indexes and materialized views about datawarehouse performance optimization
数据仓库性能优化之索引和物化视图耦合方法 %A MA Ying-ying %A DAI Mu-hong %A
马莹莹 %A 戴牡红 %J 计算机应用研究 %D 2013 %I %X 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. %K index %K coupling %K materialized view %K cost model %K data warehouse
索引 %K 耦合 %K 物化视图 %K 成本模型 %K 数据仓库 %U http://www.alljournals.cn/get_abstract_url.aspx?pcid=5B3AB970F71A803DEACDC0559115BFCF0A068CD97DD29835&cid=8240383F08CE46C8B05036380D75B607&jid=A9D9BE08CDC44144BE8B5685705D3AED&aid=57319E4289F4438F5596FCF1D4F6B040&yid=FF7AA908D58E97FA&vid=340AC2BF8E7AB4FD&iid=38B194292C032A66&sid=9EB9AF946ABE60ED&eid=2C8B50BA95995EA2&journal_id=1001-3695&journal_name=计算机应用研究&referenced_num=0&reference_num=11