Dissertation > Industrial Technology > Automation technology,computer technology > Computing technology,computer technology > Computer software > Program design,software engineering > Programming > Database theory and systems

Automatic monitoring system database replication technology

Author LiuJinPing
Tutor WangLingYun
School Huazhong University of Science and Technology
Course Electrical Engineering
Keywords Ambient air quality automatic monitoring system Database Replication Change Capture Merge Replication Replication Components
CLC TP311.13
Type Master's thesis
Year 2011
Downloads 25
Quotes 0
Download Dissertation

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 .

Related Dissertations
More Dissertations