基于索引视图实现动态数据仓库的实时数据加载-计算机科学.PDF

Vo 1. 43 No. 6A 第 43 卷第6A 期 计算机科学 2016 年 6 月 Computer Science June 2016 基于索引视图实现动态数据仓库的实时数据加载 武彤 i罩光炜 (贵州大学计算机科学与技术学院 贵阳 550025) 摘 要 随着数据仓库技术的不断普及，基于数据仓库技术的决策支持系统在企业得到了广泛应用，同时出现了动态 数据仓库。随着动态数据仓库在决策支持领域扮演的角色越来越重要，企业利用决策支持系统从辅助进行战略决策 开始向战术决策转变。而要进行战术性的分析，数据仓库中必须有动态变化的必威体育精装版数据，实现数据仓库的动态叫守性 的关键又在于实现动态数据获取，即实现实时数据捕获加载。提出了基于索引视图实现动态数据仓库的实时数据 加载，并通过实验验证了其可行性。该方法对进一步深入研究实时数据捕获技术有一定的借鉴作用。 关键词 动态数据仓库，数据仓库，实时数据，数据加载 中固法分类号 TP309.2 文献标识码 A Real-time Data Loading of Dynamic Data Warehouse Using Index View Set WU Tong T AN Guang-wei (College of Computer Science Technology ,Guizhou University ,Guiyang 5500Z5 ,China) Abstract 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 d严mmic 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 a nalysis. 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. Keywords Dyn