Research On Data Consistency Management And Data Lock Mechanism Of The Audit Data Center

In recent years,the audit data resources have been expanded,and the form of audit has been transformed from the field audit to the computer-assisted online audit.This requires the audit data center to be able to adapt to the audit needs of the new era.The audit data center need to be transformed from a simple storage of the audit data to a service platform that supports the audit staffs perform the audit business.Because the audit data of audit data center is distributed in multiple database management systems in the audit network,the audit data of each field of auditing have data duplication in the corresponding regional data centers.when the data load transaction or other transactions occur,it needs to ensure the consistency of the audit data between the main server and the replica servers;the audit result data is also stored in the main and replica servers,when the audit result data synchronizationtransaction occurs,it also needs to ensure the consistency of the audit result data;moreover,the system data of audit data center needs to be synchronized to the regional data centers by the regional information and authority information.At the same time,in the audit data center environment which has such a large amount of data,a variety of types of transactions are running,the audit data center is scheduling multiple processes and transactions on shared resource data access.In essence,this process involves multiple transactions simultaneously access the same data,which is implemented by blocking mechanism.This thesis has designed and implemented the data consistency model of audit data center,which is based on the characteristics of the three types of data center and the demand for data consistency,and three different consistency management strategies are used to maintain the data.At the same time,this thesis builds the data lock management middleware of the audit data center above the DBMS,and drives the data lock and unlock on database level through the middleware.This thesis shows that,through the audit data center consistency management model,the audit data and audit result data of audit data center in the main server and replica servers is in an eventual consistency condition,and the system data in the entire data center is in a real-time consistency condition.The data lock manager audit of audit data center can correctly implement the multi-granularity and multi-level data locking mode.