摘要
为了改进数据仓库中物化视图选择策略,提出了基于查询和视图相对收益的动态选择算法BWCC。算法根据视图的尺寸,视图相对收益以及物化视图每项属性的权重构造初始选择集,并可以由用户设定初始视图权重。用户查询触发算法动态更新视图价值,对物化视图集按照视图相对收益大小排序并进行局部调整,到达全局更新周期时参考历史价值对物化视图集进行重新计算。实验结果表明,该算法相比于传统算法具有更高的查询命中率和适应性。
In order to improve materialized views selection strategy in data warehouse system, proposed BWCC dynamic selection algorithm based on query and views relative benefit is proposed. According to the size of the algorithm view, the relative benefits and each attribute weights of materialized views, the algorithm help build initial set and the initial view weight is set by users. User inquires trigger algorithm to update view value, and adjust part of the materialized views set according to relative benefit of views. Global update periodically execute refer to historical data. centage and adaptability than traditional algorithms. Experimental results show that the algorithm has higher per-centage and adaptability than traditional algorithms.
出处
《计算机工程与设计》
CSCD
北大核心
2013年第1期146-150,158,共6页
Computer Engineering and Design
关键词
物化视图集
动态选择
属性权重
用户习惯
视图相对收益
materialized views set
dynamic ehoicel attribute weight
user behaviorl views relative benefit
