CN103678688B - Electric power automation communication overall process message quick storage and search method - Google Patents

Abstract

The invention relates to a soft message transmission technology in a power system, in particular to a method for fast storage and retrieval of messages in the whole process of electric power automation communication, which optimizes storage and supports fast retrieval of imported multi-channel massive real-time telecontrol message streams The unique data processing method can realize fast multi-point positioning of query messages from multiple dimensions, including management dimension (substation-device), business dimension, and time dimension. In order to eliminate the differences between telecontrol protocols and meet the requirements of telecontrol business analysis granularity, the business dimension is abstractly expressed, and the content of the business dimension is expressed in terms of business primitives. These business primitive items have no correlation with the specific telecontrol protocol , so it is called a primitive, its representation is simple, straightforward, easy to understand, and is not bound by specific telecontrol protocols, no need to analyze and convert, easy to process, and realizes high efficiency, object-oriented, high-performance support Massive message flow storage technology for query and location; realize fast search, matching and location functions based on business primitives.

Description

Fast storage and retrieval method of messages in the whole process of electric power automation communication

technical field

The invention relates to a soft message transmission technology in an electric power system, in particular to a method for quickly storing and retrieving messages in the whole process of electric power automation communication.

Background technique

The integrated technical support system for regional regulation (hereinafter referred to as the regulation system) and the power microcomputer protection device non-stop setting and verification value system (hereinafter referred to as the value system) are important technical support systems for power production, but due to the monitoring and management objects (relay protection equipment ) power safety production constraints, as well as the diversity and complexity of ontology types, not only make the information access and debugging work face time constraints, but also the debugging work itself is extremely cumbersome, which makes the system operation and maintenance workload heavy. In order to cooperate with the joint debugging of the fixed value system, the relay protection equipment related to the joint debugging needs to enter the maintenance state. The control system adopts the method of direct acquisition and direct delivery of soft messages, and directly obtains monitoring information from the secondary equipment body of the substation, while the main station remote machine (control Center) In order to realize real-time monitoring of substations, it is necessary to collect the message flow of a large number of substation remote machines and substation measurement and control devices in real time. Due to the large number of collected objects, the speed of single information transmission is fast, and the diversity and complexity of soft message methods , and there are many communication links and protocols involved, which directly lead to a huge number of message streams processed by the remote machine of the master station, and the retrieval is time-consuming and cumbersome.

Contents of the invention

The purpose of the present invention is to overcome the deficiencies of the prior art, and propose a method for fast storage and retrieval of messages in the whole process of electric power automation communication applicable to electric power system telecontrol communication norms.

The message fast storage method described in the present invention is realized by the following approach:

The key point of the method for quickly storing messages in the whole process of electric power automation communication is that it includes the following steps:

1) Provide a message storage system, which supports the management dimension, business dimension and time dimension. The management dimension includes the substation dimension and the device dimension, which is the information and association between the substation and equipment; the time dimension represents the time data of message transmission ; while the business dimension is embodied as business primitives, primitive items include over 30% telemetry increment, over 60% telemetry increment, over 90% telemetry increment, remote signaling displacement, SOE displacement, timing, and alarm events , action event, fixed value call, fixed value call return, fixed value download, fixed value download back to school, fixed value solidification, fixed value solidification back to school, fixed value area call, fixed value area call return, press plate call, press plate Call back, press plate modification and download, press plate download and return to school, press plate modification and solidification, press plate solidification and modification and return to school;

2) The remote machine of the main station collects and imports massive real-time telecontrol message streams from multiple substations, organizes and stores them as stream documents in the substation dimension and time dimension;

3) In the flow document, according to the protocol type set by the collection telecontrol channel, use the corresponding protocol analysis logic to segment the message flow in the business dimension, and analyze and extract the device information, business primitives, and time associated with the business message segment ;

