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

ODS Data Update Strategy Based on WAN and Heterogeneous Environment

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

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.