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

Data query method and system

A technology of data query and query, which is applied in the computer field, can solve the problems of long time consumption and instability of data query, and achieve the effect of high efficiency, good stability and reasonable utilization

Active Publication Date: 2019-07-16
BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD +1
View PDF11 Cites 9 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0007] In view of this, the embodiment of the present invention provides a data query method and system, according to the configuration information and offset value in the configuration file to obtain the thread for data query and the primary key interval of each thread query, divided into data segments, multi-threaded Query data, which solves the problem of long time-consuming and unstable data query in the existing technology

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
  • Data query method and system
  • Data query method and system
  • Data query method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0032] Exemplary embodiments of the present invention are described below in conjunction with the accompanying drawings, which include various details of the embodiments of the present invention to facilitate understanding, and they should be regarded as exemplary only. Accordingly, those of ordinary skill in the art will recognize that various changes and modifications of the embodiments described herein can be made without departing from the scope and spirit of the invention. Also, descriptions of well-known functions and constructions are omitted in the following description for clarity and conciseness.

[0033] figure 1 is a schematic diagram of main steps of a data query method according to an embodiment of the present invention. like figure 1 As shown, the data query method in the embodiment of the present invention mainly includes the following steps:

[0034] Step S101: Query the configuration file to obtain the configuration information and the offset value of the ...

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 data query method and system, and relates to the technical field of computers. A specific embodiment of the method comprises the following steps: inquiring a configuration file to obtain configuration information and an offset value of a main key of a to-be-inquired target file; obtaining threads required for data query according to the configuration information and the offset value so as to determine a primary key interval queried by each thread; and enabling each thread to carry out data query on the to-be-queried target file according to the corresponding main keyinterval and a preset query condition. According to the embodiment, the threads for data query and the main key interval, the sub-data segments and the multi-thread query data of each thread query areobtained according to the configuration information and the offset value in the configuration file, and the problems that in the prior art, the time consumption for data query is long, and data queryis unstable are solved.

Description

technical field [0001] The invention relates to the field of computers, in particular to a data query method and system. Background technique [0002] The single user data table of an e-commerce company is generally at the level of 100 million. Various daily marketing activities for users need to be carried out based on these user data tables, such as regularly sending coupons to users who have reached a certain level, and regularly sending out coupons to users who have reached a certain level. Send messages to users with certain conditions, recalculate the growth level of all users on a regular basis, etc. How to query the required data efficiently, quickly and controllably from the billion-level user data table has become a very important indicator for evaluating the data query system. [0003] In the prior art, when querying data (such as querying users who meet the conditions for issuing vouchers from the user data table), the query is generally performed in the form of...

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/2453G06F16/2455
CPCG06F16/24549G06F16/24553
Inventor 韩显强
Owner BEIJING JINGDONG SHANGKE INFORMATION TECH 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

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