Design and implementation of digital big data analysis platform based on substation maintenance full link

In view of the situation that the maintenance data of substation equipment in the process of maintenance are scattered, the operation is excessively dependent on labor, and the cost of on-site safety control is high, a digital big data analysis platform based on the whole link of substation maintenance is proposed. Firstly, the human and material information involved in the overhaul of substation equipment is analyzed, the subject of overhaul data is determined, and the data warehouse is established. Secondly, the design of ETL, the original system data, through the extraction, verification, deweighting, loading and other steps, uniform aperture in Hive data integration completed; Then, the data Cube building engine Cube based on Apache Kylin is designed and implemented. Finally, the computing performance of Cube is optimized, and the incremental construction method of Cube is proposed to ensure the real-time performance of data in Cube. The system can reduce the identification rate of data chimney, bad data and wrong parameters, which is conducive to restoring the true working state of the power system, ensuring the accuracy of decision-making, and improving the ability of safe and stable operation of the power system.