Fragment-based inventory management method and device

Abstract

The invention provides a fragment-based inventory management method and device. The fragment-based inventory management method comprises the steps: obtaining an inventory deduction request for deduction of the inventory of a hot commodity, and storing the inventory of the hot commodity in a plurality of fragments; judging whether the total inventory quantity of the hot commodities in the fragmentsis greater than the inventory deduction quantity according to the inventory deduction quantity of the hot commodities carried in the inventory deduction request; if so, judging whether to-be-deductedfragments with the sub-inventory number of the hot commodities larger than or equal to the inventory deduction number exist; if not, determining a deduction sequence for performing inventory deduction on the fragments according to the fragment types of the fragments and the sub-inventory quantity of the fragments; and according to the inventory deduction number, performing inventory deduction onthe fragments according to the deduction sequence. According to the fragment-based inventory management method, the inventory of the hot commodities is stored in the multiple fragments, and the fragment deduction sequence is determined, and inventory deduction is conducted on the fragments, and the deduction efficiency of the inventory of the hot commodities is improved.

Description

technical field [0001] The present application relates to the technical field of data processing, in particular to a shard-based inventory management method. The present application also relates to a shard-based inventory management device, a computing device, and a computer-readable storage medium. Background technique [0002] With the continuous development of Internet business, the number of people who choose to shop online continues to increase. In this case, for best-selling products, the number of orders placed during peak hours will be very large, which also means that the inventory operations of best-selling products in the database are very frequent. Very test the performance of the database. [0003] Currently, for e-commerce platforms supported by a single database, there are many ways to improve database performance, such as: increasing hardware performance, indexing tables that require high-frequency queries, optimizing Structured Query Language (SQL, Structur...

AI Technical Summary

Problems solved by technology

[0004] However, these methods are not pertinent enough to improve the efficiency of inventory management of best-selling products, which is likely to cause waste of computing resources, and with the continuous improvement of business, inventory updates will still be the bottleneck of database performance, affecting users placing orders on the website s efficiency

Images