Method and device for identifying slow SQL statement, electronic device and storage medium
CN116644322BActive Publication Date: 2026-07-07INDUSTRIAL AND COMMERCIAL BANK OF CHINA
Patent Information
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- INDUSTRIAL AND COMMERCIAL BANK OF CHINA
- Filing Date
- 2023-05-22
- Publication Date
- 2026-07-07
AI Technical Summary
Technical Problem
In existing technologies, manual identification of slow SQL statements is inefficient and inaccurate, leading to resource waste and potential failure risks.
Method used
By preprocessing the SQL statements to be identified, calculating the unordered tree edit distance with historical slow SQL statements, and normalizing the process, slow SQL statements are identified, including removing comments and blank lines, normalizing the process, and generating processing work orders for adjustment using feature vectors and syntax tree edit distance algorithms.
Benefits of technology
It improves the efficiency and accuracy of slow SQL statement identification, reduces the cost of manual intervention, and lowers the risk of system failure.
✦ Generated by Eureka AI based on patent content.
Smart Images
Figure CN116644322B_ABST
Abstract
The application discloses a slow SQL statement identification method and device, electronic equipment and a storage medium, and relates to the field of big data. The identification method comprises the following steps: processing a to-be-identified SQL statement, determining a preset distance between the processed target to-be-identified SQL statement and each historical slow SQL statement in a historical slow SQL statement library, and adding a target historical slow SQL statement indicated by a target preset distance less than or equal to a preset distance threshold to a preset statement set. When the preset statement set is not empty, the unordered tree edit distance between the target to-be-identified SQL statement and each target historical slow SQL statement is determined, the unordered tree edit distance is normalized to obtain a statement similarity, and if there is a statement similarity greater than or equal to a preset similarity threshold, the to-be-identified SQL statement is determined as a slow SQL statement. The application solves the technical problem of low efficiency and accuracy of manually identifying slow SQL statements in the related art.
Need to check novelty before this filing date? Find Prior Art