首页 | 本学科首页   官方微博 | 高级检索  
     

数据仓库中物化视图选择策略
引用本文:林小静,薛永生.数据仓库中物化视图选择策略[J].计算机工程与设计,2007,28(13):3056-3059.
作者姓名:林小静  薛永生
作者单位:厦门大学计算机系 福建厦门361005
基金项目:福建省自然科学基金 , 福建省科技计划
摘    要:为了提高决策支持和OLAP查询的响应效率,数据仓库多采用物化视图的思想.因此,物化视图的选择策略是数据仓库研究的重要问题之一.其目标是选出一组存储、维护代价与查询代价的总和为最小的物化视图.提出一个以MVPP(multi-view processing plan)为视图选择的搜索空间的物化视图选择新算法--VSMF(views selection base on multi-factor)算法.该算法在存储空间约束下同时实现多查询最优化和视图维护最优化.

关 键 词:数据仓库  物化视图  选择策略  维护策略  存储空间约束  数据仓库  物化视图选择  选择策略  data  warehouse  views  strategy  视图维护  最优化  多查询  空间约束  selection  base  算法  搜索空间  processing  plan  最小  查询代价  存储  目标
文章编号:1000-7024(2007)13-3056-04
修稿时间:2006-07-20

Selection strategy of materialized views in data warehouse
LIN Xiao-jing,XUE Yong-sheng.Selection strategy of materialized views in data warehouse[J].Computer Engineering and Design,2007,28(13):3056-3059.
Authors:LIN Xiao-jing  XUE Yong-sheng
Affiliation:Department of Computer Science, Xiamen University, Xiamen 361005, China
Abstract: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.
Keywords:data warehouse  materialized view  selection strategy  maintenance strategy  storage space constrain
本文献已被 CNKI 维普 万方数据 等数据库收录!
设为首页 | 免责声明 | 关于勤云 | 加入收藏

Copyright©北京勤云科技发展有限公司  京ICP备09084417号