Database optimization method, system and equipment based on vulnerability repair, and medium

A technology of vulnerability repairing and optimization methods, applied in the computer field, can solve the problems of increasing the probability of production failures and reducing the available time of the system, so as to reduce production failures, avoid the reduction of available time, and avoid the increase in the probability of online generation of failures Effect

Pending Publication Date: 2019-05-14
ONE CONNECT SMART TECH CO LTD SHENZHEN
View PDF0 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The purpose of this disclosure is to provide a database optimization method, system, computer equipment, and computer-readable storage medium based on bug fixes, so as to at least solve the problems in the prior art that the available time of the system is reduced due to the lack of optimization of database statements and the online production Defects that increase the chance of failure

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 optimization method, system and equipment based on vulnerability repair, and medium
  • Database optimization method, system and equipment based on vulnerability repair, and medium
  • Database optimization method, system and equipment based on vulnerability repair, and medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0028] In order to make the purpose, technical solutions and advantages of the present disclosure clearer, the present disclosure will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the present disclosure, not to limit the present disclosure. Based on the embodiments in the present disclosure, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present disclosure.

[0029]Considering the defects in the prior art that the available time of the system is reduced and the probability of online production failure is increased due to the failure to optimize the database statement. The vulnerability repair-based database optimization method provided by this disclosure can obtain the first database statement of the database after receiving the audit sig...

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 provides a database optimization method based on vulnerability repair. The method is characterized by comprising: obtaining a first database statement in response to an online post-auditing signal of a database; obtaining an optimization model, and the optimization model is used for outputting corresponding optimization suggestions for database statements input into the optimizationmodel; inputting the first database statement into an optimization model to obtain an optimization suggestion which is output by the optimization model and aims at the first database statement; and generating an optimized database statement and / or an optimized suggestion report according to the optimized suggestion for the first database statement. The invention further provides a database optimization system based on vulnerability restoration, computer equipment and a computer readable storage medium.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a database optimization method, system, computer equipment and computer-readable storage medium based on vulnerability repair. Background technique [0002] In the initial stage of the project's online use, due to the relatively small amount of business data, the execution efficiency of some database statements has little impact on the program's operating efficiency, and the development and operation and maintenance personnel cannot judge how efficient the database statement is for the program's operation. Therefore, it is rarely optimized specifically for database statements. [0003] However, with the accumulation of time and the increase in the amount of business data, the impact of the execution efficiency of database statements on program operation efficiency gradually increases, the available time of the system gradually decreases, and the probability of online production...

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): G06F16/21
Inventor 宋龙辉
Owner ONE CONNECT SMART TECH CO LTD SHENZHEN
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