Data merging method based on improvement of business monitoring efficiency of electric running

Abstract

The invention discloses a data merging method based on improvement of business monitoring efficiency of electric running, and belongs to the field of electric running. The data merging method comprises the following steps: a, importing data in a business application system of a first-level deployment part into a first-level deployment system database, carrying out storage, inspection and partitioning operation on the imported data by using a running and monitoring worktable system, and storing final data into a headquarter running and monitoring database; b, importing data in a business application system of a second-level deployment part into a second-level deployment system database, carrying out storage, inspection and partitioning operation on the imported data by using the running and monitoring worktable system, and storing final data in a provincial company running and monitoring database; and c, communicating the headquarter running and monitoring database with the provincial company running and monitoring database through a network, and calling data from each other. The data merging time is saved, and the efficiency of data merging operation is remarkably improved.

Description

technical field [0001] The invention relates to the field of power operation, in particular to a data collection method. Background technique [0002] The collection of power operation monitoring business data involves a total of 10 first-level deployment systems such as infrastructure management and control, 95598, planning and planning, economic law, vehicle management, human resource management and control, logistics management, intellectual property rights, e-commerce (ECP), IRS, and financial management and control. , ERP, marketing, power trading, PMS, TMS, IMS, OMS, unified rights management, employee reimbursement system and other 10 secondary deployment systems, the amount of data involved is huge, but the original collection method and processing flow cannot Meet the requirements for data timeliness. The original collection method is mainly that the first-level deployment part starts the data collection work of the previous month, and the data support team checks,...

AI Technical Summary

Problems solved by technology

The main problems of current data collection are: the collection is carried out in the form of data files, the data needs to be converted multiple times, the degree of automation is low, and the data collection problem needs to be rectified and re-collected many times, which affects the overall efficiency and accuracy of data collection

At present, the collected data files are in excel format. Although it has the characteristics of simple data processing and low technical requirements for support personnel, the excel format cannot set data format specifications. When the on-site collection data format is not standardized, the data at the headquarters cannot be stored. , it takes time to adjust the data format

At the same time, from the perspective of work development, during the data verification process of the collected data, it is found that there are problems in the standardization, completeness, and accuracy of the collected data, and the problems need to be fed back to the relevant business departments for rectification and re-collection. Affect the progress of data collection