Data monitoring method and device

A data monitoring method and database technology, which are applied in the field of data monitoring methods and devices, can solve the problems of low configuration efficiency, high maintenance cost, and large amount of prediction and calculation when monitoring and alarming, so as to reduce maintenance cost, reduce the amount of calculation, and reduce prediction. The effect of calculation volume

Pending Publication Date: 2020-10-02
ZHEJIANG DAHUA TECH CO LTD
View PDF0 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The embodiment of the present invention provides a data monitoring method and device to at least solve the problems of high maintenance cost, low configuration efficiency, and large amount of prediction calculations in monitoring and alarming in the related art.

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
  • Data monitoring method and device
  • Data monitoring method and device
  • Data monitoring method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0026] The method embodiment provided in Embodiment 1 of the present application may be executed in a mobile terminal, a computer terminal, or a similar computing device.

[0027] The embodiment of this application can run on figure 1 On the network architecture shown, such as figure 1 As shown, the network architecture includes: a computer 10, a server 20, and a database 30, wherein the computer 10 and the server 20 are based on the B / S architecture, and the database 30 to be monitored is a Greenplum distributed database based on the MPP architecture. Wherein, the data in the database 30 is data collected from sources of Mysql, Oracle, Postgresql, Kafka message queues, and MQ message queues. The data in the Greenplumn database exists in the form of tables, and a separate creation time column is established for each table, with uniform date and time formats and uniform names. Tables in Greenplumn Database include partitioned tables and non-partitioned tables, and partitioned...

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 provides a data monitoring method and device, and the method comprises the steps: obtaining a monitoring object parameter and a monitoring logic parameter on a configuration interface, the monitoring object parameter being used for indicating a data object in a database, and the monitoring logic parameter being used for indicating the monitoring logic of the data object for monitoring; generating a to-be-executed monitoring statement according to the monitoring object parameter and the monitoring logic parameter, the monitoring statement being used for monitoring the monitoring data object according to the pre-configured monitoring logic; and executing the monitoring statement to monitor the data object according to the monitoring logic. According to the method and the device, the problems of relatively high maintenance cost, low configuration efficiency and large prediction calculation amount during monitoring and alarming in a data rule base are solved, so that the effects of improving the data rule configuration efficiency, reducing the data monitoring and maintenance cost and reducing the prediction calculation amount during data monitoring and alarming are achieved.

Description

technical field [0001] The invention relates to the field of data quality management, in particular to a data monitoring method and device. Background technique [0002] Data quality management technology is mainly aimed at a series of management activities such as identification, measurement, monitoring, and early warning for data quality problems. [0003] In some data monitoring scenarios, it is necessary to establish rules for each field of all tables in the database or data warehouse, and configure the rule operation cycle. The maintenance cost is high and the configuration efficiency is not high. In other data monitoring scenarios, the monitoring and alarming of data needs to be based on a large amount of historical data, and a large number of fitting calculations are performed, and the amount of prediction calculation is large. [0004] In the related art, the maintenance cost in the data rule base is high, the configuration efficiency is low, and the amount of pre...

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 Applications(China)
IPC IPC(8): G06F16/21G06F16/242
CPCG06F16/21G06F16/2433
Inventor 刘文之何林强
Owner ZHEJIANG DAHUA TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products