Design And Implementation Of Management System For Integrating Data From Marketing,Distribution,and Scheduling

The data quality management of operation,distribution and dispatching is to connect the basic data in the system used by different professional departments to make the data consistent.There are many shortcomings in the existing data quality management technology,such as management process confusion,corresponding data dislocation,system information distortion and so on.In order to save time and cost,and improve the standardization of work results,we need a business distribution coordination through management system to realize the consistency and integrity analysis of similar data in different professional systems and problem data governance.According to the demand of data management and control,this paper combs the original operation and maintenance management methods of distribution network,marketing and dispatching,studies and designs a set of breakthrough method,which is used to build the data quality system of operation,distribution and dispatching,and achieves three goals: one is to extract data information in different systems by establishing an intermediate database,and study the unified principle of data correspondence,Ensure data correspondence and continuous maintainability;Second,according to the cross data between different systems,the database table and a set of reasonable consistency checking method are formulated to ensure the correct and complete Association of data;The third is to open the interface fusion intersection process and establish a reasonable transfer process to maintain the incremental data in control.The data quality management system of operation and distribution dispatching is guided by the original system data,which are continuously used and updated to ensure the feasibility of the method;Based on the on-site census data and supported by data consistency verification,the method is reliable.State Grid Sichuan electric power company uses the system to guide the staff to carry out the problem data governance work directionally,so that the comprehensive index of the consistency rate of operation,distribution and dispatching is increased from 38% in 2016 to 99% in 2021.Through the realization of the high consistency of the equipment basic account,line transformer,household transformer and household box relationship and other basic information of marketing,distribution network and dispatching departments in the management system,it provides support for the relevant business application and analysis functions,so as to promote the comprehensive improvement of the company’s operation efficiency and service ability.In the next step,the system also hopes to realize intelligent applications such as automatic release of planned(fault)outage information,fault research and judgment command and auxiliary formulation of industry expansion report and installation scheme,so as to further reduce labor costs and improve work efficiency.