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

Abstract

A production early warning monitoring method of a provincial power metering center, firstly, the production early warning monitoring program of the monitoring server uses ADODB to access the Oracle database of MDS, and establishes a trusted connection with the MDS server database; secondly, submits the sql script to the MDS database, and executes it on the MDS server side The sql script reads the data table and view related fields related to the production-related arrival of new purchases, verification processes, assembly line verification tasks, and distribution links, and completes the operation instructions of data query, outreach and calculation; finally returns to the monitoring server Intuitive early warning information data, close the connection. The invention can monitor the quantitative relationship of measuring instruments corresponding to each link of the business flow of the production scheduling platform, and is suitable for improving the monitoring efficiency of production early warning and the accuracy of monitoring scheduling data, effectively reducing the intensity of monitoring work, and effectively improving the energy efficiency of monitoring work.

Description

A Production Early Warning and Monitoring Method for Provincial Power Metering Center

technical field

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

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 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 incompatibility, 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.

The MDS system database tables required for the production of early warning monitoring programs mainly include (1) vw_equip_manufacturer (equipment manufacturer view), (2) vw_wiring_mode (wiring mode view), (3) WFPROCESSINST (workflow data table), (4) T_DETECT_TASK (verification task data table), (5) c_arrive_check_in (arrival registration information data table), (6) c_arrive_meter_para (arrival electric energy meter related parameter data table), (7) D_IO_TASK (in and out warehouse information data table), (8) U_DIST_TASK_DET ( Delivery task details), (9) d_meter (energy meter information).

Contents of the invention

The purpose of the present invention is to disclose a production early warning and monitoring method of a provincial power metering center, which can not only monitor the macro information corresponding to the business logic state of all measuring instruments in each production link of arrival, verification and distribution, but also specifically display each Detailed information such as the batch number, wiring, manufacturer, status, location, and quantity of measuring instruments under a business logic state, to realize accurate, efficient, and real-time monitoring of the entire process of production early warning and monitoring business objects, locations, and status.

In order to solve the problems of the technologies described above, the technical solution adopted in the present invention is:

The invention discloses a production warning monitoring method of a provincial power metering center. The method of the invention uses ADODB to access the Oracle database of the MDS. First, the early warning monitoring program in the monitoring server establishes a trusted connection with the MDS server database, and secondly, the early warning monitoring program automatically submits to the MDS server. Early warning monitoring function sql script, execute this SQL script on the MDS server side, read the relevant fields of the MDS system database table required by the production early warning monitoring program, complete the data query, outlink and operation instructions contained in the early warning monitoring program SQL script, and finally send The monitoring server returns intuitive early warning information data and closes the connection; the early warning monitoring method includes monitoring the macroscopic data of the production business and monitoring the microscopic detailed data of the business.

The monitoring process only requires ADODB to access the Oracle database once, and the SQL script automatically judges the status information and quantity relationship corresponding to each arrival batch number within the production warning monitoring range, and automatically completes the storage progress, manufacturer, wiring, and verification methods , verification type, number of verification tasks, qualified number, verification return quantity and return time information filtering and screening, without manual intervention and operation.

The business macro data monitoring is used to describe the state and quantity relationship of the four major business links of "arrival-process-verification-delivery". According to the measurement business logic and the data extraction method designed by the present invention, the MDS data is analyzed from multiple angles. Perform screening to filter out the quantity of measuring instruments corresponding to each link of "arrival-process-verification-delivery".

According to the macroscopic data monitoring of the current verification task load of the verification assembly line, the number of measuring instruments to be verified in the warehouse, and the average value of the experience data of the production line of the assembly line, the number of hours that can be supported is calculated, and the emergency situation is distinguished by using green, blue, yellow, and red colors. Realize the intuitive monitoring of early warning information.

The business micro data monitoring is used to describe the manufacturer name, wiring mode, equipment code, Detailed information such as task type, task status, task execution method, task completion progress percentage, and number of measuring instruments.

Make a hyperlink to the column name of the business macro data, click to get the business micro detailed data on the pop-up new page, sort according to the manufacturer name, connection mode, and equipment code, and automatically summarize and sum the quantity columns of the detailed data, It is convenient for users to browse and export reports directly.

The aforementioned macro data of the early warning and monitoring business, the scope of the monitoring interval is from the temporary storage business of newly purchased equipment to the distribution business, based on the MDS data dictionary and various business logic criteria, from the business name, status, logical relationship before and after the business, and measuring instruments Attributes describe the status and quantity of business data from multiple angles, so that the data can accurately reflect the actual production and can be used to guide production from a macro perspective.

The aforementioned early warning and monitoring business micro data, the monitoring object is a specific business link, which is a detailed description of the macro data of each specific business link, and shows in detail the micro data details of the measuring instruments corresponding to the business link at the current moment.

