DataSend:一种因特网环境下的数据库数据同步软件  

A Kind of Data-Synchronous Software of Database under Internet Environment

作　　者：刘风略[1] 饶若楠[1] 

机构地区：[1]上海交通大学计算机科学与工程系

出　　处：《微型电脑应用》2007年第6期53-55,5,共3页Microcomputer Applications

摘　　要：在稳定性不好的网络环境下利用SQL SERVER数据库的复制功能进行数据同步容易造成数据的不完全一致。本文讨论了一个基于SQL SERVER复制方法和压缩技术的数据同步软件DataSend的设计和应用。DataSend通过建设中间层缓解了源数据库和目标数据库的压力;对传输数据进行压缩处理后再传输;通过状态来控制传输的准确性。从而提高了数据同步的传输效率、灵活性、安全性和准确性。SQL Server replication can synchronize data to various servers by back - end configuration, but it has somelimitations and can not meet specific demands of enterprises. In this thesis, a series of improvements were proposed based onSQL server's replication, including that building middle layer to reduce the workloads of the source and destination database,serializing data before transfer to improve efficiency, and setting record status control for higher accuracy. With the aboveimprovements, our data synchronization method has higher flexibility, better safety and more accuracy compared to SQLserver's replication.

关 键 词：数据同步 Agent 触发器 序列化 反序列化 数据抽取 数据转换 数据装载 

分 类 号：TP311.5[自动化与计算机技术—计算机软件与理论]