SYSTEM FOR EFFICIENT PROCESSING OF TRANSACTION REQUESTS RELATED TO AN ACCOUNT IN A DATABASE

摘要

One embodiment provides a system that facilitates efficient processing of requests related to a database. During operation, the system receives, by a server, a request to transfer an amount in to an account of a user, wherein the account is visible to the user and corresponds to a record in a database. The system selects one of a plurality of shadow accounts that correspond to the account, wherein a shadow account is not visible to the user. The system locks the selected shadow account, which prevents any changes to be made to the corresponding record in the database. The system modifies a balance of the selected shadow account by adding the amount to be transferred in to a current balance of the selected shadow account.

主权项

1. A computer system for efficiently processing requests related to a database, the system comprising:
a processor; and a memory coupled to the processor and storing instructions, which when executed by the processor cause the processor to perform a method, the method comprising:
receiving, by a server, a request to transfer an amount in to an account of a user, wherein the account is visible to the user and corresponds to a record in a database;selecting one of a plurality of shadow accounts that correspond to the account, wherein a shadow account is not visible to the user;locking the selected shadow account, which prevents any changes to be made to the corresponding record in the database; andmodifying a balance of the selected shadow account by adding the amount to be transferred in to a current balance of the selected shadow account.