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

Determination method for abnormal SQL (structured query language) statement and server

A query language and abnormal structure technology, which is applied in instruments, special data processing applications, electrical digital data processing, etc., can solve the problems of unable to predict and analyze abnormal SQL statements, large system resources, and affecting user experience, etc.

Active Publication Date: 2015-07-15
CHINA MOBILE GRP BEIJING
View PDF3 Cites 16 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] The above-mentioned methods for determining abnormal SQL statements can only be determined when the abnormal SQL statements have affected system performance and user experience, and can only be determined by professional analysis. It is impossible to perform predictive analysis when the abnormal SQL statements have just appeared and have not affected system performance and user experience.
Therefore, there is a need for a method that can determine abnormal SQL statements in advance, so as to prevent abnormal SQL statements from consuming a large amount of system resources and affecting user experience

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
  • Determination method for abnormal SQL (structured query language) statement and server
  • Determination method for abnormal SQL (structured query language) statement and server
  • Determination method for abnormal SQL (structured query language) statement and server

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0091] In order to determine abnormal SQL statements in advance, thereby preventing abnormal SQL statements from consuming a large amount of system resources and affecting user experience, an embodiment of the present invention provides a method for determining abnormal SQL statements. The process of the method is as follows: figure 1 As shown, the execution steps are as follows:

[0092] S10: Obtain the total execution time and total execution times of each first business SQL statement in the current collection cycle, sort the obtained total execution time in descending order, and the total execution before the first set number The first business SQL statement corresponding to the time is used as the second business SQL statement.

[0093]There are many main technical indicators that can reflect the execution efficiency of the first business SQL statement: total execution times, total execution time, average execution time, processing time, logical reads, physical reads, sort...

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 determination method for an abnormal SQL (structured query language) statement and a server. The determination method comprises the following steps: obtaining total execution time and total execution frequency of each first service SQL statement in a current collecting period, taking the first service SQL statement corresponding to the total execution time before a first set number as a second service SQL statement; obtaining the total execution time and the total execution frequency of each second service SQL statement in a selected collecting period; calculating the rate of rise of the average execution time corresponding to the second service SQL statement; judging whether the rate of rise of the average execution time of each second service SQL statement is greater than a first set threshold value or not respectively, judging that the second service SQL statement with the rate of rise of the average execution time greater than the first set threshold value is the abnormal SQL statement. The normal operation of the system and good user experience are ensured by the technical scheme.

Description

technical field [0001] The invention relates to the field of communication technology, in particular to a method for determining an abnormal Structured Query Language (Structured Query Language, SQL) statement and a server. Background technique [0002] An SQL statement is a syntax for defining and operating data in a database. An abnormal SQL statement (also called a slow query SQL statement or a large SQL statement) refers to a business SQL statement that executes slowly and has a greater impact on database performance. statement. When the user uses the client to perform operations such as phone charge balance query, package usage query, etc., the client will send a query request to the server, and the server will use business SQL statements to query in the database according to the received query request. If an abnormal SQL statement occurs , it will occupy a large amount of system resources of the server, and the query speed is also very slow. On the client side, it is ...

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
Inventor 王江康姝婷马洪利陈海涛杨晶孙晓王辉王岩丁健杨海威姜宏岩
Owner CHINA MOBILE GRP BEIJING
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