Storage and transportation database cache management method and device

A cache management and database technology, applied in the database field, can solve the problems of low query efficiency, slow storage and transportation database, etc., and achieve the effect of improving retrieval efficiency, fast acquisition, and query efficiency.

Active Publication Date: 2020-11-20
SICHUAN HONGTU LOGISTICS +1
View PDF11 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The purpose of this application is to provide a storage and transportation database cache management method and device to effectively improve the technical defects of slow access to the storage and transportation database and low query efficiency

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
  • Storage and transportation database cache management method and device
  • Storage and transportation database cache management method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0020] The technical solutions in the embodiments of the present application will be described below in conjunction with the drawings in the embodiments of the present application.

[0021] It should be noted that similar reference numerals and letters indicate similar items in the following drawings. Therefore, once a certain item is defined in one drawing, it does not need to be further defined and explained in the subsequent drawings. At the same time, in the description of this application, the terms "first", "second", etc. are only used to distinguish the description, and cannot be understood as indicating or implying relative importance.

[0022] See figure 1 The embodiment of the present application provides a storage and transportation database cache management method, which is applied to the storage and transportation of products in the warehouse, and the method includes: step S11, step S12, and step S13.

[0023] Step S11: Classify and code the shelf data to obtain the corr...

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 invention provides a storage and transportation database cache management method and device. The method comprises the steps that shelf data is classified and encoded to obtain a corresponding first encoding area, warehouse data is classified and encoded to obtain a corresponding second encoding area, product data is classified and encoded to obtain a corresponding third encoding area, and transportation data is classified and encoded to obtain a corresponding fourth encoding area; according to the first coding region, the second coding region, the third coding region and the fourth codingregion, a plurality of cache regions for data table partitions are established in a storage and transportation database, and codes corresponding to the shelf data, codes corresponding to the warehousedata, codes corresponding to the product data and codes corresponding to the transportation data are cached; when a data query request of a client is received, query is carried out in one of the cache regions according to the data type in the data query request. The query efficiency is improved through the method.

Description

Technical field [0001] This application relates to the field of database technology, and in particular to a method and device for managing storage and transportation database cache. Background technique [0002] Warehousing plays a vital role in the entire supply chain of an enterprise. If the correct purchase and inventory control and delivery cannot be guaranteed, management costs will increase, service quality will be difficult to guarantee, and the competitiveness of the enterprise will be affected. Traditional simple and static warehouse management can no longer guarantee the efficient use of various resources of the enterprise. Today's warehouse operations and inventory control operations have become very complex and diversified. Relying only on manual memory and manual entry is not only time-consuming and labor-intensive, but also prone to errors, which brings huge losses to the enterprise. [0003] At present, it is more and more common to use storage and transportation da...

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
Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/22G06F16/2455G06F16/25G06Q10/08
CPCG06F16/2282G06F16/24552G06F16/252G06Q10/087
Inventor 施甘图陈旭庭治宏杨小康
Owner SICHUAN HONGTU LOGISTICS
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products