结构化查询语言的检测方法、装置和电子设备

By intercepting SQL queries and pre-calculating their impact dates, the problem of system lag caused by long SQL execution times was solved, enabling advance prediction of system operation and improved stability.

CN115454804BActive Publication Date: 2026-07-17WEBANK (CHINA)
View PDF 2 Cites 0 Cited by

Patent Information

Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
WEBANK (CHINA)
Filing Date
2022-09-23
Publication Date
2026-07-17

AI Technical Summary

Technical Problem

In existing technologies, when the execution time of Structured Query Language (SQL) is long, its impact on the system cannot be identified in advance, resulting in system lag and affecting system stability.

Method used

By intercepting SQL queries and pre-calculating their corresponding first predicted date, and using the execution time of each SQL query and the maximum tolerable execution time, it is determined whether the date is one that will affect system operation. If so, the execution of the SQL query is stopped.

Benefits of technology

Early identification and blocking of SQL queries that may affect system operation improves system stability and efficiency, and avoids the lag in system operation.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN115454804B_ABST
    Figure CN115454804B_ABST
Patent Text Reader

Abstract

本申请实施例提供了一种结构化查询语言的检测方法、装置和电子设备，通过拦截结构化查询语言；在预先计算的对应关系中获取结构化查询语言对应的第一预测日期，第一预测日期与下述参数有关：每次执行结构化查询语言时的耗时，结构化查询语言能被容忍的最大耗时、以及执行预测第一预测日期时的日期；当确定第一日期为第一预测日期时，停止执行结构化查询语言；其中，第一日期为拦截结构化查询语言时的日期。这样，使得第一预测日期为执行该结构化查询语言会影响系统运行的日期，在第一日期为第一预设日期时，停止执行该结构化查询语言，能够有效的提升系统运行的稳定性。
Need to check novelty before this filing date? Find Prior Art