Cache-based reduction method, device and system

Abstract

The invention aims to provide a cache-based inventory reduction method, device and system, and the method comprises the steps: carrying out the disassembly of original inventory data based on an inventory reduction request, and obtaining a plurality of pieces of inventory with a unique code; performing first cache verification on the plurality of stocks with the unique codes through distributed cache, and performing second cache verification based on a verification result to obtain identification information of stock rows; operating a database based on the identification information of the inventory line, and sending a current inventory change message; and confirming the inventory in the database and performing corresponding cache processing by monitoring the current inventory change message. Therefore, the original inventory is disassembled, the minimum granularity of the row lock is ensured, the impact of directly operating the database is avoided through the cache middleware, the inventory database is verified and the cache is updated twice through the asynchronous refreshing mode of monitoring the inventory change message, and the final consistency of the data is ensured.

Description

technical field [0001] The present application relates to the field of computers, in particular to a method, device and system for inventory reduction based on cache. Background technique [0002] Operations such as management, reduction, and addition of commodity inventory data are entirely based on the database. When a user requests a deduction, it is directly updated and stored for deduction operations, and the commodity data is persisted in the database. Database-based operations are accurate and reliable Yes, but the inventory reduction action directly operates the database. Since the performance of the database itself is limited, in the case of high concurrent requests, the reduction requests will backlog, and the request may fail, and the database request connection cannot be obtained, or the database may not be able to provide external services . will hang up. If the method of sub-database and sub-table is adopted, the performance requirements cannot be met fundame...

AI Technical Summary

Problems solved by technology

[0003] One purpose of the present application is to provide a cache-based inventory reduction method, device, and system to solve the large-area waiting or even paralysis and inventory cache data caused by direct operation of the database in the context of high concurrent requests in the prior art Problems that cannot be updated in time and data is inconsistent

Images