基于索引视图实现动态数据仓库的实时数据加载

随着数据仓库技术的不断普及,基于数据仓库技术的决策支持系统在企业得到了广泛应用,同时出现了动态数据仓库。随着动态数据仓库在决策支持领域扮演的角色越来越重要,企业利用决策支持系统从辅助进行战略决策开始向战术决策转变。而要进行战术性的分析,数据仓库中必须有动态变化的最新数据,实现数据仓库的“动态”特性的关键又在于实现“动态数据获取”,即实现实时数据捕获加载。提出了基于索引视图实现动态数据仓库的实时数据加载,并通过实验验证了其可行性。该方法对进一步深入研究实时数据捕获技术有一定的借鉴作用。

Real-time Data Loading of Dynamic Data Warehouse Using Index View Set

With the vast employment of data warehouse technology,decision making supporting system using data warehouse technology is commonly used among corporations.At the same time,dynamic data warehouse appeares.As dynamic data warehouse becomes increasingly important in the decision making supporting field,corporations tend to more frequently employ decision making supporting system to assist tactical decision making,migrating from strategical decision making.However,the dynamically updated data in the data warehouse is the prerequisite to carry out tactical analysis.The key to realize the dynamic features of data warehouse is to obtain dynamic updated data,which is real-time data loading.This article proposed to use index view set to realize real-time data loading in the dynamic data warehouse and demonstrated the feasibility of the approach.It also shields light to further research on real-time data loading.