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

Structured query language performance optimization method and system

A technology of structured query and optimization method, applied in the field of database management, can solve other problems of the new version, slow running speed, poor performance, etc., to achieve the effect of improving customer satisfaction, reducing interruption time, and speeding up resolution time

Active Publication Date: 2016-10-05
HANDAN BRANCH OF CHINA MOBILE GRP HEBEI COMPANYLIMITED
View PDF4 Cites 9 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] First, the method of spotting problematic SQL with poor performance leaves room for improvement
In the prior art, the problem of poor performance is mainly found through the method that the personnel using the business system at the front desk report that the running speed is slow, or the indicators such as the central processing unit (CPU, Central Processing Unit) at the system level give an alarm.
The defect of this method is: since the problem SQL can only be found by using the method when the business peak, it is usually found that the problem SQL has been running for a period of time, so the opportunity to reduce the negative impact of the system by the performance of SQL is delayed
[0007] The above two technical solutions have the following defects: Technical solution 1 requires a long processing cycle, generally requires the second line to modify the program source code, then compile, and release the program to solve the problem, because the processing is urgent and lacks normal testing Processes, new versions often appear and cause other problems
Further, both technical solution 1 and technical solution 2 have the risk of affecting other related applications
[0008] Generally speaking, the existing technical solutions cannot provide an overall solution, but can only partially solve the problems that arise
Specifically, the implementation of many existing technical solutions requires the time to modify the code, making the cycle longer
At the same time, the existing technical solutions require specialized operation and maintenance personnel to regularly analyze the performance of problem SQL
In addition, the existing technical solutions not only lack the operation, maintenance and optimization of SQL operation performance that is known and controllable, but also have the problem of low efficiency

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
  • Structured query language performance optimization method and system
  • Structured query language performance optimization method and system
  • Structured query language performance optimization method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0057] figure 1 A schematic diagram of an implementation flow of the SQL performance optimization method provided in Embodiment 1 of the present invention, Figure 2 to Figure 4 for figure 1 A schematic diagram of the refinement process flow of steps 120 to 140 in the above. like figure 1 As shown, the method includes:

[0058] Step 110: preconfigure SQL parameters;

[0059] In this step, the SQL parameters include: SQL alarm parameters and SQL optimization suggestion parameters; the SQL parameters can be pre-configured by the parameter configuration unit of the parameter configuration module in the SQL performance optimization system.

[0060] The SQL alarm parameters are pre-configured in the SQL alarm parameter table (ALERT_PARAMETER) by the parameter configuration unit; the SQL alarm parameters mainly include: alarm start time, alarm end time, alarm time interval, alarm key indicator 1, alarm key Indicator 2, alarm key indicator 3, alarm SQL quantity limit, alarm keyw...

Embodiment 2

[0114] Figure 5 A schematic diagram of the process of the SQL performance optimization method provided in Embodiment 2 of the present invention, such as Figure 5 As shown, the SQL parameters are preconfigured, and the method further includes:

[0115] Step 211: Invoke SQL parameters.

[0116] Step 221: After querying the problem SQL according to the SQL alarm parameters, save the first daily alarm data to the alarm log table.

[0117]Step 231 : Scan the alarm log table to obtain the alarm log data and keep it to the optimization suggestion log table; scan the optimization suggestion log table to obtain the first optimization suggestion log data.

[0118] Step 232: Determine whether to provide optimization suggestions for the problem SQL.

[0119] Step 233 : When it is determined that the optimization suggestion for the problem SQL is performed, a tuning task is generated, and after the tuning task is executed and the SQL optimization execution plan is generated, the SQL o...

Embodiment 3

[0124] Figure 5 A schematic diagram of the process of the SQL performance optimization method provided in Embodiment 3 of the present invention, such as Figure 5 As shown, the SQL parameters are preconfigured, and the method further includes:

[0125] Step 211: Invoke SQL parameters.

[0126] Step 222: After querying the problem SQL by using other channels based on the SQL parameters, save the second daily alarm data to the alarm log table.

[0127] Step 231 : Scan the alarm log table to obtain the alarm log data and keep it to the optimization suggestion log table; scan the optimization suggestion log table to obtain the first optimization suggestion log data.

[0128] Step 232: Determine whether to provide optimization suggestions for the problem SQL.

[0129] Step 233 : When it is determined that the optimization suggestion for the problem SQL is performed, a tuning task is generated, and after the tuning task is executed and the SQL optimization execution plan is gene...

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 structured query language (SQL) performance optimization method. The method comprises the step of pre-configuring an SQL parameter. The method further comprises the steps of: calling the SQL parameter, inquiring a questioned SQL according to the SQL parameter, and warning the questioned SQL if the questioned SQL is inquired; providing an SQL optimization recommendation to the questioned SQL according to the warning; and residing the SQL optimization recommendation. The invention further discloses an SQL performance optimization system.

Description

technical field [0001] The invention relates to the field of database management, in particular to a structured query language (SQL, Structured Query Language) performance optimization method and system. Background technique [0002] In a database environment, especially relational databases, SQL statements are used. In the operation of the database system, poor SQL performance often occurs, resulting in the following problems: [0003] First of all, the method of finding the problem SQL with poor performance has yet to be improved. In the prior art, the problem SQL with poor performance is mainly found through the method that the staff using the business system in the foreground reflects the slow running speed, or the system-level central processing unit (CPU, Central Processing Unit) and other indicators give an alarm. The disadvantage of this method is that the problem SQL can be found only when the business peaks by using the method, so when the problem SQL is found, 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
IPC IPC(8): G06F17/30
Inventor 芦薇
Owner HANDAN BRANCH OF CHINA MOBILE GRP HEBEI COMPANYLIMITED
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