High dispersion SQL dynamic baseline alarm method and system

A dynamic baseline and alarm system technology, applied in the database field, can solve the problems of random discontinuity, large dispersion of SQL statements, and the inability to automatically include new SQL statements in the baseline calculation of SQL statements, etc., to achieve accurate fitting results

Active Publication Date: 2022-07-15
SHANGHAI NETIS TECH
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The core data SQL in the database monitoring system has the following characteristics: 1) Individual SQL appears random and discontinuous; 2) The response time of SQL statement execution is irregular; 3) SQL statements have large dispersion; 4) SQL statements have a large number of dimension values cannot be determined in advance
Therefore, the main problems faced by the database SQL statement baseline are: 1) It is impossible to generate an accurate and reasonable alarm baseline for the SQL statement; 2) The current baseline algorithm on the market does not combine the characteristics of the SQL statement; 3) The performance of the standard AI baseline algorithm cannot satisfy a large number of Dynamic baseline; 4) The baseline calculation for SQL statements cannot be automatically included in new SQL statements

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
  • High dispersion SQL dynamic baseline alarm method and system
  • High dispersion SQL dynamic baseline alarm method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0045] The present invention will be described in detail below with reference to specific embodiments. The following examples will help those skilled in the art to further understand the present invention, but do not limit the present invention in any form. It should be noted that, for those skilled in the art, several changes and improvements can be made without departing from the inventive concept. These all belong to the protection scope of the present invention.

[0046] refer to figure 1 System flow chart, the method includes the following steps:

[0047] Step 1: The SQL statistics module based on network data associates SQL transactions;

[0048] The output is SQL statistics, including indicators such as SQL text, transaction success rate, response time, and response rate, as well as dimension divisions for SQL features such as table name, return code, SQL type, SQL transaction status, and transaction execution time.

[0049] Step 2: Segment the SQL baseline algorith...

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 present invention provides a high-dispersion SQL dynamic baseline alarm method and system, including: acquiring SQL statistical data from network data; The data is fused and automatically analyzed to generate a dynamic baseline; on the basis of the dynamic baseline, by adding the currently calculated dynamic factor, the deviation value limit between the given index and the dynamic baseline within the allowable range is obtained, and the dynamic threshold is obtained; according to SQL statistics, For dynamic baseline and dynamic threshold, in the specified time range, the specified time range is divided into multiple equal parts, the baseline is calculated in each divided time, and the current time is used for alarm control in the time interval corresponding to the baseline. The alarm baselines generated for different dimensions are more reasonable and the fitting is more accurate.

Description

technical field [0001] The invention relates to the field of databases, and in particular, to a high-dispersion SQL dynamic baseline alarm method and system. Background technique [0002] SQL data is the mainstream IT technology, and database monitoring is an area with a huge market. Baseline-based alerting is also one of the mainstream methods. The existing baseline technology has the following characteristics: 1) The generation of the baseline depends on continuous high-density data; 2) The data tends to analyze regularity; 3) It is suitable for dimension values ​​with low dispersion; 4) The baseline object needs to be defined in advance . [0003] The core data SQL in the database monitoring system has the following characteristics: 1) Individual SQL appears random discontinuity; 2) The response time of SQL statement execution is irregular; 3) The SQL statement has a large dispersion; 4) The SQL statement has a large number of dimension values cannot be determined in a...

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 & AuthorityPatents(China)
IPC IPC(8): G06F16/2458G06F16/242G06F16/28
CPCG06F16/2462G06F16/2433G06F16/284
Inventor朱宇田世新徐龙蔡晓华杨光辉
OwnerSHANGHAI NETIS TECH