数据仓库自维护下视图分解系统的设计与实现

数据仓库自维护实质上是通过维护实化视图实现,然而现有的实化视图自维护策略不能有效的减少数据仓库集成端和数据源监视端的多余数据,从而影响数据仓库环境的整体响应速度.一种基于数据仓库自维护方法的视图分解系统改进了现有的视图分解模式,将全局定义的实化视图分解成局部定义的单源视图集来减少存在数据仓库中不必要的数据,实现了现有实化视图自维护策略的分解和重写,提高数据仓库自维护效率.

Design and implementation of decomposing views system for data warehouse self-maintenance

The data warehouse self-maintenance problem is substantially the problem of making materialized views self-maintainable.Because the exiting policies of materialized views self-maintenance cannot effectually reduce superfluous data in the integration and data sources of data warehouse,the response velocity of data warehouse environment will be tampered.The decomposing views system for data warehouse self-maintenance and improves the present pattern of decomposing views through deriving local views definations of single data source from the global definitions of materialized views.In conclution,the system not only can realize the functions of de-composing and rewriting materialized views,but also can heighten the efficiency of data warehouse self-maintainance.