4) First, use the combination key [flow document-segment point] as the search anchor point to create a search anchor point table, which is composed of the primary key anchor point ID, stream document name, and segment point position; secondly, create a positioning index Table, the table is composed of foreign key reference anchor point ID, substation, device, time, and business primitives. During the process of step 3), maintain and retrieve the row information of the anchor point table and the anchor index table, and store them in the message storage In the system, the optimized storage of messages in the whole process of electric power automation communication is completed.

The quick retrieval method of the present invention, its gist is, comprises the following steps:

1) Provide a message storage system as described above, input combined query conditions, including substation dimension, device dimension, time dimension and business dimension expressed in business primitive language, the above query conditions are one or more;

2) Query the [Positioning Index Table] through the sql statement to obtain the set of positioning point IDs that meet the conditions (multiple rows are allowed), and then obtain the physical flow document name and segment offset position that meet the query conditions through the [Retrieve Positioning Point Table] to achieve Quickly locate the starting position of the source message that meets the query condition.

The method for quickly storing and retrieving messages in the whole process of electric power automation communication described in the present invention is a data processing method that optimizes storage of imported multi-channel massive real-time telecontrol message streams and supports fast retrieval, and can realize realization from multiple dimensions Fast multi-point positioning of query messages, the dimensions that support combined queries include management dimension (substation-device), business dimension, and time dimension. In order to eliminate the differences between telecontrol protocols and meet the requirements of telecontrol business analysis granularity, this method abstracts the business dimension and expresses the content of the business dimension with business primitives. These business primitive items are not related to the specific telecontrol protocol. coherence, and are therefore called primitives. The business primitives described above are simple, straightforward, easy to understand, and are not restricted by specific telecontrol protocols. They do not need to be parsed and converted, and are easy to process. They realize efficient, object-oriented, and high-performance query and positioning support. Message flow storage technology; and through the organization and storage method based on the power automation standard specification business primitives, the rapid search, matching and positioning function based on business primitives can be realized in a large number of recorded messages.

Description of drawings

Fig. 1 is a schematic flow chart of the method for fast storing and retrieving messages in the whole process of electric power automation communication according to the present invention.

The present invention will be further described below according to specific embodiments.

detailed description

Best practice:

The method for fast storage and retrieval of messages in the whole process of electric power automation communication includes a fast storage method and a retrieval method based on fast storage, which satisfies the operation analysis and evaluation of the whole process of electric power automation communication, and is compatible with IEC 870-5- 104, IEC 870-5-103, and IEC61850 and other telecontrol communication specifications. The fast storage and retrieval methods described above are all based on business primitives, and are a data processing method that optimizes storage and supports fast retrieval of imported multi-channel massive real-time telecontrol message streams, and can realize data processing from multiple This dimension realizes fast multi-point positioning of query messages, and the dimensions that support combined query include management dimension (substation-device), business dimension, and time dimension. In order to eliminate the differences between telecontrol protocols and meet the granularity requirements of telecontrol business analysis, this method abstracts the following items under the business dimension. These items have no correlation with specific telecontrol protocols and are called primitives. Primitive language items include: over 30% telemetry increment, over 60% telemetry increment, over 90% telemetry increment, telemetry displacement, SOE displacement, time calibration, alarm event, action event, fixed value call, fixed value Value call return, fixed value download, fixed value download back to school, fixed value solidification, fixed value solidification back to school, fixed value area call, fixed value area call return, pressure plate call, pressure plate call return, pressure plate modification download, pressure plate Download and return to school, press plate modification and curing, press plate curing modification and return to school.

With reference to accompanying drawing 1, described electric power automation communication whole process message optimization storage method, comprises the steps:

Step 1. Use winpcap or libpcap technology to set filtering rules and obtain interactive packets through the shared port of the switch. The remote machine of the master station collects and imports massive real-time telecontrol message streams from multiple substations, organizes and stores them as stream files in the substation dimension (1 substation) and time dimension (1 day, year-month-day);

