Computer Science ›› 2016, Vol. 43 ›› Issue (Z6): 493-496.doi: 10.11896/j.issn.1002-137X.2016.6A.116

Previous Articles     Next Articles

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!