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

Establishment method and establishment system of association query system

A technology of related query and method establishment, which is applied in the direction of instruments, database indexing, calculation, etc., can solve the problems of low query efficiency and slow query speed, and achieve the effect of improving query speed, reducing the number of records, and improving query efficiency

Active Publication Date: 2019-05-31
SHANGHAI CTRIP COMMERCE CO LTD
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The technical problem to be solved by the present invention is to overcome the shortcomings of the order data query method in the prior art that the query speed is very slow and the query efficiency is very low for large-scale data, and provide a method and system for establishing an associated query system

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
  • Establishment method and establishment system of association query system
  • Establishment method and establishment system of association query system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0036] The present invention is further illustrated below by means of examples, but the present invention is not limited to the scope of the examples.

[0037] Such as figure 1 As shown, the establishment system of the associated query system of the present invention includes an acquisition module 1, a first building module 2, a second building module 3, a first data writing module 4, a data extraction module 5, a third building module 6, a fourth A building module 7 , a second data writing module 8 and a checking module 9 .

[0038] Wherein, the associated query system includes an order data storage table and a dimension field associated data storage table, both of which are hbase tables; the acquisition module 1 is used to obtain user order data, specifically, it can receive user order data passed in from outside, and send the user The order data is formatted in json format;

[0039] The check module 9 will check whether the order data is complete, if so, then call the fir...

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 discloses a building method and system of a relation query system. The building method comprises the steps that 1, user order data is obtained; 2, order numbers and order data prefixes are constructed as keys for recording order data storage lists; 3, order data field names are constructed as column names recorded in the S2, and values corresponding to the fields are used as column values; 4, the data constructed in the S2 and the S3 are written into the order data storage lists; 5, names and values of dimension fields for performing dimension query are extracted from the order data; 6, the dimension fields and values and order data suffixes thereof are constructed as keys for recording dimension field related data storage lists; 7, the keys of the order data storage lists in the S2 are constructed as column names recorded in the S6, and system timestamps are used as column values; 8, the data constructed in the S6 and the S7 are written into the dimension field related data storage lists. Data query is performed on the basis of dimension fields, and the query speed and efficiency are improved.

Description

technical field [0001] The invention relates to a method and system for establishing an association query system. Background technique [0002] The existing way of using SQL (Structured Query Language) to store user data is to store the user's data in the database as a record according to an order. When it is necessary to query the relationship, it needs to be retrieved from the database according to the given value Get this record, and then query the order details from the order table according to the queried order number. The existing approach is very slow for large-scale data queries, and in the best case each query takes at least 30 seconds, which is undoubtedly inefficient and unacceptable for users. Contents of the invention [0003] The technical problem to be solved by the present invention is to overcome the defects of slow query speed and low query efficiency in the order data query mode in the prior art for large-scale data, and provide a method and system for ...

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 Patents(China)
IPC IPC(8): G06F16/22G06F16/2455
CPCG06F16/2228G06F16/24553
Inventor 谢柳平郑佰云
Owner SHANGHAI CTRIP COMMERCE CO 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