Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Method and device for updating stock record information in database

A technology for recording information and databases, applied in the field of databases, can solve problems such as limiting system processing efficiency, and achieve the effect of improving system response efficiency and ensuring consistency

Active Publication Date: 2015-06-10
ALIBABA GRP HLDG LTD
View PDF9 Cites 45 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

But in fact, the transaction volume generated per second on each SKU may be much greater than 5 transactions, especially when participating in a promotional event, or on special dates such as holidays, the transaction volume per second generated by a single SKU will be more , therefore, according to the update method in the prior art, the processing efficiency of the system will be limited

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method and device for updating stock record information in database
  • Method and device for updating stock record information in database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0027] The following will clearly and completely describe the technical solutions in the embodiments of the application with reference to the drawings in the embodiments of the application. Apparently, the described embodiments are only some of the embodiments of the application, not all of them. All other embodiments obtained by persons of ordinary skill in the art based on the embodiments in this application belong to the protection scope of this application.

[0028] First of all, it needs to be explained that the inventor of this application found that in the process of implementing this application, for the same commodity object, its total inventory is based on a certain relationship with each SKU inventory record, but the data generated in the application Update requests do not act directly on this total inventory record, but on the SKU inventory record associated with it. Because when the user selects a product object, the selection is based on a certain SKU, and only t...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The application discloses a method and device for updating stock record information in a database. The method comprises the following steps: determining an SKU (stock keeping unit) stock record to be changed after receiving a request from application for change of the stock record of a designated commodity target; modifying the SKU stock record to be changed, and writing the change information of the SKU stock record in a log file of the database; when preset conditions are met, reading the log file of the database to obtain the latest change records in the database concerning the SKU stock record, wherein the latest change records comprise the change records generated from the previous reading moment to the current reading moment; calculating the difference between the SKU stock record before the changes and the SKU stock record after the changes according to the latest change records; reading a total stock record of the designated commodity target in the database, and updating the value of the total stock record according to the difference. The application can guarantee the data consistency while improving the system response efficiency.

Description

technical field [0001] The present application relates to the field of database technology, in particular to a method and device for updating inventory record information in a database. Background technique [0002] In some database systems, there are often interrelated data. Generally, in order to ensure the correctness of various data, these data need to be updated synchronously. For example, in an e-commerce trading platform, for a specific product object, its SKU (minimum sales attribute) inventory and total inventory need to be maintained in the database. Assuming that the product object is a mobile phone, its SKU is divided into black and white, and the inventory quantity is 50 pieces each, then the data records reflected in the inventory management can be shown in Table 1: [0003] Table 1 [0004] commodity SKUs Inventory Remark a mobile phone N / A 100 Total inventory of goods a mobile phone black 50 SKU ...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F17/30
Inventor 许俊
Owner ALIBABA GRP HLDG LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com