Automatic optimization method and device for SQL (Structured Query Language), computer equipment and storage medium

An automatic optimization and automatic addition technology, applied in the field of database scripts, which can solve the problems of low-quality script modification and optimization, inefficiency in modification and optimization, and inability to locate scripts in time.

Inactive Publication Date: 2018-08-10
PING AN TECH (SHENZHEN) CO LTD
View PDF5 Cites 7 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] This application provides a SQL automatic optimization method, device, computer equipment and storage medium, aiming to solve the problem of being unable to locate the script that specifically causes the problem in time when many scripts in the prior art are executed, resulting in low-quality scripts. Inefficiencies of modification and optimization

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
  • Automatic optimization method and device for SQL (Structured Query Language), computer equipment and storage medium
  • Automatic optimization method and device for SQL (Structured Query Language), computer equipment and storage medium
  • Automatic optimization method and device for SQL (Structured Query Language), computer equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0027] The following will clearly and completely describe the technical solutions in the embodiments of the present application with reference to the drawings in the embodiments of the present application. Obviously, the described embodiments are part of the embodiments of the present application, not all of them. Based on the embodiments in this application, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the scope of protection of this application.

[0028] It should be understood that when used in this specification and the appended claims, the terms "comprising" and "comprises" indicate the presence of described features, integers, steps, operations, elements and / or components, but do not exclude one or Presence or addition of multiple other features, integers, steps, operations, elements, components and / or collections thereof.

[0029] It should also be understood that the terminology used in the specificati...

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 an automatic optimization method and device for a SQL (Structured Query Language), computer equipment and a storage medium. The method comprises the following steps: when a current script is under an execution state, according to a system performance index monitoring item set in the current script, collecting a current system performance index parameter; when the current system performance index parameter exceeds a preset index early warning value, recording the current script in an appointed path; obtaining the execution plan of the current script; if the execution plan of the current script lacks an index, automatically adding the index to the current script; if the index of the current script fails, through a forced index, carrying out script repairing to obtaina repaired script. By use of the method, system performance can be monitored in time, in addition, the SQL script which can greatly influence the system performance can be automatically optimized, andperformance problems can be quickly found and solved.

Description

technical field [0001] The present application relates to the technical field of database scripts, in particular to an SQL automatic optimization method, device, computer equipment and storage medium. Background technique [0002] A script is an executable file written in a certain format using a specific descriptive language, also known as a macro or a batch file. In the process of software development, the quality of scripts written by developers varies from person to person, and low-quality scripts bring great performance risks to the system when they are executed. Generally, the system will troubleshoot and fix the problems caused by the script after the script execution has performance problems. Due to the large number of scripts, it is impossible to locate the script that specifically causes the problem in time, resulting in low efficiency in modifying and optimizing low-quality scripts. Contents of the invention [0003] This application provides a SQL automatic o...

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/30G06F8/30
CPCG06F8/31G06F16/21G06F9/45516G06F11/3409G06F2201/80G06F2201/865G06F2201/88
Inventor 徐钊
Owner PING AN TECH (SHENZHEN) 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