Substation historical data unified storage method and system

Abstract

The invention provides a substation historical data unified storage method and system. The method comprises the steps that a proxy server is adopted to extract storage objects in relevant systems of substations; the storage objects are subjected to structured processing; and data obtained after structured processing is stored into a storage server cluster. Through the substation historical data unified storage method and system, permanent storage of historical data and files is realized, the limitation on storage capacity of a cache library is avoided, and the requirement of defect data statistical analysis of all manufacturer devices or equipment of all the substations in a region on mass data storage is met.

Description

technical field [0001] The invention belongs to the technical field of substation automation, and in particular relates to a method and system for unified storage of substation historical data. Background technique [0002] With the construction of the smart grid, the scale of the grid is getting bigger and bigger, and the research and application of digital grids and digital substations are deepening, and the system is facing more and more collection points. The collection volume of a medium-sized area can reach 20,000 to 100,000, while a large-scale survey may face a data collection scale of 500,000 to 1 million in the future. The preliminary estimate of one-year data will shift from the current gigabyte level to the terabyte level. In addition, with the continuous improvement of scheduling automation level, higher requirements are put forward for real-time operation data to be stored continuously according to actual time series instead of periodic sampling, so as to meet ...

AI Technical Summary

Problems solved by technology

Therefore, no matter in terms of writing speed or query efficiency, it is difficult to use conventional relational databases to store these unstructured and large amounts of historical information to meet the requirements of massive data storage and efficient access. Due to the limitation of massive historical data storage and access in substations, we are looking for a non-relational database solution based on a big data platform that can be used for networked distributed storage

[0003] At present, there are multiple sets of information systems in substations, such as data acquisition and monitoring system SCADA, protection information sub-station, PMU, equipment online monitoring system and traveling wave ranging system, etc. These systems are relatively independent, and there are repeated acquisitions, The problems of low utilization rate and difficult data sharing have caused serious waste of resources; on the other hand, due to the large differences in the historical data structures of the same type from different manufacturers, it is not conducive to unified storage, query and comprehensive analysis, and cannot meet the needs of all substations in a region. Defect data statistical analysis needs of all manufacturers’ devices or equipment, and the current master station lacks a unified storage method and corresponding management system for the historical data of all substations in a region. storage management system

Since there are hundreds of substations under the jurisdiction of a region, and the historical data stored in a substation after three years of operation reaches hundreds of gigabytes, conventional relational databases obviously cannot meet the above-mentioned requirements for massive data storage.

Images