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

Data query method and device and storage medium

A data query device and data query technology, applied in database indexing, electronic digital data processing, structured data retrieval, etc., can solve the problems of slow query speed and low cache query hit rate

Active Publication Date: 2021-02-23
CHINA MOBILE SUZHOU SOFTWARE TECH CO LTD +1
View PDF2 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] In order to solve the above technical problems, the embodiment of the present invention expects to provide a data query method, device and storage medium, which can solve the problem of low cache query hit rate and slow query speed question

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 device and storage medium
  • Data query method and device and storage medium
  • Data query method and device and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0049] An embodiment of the present invention provides a data query method, such as figure 2 As shown, the method may include:

[0050] S101. When a data query operation is received, establish a first query model according to the data query operation.

[0051] A data query method provided by an embodiment of the present invention is applicable to a scenario where a data query device performs data query and data analysis according to a received query analysis operation.

[0052] In the embodiment of the present invention, the establishment of the first query model by the data query device according to the data query operation specifically includes: the data query device extracts the field to be queried, the measurement parameter and the filtering condition included in the data query operation from the received data query operation; and then , the data query device adds the field to be queried, the measurement parameter and the filter condition to the preset query model framew...

Embodiment 2

[0088] An embodiment of the present invention provides a data query method, such as image 3 As shown, the method may include:

[0089] S201. When the data query device receives a data query operation, it extracts fields to be queried, measurement parameters, and filtering conditions included in the data query operation from the data query operation.

[0090] In the embodiment of the present invention, the method for the data query device to receive a data query operation may include: the data query device may receive a query analysis request sent on a visual graphical interface, or a data query analysis command sent in a programming language; It can also receive data query and analysis requests sent by other functional modules. The specific ones can be selected according to the actual situation, and are not specifically limited in the embodiments of the present invention.

[0091] In the embodiment of the present invention, the data query device identifies the field that ne...

Embodiment 3

[0158] Based on the same inventive concept of Embodiment 1 and Embodiment 2, the embodiment of the present invention provides a data query device 1, corresponding to a data query method; Figure 4 Schematic diagram of the structure of a data query device provided by the embodiment of the present invention Figure 1 ,Such as Figure 4 As shown, the data query device 1 includes:

[0159] The building unit 10 is configured to, when receiving a data query operation, create a first query model according to the data query operation.

[0160] The query unit 11 is configured to search for a first preset query model including the first query model from the correspondence between preset query models and preset query results, and the first preset query model is the preset query model The correspondence between the model and the preset query result includes the preset query model of the first query model.

[0161] An extracting unit 12, configured to extract a first query result corres...

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

Embodiments of the invention disclose a data query method and device, and a storage medium, which can improve a cache query hit rate and a query speed, and the method can comprise the following steps:when a data query operation is received, establishing a first query model according to the data query operation; searching a first preset query model containing the first query model from a preset query model and preset query result corresponding relationship, the first preset query model being a preset query model containing the first query model in the preset query model and preset query resultcorresponding relationship; and extracting a first query result corresponding to the first query model from a first preset query result corresponding to the first preset query model, the first presetquery result being a query result corresponding to the first preset query model in a corresponding relationship between the preset query model and the preset query result.

Description

technical field [0001] The invention relates to the field of software engineering, in particular to a data query method, device and storage medium. Background technique [0002] At present, in the big data visual analysis system, the commonly used interactive analysis operation methods such as drilling and filtering are all based on Structured Query Language (SQL, Structured Query Language) statement query to obtain results and analyze them. Among them, after the visual analysis system parses the query analysis operation into SQL statements, it first checks whether the same SQL statement exists in the cache system of the visual analysis system. The statement is sent to the data warehouse or database for query and waits for the query result to be returned, and then the SQL statement and the key-value pair of the query result are stored in the cache system. [0003] In practical applications, the cache usually stores SQL statements used by historical queries and their corresp...

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): G06F16/22G06F16/242G06F16/2453G06F16/248
CPCG06F16/2433G06F16/24539G06F16/2228G06F16/248
Inventor 吴迎俊朱明明
Owner CHINA MOBILE SUZHOU SOFTWARE 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