The Design And Implementation Of Transmission And Distribution Equipment Condition Evaluation System Based On Big Data Analysis Technology

With the rapid advancement of current power technology,the monitoring methods for the operation status of the main equipment are gradually increasing,such as live detection,online monitoring,bad working conditions and equipment history memorabilia.The amount of data that appears can show the internal and external operating status of the main grid equipment.After the status is summarized and analyzed,the current running status of the equipment can be obtained,which provides the decision basis for equipment maintenance,and is also the core data of the comparison.In order to gradually improve the specific value of big data in the state of power transmission and transformation equipment evaluation,this paper proposes the construction of the state evaluation system of power transmission and transformation equipment based on big data analysis technology.The state evaluation system of power transmission and transformation equipment is B/S architecture mode.With the integration of Spring MVC framework and Mybatis framework,SparkSQL is used as a SQL-based query method based on big data storage,and data is stored in Oracle database.The system is divided into four layers:basic platform,application platform,data application,and visual display.The system accumulates access to data of 12 business systems,namely PMS system,online monitoring system,live detection system,EMS system,meteorological information system,GIS system,Shandong power grid lightning intelligent monitoring system,substation intelligent inspection robot system,and UAV inspection system,fault recording system,reliability system and reactive power management system.The system mainly analyzes,designs and implements five major businesses:data management,load assessment,status evaluation,fault prediction and risk assessment.Among them,data management is used to implement and manage source system address,grid operation,grid environment,data cleaning,data preprocessing,status information source,comprehensive display,data model,lost data supplementation,data conversion management,data quality evaluation indicators,etc.Load evaluation is used to implement equipment load rate analysis,load capacity assessment,and load capacity prediction.The state evaluation is mainly to realize the regular state evaluation,the differential threshold,the rapid evaluation,and the equipment differentiation evaluation.Fault prediction can realize substation equipment fault prediction,fault prediction process,substation equipment fault prediction statistics,and transmission line fault prediction.The risk assessment enables current and historical load monitoring,load capacity assessment,and load capacity forecasting.The application of the system can realize the standardized conversion of data related to power transmission and transformation status assessment,realize cross-platform interactive sharing of related data such as live detection,online monitoring,routine test,inspection,power grid operation and environmental meteorology,and enhance the efficiency of status assessment of power transmission and transformation equipment.