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

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 queries.
Slow queries will slow down the response of the entire database due to excessive consumption of CPU or I / O (input / output). In short connection scenarios, it may also cause exhaustion of the number of connections.

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

Embodiment Construction

[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 clearly and completely described below in conjunction with the 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, a plurality of operations appearing in a specific order are contained, but it should be clearly understood that these operations may not be performed in the order in which they appear herein Execution or parallel execution, the serial numbers of the operations, such as 101, 102, etc., are only used to distinguish different operations, and the serial numbers themselves do not represent any execution order. Additionally, these processes can include more or fewer operations, and these operations can be performed sequentially or in parallel. It should be n...

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 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