Step 2. According to the intercepted message, the protocol type (IEC870-5-104, IEC 870-5-103, or IEC61850) set by the collection telecontrol channel is used inside the flow document, and the corresponding protocol analysis logic is used to report in the business dimension. Segmentation of the text flow, and analyze and extract the device information, business primitives, and time (hour-minute-second) associated with the business message segment;

Step 3. First, use the combination key [flow document-segment point] as the search anchor point to create a search anchor point table, which is composed of anchor point ID (primary key), stream document name, and segment point position; A location index table, which is composed of location point ID (foreign key reference), substation, device, time (year-month-day-hour-minute-second), and business primitives. In the process of step 2, the row information of the search positioning point table and the positioning index table are maintained at the same time, and the optimized storage of the messages in the whole process of electric power automation communication is completed.

The method for quickly retrieving messages in the whole process of electric power automation communication includes the following steps:

Step 1. The searcher enters combined query conditions: substation (multiple selection is possible), device (multiple selection is possible), time (time period is described in the form of year-month-day-hour-minute-second), business dimension (all business primitives , can be selected);

Step 2. Use the sql statement to query the [location index table] to obtain the set of location point IDs that meet the conditions (multiple rows are allowed), and then use the [retrieve location point table] to obtain the physical flow file name and segment offset position that meet the query conditions. In this way, the starting position (multi-point) of the source message that meets the query condition can be quickly located.

The parts not described in the present invention are the same as the prior art.

Claims (2)

1. electric power automation communication overall process message quick storage method, it is characterised in that comprise the following steps：

1）Packet storage system is provided, its dimension supported has management dimension, business peacekeeping time dimension, management dimension includes transformer station's dimension Degree and device dimension are the information of transformer station and apparatus and are associated；Time dimension then represents the time data of message transmission；And Business dimension is presented as service primitive, primitive item include surpass 30% remote measurement increment, surpass 60% remote measurement increment, surpass 90% remote measurement increment, it is distant When believing displacement, SOE displacements, school, alarm event, action event, definite value are called, definite value is called and filled under return, definite value under dress, definite value Return to school, definite value solidification, definite value solidification return to school, definite value area calling, definite value area calling return, pressing plate calling, pressing plate calling return, pressure Dress is returned to school under the lower dress of plate modification, pressing plate, pressing plate changes solidification, pressing plate solidification modification is returned to school；

2）The real-time telemechanical message flow of multiple transformer station's magnanimity that main website telecontrol communication machine collection is imported, with transformer station's dimension and time dimension group Knit and save as flowing document；

3）The protocol type that inside documents are set according to collection telecontrol channel is flowed, using correspondence stipulations resolution logic, is tieed up with business The segmentation of message flow is carried out, and analyzes the device information for extracting service message section association, service primitive, time；

4）First using [stream document-section point] Macintosh as retrieval anchor point, a retrieval anchor point table is set up, the table is arranged by leading Key anchor point ID, stream document name, section point position are constituted；Next sets up a positioning concordance list, and the table is arranged to be positioned by foreign key reference Point ID, transformer station, device, time, service primitive are constituted, in step 3）Retrieval anchor point table, positioning rope are safeguarded while process Draw the row information of table, and store into packet storage system, complete the optimization storage of electric power automation communication overall process message.

2. electric power automation communication overall process message method for quickly retrieving, it is characterised in that comprise the following steps：

A kind of packet storage system as claimed in claim 1 is provided, query composition condition, including transformer station's dimension, dress is inputted The business put dimension, time dimension and stated with service primitive is tieed up, and above-mentioned querying condition is one or more；

Inquired about by sql sentences【Position concordance list】The anchor point ID set for the condition that meets is obtained, then is passed through【Retrieve anchor point Table】Physical streams document name and the field offset position for meeting querying condition are obtained, realization quickly navigates to the source for meeting querying condition Start of message (SOM) position.