摘要
该文研究了一种基于SQLSERVER复制方法的数据同步机制，并将其应用于某大型征稽管理系统，实现了省到市、到县所、到站点这四级之间数据变化的实时同步。通过设置动态筛选，使用存储过程，配置触发器和调度作业，实现了全省近300站点同步更新各自站点数据，减少了数据传输量，提高了数据同步的传输效率、灵活性、安全性和准确性。
This paper made a research into a Data Synchronization Mechanism based on SQL SERVER Replication and applied it into a certain toll collection management system so that real-time synchronization of data changes from a province to a city, to a county and to a site can be realized. By setting up dynamic filtration and taking charge of storage process, trigger and job scheduling, about 300 sites of the whole province could synchronically update their own site data, and at the same time transmission efficiency, flexibility, security and accuracy of the data synchronization were enhanced.
作者
戴婉荣
熊前兴
DAI Wan-rong, XIONG Qian-xing （Computer Science and Technology, Wuhan University of Technology, Wuhan 430063,China）
出处
《电脑知识与技术》
2009年第7期5096-5098,共3页
Computer Knowledge and Technology
