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

Database SQL index dynamic optimization method

A dynamic optimization and database technology, which is applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve the problems that the time of fault processing depends on engineers, the support of database platform is not very friendly, and the scope of fault influence is expanded, etc., to achieve improvement SQL execution efficiency, reducing the probability of failure and the impact of failure, reducing human dependence and the effect of misoperation

Inactive Publication Date: 2018-06-15
上海新炬网络技术有限公司
View PDF10 Cites 9 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0012] 1), a wide variety, poor security
[0013] At present, various IndexAnalyze systems on the Internet are similar, but there are still many problems in the rigor, timeliness, and accuracy of the monitoring indicators of various manufacturers, and the support for various database platforms is not very friendly.
[0014] 2), only play a monitoring role
We are very cautious about changing the database. Once human error occurs, the scope of failure will be further expanded.
[0018] The above technologies all have the same problem due to their implementation mechanism. When a problem occurs, manual intervention is required to analyze and operate. This series of operations requires a lot of time and requires experienced engineers to complete the process manually. To a certain extent, the time for troubleshooting depends greatly on the engineer's personal ability and familiarity with the environment

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
  • Database SQL index dynamic optimization method
  • Database SQL index dynamic optimization method
  • Database SQL index dynamic optimization method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0035] The present invention will be further described below in conjunction with the accompanying drawings and embodiments.

[0036] figure 2 It is a flow chart of dynamic optimization of database SQL index in the present invention.

[0037] See figure 2 , the database SQL index dynamic optimization method provided by the present invention comprises the following steps:

[0038] Step S1: By configuring scheduled tasks, regularly collect SQL resource usage and establish a resource baseline;

[0039] Step S2: Analyzing the execution plan and the indexing condition of the predicate condition for the collected SQL resource usage;

[0040] Step S3: Track the analyzed data, and if the optimization threshold is reached, implement corresponding index optimization.

[0041] image 3 It is a schematic diagram of the database SQL index dynamic optimization system architecture of the present invention.

[0042] Please continue to see image 3 , the present invention is mainly div...

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 database SQL index dynamic optimization method. The method comprises the steps that S1, by configuring timed tasks, SQL resource usage is collected at fixed time, and a resource base line is established; S2, for collected SQL resource usage, an execution plan and indexes of predicate conditions are analyzed; and S3, analyzed data is tracked, and if an optimization threshold is reached, optimization of the corresponding indexes is performed. According to the database SQL index dynamic optimization method, comprehensive monitoring and analysis are performed on SQL usage, and analysis is performed according to the predicate conditions to realize optimization, so that SQL execution efficiency is greatly improved; an SQL performance problem is systematically intervenedand optimized at the initial stage, so that the fault occurrence probability and the fault influence are lowered; and all SQL predicate index analysis is automatically completed without the need forhuman intervention, so that human dependency and misoperation are lowered.

Description

technical field [0001] The invention relates to a database SQL processing method, in particular to a database SQL index dynamic optimization method. Background technique [0002] Information technology has become a crucial productivity in the telecommunications industry, and the quality of business systems directly affects the production of enterprises. At present, the database layer is the most critical link in the traditional enterprise architecture, and the efficient SQL execution efficiency in the database will greatly improve the throughput of the system. [0003] In the current environment, considering that unreasonable index design will generate additional index maintenance consumption caused by DML statements, only the index design of key fields is arranged before the business goes online. During the operation of the system, a large number of variant SQLs are often generated due to changes in business requirements. How to dynamically complete index optimization duri...

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): G06F17/30
CPCG06F16/2228G06F16/2246
Inventor 程永新孙玉颖胡杰
Owner 上海新炬网络技术有限公司
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