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

Electric power automation communication overall process message quick storage and search method Download PDF

Info

Publication number
CN103678688B
CN103678688B CN201310734944.7A CN201310734944A CN103678688B CN 103678688 B CN103678688 B CN 103678688B CN 201310734944 A CN201310734944 A CN 201310734944A CN 103678688 B CN103678688 B CN 103678688B
Authority
CN
China
Prior art keywords
dimension
message
definite value
business
time
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN201310734944.7A
Other languages
Chinese (zh)
Other versions
CN103678688A (en
Inventor
黄春红
高俊彦
白小铮
钱金霞
郭熠昀
李达
王小辉
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
State Grid Corp of China SGCC
State Grid Fujian Electric Power Co Ltd
Xiamen Power Supply Co of State Grid Fujian Electric Power Co Ltd
Original Assignee
State Grid Corp of China SGCC
State Grid Fujian Electric Power Co Ltd
Xiamen Power Supply Co of State Grid Fujian Electric Power Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by State Grid Corp of China SGCC, State Grid Fujian Electric Power Co Ltd, Xiamen Power Supply Co of State Grid Fujian Electric Power Co Ltd filed Critical State Grid Corp of China SGCC
Priority to CN201310734944.7A priority Critical patent/CN103678688B/en
Publication of CN103678688A publication Critical patent/CN103678688A/en
Application granted granted Critical
Publication of CN103678688B publication Critical patent/CN103678688B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/90Details of database functions independent of the retrieved data types
    • G06F16/93Document management systems
    • HELECTRICITY
    • H02GENERATION; CONVERSION OR DISTRIBUTION OF ELECTRIC POWER
    • H02JCIRCUIT ARRANGEMENTS OR SYSTEMS FOR SUPPLYING OR DISTRIBUTING ELECTRIC POWER; SYSTEMS FOR STORING ELECTRIC ENERGY
    • H02J13/00Circuit arrangements for providing remote indication of network conditions, e.g. an instantaneous record of the open or closed condition of each circuitbreaker in the network; Circuit arrangements for providing remote control of switching means in a power distribution network, e.g. switching in and out of current consumers by using a pulse code signal carried by the network

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • General Business, Economics & Management (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Power Engineering (AREA)
  • Remote Monitoring And Control Of Power-Distribution Networks (AREA)

Abstract

The present invention relates to soft message tranmission techniques in a kind of power system, particularly a kind of electric power automation communication overall process message quick storage and search method, storage is optimized to the real-time telemechanical message flow of multichannel magnanimity of remittance and the data processing method of quick-searching is supported, the quick multipoint positioning that query message is realized from multiple dimensions, including management dimension can be realized(Transforming plant apparatus), business dimension, time dimension.To eliminate the difference between Telecontrol Protocol, meet the requirement of telemechanical business diagnosis granularity, abstract representations are carried out to business dimension, the content of business dimension is stated with service primitive, these service primitives do not have coherence with specific Telecontrol Protocol, therefore referred to as primitive, its sign is simple, blunt, it should be readily appreciated that, and do not constrained by specific Telecontrol Protocol, without being parsed and being changed again, processing is convenient, realizes efficient, object-oriented, supports the magnanimity message flow memory technology of High Performance Data Query positioning;Realize the fast search matching positioning function based on service primitive.

Description

Electric power automation communication overall process message quick storage and search method
Technical field
The present invention relates to soft message tranmission techniques in a kind of power system, particularly a kind of electric power automation communication overall process Message quick storage and search method.
Background technology
The integral technology support system of area regulation and control(Hereinafter referred to as regulator control system)Do not have a power failure with Power electric computer protection device whole Fixed and verification stabilization system(Hereinafter referred to as stabilization system)It is the important technology support system of power generation, but due to monitoring management The electric power safety production constraint of object (relay protection devices), and body types diversity and complexity, make information access debug work Time restriction is not only faced, and debugging efforts are abnormal cumbersome in itself so that and system operation maintenance workload pressure is big.For with The joint debugging of stabilization system is closed, the related relay protection devices of joint debugging need to enter maintenance state, and regulator control system directly adopts direct sending using soft message Mode, monitoring information is directly obtained from substation secondary device body, and main website telecontrol communication machine(Control centre)To realize transformer station Monitoring in real time is, it is necessary to the message flow of the numerous transformer station's telecontrol communication machine of collecting quantity and transformer station measurement and control device in real time, due to collection Number of objects it is many, monomer information transmission speed is fast, the diversity and complexity of soft message mode, and link is passed through in communication It is many, be related to that stipulations are more, directly result in the message flow enormous amount of main website telecontrol communication machine processing, retrieval is time-consuming, cumbersome.
The content of the invention
It is an object of the invention to overcome the deficiencies in the prior art part, and propose a kind of logical suitable for Operation of Electric Systems Interrogate the electric power automation communication overall process message quick storage and search method of specification.
Message quick storage method of the present invention is realized by following approach:
Electric power automation communication overall process message quick storage method, it is characterized by, and comprises the following steps:
1)Packet storage system is provided, its dimension supported has management dimension, business peacekeeping time dimension, management dimension includes power transformation Dimension of standing and device dimension are the information of transformer station and apparatus and are associated;Time dimension then represents the time number of message transmission According to;And business dimension is presented as service primitive, primitive item, which includes, to be surpassed 30% remote measurement increment, surpasses 60% remote measurement increment, surpasses 90% remote measurement increasing When amount, remote signalling displacement, SOE displacements, school, the calling of alarm event, action event, definite value, definite value calling return, it is dress under definite value, fixed The lower dress of value is returned to school, definite value solidifies, definite value solidification is returned to school, definite value area is called, the calling of definite value area is returned, pressing plate is called, pressing plate calling Dress is returned to school, pressing plate changes solidification under return, the lower dress of pressing plate modification, pressing plate, 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 Dimensional tissue saves as flowing document;
3)The protocol type that inside documents are set according to collection telecontrol channel is flowed, using correspondence stipulations resolution logic, with industry Business dimension carries out the segmentation of message flow, 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, table row are set up It is made up of major key anchor point ID, stream document name, section point position;Next sets up a positioning concordance list, and the table is arranged by foreign key reference Anchor point ID, transformer station, device, time, service primitive are constituted, in step 3)Retrieval anchor point table is safeguarded while process, is determined The row information of position index table, and store into packet storage system, the optimization for completing electric power automation communication overall process message is deposited Storage.
Method for quickly retrieving of the present invention, it is characterized by, and comprises the following steps:
1)A kind of packet storage system as described above 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;
2)Inquired about by sql sentences【Position concordance list】Obtain the anchor point ID set for the condition that meets(Can be with multirow), then Pass through【Retrieve anchor point table】Physical streams document name and the field offset position for meeting querying condition are obtained, realization is quickly navigated to Meet the source messages original position of querying condition.
Electric power automation communication overall process message quick storage and search method of the present invention, to the multichannel sea of remittance Measure real-time telemechanical message flow to optimize storage and support the data processing method of quick-searching, can realize and be realized from multiple dimensions The quick multipoint positioning of query message, supporting the dimension of query composition has management to tie up(Transformer station-device), business dimension, time dimension. This method meets the requirement of telemechanical business diagnosis granularity to eliminate the difference between Telecontrol Protocol, and abstract representations are carried out to business dimension, State the content of business dimension with service primitive, these service primitives and specific Telecontrol Protocol do not have a coherence, therefore and Referred to as primitive.Described service primitive characterizes simple, blunt, it is easy to understands, and is not constrained by specific Telecontrol Protocol, nothing It need to be parsed and be changed again, processing is convenient, realized efficient, object-oriented, support the magnanimity message of High Performance Data Query positioning Flow memory technology;And, can be in magnanimity by the tissue storage method based on power automation Standards Code service primitive In recorded message, the fast search matching positioning function based on service primitive is realized.
Brief description of the drawings
Fig. 1 show electric power automation communication overall process message quick storage of the present invention and the flow of search method is shown It is intended to.
The present invention is described further below according to embodiment.
Embodiment
Most preferred embodiment:
Electric power automation communication overall process message quick storage and search method of the present invention, include quick storage Method and the search method based on quick storage, it meets the operating analysis and assessment of electric power automation communication overall process, compatible The telecontrol communication specifications such as IEC 870-5-104, IEC 870-5-103 and IEC61850.Described quick storage and retrieval side Method is all based on service primitive and carried out, be a kind of real-time telemechanical message flow of the multichannel magnanimity to remittance optimize storage and The data processing method of quick-searching is supported, the quick multipoint positioning that query message is realized from multiple dimensions, support group can be realized Closing the dimension of inquiry has management to tie up(Transformer station-device), business dimension, time dimension.This method is the difference between elimination Telecontrol Protocol, The requirement of telemechanical business diagnosis granularity is met, taking out under business dimension there are following items, and these projects do not have with specific Telecontrol Protocol There are coherence, referred to as primitive.Primitive includes: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.
Referring to the drawings 1, the electric power automation communication overall process packet optimization storage method comprises the following steps:
Step 1, with winpcap or libpcap technologies, filtering rule is set, passes through interchanger shared port and obtains and hand over Mutual message.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(1 power transformation Stand)And time dimension(1 day, year-month-day)Tissue storage is stream document;
Step 2, the message according to intercepting and capturing, the protocol type that stream inside documents are set using collection telecontrol channel(IEC 870-5-104, IEC 870-5-103 or IEC61850), using correspondence stipulations resolution logic, tieed up with business and carry out message flow Segmentation, and analyze the device information for extracting service message section association, service primitive, time(When-point-second);
Step 3, first using [stream document-section point] Macintosh as retrieval anchor point, set up a retrieval anchor point table, should Table is arranged by anchor point ID(Major key), stream document name, section point position constitute;Next sets up a positioning concordance list, and the table is arranged by fixed Site ID(Foreign key reference), transformer station, device, the time(During year-month-day-point-second), service primitive constitute.During step 2 Retrieval anchor point table is safeguarded simultaneously, the row information of concordance list is positioned, and the optimization for completing electric power automation communication overall process message is deposited Storage.
The method for quickly retrieving of electric power automation communication overall process message, comprises the following steps:
Step 1, searcher's input query composition condition:Transformer station(Can be with final election), device(Can be with final election), the time(With During year-month-day-point-second form describes the period), business dimension(All service primitives, can be with final election);
Step 2, inquired about by sql sentences【Position concordance list】Obtain the anchor point ID set for the condition that meets(Can be many OK), then pass through【Retrieve anchor point table】Physical streams document name and the field offset position for meeting querying condition are obtained, thus may be used The source messages original position for meeting querying condition is quickly navigated to realize(Multiple spot).
The not described part of the present invention is 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.
CN201310734944.7A 2013-12-27 2013-12-27 Electric power automation communication overall process message quick storage and search method Active CN103678688B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201310734944.7A CN103678688B (en) 2013-12-27 2013-12-27 Electric power automation communication overall process message quick storage and search method

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201310734944.7A CN103678688B (en) 2013-12-27 2013-12-27 Electric power automation communication overall process message quick storage and search method

