Supercharge Your Innovation With Domain-Expert AI Agents!

SQL performance analysis method, system and device based on tracking technology and medium

An analysis method and analysis system technology, applied in program control design, special data processing applications, instruments, etc., can solve the problems of high cost and low efficiency of manual detection database, and achieve low cost, high performance efficiency, and easy detection process. Effect

Pending Publication Date: 2020-12-11
SHANGHAI CTRIP COMMERCE CO LTD
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The technical problem to be solved by the present invention is to provide a SQL performance analysis method, system, device and medium based on tracking technology in order to overcome the defects of low efficiency and high cost of manual detection of database performance in the prior art

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 performance analysis method, system and device based on tracking technology and medium
  • SQL performance analysis method, system and device based on tracking technology and medium
  • SQL performance analysis method, system and device based on tracking technology and medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0049] The SQL performance analysis method based on the tracking technology of the present embodiment, such as figure 1 shown, including the following steps:

[0050] S101. Obtain the original SQL statement and corresponding parameters run by the application program through the tracking plug-in;

[0051] S102. Match and assemble the original SQL statement with parameters to obtain the SQL statement to be analyzed;

[0052] S103. Perform performance analysis on the SQL statement to be analyzed according to the execution plan to obtain a SQL performance analysis result.

[0053] The SQL performance analysis method based on the tracking technology in this embodiment uses the tracking plug-in to obtain the original SQL statement and parameters that the application runs, and performs performance analysis on the SQL statement through the execution plan after parameter matching and assembly, so that the performance of the SQL can be found before going online Risks, timely resolutio...

Embodiment 2

[0055] On the basis of Embodiment 1, this embodiment provides a SQL performance analysis method based on tracing technology, such as figure 2 as shown,

[0056] Specifically, step S101 specifically includes:

[0057] S1011, using a dynamic tracking tool Btrace (a tracking tool) to set a buried point in the application program to obtain the original SQL statement and corresponding parameters run by the application program.

[0058]The SQL performance analysis method based on the trace technology of this embodiment uses a safe JVM (Java Virtual Machine) dynamic trace tool Btrace to obtain the original SQL statement and corresponding parameters run by the application program. By executing the written SQLJava (an object-oriented programming language) script and compiling it into a bytecode file, using the Attach API (a Java application programming interface) to dynamically attach the agent package to the JVM to be monitored, through the agent The package parses SQL Java scripts...

Embodiment 3

[0084] The SQL performance analysis system based on the tracking technology of the present embodiment, such as Figure 5 As shown, including: data tracking module 1 and data analysis module 2;

[0085] The data tracking module 1 is communicatively connected with the data analysis module 2;

[0086] The data tracking module 1 is used to obtain the original SQL statement and the corresponding parameters of the application program through the tracking plug-in, and match the original SQL statement with the parameters to obtain the matching SQL statement, and send it to the data analysis module 2;

[0087] The data analysis module 2 is used to obtain and assemble matching SQL statements to obtain SQL statements to be analyzed, and perform performance analysis on the SQL statements to be analyzed according to the execution plan to obtain SQL performance analysis results.

[0088] The SQL performance analysis system based on the tracking technology in this embodiment uses the tracki...

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 SQL (Structured Query Language) performance analysis method, system and equipment based on a tracking technology and a medium. The SQL performance analysis method comprisesthe following steps: acquiring an original SQL statement operated by an application program and corresponding parameters through a tracking plug-in; matching and assembling the original SQL statementwith the parameters to obtain a to-be-analyzed SQL statement; and performing performance analysis on the to-be-analyzed SQL statement according to the execution plan to obtain an SQL performance analysis result. According to the method, the tracking plug-in is used for obtaining the original SQL statement and parameters of application program running, performance analysis is conducted on the SQL statement through the execution plan after parameter matching and assembling, the performance risk of SQL can be found before online, the risk is solved in time, online major events are prevented, theefficiency is high, the cost is low, and the detection process is easier and more comprehensive.

Description

technical field [0001] The invention relates to the field of testing, in particular to a method, system, device and medium for analyzing SQL performance based on tracing technology. Background technique [0002] At present, the performance of the database is increasingly becoming the performance bottleneck of the entire application system. The pros and cons of the data layer will slow down the running time of the application program and affect the response time of the application system, resulting in poor user experience. The database business processing volume used by the online payment application system is huge. Once the performance risk of the database occurs, it may directly affect the business processing of the payment application system and cause order loss. However, SQL (Structured Query Language) performance testing is very difficult, and the method of manually testing database performance is inefficient and expensive. Contents of the invention [0003] The techn...

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): G06F16/242G06F16/2457G06F9/54
CPCG06F16/2433G06F16/24578G06F9/546
Inventor 周才菊李志新高润杰陈奎
Owner SHANGHAI CTRIP COMMERCE CO LTD
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com