摘要
物化视图是数据仓库中提高查询效率的有力方法,物化视图的选择一直是数据仓库领域的研究热点。通过对星型模型的研究,根据对数据仓库的常用查询及其执行概率,设计出一个候选视图的算法,并详细介绍了线性代价模型,在该模型和候选视图算法基础上,参照文献[4]提出一个改进的物化视图选择贪心算法。
Materialized view is a method for improving the efficiency of queries in data warehouse system, the selection of it is a hot issue in data warehouse area. According to frequent queries and their probabilities, we design a candidate views selection algorithm, and then introduce a linear cost model in detail. Based on this model and candidate algorithm, we improve the greedy algorithm for materialized views selection in reference[4].
出处
《计算机应用》
CSCD
北大核心
2003年第9期58-60,共3页
journal of Computer Applications
关键词
数据仓库
物化视图
选择算法
data warehouse
materialized view
selection algorithm