Supercharge Your Innovation With Domain-Expert AI Agents!

Database intelligent monitoring method and system based on historical experience and storage medium

An intelligent monitoring and database technology, applied in the field of big data processing, can solve problems such as low efficiency of database alarm processing, and achieve the effect of improving positioning and processing efficiency, improving processing efficiency, and reducing the impact of human factors

Pending Publication Date: 2021-04-20
CHINA PING AN LIFE INSURANCE CO LTD
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0008] The invention provides a database intelligent monitoring method, system and computer-readable storage medium based on historical experience, which mainly solves the problem of low efficiency of database alarm processing

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
  • Database intelligent monitoring method and system based on historical experience and storage medium
  • Database intelligent monitoring method and system based on historical experience and storage medium
  • Database intelligent monitoring method and system based on historical experience and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0043] It should be understood that the specific embodiments described here are only used to explain the present invention, not to limit the present invention.

[0044] The invention provides a database intelligent monitoring method based on historical experience. Based on the hidden danger of information leakage in the bus system, by presetting the historical record table and the preprocessing scheme table, when solving the alarm situation, first query whether it is a processed historical situation Or whether it is the status filed in the pre-processing plan table, and then processed according to the historical processing records or according to the filing conditions in the pre-processing plan, which improves the alarm processing efficiency.

[0045] The invention provides a database intelligent monitoring method based on historical experience. figure 1 It shows the flow of a preferred embodiment of the historical experience-based database intelligent monitoring method of the...

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 relates to a big data processing technology, and discloses an intelligent database monitoring method based on historical experience, and the method comprises the steps: receiving a database task; receiving a database task; querying an SQL (Structured Query Language) corresponding to the database task in a preset SQL query database, querying information data corresponding to the SQL in the database according to the SQL, and processing the information data conforming to a preset alarm rule; giving an alarm and generating alarm information; traversing a preset historical record table, and determining historical processing data matched with the information data in the historical record table; and sending the historical processing data and the alarm information together. The invention further relates to a blockchain technology, data is stored in the blockchain, and when shielding is set, the alarm positioning speed and the alarm processing speed of the database are improved by setting the historical record table and the preprocessing scheme table.

Description

technical field [0001] The invention relates to big data processing technology, in particular to a database intelligent monitoring method, system and storage medium based on historical experience. Background technique [0002] There are two types of existing database monitoring, one is through the performance monitoring of the database itself and SQL performance-related monitoring; the other is data-related monitoring based on business logic to monitor whether there is any wrong data. [0003] The alarm is triggered by querying the database to find the wrong data, or by setting the alarm threshold, when the error data reaches the alarm threshold, the alarm is triggered; after the alarm occurs, the operation and maintenance personnel will query the alarm data and analyze the alarm problem according to the alarm content, but the disadvantages are as follows: [0004] 1) The efficiency of alarm processing is limited by the technical ability and processing experience of operatio...

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): G06F11/30
Inventor 王小龙
Owner CHINA PING AN LIFE INSURANCE 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