Method and device for account balance update

Abstract

The invention discloses a method and device for account balance update. The method includes that every transaction record corresponding to a target account in the set time length is determined; if the sum of the transaction amount sum of the determined transaction records and the balance of a target account is less than the threshold, some of the transaction records are deleted from the determined transaction records to make sure that the sum of the transaction amount sum of the transaction records after the deletion and the balance of the target account is not less than the threshold. According to the invention, every transaction record of the target account in the set time length is determined at first, compared with the prior art that the balance of the target account is updated in real time, the method provided prevents the waiting caused by lock contention and improves the system response speed; and furthermore, some of the transaction records are deleted from the determined transaction records to make sure that the sum of the transaction amount sum of the transaction records after the deletion and the balance of the target account is not less than the threshold, so that the breakdown probability of the account balance is small.

Description

technical field [0001] The invention relates to the field of data processing, in particular to a method and device for updating account balance. Background technique [0002] Bank accounting systems and payment and settlement systems often face hot account issues. According to business characteristics, some accounts in these systems need to interact frequently with other accounts, and account balances need to be updated frequently, thus becoming hot accounts. [0003] Usually, in accounting processing, each account balance update needs to lock the relevant account, so as to avoid data inconsistency caused by other operations on the account being processed again. However, as the business volume continues to increase, hot accounts Multiple concurrent operations will be generated in an instant, and the application frequently initiates update requests to the same account in the database. Since only one thread can hold the resource lock at that time, other threads must wait for ...

AI Technical Summary

Problems solved by technology

[0004] However, in the prior art, in the case of batch updating of hot account balances, since the judgment and update of whether the balance is sufficient or not is not performed in real time, it is equivalent to recording the subsidiary account first, and then periodically summarizing and updating the balance, so it is possible to When the balance was updated, it was discovered that the account balance was insufficient, and there was a risk of the account balance being broken down

Images