Realization method of scada historical data distributed storage for power grid

A technology for distributed storage and historical data, applied in the field of SCADA historical data distributed storage, it can solve the problems of inability to meet the needs of mass data storage and efficient access, and achieve good scalability.

Active Publication Date: 2016-08-10
CHINA ELECTRIC POWER RES INST +2
View PDF5 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] SCADA historical data comes from the sampling of real-time data points of SCADA applications. Under the trend of gradually connecting the power grid, the scale of the power grid will become larger and larger, and the historical SCADA data will increase exponentially to reach a massive amount. The existing commercial relationship database will Unable to meet massive data storage and efficient access requirements

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Realization method of scada historical data distributed storage for power grid
  • Realization method of scada historical data distributed storage for power grid
  • Realization method of scada historical data distributed storage for power grid

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0025] The specific implementation manners of the present invention will be further described in detail below in conjunction with the accompanying drawings.

[0026] The distributed storage of SCADA historical data for large power grids uses a distributed, column-oriented, high-reliability, high-performance, scalable, and versioned open source database Hbase to store SCADA historical sampling data. SCADA historical sampling data is characterized by a large amount of data and time stamps, which coincides with HBase distributed storage and time stamps. The HBase table structure is different from the relational database table structure. The logical view is as follows figure 1 As shown, although Hbase still stores data in the form of a table, the columns are divided into several column families (column family), and the index of the table is row key, column key and timestamp. In addition, HBase does not support the SQL language, nor does it have batch write and query interfaces. ...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention discloses a realizing method of supervisory control and data acquisition (SCADA) history data distribution-type storage facing a power grid. A front-arranged server collects power data in real time, assembles the data into messages, and sends the messages to a bus; each application server reads the respectively subscribed messages, and data obtained through analysis are placed in a real-time database; and the data in the real-time database are updated continuously, and the data in different service types are stored into an open-source distribution-type database in a batch mode with different sampling frequencies. The realizing method adopts the SCADA history data distribution-type storage, has the advantages of achieving rapid inquiry and analysis capacity of big data, supporting multi-copy fault tolerance, supporting distribution-type calculation and the like, and has good expansibility.

Description

technical field [0001] The invention belongs to the technical field of electric power system control, and in particular relates to a method for realizing distributed storage of SCADA historical data facing a power grid. Background technique [0002] SCADA historical data comes from the sampling of real-time data points of SCADA applications. Under the trend of gradually connecting the power grid, the scale of the power grid will become larger and larger, and the historical SCADA data will increase exponentially to reach a massive amount. The existing commercial relationship database will It cannot meet the requirements of massive data storage and efficient access. Contents of the invention [0003] Aiming at the deficiencies of the prior art, the present invention provides a method for realizing distributed storage of SCADA historical data facing the power grid, which supports distributed storage and reverse query of massive scada historical data, and has good expansibilit...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Patents(China)
IPC IPC(8): G06F17/30
Inventor 闫湖李立新狄方春袁荣昌戴娇文杰
Owner CHINA ELECTRIC POWER RES INST
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products