网络隔离下的内外网数据同步系统研究
首发时间:2009-03-30
摘要:本文深入探讨了网络隔离技术和数据库同步技术,并将二者结合起来考虑,研究了在网络隔离环境下数据库同步策略,提出了网络隔离下的内外网数据库同步方案,并给出了该方案的实现思路。该方法运用触发器对源数据库变化进行捕获,还原出源数据库发生变更的SQL语句并记录日志,然后通过从日志文件中获取被还原的SQL语句,执行更新目标数据库,从而达到数据同步。该方法具有完全异构、灵活性好、通用性强、安全性高的特点。文章给出了实现该方法的总体框架结构,整个框架由同步预配置、变化捕获、日志还原、网络通讯和数据更新等五个功能模块组成,并按照总体框架及流程给出了每个模块的实现细节。
For information in English, please click here
Research On Data Synchronization System with GAP between Internet and Intranet
Abstract:In this paper, in-depth exploration into the network quarantine technology and database synchronization technology, and combine the two considerations, studied under isolation at the network database synchronization strategy, put forward a network of internal and external isolation Net database synchronization program and give the program implementation ideas. This method is the use of triggers on the source database to capture changes, restore the source database to change the SQL statement and record the log, then from the log file will be restored to obtain the SQL statement, perform the update the target database, so as to achieve data synchronization. The method is completely heterogeneous, good flexibility, high universality, high security features. Article give the implementation of the method of the overall framework of the structure, the entire framework of pre-configured by the simultaneous change capture, log reduction, network communications and data to update the five functional modules, and in accordance with the general framework and give the flow for each module the implementation details.
Keywords: Data Synchronization;Network Isolation;Trigger to capture changes
基金:
论文图表:
引用
No.3087445420112383****
同行评议
勘误表
网络隔离下的内外网数据同步系统研究
评论
全部评论0/1000