Unlock instant, AI-driven research and patent intelligence for your innovation.

A script anomaly detection method and its terminal

An anomaly detection and scripting technology, applied in the database field, can solve problems such as increased maintenance costs and low detection efficiency, and achieve the effects of reducing maintenance costs, narrowing the detection range, and improving accuracy and response speed

Active Publication Date: 2020-01-10
CHINA PING AN LIFE INSURANCE CO LTD
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] In view of this, the embodiment of the present invention provides a script anomaly detection method and its terminal to solve the existing script anomaly detection technology, which requires the administrator to manually analyze the SQL language, the detection efficiency is low, and the dependency management The staff has a higher technical level, which increases the cost of maintenance

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
  • A script anomaly detection method and its terminal
  • A script anomaly detection method and its terminal
  • A script anomaly detection method and its terminal

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0032] In order to make the objectives, technical solutions and advantages of the present invention clearer, the present invention will be further described in detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present invention, but not to limit the present invention.

[0033] In the embodiment of the present invention, the first consumption characteristic value is obtained by acquiring the running state parameter of the SQL script, and determining the consumption of the SQL script within a preset time period through the running state parameter, and then the terminal device selects N with larger consumption. Then, the terminal device will generate a script consumption exception list according to the N SQL scripts that consume a lot of energy, and select the target SQL script from the abnormal script consumption list to obtain the target SQL script. The se...

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 is applied to the technical field of databases, and provides a script exception detection method and a terminal thereof. The method comprises the steps that a running state parameter ofeach structured query language SQL script is acquired; according to the running state parameter of each SQL script, a first consumption characteristic value of each SQL script is calculated; the SQL script corresponding to the front N first consumption characteristic values are selected to generate a script consumption exception list; second consumption characteristic values corresponding to variable parameters in a target SQL script when each variable value is taken are respectively acquired; if a second consumption characteristic value corresponding to a variable parameter when a certain variable value is taken is greater than a consumption characteristic threshold, the target SQL script is identified as an exception script. According to the script exception detection method and the terminal thereof, the consumption characteristic value of each variable value is obtained as a basis to determine whether or not the SQL script is the exception script, thereby the purpose that the exceptional SQL script is automatically identified is achieved, and the detection efficiency is improved.

Description

technical field [0001] The invention belongs to the technical field of databases, and in particular relates to a script abnormality detection method and a terminal thereof. Background technique [0002] SQL scripts are widely used in the field of network services. Therefore, the efficiency of SQL scripts determines the response rate of service requests. If the SQL script runs abnormally, it will take a long time for the service requests initiated by users to be processed, and there will be service requests. Requests pile up. Therefore, how to quickly detect the abnormal situation of the SQL script is particularly important. However, the existing abnormal detection technology of SQL scripts requires the administrator to perform manual analysis on the SQL language, the detection efficiency is low, and it relies on the administrator to have a high technical level, thereby increasing the maintenance cost. SUMMARY OF THE INVENTION [0003] In view of this, the embodiments of ...

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 Patents(China)
IPC IPC(8): G06F11/36
CPCG06F11/3688
Inventor 吴丽娜肖涵月何恩赐
Owner CHINA PING AN LIFE INSURANCE CO LTD