The data tables related to the MDS server database include: equipment manufacturer view, wiring mode view, workflow data table, verification task data table, arrival registration information data table, arrival electric energy meter related parameter data table, storage and storage information data table, Workflow work item data table, electric energy meter information data table, electric energy meter verification record data table, electric energy meter verification conclusion data table, distribution task data table, and distribution task detailed data table.

The steps of the production early warning and monitoring method of a provincial power metering center of the present invention are as follows:

(1) Query and obtain the wiring mode of measuring instruments.

(2) Query and obtain the task quantity, already-inbound quantity, and connection mode of each newly-purchased warehouse task.

(3) Query and obtain the quantity and wiring mode of each measuring instrument in the verification task process stage.

(4) Query and obtain the number of tasks for each verification task, the number of verification systems, the number of verification out-of-warehouses, and the wiring method.

(5) Query and obtain the historical average data value of the hourly production capacity of each verification assembly line.

(6) Query and obtain the delivery quantity, table barcode status, location, and connection mode of the delivery task corresponding to each arrival batch number.

(7) Correlate according to the wiring method, based on the wiring method, associate according to the wiring method, and use functions such as decode(), sum(), and max() to perform row-column conversion and summation operations on the associated information And take the most value operation to obtain the early warning data information of each connection mode.

(8) According to the number of measuring instruments to be verified in the warehouse, the wiring mode, the current number of verification systems, and the average value of the historical production capacity data of the verification system, calculate the number of hours that the number of measuring instruments to be verified in the warehouse can support the continuous verification of the verification system, reflecting The degree of urgency with which the measuring instruments currently waiting for verification in the warehouse can continue to meet the verification needs of the verification system also reflects the heavy degree of verification tasks in a certain period of time in the future. Calculation method: The number of hours that can support the continuous verification of the verification system = the number of measuring instruments to be verified in the warehouse corresponding to the wiring mode / (the current number of verification systems corresponding to the wiring mode * the average value of the historical production capacity data of the verification system). Use green, blue, yellow, and red colors to distinguish, so that it is beautiful and intuitive. It will display green for more than 48 hours, blue for 24-48 hours, yellow for 12-24 hours, and red for less than 12 hours.

The beneficial effects of the present invention compared with the prior art are: a provincial electric power metering center production early warning monitoring method of the present invention can fully automatically analyze the complete information and state macro data of "arrival—process—verification—delivery", Use visual and intuitive monitoring methods to present early warning information in the form of graphics and reports, and overcome the abstraction and dispersion of the "arrival-process-verification-delivery" data chain, and the fact that users in each position can only access partial production data Limitations, realize "controllable, controllable, and in control" of the whole process of "arrival-process-verification-delivery" business, issue early warnings, prevent human factors from delaying production, reduce monitoring management costs, and reduce monitoring work Intensity, improve the level of measurement management capabilities and decision-making benefits, ensure the efficient operation of measurement work, increase production capacity and maintain a high level.

The method of the present invention automatically stores the early warning monitoring data on the server side of the monitoring system through the early warning monitoring, which can be viewed as historical data, and can also be sent as short messages and WeChat messages.

The invention is applicable to the production early warning and monitoring of the provincial power metering center, and the method can be popularized and applied in other enterprises.

Description of drawings

Fig. 1 is a flowchart of a production early warning monitoring method of a provincial power metering center according to the present invention.

Detailed ways

In the embodiment of the present invention, the web monitoring program of the monitoring system server is composed of java, asp script and sql script. The monitoring program first establishes a trusted connection with the MDS server database based on ADODB (the abbreviation of Active Data Object DataBase, that is, the active data object database), and then passes the SQL query statement and parameters and receives the query result set, closes the connection, and finally transmits the data and data to the client. sheet.

key step:

(1) Take the wiring method of the measuring instrument.

Query and obtain the wiring mode from vw_wiring_mode (wiring mode view). Use the substr() function to intercept the left two characters of the wiring mode to obtain the "single-phase, three-phase" wiring mode.

(2) Take newly-purchased equipment and put it into storage for temporary storage, the wiring method of measuring instruments, and the quantity that has been put into storage.

Query the wiring mode and newly purchased quantity from D_IO_TASK (inbound and outbound task information), and the access method does not include the arrival batch number that is already in T_DETECT_TASK (verification task information).

(3) Take the connection mode and quantity of measuring instruments in the verification task process stage.

From d_meter (electric energy meter asset information), query the wiring mode and quantity of newly purchased electric energy meters to be verified. The method of obtaining data is that the batch number of d_meter is outside the full inspection and re-inspection of T_DETECT_TASK (verification task information). And the measuring instrument whose verification task has been completed is in the corresponding arrival batch number, and the status of d_meter is "new purchase, waiting for verification".

