作者投稿和查稿 主编审稿 专家审稿 编委审稿 远程编辑

计算机工程 ›› 2006, Vol. 32 ›› Issue (17): 147-149. doi: 10.3969/j.issn.1000-3428.2006.17.051

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

基于广域网和异构环境的ODS数据更新策略

夏秀峰1,张 悦1,周大海1,于 戈2   

  1. (1. 沈阳航空工业学院计算机科学与工程学院,沈阳 110034;2. 东北大学信息科学与工程学院,沈阳 110004)
  • 收稿日期:1900-01-01 修回日期:1900-01-01 出版日期:2006-09-05 发布日期:2006-09-05

ODS Data Update Strategy Based on WAN and Heterogeneous Environment

XIA Xiufeng1, ZHANG Yue1, ZHOU Dahai1, YU Ge2   

  1. (1. School of Computer Science and Engineering, Shenyang Institute of Aeronautical Engineering, Shenyang 110034; 2. School of Information Science and Engineering, Northeastern University, Shenyang 110004)
  • Received:1900-01-01 Revised:1900-01-01 Online:2006-09-05 Published:2006-09-05

摘要: 为满足信息处理的多层次需求,为企业日常决策分析者提供即时准确的全局数据视图,出现了DB-ODS-DW 3层体系结构,其中ODS承担了承上启下的重要作用。该文就ODS中的关键技术——数据更新策略进行了深入的研究,在对比分析了ODS传统数据更新策略的基础上,提出了一种基于网络和异构环境下的ODS数据更新策略,利用XML技术实现了异构数据库环境下变化数据的更新,以及变化数据文件的高效传输,并在实际应用中获得了理想的效果。

关键词: 操作型数据仓, 广域网, 异构环境, 变化数据文件, XML文档

Abstract: To satisfy the multi-level requirements of information process and supply the up to the second and exact global data view for decision-maker and analyzer in enterprise, the three-leveled architecture DB-ODS-DW in which ODS takes a connecting link functions between the preceding and the following is come forth. The data update strategy, an essential technique of ODS is studied in this paper. Contrasting with the traditional ODS data update strategies, a new strategy based on WAN and heterogeneous environment is proposed, in which the XML is used to implement the delta data updating in heterogeneous databases and to transmit the delta data file efficiently. This kind of strategy has been applied in practice and perfect effect has been obtained.

Key words: Operational data store, WAN, Heterogeneous environment, Delta data file, XML document

中图分类号: