Transaction data updating method and device

Abstract

The invention provides a transaction data updating method and device, and the method comprises the steps: querying a first transaction information table after a transaction happens online, judging that the transaction is an effective transaction, and writing the transaction flow information of the transaction into a transaction flow information table when the transaction is the effective transaction; scanning a plurality of pieces of transaction flow information of which the final modification state is a first state in the transaction flow information table every a first set duration, temporarily storing the transaction flow information in a first list, and arranging the transaction flow information according to a preset sorting mode; according to the sequence of the transaction flow information in the first list, calling the amount updating transaction, updating the amount information table one by one, and after each piece of transaction flow information is successfully updated, changing the final modification state of the piece of transaction flow information in the transaction flow information table into a second state, and writing the serial number of the transaction flow information into the last updated serial number in the amount information table. According to the invention, the problem of updating failure caused by optimistic locks in transaction data updating affairscan be solved.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to a method and device for updating transaction data. Background technique [0002] In a transaction that includes record flow and amount update, when the amount is updated, a large number of update failures often occur due to optimistic locks. This is reflected in the fact that to ensure consistency, the flow records and amount updates are synchronized in one transaction. When the amount is updated, an optimistic lock (generally using the version number) will be used instead of a pessimistic lock (directly lock the database) to resolve high concurrency conflicts. But this only applies to the case where the database "write" operation is relatively small. Once the database is accessed frequently, optimistic locking will cause resource conflicts under multi-threading, making the database connection pool unable to be released, and only one of the multiple updates is allowed to...

AI Technical Summary

Problems solved by technology

[0004] The embodiment of the present invention proposes a transaction data update method to solve the problem of update failure due to optimistic locking in the transaction data update transaction. The method includes:

Images