Research on Big Data Query Optimization Method of Power System Substation Equipment Condition Monitoring | IEEE Conference Publication | IEEE Xplore

Research on Big Data Query Optimization Method of Power System Substation Equipment Condition Monitoring


Abstract:

In order to solve the problem of long query time caused by high cost of non-row key data query, an optimization method for big data query of power system substation equip...Show More

Abstract:

In order to solve the problem of long query time caused by high cost of non-row key data query, an optimization method for big data query of power system substation equipment condition monitoring is designed. According to the architecture of cloud computing platform, the distributed storage database of monitoring data is established to provide storage layer support for big data analysis. According to the association rules of multivariate time series, the attribute support is calculated, the key parameters of online monitoring data are extracted, and the parallel association algorithm of multi-source data is designed to transform multi-source data into local data structure. Based on the coprocessor, the secondary index is established to optimize the query of the row key data and non-row key data. The experimental results show that compared with the existing query methods, the big data query optimization method proposed in this paper has higher real-time performance, effectively reduces the query time of substation equipment status, and is suitable for power system substation equipment status monitoring.
Date of Conference: 18-21 July 2021
Date Added to IEEE Xplore: 02 December 2021
ISBN Information:
Conference Location: Chengdu, China

I. Introduction

Under the "overhaul" system of State Grid Corporation of China, an integrated power transmission and transformation condition monitoring and evaluation platform supporting fault diagnosis, condition assessment, condition base maintenance and other applications must be established. In order to ensure the safe and reliable operation of power equipment and meet the needs of smart grid for the whole life cycle management of power equipment, the working state and life of power equipment are evaluated, and the faults are analyzed, judged and predicted. The status information of power equipment is the data base for the application of status monitoring, evaluation and diagnosis of power equipment. In the unified provincial centralized substation condition monitoring and evaluation platform, due to the access to all kinds of equipment condition monitoring devices, the amount of state information data increases rapidly in geometric progression, and the types of data are gradually diversified. It includes not only real-time online condition monitoring data, but also offline information such as equipment basic information, test data, operation data, defect data, inspection record, live test data, etc., which gradually constitutes the big data of power equipment status information[1]. In the description of big data definition and characteristics, Gartner believes that big data generally has "3V" characteristics, namely volume, variety and velocity. IDC thinks it should have value, while IBM thinks it should add veracity. At present, when solving practical problems, other characteristics should be properly considered on the basis of grasping "3V" characteristics. Due to the huge amount of data, many kinds of data, high real-time requirements and low value density, the conventional data management and processing methods are difficult to meet the higher requirements of smart grid for fast query of substation equipment status information.

Contact IEEE to Subscribe

References

References is not available for this document.