Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

A business monitoring method based on real-time statistics and alarm formula

A formula and business technology, applied in the field of data processing, can solve the problems of reduced real-time statistical performance, slow statistical speed, slowing down the database, etc., to achieve the effect of reducing the number of queries, reducing delays, and improving system performance

Active Publication Date: 2022-02-11
SICHUAN XW BANK CO LTD
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] The purpose of the present invention is: in order to solve the existing data statistics method to use SQL to carry out query statistics, the number of queries is directly related to the variable number of statistics linearly, when the query volume is large, the database will be slowed down, resulting in slow statistics, real-time statistics The performance is reduced, resulting in the problem that the alarm is not timely. The present invention provides a business monitoring method based on real-time statistics and alarm formulas

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 business monitoring method based on real-time statistics and alarm formula
  • A business monitoring method based on real-time statistics and alarm formula
  • A business monitoring method based on real-time statistics and alarm formula

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0034] Such as figure 1 and figure 2 As shown, this embodiment provides a business monitoring method based on real-time statistics and alarm formulas, the business monitoring method is based on a parallel monitoring device, and the parallel monitoring device is connected to a cache sharing device for communication, and the parallel monitoring device includes variables running in parallel The statistics subsystem and the formula alarm subsystem, the cache sharing device includes a cache sharing system, the variable statistics subsystem and the formula alarm subsystem share data through the cache sharing system, and the variable statistics subsystem includes single-thread access and variable Statistical scheduling task module and multi-thread statistical task queue module, the formula alarm subsystem includes a single-threaded formula scheduling task subsystem module, multi-threaded formula alarm task execution queue module, alarm formula list and alarm system, and the cache sh...

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 discloses a business monitoring method based on real-time statistics and alarm formulas, and relates to the technical field of data processing. The invention includes a variable statistics subsystem and a formula alarm subsystem running in parallel, and the relationship between the variable statistics subsystem and the formula alarm subsystem Sharing data through the cache sharing system, the business monitoring method includes the following steps: S1: The variable statistics subsystem periodically and parallelly counts the values ​​of each variable according to the preset time granularity, and stores the statistical values ​​of each variable in the cache sharing system; S2: The formula alarm subsystem concurrently extracts the statistical values ​​of the variables associated with the formula calculation from the cache sharing system according to the preset cycle, and concurrently calculates the function values ​​of each associated variable, and periodically substitutes them into the formula for calculation. When the calculation result If it is true, an alarm will be issued. The present invention can flexibly configure variables and self-defined formulas to monitor the system in a more flexible and accurate manner, and adapt to flexible and changeable multi-dimensional business monitoring requirements.

Description

technical field [0001] The invention relates to the technical field of data processing, and more specifically relates to a business monitoring method based on real-time statistics and alarm formulas. Background technique [0002] The prior art usually uses the database's own statistical functions or SQL (Structured Query Language, Structured Query Language) to perform statistics, and uses hard-coded methods to determine whether the statistical value reaches a certain threshold and issue an alarm. [0003] However, the existing statistical methods have the following problems: [0004] 1. Directly use SQL for query statistics. SQL cannot be reused for data. The number of queries is directly related to the number of variables counted. If you want to count historical data (such as statistics by day), the number of queries will be more. When the amount is relatively large, query Too many times will slow down the database, affect business operation, and slow down the statistics s...

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/30G06F16/2458
CPCG06F11/3051
Inventor 王崟平
Owner SICHUAN XW BANK CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products