Research And Application Of Distributed Database Of Bank Monitoring System

An application in a distributed database system, the bank security monitoring system is a typical enterprise-class distributed application. The scattered distribution outlets of the bank, and the province and the national network, there are large number of monitoring equipment, user personnel information and alarms. Using a distributed database solution is necessary. Then a problem is followed, the need for remote data synchronization, if necessary, communication mechanisms should be adopted to ensure real-time data synchronization, reliability, efficiency.In this thesis, distributed database monitoring system for banking features, combined with WCF communication technology for the synchronization of distributed database and application implementation. Specific work of this thesis is as follows:(1) Introduced the theory of distributed database.(2) Proposed monitoring system based on bank distributed database synchronization program. Including how to generate synchronous data, how to transfer synchronous data, how to load synchronous data.(3) In-depth study of the DTC-based distributed transaction management models, including matters of registration, building transaction commit tree, based on the submission of two-phase commit transaction mechanism.(4) Deep research for the current data synchronization technology and analyze their advantages and disadvantages. Then design a new data synchronization solution for the real apply environment of bank.(5) Analysis, design and realization of the related key technologies and core modules related to the synchronization model.(6) ETL and WCF-based data synchronization model is applied to bank monitoring system in order to implement distributed data synchronization. Including database design unified coding, data synchronization, data recovery and so on.The system has been deployed in ICBC monitoring center of Sichuan province. The system is running well, the real-time data synchronization and stability are high, which further demonstrates the feasibility of the synchronous model.