Resource processing method and device

Abstract

The invention discloses a resource processing method and device. The method comprises the following steps of: obtaining at least two operation requests, wherein the operation requests are used for carrying out inventory reduction operation on a same data stored in a database, the first data is a sum of same resources in the database, the inventory reduction is carrying out subtraction on the sum of the same resources in the database, the database comprises at least two data storage areas, and the data stored in each data storage area is greater than or equal to 1; respectively distributing a data storage area for the at least two operation requests; and carrying out inventory reduction operation on the data stored in the data storage area corresponding to each operation request. The method and device can prevent the inventory reduction operation from becoming a minus while improving the concurrent operation of a database system.

Description

technical field [0001] The present invention relates to the technical field of databases, in particular to a resource processing method and device. Background technique [0002] With the continuous development of Internet technology, while network operators provide users with convenient network services, they also need to maintain their own database systems and constantly update the data stored in the database, so that users can experience more convenient network services through the Internet . [0003] Usually, when the same resource is stored in the database, it is generally stored in the same data storage area in the database. Among them, the same resource can be defined by users according to different needs. To illustrate with an example, for a database storing train tickets, the same train number corresponding to the train tickets can be used as the same resource. For example, the train tickets of K23 and K24 can be used as two resources. The number of train tickets ...

AI Technical Summary

Problems solved by technology

Still taking the train ticket as an example to elaborate, multiple operation requests request the purchase of K23 tickets at the same time, which requires subtraction of the total number of K23 tickets stored in the database, but since multiple operation requests simultaneously request the The total number of K23 tickets is subtracted. Due to network congestion or other failures, the total number of K23 tickets is prone to negative numbers if the modification is not timely

[0005] In order to prevent errors in the same resource stored in the database during concurrent operations, one solution is to allow only one operation request to perform inventory reduction operations at the same time when performing inventory reduction operations on the same resources stored in the database. But this solution loses the meaning of concurrent database operations

At present, no effective solution has been proposed to prevent the inventory reduction operation from becoming negative while improving the concurrent operation of the database system.

Images