(4) Take the wiring method and quantity of the measuring instruments in storage to be verified.

From T_DETECT_TASK (verification task information), c_arrive_check_in (arrival registration information), c_arrive_meter_para (arrival electric energy meter parameter information), query the verification task quantity, wiring, and completed amount. The access method is that T_DETECT_TASK is associated with c_arrive_check_in, c_arrive_check_in is associated with c_arrive_meter_para, and the T_DETECT_TASK task status is pending verification.

(5) Calculate the number of hours that can be continuously supplied to the verification assembly line for verification based on the current quantity in storage to be verified, the number of operating verification systems, and the average production capacity of the verification system. The counting method is to calculate the number of current verification pipeline tasks and the number of returned warehouses. If there are verification tasks that are not all returned to the warehouse, it is judged that the pipeline has verification and is working, otherwise, the pipeline has no verification tasks.

(6) Take the wiring and quantity of measuring instruments that can be used for distribution.

From d_meter (watt-hour meter asset information), query the wiring mode of each meter barcode, the batch number of arrival, and the status in stock.

Measuring instruments that can be used for distribution meet the following conditions:

Condition 1: The verification conclusion is qualified, the location is in the provincial metrology center, and the results of the full inspection (verification/testing/calibration) have been processed;

Condition 2: Take the quantity of qualified meters in the arrival batch of measuring instruments that meet condition 1, and then deduct the quantity corresponding to the effective distribution plan that has been formulated and approved, and the remaining quantity is the quantity that can be redistributed.

The number of verification systems currently participating in the verification work meets the following conditions at the same time:

(1) The verification system has verification tasks;

(2) Compare the number of measuring instruments for the verification task with the number returned to the warehouse. If there are verification tasks that are not all returned to the warehouse, it is judged that the verification system is in the verification working state and there are verification tasks, otherwise it is judged that the verification system is not involved in the verification work.

The way to get the data is to carry out from the energy meter asset information table d_meter (electric energy meter asset information data table), WFWORKITEM (workflow work item data table), T_DETECT_TASK (verification task data table) according to the arrival batch number arrive_batch_no, task number task_no Association, filter according to status_code, currentstate, processinstname.

(7) Make hyperlinks to the names of the four links of early warning monitoring, "new purchases in stock, unloaded tasks, verification process backlog, pending verification, and available for delivery" as a hyperlink. Click to get the Link data details.

Use the wiring method to correlate the information in steps 1-6, and use the decode function of oracle to carry out the row-to-column operation. The max function takes the maximum value of the time, and the sum function sums the quantity to obtain each wiring method, status, and quantity. and other information.

Create a database table on the monitoring server side to store the early warning monitoring data.

To sum up, a production early warning monitoring method of a provincial power metering center of the present invention integrates arrival information, verification task process information, verification task information, inventory information, distribution information and verification assembly line status information through early warning monitoring. Automatically filter and filter out the data and status of all arrival batch numbers through the SQL script of the monitoring program. For any incoming batch number, as long as it satisfies the access rules of each link of early warning monitoring, it can be found, calculated and displayed by the early warning monitoring program without manual intervention. Use the wiring method to distinguish "the amount of new purchases that have not yet been placed in the warehouse, the backlog of the verification process, the amount in stock to be verified, the amount that can be supported for several hours, and the amount in stock that can be delivered", which can ensure the accuracy and uniqueness of the early warning information. sex. Make hyperlinks to the column names, realize the early warning of the macro link of the data and the information description of the micro link, form an intuitive early warning and monitoring of production, and provide basic data support and technical support for monitoring, scheduling and management. Hyperlinks additionally display the batch number, wiring method, manufacturer, equipment code, verification system and verification type, task number, task quantity, qualified number, return quantity and latest return time of the measuring instruments corresponding to each early warning link, etc. . Realize the "controllable, controllable, and in-control" of the entire process of internal business operation data in the metering center, eliminate human factors from delaying new purchases, verification task processes, full inspections and sampling inspections, and distribution services, reduce monitoring management costs, and reduce monitoring work intensity , improve the level of measurement management capabilities and decision-making benefits, ensure the efficient operation of measurement work, increase production capacity and maintain a high level.

Table 1: Early warning and monitoring macro unit display chart;

Table 2: Chart of new purchases and storage of early warning and monitoring micro units;

Table 3: Chart of backlog of early warning and monitoring micro-unit processes;

Table 4: Chart of the amount in stock of the micro-units to be inspected for early warning monitoring;

Table 5: Early warning and monitoring micro units can be used as distribution volume charts.

the

           

The specific implementation manners of the present invention have been described above in conjunction with the accompanying drawings, but these descriptions should not be construed as limiting the scope of the present invention. On the premise of not departing from the spirit and scope of the present invention, the present invention will also have corresponding changes and improvements, and these changes and improvements are required to fall within the scope of the claimed invention. The protection scope of the present invention is defined by the claims.

