Changing process method based on database logical lock

Abstract

The invention provides a change treatment method on the basis of a data base logical lock, which comprises: inquiring a data base to obtain corresponding record data and a logical lock serial number when a transaction request need updating data, checking, judging and calculating transaction request data and the record data which is obtained through inquiring the data base, starting the data updating processing when the transaction conditions are satisfied, using an exclusive lock to lock corresponding data base resources, obtaining the logical lock serial number and the record data, comparingwhether the logical lock serial number is corresponding with the logical lock serial number which is obtained through inquiring the data base, updating the record data according to a processing resultof a transaction logical processing unit and adding one to the logical lock serial number if the logical lock serial number is corresponding with the logical lock serial number which is obtained through inquiring the data base, thereby, the data change processing succeeds, and otherwise the data change processing fails. The method of the invention which centralizes the updating processing with the lock in the last through modifying the applicable process effectively solves the problems that system resources are greatly occupied and the efficiency is lower when a large amount of transactions occur.

Description

technical field [0001] The invention relates to a computer data processing method, in particular to a change processing method for online transaction processing based on database logic locks. Background technique [0002] In the process of computer data processing, it is often necessary to query and update data, especially in business data processing systems with large data volumes and large business volumes, such as bank computer systems. When a large number of online transactions are concurrent, due to the information stored in the database It is extremely huge and requires very high efficiency in database access processing. [0003] At present, most of the core business systems of banks and other financial institutions use special database software systems. When accessing databases in online transactions, the general method used is: when the online needs to update data, first use an exclusive lock to lock the data resources (such as table lock or row lock), before the en...

AI Technical Summary

Problems solved by technology

Although the above method appropriately reduces the processing time of exclusive locking, there is still room for improvement in terms of database access efficiency and computer real-time processing speed

Images