Secondary equipment big data storage and processing method by utilizing cloud computing technology

Abstract

The invention is to provide a mass historical data storage and processing method for carrying out centralized storage, unified management and parallel computing on mass process monitoring data generated by secondary equipment of an electric power system protection device, a fault filter, an automatic safety device, an integrated automation system and an operational power supply system and the like by utilizing the cloud computing technology. A unified storage standard is formed for the data of process inspection data, equipment defect data, equipment state log and patrol inspection data and the like by utilizing the cloud computing technology; and condition query and parallel processing under the large-scale data are realized by adopting a distributed computation frame. The method realizes storage of whole database-oriented long-period and structured secondary equipment historical data, meets the requirements of an electric system for the aspects of storage capacity, data writing speed, query efficiency and system expansibility, and provides powerful support for analysis and excavation of the mass historical data of the secondary equipment.

Description

technical field [0001] The invention relates to the interdisciplinary research field of computer technology and electric power, and specifically proposes a storage and processing method for secondary equipment historical monitoring big data for electric power systems. Background technique [0002] With the development of microcomputer and communication technology, traditional metering equipment has gradually faded out of the power system. At present, most power companies still adopt a professional division of labor system for the management of secondary equipment, such as protection devices, fault filters, safety automatic The device is managed by the protection team, the comprehensive automatic system is managed by the telecontrol team, and the operating power system is managed by the DC team. The management of equipment data and information cannot be shared, which makes the operation and maintenance personnel only familiar with their own professional aspects, but they know...

AI Technical Summary

Problems solved by technology

For data that is relatively long from the current time, it is often backed up as a file and stored offline, which has a great impact on the availability of historical data

[0006] 3) Query efficiency issues under large-scale data

In the experiment, it is found that in the query of large-scale data, the performance of relational database will deteriorate with the increase of data size

Thousands of measuring points will generate tens of millions of records in a day's operation. If you record all the data of several months and years in the database and execute conditional query, the query will take tens of minutes or even hours. This kind of query performance Unacceptable in advanced application scenarios especially related to ad hoc queries

[0007] At present, there is no information storage and processing system for power systems covering various professional secondary equipment in China. It is urgent to establish a scalable, large-capacity, high-performance comprehensive information storage and processing system for the massive historical monitoring data of secondary equipment. platform

Images