Claims (8)

1. a provincial electric-power metering center produces pre-warning monitoring method, it is characterized in that, described method is used the oracle database of ADODB access MDS, first the flow monitoring program of monitoring server breaks the wall of mistrust and is connected with MDS server database, and secondly flow monitoring program is submitted flow monitoring sql script to automatically to MDS server; Carry out SQL script at MDS server end, read MDS system database with relevant database table and the view relevant field of production early warning, complete data query that SQL script comprises, outreach and arithmetic operation, return to early warning data message intuitively to monitoring server, finally close connection; Described monitoring comprises the monitoring of early warning macro and early warning microscopic units is monitored.

2. the provincial electric-power metering of one according to claim 1 center produces pre-warning monitoring method, it is characterized in that, described monitor procedure only needs ADODB For Accessing Oracle Database once, SQL script automatic decision is in producing each receipt lot number corresponding status information and the quantitative relation within the scope of early warning monitoring, and automatically complete warehouse-in progress, producer, wiring, calibrating mode, calibrating type, verification task quantity, passing number, calibrating and return that Liang Hehui storehouse, storehouse temporal information is filtered and screening, without manual intervention and operation.

3. the provincial electric-power metering of one according to claim 1 center produces pre-warning monitoring method, it is characterized in that, described early warning macro monitoring, state and the quantitative relation of " arrival---flow process---calibrating---dispensing " 4 large service links are described, according to the extraction data method of measurement service logic and the present invention's design, multi-angle is screened MDS data, filters out all in " arrival---flow process---calibrating---dispensing " measurement instrument quantity corresponding to every link.

4. the provincial electric-power metering of one according to claim 2 center produces pre-warning monitoring method, it is characterized in that, monitor current calibrating streamline verification task load condition, measurement instrument quantity, the streamline production capacity empirical data mean value that fixes on storehouse to be checked according to described early warning macro, calculate the hourage that can support, utilize green, blue, yellow, red color differentiation emergency condition, realize the visual supervisory control of early warning information.

5. the provincial electric-power metering of one according to claim 1 center produces pre-warning monitoring method, it is characterized in that corresponding producer's title, the mode of connection, device code, task type, task status, tasks carrying mode, task schedule number percent, the measurement instrument quantity information detail of each receipt lot that concrete each service link of described business micro-data monitoring " arrival---flow process---calibrating---dispensing " 4 large service links for describing comprises.

6. the provincial electric-power metering of one according to claim 1 center produces pre-warning monitoring method, it is characterized in that, the concrete steps of described pre-warning monitoring method are:

(1) inquire about and obtain the mode of connection of measurement instrument;

(2) inquire about and obtain the each task quantity of storehouse task, warehousing quantity, mode of connection newly bought;

(3) inquire about and obtain each measurement instrument quantity, mode of connection in the verification task flow process stage;

(4) inquire about and obtain task quantity, verification system quantity, calibrating outbound quantity, the mode of connection of each verification task;

(5) inquire about and obtain every calibrating streamline production capacity historical average per hour according to value;

(6) inquire about and obtain dispensing quantity, table bar code state, position, the mode of connection of the dispensing task that each receipt lot is number corresponding, get and can do measurement instrument wiring, the quantity of providing and delivering;

(7) associate according to the mode of connection, taking the mode of connection as benchmark, carry out association according to the mode of connection, and utilize decode (), sum () with max () function to information procession conversion operations, sum operation after associated and get Value Operations, obtain the early warning data message of each mode of connection;

(8) according to measurement instrument quantity, the mode of connection, current verification system quantity, the historical production capacity data of the verification system mean value that fixes on storehouse to be checked, calculate the measurement instrument quantity that fixes on storehouse to be checked and can support the verification system hourage of calibrating continuously.

7. the provincial electric-power metering of one according to claim 6 center produces pre-warning monitoring method, it is characterized in that, the described measurement instrument of providing and delivering that does meets the following conditions simultaneously:

(1) calibrating conclusion is qualified, and position is in provincial measurement centre, and the full inspection of process (calibrating/detection/calibration) result treatment;

(2) get 1 the measurement instrument receipt lot eligible list count number of satisfying condition, then deduction falls to have formulated and examine quantity corresponding to effective distribution plan, remaining quantity is exactly to do the quantity of providing and delivering again.

8. the provincial electric-power metering of one according to claim 6 center produces pre-warning monitoring method, it is characterized in that, the verification system quantity of described current participation calibration operation meets the following conditions simultaneously:

(1) verification system has verification task;

(2) compare the measurement instrument quantity of verification task and return storehouse quantity, if there are the whole Hui Ku of verification task, judge this verification system in calibration operation state and have verification task, otherwise judging that this verification system does not participate in calibration operation.