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

Data query statement optimization method, device, terminal and storage medium

A technology for data query and query statement, which is applied in electronic digital data processing, special data processing applications, digital data information retrieval, etc. The effect of optimizing costs, improving efficiency, and reducing technical level requirements

Pending Publication Date: 2021-04-02
PINGAN PUHUI ENTERPRISE MANAGEMENT CO LTD
View PDF3 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The embodiment of the present application provides a data query statement optimization method, device, terminal and storage medium to solve the query statement optimization in the prior art that needs to be implemented by professional and technical personnel, which requires a high technical level of the implementers. Optimize the problem of low efficiency and high cost

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0027] In the following description, specific details such as specific system structures and technologies are presented for the purpose of illustration rather than limitation, so as to thoroughly understand the embodiments of the present application. It will be apparent, however, to one skilled in the art that the present application may be practiced in other embodiments without these specific details. In other instances, detailed descriptions of well-known systems, devices, circuits, and methods are omitted so as not to obscure the description of the present application with unnecessary detail.

[0028] It should be understood that when used in this specification and the appended claims, the term "comprising" indicates the presence of described features, integers, steps, operations, elements and / or components, but does not exclude one or more other features. , whole, step, operation, element, component and / or the presence or addition of a collection thereof.

[0029] It shou...

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 is applicable to the technical field of artificial intelligence, and provides a data query statement optimization method, a device, a terminal and a storage medium. The method comprisesthe steps of obtaining a first execution plan corresponding to the data query statement according to the data query statement; analyzing the first execution plan to obtain a target query statement with performance index data in a set index range in the data query statements; performing statement keyword recognition on the target query statement, and searching a corresponding model label from an optimization model library based on the recognized statement keyword; and based on the model label, obtaining a statement optimization suggestion indicated by the model label, and outputting the statement optimization suggestion. According to the scheme, the query optimization efficiency can be improved, and the optimization cost is reduced.

Description

technical field [0001] The present application belongs to the technical field of artificial intelligence, and in particular relates to a method, device, terminal and storage medium for optimizing data query sentences. Background technique [0002] For a long time, data retrieval query and its analysis have been an important part of the industry. On the basis of a certain data source, the premise of accurate data analysis is to carry out a good data retrieval and query process. A good data retrieval and query process can not only improve the accuracy of data retrieval and query, but also improve the query efficiency of finding valid data from massive data sources. Therefore, it is necessary to optimize the data query and optimize the performance of the query statement. [0003] However, in the prior art, query optimization needs to comprehensively consider data volume, execution performance of query statements, whether it is necessary to optimize query statements in order t...

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/242G06F16/2453G06F16/2455
CPCG06F16/242G06F16/2433G06F16/2453G06F16/2455
Inventor 齐秀
Owner PINGAN PUHUI ENTERPRISE MANAGEMENT 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