计算机科学 ›› 2016, Vol. 43 ›› Issue (Z6): 493-496.doi: 10.11896/j.issn.1002-137X.2016.6A.116

• 软件工程与数据库技术 • 上一篇    下一篇

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

武彤,谭光炜   

  1. 贵州大学计算机科学与技术学院 贵阳550025,贵州大学计算机科学与技术学院 贵阳550025
  • 出版日期:2018-11-14 发布日期:2018-11-14
  • 基金资助:
    本文受动态数据仓库的数据加载技术研究(黔科合J字[2013]2115号)资助

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

WU Tong and TAN Guang-wei   

  • Online:2018-11-14 Published:2018-11-14

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

关键词: 动态数据仓库,数据仓库,实时数据,数据加载

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 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.

Key words: Dynamic data warehouse,Data warehouse,Real-time data,Data loading

[1] iHaisten M.Real Time Data Warehouse:The Next Stage in Data Warehouse Evolution[J].DM Review,2003
[2] 徐富亮,周祖德.变化数据捕获技术研究[J].武汉理工大学学报(信息与管理工程版),2009,1(5):740-743
[3] Ankorion I.Change data capture-efficient ETL for real-time BI[J].DM Review magazine,2005(1)
[4] 刘兆强.基于快照差分的数据源更新检测方法研究及其实现[D].广州:暨南大学,2007:13-20
[5] 陆剑锋,张洁.数据仓库数据更新的研究及基于Oracle数据库的开发与应用[J].计算机工程与应用,2004,0(26):384-386
[6] 邹先霞,贾维嘉,潘久辉.基于数据库日志的变化数据捕获研究[J].小型微型计算机系统,2012,3(3):531-536
[7] 王珊,萨师煊.数据库系统概论[M].北京:高等教育出版社,2009:89-91
[8] SQL Server视图索引与索引视图指南.http://database.51cto.com/art/201007/212533.htm
[9] 谭光炜.动态数据仓库实时数据的捕获及加载技术研究[D].贵阳:贵州大学,2015:50-63

No related articles found!
Viewed
Full text


Abstract

Cited

  Shared   
  Discussed   
No Suggested Reading articles found!