Order management method and device, order query method and device, equipment and medium

An order management and order technology, applied in the computer field, can solve the problems of data length, large index length, efficient processing of unfavorable order data, long query execution time, etc.

Inactive Publication Date: 2019-08-27
广州精选速购网络科技有限公司
View PDF6 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] Most of the existing platforms use a single data table for order management, the data length and index length are huge (a dozen GB), and the query execution time is long, which is not conducive to the efficient processing of order data

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
  • Order management method and device, order query method and device, equipment and medium
  • Order management method and device, order query method and device, equipment and medium
  • Order management method and device, order query method and device, equipment and medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0039] Embodiments of the technical solutions of the present invention will be described in detail below in conjunction with the accompanying drawings. The following examples are only used to illustrate the technical solution of the present invention more clearly, so they are only examples, and should not be used to limit the protection scope of the present invention.

[0040] It should be noted that, unless otherwise specified, the technical terms or scientific terms used in this application shall have the usual meanings understood by those skilled in the art to which the present invention belongs.

[0041] The invention provides an order management and query method, device, equipment and medium. Embodiments of the present invention will be described below in conjunction with the accompanying drawings.

[0042] Please refer to figure 1 , figure 1 It is a flow chart of an order management method provided in a specific embodiment of the present invention. The order managemen...

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 an order management method and device, an order query method and device, equipment and a medium. The method comprises the steps of establishing a plurality of sub-tables, numbering each sub-table wherein each sub-table corresponds to one sub-table number; acquiring a user number; determining a sub-table number corresponding to the user number; and storing all the order datacorresponding to the user numbers in the sub-tables corresponding to the sub-table numbers. By establishing a plurality of sub-tables, a single table with a large original data size can be convertedinto a plurality of sub-tables, so that the data length and the index length can be greatly reduced, the query speed can be greatly increased, the database performance can be improved, the order search efficiency and the system stability can be improved, and the order management efficiency can be improved.

Description

technical field [0001] The present invention relates to the field of computer technology, in particular to an order management and query method, device, equipment and medium. Background technique [0002] In recent years, the e-commerce industry has developed rapidly, online shopping has become a common phenomenon, and the amount of order data has increased dramatically. How to manage order data on e-commerce platforms has become the primary issue. [0003] Most of the existing platforms use a single data table for order management. The data length and index length are huge (a dozen GB), and the query execution time is long, which is not conducive to the efficient processing of order data. Contents of the invention [0004] Aiming at the defects in the prior art, the present invention provides an order management and query method, device, equipment and medium, which can improve database performance, order search efficiency and system stability, and order management efficie...

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): G06Q10/10G06Q30/06G06F16/31G06F16/33
CPCG06Q10/10G06Q30/0635G06F16/328G06F16/3331
Inventor 孙高金李思林林志刚范世军
Owner 广州精选速购网络科技有限公司
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