Automatic monitoring system database replication technology
|School||Huazhong University of Science and Technology|
|Keywords||Ambient air quality automatic monitoring system Database Replication Change Capture Merge Replication Replication Components|
In this paper, automatic air quality monitoring system, for example , describes the database replication technology in the automatic monitoring system application . Automatic air quality monitoring system can help control ambient air quality and trends , people's livelihood and work of great guiding significance for help . It includes monitoring center stations and monitoring stations , monitoring stations located throughout the urban area , the data stored in the distributed environment . To merge the sub-station data backup , the application of database replication technology . Database replication and the replication process is divided into the revision process . Replication process consists of four steps: change capture , distribution, synchronization and conflict monitoring and resolution . Top five ways to capture changes : Snapshot method, trigger method, the log method , API method and the timestamp method . These five methods for capturing changes were introduced . Distributed according to the distribution server location is divided into: push, pull mode , sliding combination bidirectional mode. Generally based on the actual situation in conflict detection and resolution. This article is based on engineering issues \According to the actual needs of the system , the choice of SQL Server merge replication as synchronization scheme . Guidance for merge replication method, batch programming method and replication experiments were carried out . Using C #. Net developed a replication components, and use Indusoft build a test platform , tested it . These three methods for comparative experiments concluded : For multiple sub- site replication deployments, batch processing and replication components developed method is superior to the wizard .