SQL statement execution performance identification method and device, computer equipment and storage medium

An identification method and execution plan technology, applied in the field of data processing, can solve problems such as the inability to dynamically identify SQL statements, the risks and low efficiency of SQL statement execution, and achieve the effects of reducing the scope, improving the utilization rate, and improving the identification efficiency.

Pending Publication Date: 2021-04-06
PINGAN PUHUI ENTERPRISE MANAGEMENT CO LTD
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The main purpose of this application is to provide an identification method, device, computer equipment, and storage medium for SQL statement execution performance, aiming at solving the problem that the performance test of SQL statement cannot dynamically identify the risk and efficiency of SQL statement execution in the process of application version replacement. low problem

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
  • SQL statement execution performance identification method and device, computer equipment and storage medium
  • SQL statement execution performance identification method and device, computer equipment and storage medium
  • SQL statement execution performance identification method and device, computer equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0045] In order to make the purpose, technical solution and advantages of the present application clearer, the present application 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 application, and are not intended to limit the present application.

[0046] refer to figure 1 , the embodiment of the present application provides a SQL statement execution performance identification method, including at least steps S10-S40, the detailed description of each step of the SQL statement execution performance identification method is as follows.

[0047] S10. Extract the SQL statement of the first version of the application, add a first identifier to the SQL statement of the first version; extract the SQL statement of the current version of the application, and add a second identifier to the SQL statement of the current version;...

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 relates to the field of data processing, and discloses an SQL statement execution performance identification method and device, computer equipment and a storage medium, and the method comprises the steps: extracting an SQL statement of a first version of an application, and adding a first identifier to the SQL statement of the first version; extracting the SQL statement of the current version of the application, and adding a second identifier to the SQL statement of the current version; wherein the first version and the current version are two adjacent versions; determining a changed SQL statement of the current version of the application relative to the first version according to the first identifier and the second identifier; converting the changed SQL statement into an execution plan text, and obtaining execution information obtained after the execution plan text runs; and identifying an execution performance risk of the SQL statement of the current version according to the execution information. By comparing the SQL statement of the current version with the SQL statement of the previous version of the application, the changed SQL statement is quickly positioned, and the risk performance is identified, so that the risk analysis range is effectively reduced, and the risk control efficiency is improved.

Description

technical field [0001] The present application relates to the field of data processing, in particular to a method, device, computer equipment and storage medium for identifying execution performance of SQL statements. Background technique [0002] With the continuous replacement and iteration of the application version, the data used by the business continues to develop, and more and more data is stored in the database. When operating data in the database through the application, the greater the amount of data, the more difficult the operation is. Therefore, it is necessary to perform a performance test on the execution of the SQL statement to test whether the execution of the SQL statement can effectively control the risk. Due to the continuous replacement of the application version, the SQL statement in the application will occur. However, the current performance test of SQL statement execution cannot dynamically identify the risk of SQL statement execution, and with the i...

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/242G06F16/2453G06F16/2455G06F11/34
CPCG06F11/3409G06F16/2433G06F16/24542G06F16/2455
Inventor 刘建华
Owner PINGAN PUHUI ENTERPRISE MANAGEMENT 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