计算机应用 ›› 2009, Vol. 29 ›› Issue (06): 1605-1611.
• 数据挖掘 • 上一篇 下一篇
李明1,刘青宝2,陆昌辉3
收稿日期:
修回日期:
发布日期:
出版日期:
通讯作者:
基金资助:
Received:
Revised:
Online:
Published:
摘要: 针对现有物化视图选择算法无法很好解决OLAP随机查询的问题,提出了一种新型的两阶段物化视图选择算法(2-PMVS),将传统的静态选择算法与动态选择算法相结合,使其可以动态矫正用户随机查询与预估查询之间的偏差。经实验证明,该算法切实有效。
关键词: 数据仓库, 物化视图, 两阶段物化视图选择算法, data warehouse, materialized view
Abstract: To address the problem that the current materialized view selection methods couldn't solve random OLAP query efficiently, this paper proposed a 2-Phases Materialized View Selection (2-PMVS) algorithm which combined static materialized view selection algorithm with dynamic materialized view selection algorithm. It could dynamically bridge the gap between random queries and default queries. The experiments validate the effectiveness of the algorithm.
Key words: 2-Phases Materialized View Selection (2-PMVS)
李明 刘青宝 陆昌辉. 新型物化视图选择算法[J]. 计算机应用, 2009, 29(06): 1605-1611.
0 / 推荐
导出引用管理器 EndNote|Ris|BibTeX
链接本文: https://www.joca.cn/CN/
https://www.joca.cn/CN/Y2009/V29/I06/1605