Publications (2)

Publication Number Publication Date
CN103678688A CN103678688A (en) 2014-03-26
CN103678688B true CN103678688B (en) 2017-09-29

Family

ID=50316232

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201310734944.7A Active CN103678688B (en) 2013-12-27 2013-12-27 Electric power automation communication overall process message quick storage and search method

Country Status (1)

Country Link
CN (1) CN103678688B (en)

Families Citing this family (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103995676A (en) * 2014-06-16 2014-08-20 国家电网公司 Data storage method and device and data processing method and device
CN104090939A (en) * 2014-06-30 2014-10-08 国家电网公司 Storage and quick indexing method for mass data of intelligent substation
CN104516953B (en) * 2014-12-12 2016-03-09 国家电网公司 A kind of black box subsystem for power dispatching automation magnanimity message
CN105049275B (en) * 2015-05-28 2020-09-04 国家电网公司 Method for seamlessly importing substation configuration to network analyzer
CN106557550B (en) * 2016-10-24 2020-06-16 珠海许继电气有限公司 Method and device for realizing rapid storage, retrieval and completion of self-description fixed-point records of power distribution terminal
WO2019033416A1 (en) * 2017-08-18 2019-02-21 Oppo广东移动通信有限公司 Wireless communication method, terminal device, and network device
CN111313542A (en) * 2019-11-12 2020-06-19 山东网聪信息科技有限公司 System and method for power grid 103 protocol information simulation and telemechanical information rapid check

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
EP0829977A2 (en) * 1996-09-13 1998-03-18 Philips Patentverwaltung GmbH RDS-TMC radio receiver for processing specific regional and transregional road region notations
CN101908176A (en) * 2010-08-02 2010-12-08 国电南瑞科技股份有限公司 Method for modeling on basis of power information data and applying metadata management
CN103220171A (en) * 2013-04-08 2013-07-24 嘉兴电力局 Digital substation message analyzer

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
EP0829977A2 (en) * 1996-09-13 1998-03-18 Philips Patentverwaltung GmbH RDS-TMC radio receiver for processing specific regional and transregional road region notations
CN101908176A (en) * 2010-08-02 2010-12-08 国电南瑞科技股份有限公司 Method for modeling on basis of power information data and applying metadata management
CN103220171A (en) * 2013-04-08 2013-07-24 嘉兴电力局 Digital substation message analyzer

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
供应 TH-600电力远动报文规约分析仪;西安拓航电子科技有限公司;《http://tuohang.qiugouxinxi.net/detail_gy-38067643.htm》;20130813;第1页第1-6段、第2页第1-3段 *
基于Lucene的电力企业信息全文搜索系统的设计和实现;何霞;《中国优秀硕士学位论文全文数据库信息科技辑》;20091015(第10期);第46-49页、图5-5-图5-7 *

Also Published As

Publication number Publication date
CN103678688A (en) 2014-03-26

Similar Documents

Publication Publication Date Title
CN103678688B (en) Electric power automation communication overall process message quick storage and search method
CN104065163B (en) Delivery method on a kind of intelligent substation warning information
CN102426525B (en) Panoramic modeling method of multi-application system
CN106026405A (en) Relay protection on-line monitoring and analyzing system based on EMS system
CN105787089A (en) Power distribution network scheduling foundation data integrating method
US10706062B2 (en) Method and system for exchanging data from a big data source to a big data target corresponding to components of the big data source
CN103779962A (en) Intelligent telecontrol machine based method for converting 61850 model to CIM model
CN103618620A (en) Front-end processor system of multi-layer structure
CN104201779B (en) A kind of online monitoring data based on SVG is automatically integrating monitoring method
CN109542750A (en) Distributed information log system
CN109617970A (en) A kind of intelligent things netting index based on mode of wireless transmission adopts instrument
CN102437644A (en) Distribution transformer long-distance monitoring system based on GPRS (general packet radio service)
CN103227511A (en) On-line monitoring station end integrated processing system of transformer station
CN106300662A (en) The secondary device on-line monitoring and fault diagonosing system merged based on information physical
CN201429790Y (en) Punching-machine remote monitoring device
CN103716306B (en) Transformer station and the seamless communication method of scheduling station
CN103310022A (en) Protection setting value on-line tracking system and method
CN202231496U (en) Remote monitoring and diagnostic system of transformer substation device
CN109713791B (en) Diagnostic method for remote control command abnormity of smart power grid
CN103633736B (en) From the on-line monitoring communication means of power transformation substation to main website
CN103383649A (en) Design model of complex virtual instrument system
CN202364244U (en) Processing device of distributed log analysis system
CN116401605A (en) Power failure waveform judging system and method
CN204496672U (en) Based on the gas alarm instrument system of Internet of Things
CN113659712A (en) Power equipment big data label operation platform and method

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant