Research on Improving Intelligent Inspection Efficiency of Substation Based on Big Data Analysis

The integration of big data analysis technology into the state monitoring of substation equipment can improve the utilization rate of state monitoring data, information sharing and data analysis ability. In this paper, three distributed data analysis schemes, namely Hive relational online analysis (ROLAP), Impala relational online analysis (ROLAP) and HBase multidimensional online analysis (MOLAP), were proposed based on the business development requirements of power system and the storage performance and analysis efficiency of traditional state monitoring platform. The experimental results show that the data loading speed is slower than the conventional model, but the roll-up performance and storage overhead are better than the conventional mathematical model. The load time is approximately 1.7 to 1.9 times that of the regular data model. The validity and feasibility of the model are verified by experiments.