Query statement processing method and device

A query statement and processing method technology, applied in the database field, can solve the problems of slow query, long execution time, exhausted connections, etc., and achieve the effect of comprehensive data support

Inactive Publication Date: 2018-03-02
BEIJING XIAODU INFORMATION TECH CO LTD
View PDF6 Cites 6 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] Database technology has been widely used. In the face of large amounts of data, unreasonable SQL (Structured Query Language, Structured Query Language) statements will lead to long execution times and slow que

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
  • Query statement processing method and device
  • Query statement processing method and device
  • Query statement processing method and device

Examples

Experimental program
Comparison scheme
Effect test

Example Embodiment

[0051] In order to enable those skilled in the art to better understand the solutions of the present invention, the technical solutions in the embodiments of the present invention will be described clearly and completely in conjunction with the accompanying drawings in the embodiments of the present invention.

[0052] In some processes described in the specification and claims of the present invention and the above-mentioned drawings, multiple operations appearing in a specific order are included, but it should be clearly understood that these operations may not be performed in the order in which they appear in this document. Execution or parallel execution, the sequence numbers of operations such as 101, 102, etc., are only used to distinguish different operations, and the sequence numbers themselves do not represent any execution order. In addition, these processes may include more or fewer operations, and these operations may be executed sequentially or in parallel. It should...

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 provide a query statement processing method and device, and relates to the field of databases. The method comprises the following steps of: analyzing a query statement, anexecution consumed time of which does not exceed a set threshold value, so as to obtain an analysis result; judging whether the analysis result satisfies a risk judgement condition or not on the basis of the analysis result; and if the analysis result satisfies the risk judgement condition, determining the query statement as a risky query statement. The query statement processing method and device are beneficial for providing effective and comprehensive data support for database optimization.

Description

technical field [0001] The embodiments of the present invention relate to the field of databases, and in particular, to a query statement processing method and device. Background technique [0002] Database technology has been widely used. In the face of large amounts of data, unreasonable SQL (Structured Query Language, Structured Query Language) statements will lead to long execution times and slow queries. Slow queries will slow down the response of the entire database due to excessive consumption of CPU or I / O (input / output), and may also cause the number of connections to be exhausted in short connection scenarios. Mainstream databases such as MySql already support the slow query log function, which can detect all database operation records. When the execution time is greater than the set threshold, information records such as the executed SQL statement will be saved to the file. [0003] The purpose of analyzing slow query logs is to find out the SQL statements that ...

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): G06F17/30
CPCG06F16/217G06F16/245
Inventor 郭赫曦
Owner BEIJING XIAODU INFORMATION TECH CO LTD
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

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap