数据仓库中物化视图选择策略  

Selection strategy of materialized views in data warehouse

作　　者：林小静[1] 薛永生[1] 

机构地区：[1]厦门大学计算机系,福建厦门361005

出　　处：《计算机工程与设计》2007年第13期3056-3059,共4页Computer Engineering and Design

基　　金：福建省自然科学基金项目(A0310008);福建省重点科技基金项目(2003H043)

摘　　要：为了提高决策支持和OLAP查询的响应效率,数据仓库多采用物化视图的思想。因此,物化视图的选择策略是数据仓库研究的重要问题之一。其目标是选出一组存储、维护代价与查询代价的总和为最小的物化视图。提出一个以MVPP(mul-ti-view processing plan)为视图选择的搜索空间的物化视图选择新算法——VSMF(views selection base on multi-factor)算法。该算法在存储空间约束下同时实现多查询最优化和视图维护最优化。A set of materialized views are stored in the data warehouse for the purpose of efficiently implementing decision-support or OLAP queries. The selection of materialized views is one of the most important issues in the data warehouse development. The goal is to select an appropriate set of views so that the total cost of storage, maintenance and query is minimized. A new algorithm named VSMF （views selection base on multi-factor） algorithm using multi-view processing plan structure as search space is proposed, which solve the problem considering both multi-query optimization and the maintenance process optimization under the storage space constrain.

关 键 词：数据仓库 物化视图 选择策略 维护策略 存储空间约束 

分 类 号：TP311.131[自动化与计算机技术—计算机软件与理论]