Shared data updating device and shared data updating method

Abstract

The invention provides a shared data updating device. The device comprises a storage unit, a discrepant data computing unit, a data persistence unit and a data verification unit, wherein the storage unit is used for saving a basic data base table and a cache data base table; the basic data base table is used for saving summarized data of shared data; the cache data base table is used for saving discrepant data of the shared data; the discrepant data calculating unit is used for computing discrepant data of the shared data caused by updating operation; the data persistence unit adopts isolated transaction to insert the discrepant data into the cache data base table; and the data verification unit is used for inquiring the discrepant data of the basic data base table and the cache data base table and determining whether to submit isolated transaction according to a verification result. The invention further provides a shared data updating method. According to the technical scheme, locking process can be eliminated during data updating and verification processes on the basis that the data updating correctness is guaranteed, so that the concurrency supported by a system is improved.

Description

technical field [0001] The present invention relates to the field of computer technology, in particular to a shared data update device and a shared data update method. Background technique [0002] In a business system, many shared data face high concurrent user access, and shared data is often the core business model of the system. Therefore, the correctness of shared data must be guaranteed. If you want to ensure the correctness of data, it will inevitably involve competition and waiting when transactions update shared data, such as figure 1 As shown, user 1 is updating the data table records to increase the number by 20, and at the same time, user 2 needs to reduce the number of the same record by 40 through operations, and there may still be other users who are updating the same record at this time. How to support users' concurrent access and maximize the concurrency supported by the system is a problem that must be solved. [0003] In order to ensure the accuracy of b...

AI Technical Summary

Problems solved by technology

It can be clearly seen that an update transaction caused by a user operation may cause two lock waits

In the case of high concurrency, the system's ability to support concurrency is reduced

Images