Provincial electric power measurement center production early-warning and monitoring method

Abstract

The invention discloses a provincial electric power measurement center production early-warning and monitoring method. The method includes the steps that firstly, a production early-warning and monitoring program of a monitoring server has access to an Oracle database of an MDS through ADODB and establishes trust connection with an MDS server database; secondly, sql scripts are submitted to the MDS database, the sql scripts are executed at an MDS server side, data tables and view related fields of the arrival new-purchase warehouse-in operation, the verification process, the assembly line verification task and the distribution link related to production are read, and operational instructions of data inquiry, external connection and operation are finished; finally, visual early-warning information data are sent back to the monitoring server, and connection is closed. According to the provincial electric power measurement center production early-warning and monitoring method, the quantitative relation of measuring instruments corresponding to all links of service circulation of a production dispatching platform can be monitored, the provincial electric power measurement center production early-warning and monitoring method are suitable for improving the monitoring efficiency and the accuracy of monitoring dispatching data in production early warning, the intensity of monitoring work is effectively lowered, and monitoring work efficiency can be practically improved.

Description

technical field [0001] The invention relates to a production early warning and monitoring method of a provincial power metering center, which belongs to the technical field of databases and software programming methods for production early warning and monitoring of enterprises. Background technique [0002] The provincial power metering center relies on the production dispatching platform (MDS) to carry out centralized verification and unified distribution of measuring instruments. The main links involved in production are arrival, verification and distribution. However, in the process of using MDS, it is found that the "inventory query" in the MDS public query cannot intuitively reflect the corresponding relationship between the business logic status and quantity of each business link in the internal circulation process of measuring instruments in the provincial measurement center, which requires manual comprehensive synthesis Query and screening can easily cause data omiss...

AI Technical Summary

Problems solved by technology

However, in the process of using MDS, it is found that the "inventory query" in the MDS public query cannot intuitively reflect the corresponding relationship between the business logic status and quantity of each business link in the internal circulation process of measuring instruments in the provincial measurement center, which requires manual comprehensive synthesis Query and screening can easily cause data omission and duplication

The MDS system itself lacks the necessary business logic information global monitoring function and locking mechanism, which can easily cause problems such as inconsistency, duplication, and errors in production business logic status and data, which is not conducive to monitoring, management and decision-making, and directly affects production capacity.

Images