CN104501848B - Data accessing method and system of substation equipment - Google Patents
Data accessing method and system of substation equipment Download PDFInfo
- Publication number
- CN104501848B CN104501848B CN201410738003.5A CN201410738003A CN104501848B CN 104501848 B CN104501848 B CN 104501848B CN 201410738003 A CN201410738003 A CN 201410738003A CN 104501848 B CN104501848 B CN 104501848B
- Authority
- CN
- China
- Prior art keywords
- data
- measuring point
- information
- converting equipment
- equipment
- 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
Links
Landscapes
- Data Exchanges In Wide-Area Networks (AREA)
- Selective Calling Equipment (AREA)
Abstract
The invention discloses a data accessing method and system of substation equipment. The data accessing method comprises the following steps: monitoring the substation equipment by each type of monitoring equipment to obtain measuring point information of measuring points of the substation equipment; converting the measuring point information of the measuring points into data with a uniform format; sending the data to message queues which correspond to all the substation equipment measuring points one by one, and storing; reorganizing the data from the message queues through a pre-set package rule according to a package format to obtain a target data package; sending target information of the obtained target data package to a real-time/historical database to be stored. The data accessing method and system can be used for uniformly managing the formats of the information of the equipment measuring points monitored by all the monitoring equipment of all factories; the data are stored according to requirements and the data redundancy is reduced.
Description
Technical field
The present invention relates to converting equipment on-line monitoring technique field is and in particular to a kind of data cut-in method of converting equipment
And system.
Background technology
At present, in order to ensure power grid security, stable, Effec-tive Function is it will usually carry out substation equipment condition monitoring, and will supervise
The equipment measuring point data measuring stores in real time/historical data base, is equipment fault early-warning and monitoring offer analytical data.?
In actual monitoring scene, because monitoring device comes from each producer and has various types of monitoring devices, the equipment monitoring is surveyed
The form of point information is inconsistent.And cannot dynamically intercept the equipment measuring point data of certain time period as requested.Cause
This, the various types of monitoring device that prior art is usually each producer separately designs interface server, and equipment measuring point data is carried out
Process；And will, all of equipment measuring point data all stores in real time/historical data base sequentially in time.But, by institute
Various with interface server quantity and type, lead to development cost higher.And in order to preserve armamentarium measuring point data, cause
Data bulk redundancy, takies memory space.
Content of the invention
For solving the deficiency that prior art exists, the invention discloses a kind of data cut-in method of converting equipment and be
System, the application achieves the consolidation form of the measuring point information of the converting equipment that all types of monitoring devices are monitored to each producer,
Store on demand, improve the efficiency of management, reduce memory space.
For achieving the above object, the concrete scheme of the present invention is as follows:
A kind of data cut-in method of converting equipment, comprises the following steps:
Step one: converting equipment is monitored obtain with the measuring point information of converting equipment by all types of monitoring devices；
Step 2: measuring point information is converted into the data of consolidation form, and sends the data to survey with each converting equipment
The one-to-one message queue of point is stored；
Step 3: by set in advance group of bag rule, reorganize data according to group bag form from message queue, obtain
To target data bag；
Step 4: the target information processing the target data bag obtaining is sent in real time/historical data base and is stored.
The measuring point information of the converting equipment that in described step one, all types of monitoring devices collect is passed by socket interface
Deliver to message queue.
Measuring point information in described step one includes oil dissolved gas information in converting equipment, shelf depreciation information, electric parameters
Information, winding deformation information, temperature information, online infrared imaging information etc..
In described step 2, in socket interface, the measuring point information integration of converting equipment measuring point is become key-value lattice
The data of formula.
In described step 2, the data is activation of consolidation form is given the one-to-one kafka of each converting equipment measuring point and disappears
Breath queue is stored.
Described socket interface obtains the measuring point information of the converting equipment that all types of monitoring devices collect particularly as follows: passing through
Socket interface periodically obtains the measuring point information of the converting equipment that all types of monitoring devices collect.
Described socket interface by one pre-set can dynamic regulation time window periodically obtain all kinds of
The measuring point information of the converting equipment that type monitoring device collects.
In described step 3, according to data set bag rule, the corresponding period data chosen in corresponding message queue is solved
Analysis, obtains the packet of equipment needed thereby, required time section according to group bag form.
Described group of bag form is made up of four partial data splicings: Part I data is data id, unique identification data；The
Two partial datas describe data for measuring point, describe data corresponding equipment measuring point information in this packet；Part III data is
Time segment data, describes the initial time of data and end time information in this packet；Part IV data is equipment measuring point
Data, this measuring point data comes from Part II measuring point and describes measuring point described by data, and comes from the Part III time period
The time period of data defined.
A kind of data insertion system of converting equipment, comprising:
Socket interface, for obtaining the measuring point information of the converting equipment that monitoring device monitors, and described measuring point is believed
Breath is integrated into the data of key-value form；
Message queue, the data for sending to described socket interface stores；
Interface server, for parsing to the data obtaining from described message queue, and according to group bag rule, to institute
State data to package, obtain described target data bag and export；
In real time/historical data base, the target data bag for sending to described interface server stores.
Beneficial effects of the present invention:
The measuring point information of the converting equipment by the monitoring device collection all types of to each producer obtaining for the application is carried out
Encapsulation, is obtained the data of key-value form, and stores that data into be entered in one-to-one message queue with equipment measuring point
Row storage it is ensured that measuring point information complete.Then, by set in advance group of bag rule, according to group bag lattice from message queue
Formula reorganizes data, obtains target data bag, target data bag is sent in real time/history data store.It is achieved thereby that
The uniform format management of the equipment measuring point information of all types of monitoring device monitorings to each producer, and data storage on demand, reduce
Data redundancy.
Brief description
Fig. 1 is a kind of flow chart of the embodiment of present invention converting equipment data cut-in method；
Fig. 2 is a kind of structural representation of the embodiment of present invention converting equipment data insertion system；
Fig. 3 is a kind of group bag form schematic diagram of present invention converting equipment data cut-in method.
Specific embodiment:
The present invention is described in detail below in conjunction with the accompanying drawings:
The embodiment of the invention discloses a kind of data cut-in method of converting equipment and system, all kinds of by obtaining each producer
The converting equipment measuring point measuring point information integration of type monitoring device collection becomes the data of key-value form, and by this data is activation
Give the one-to-one message queue of each equipment measuring point to be stored, thus ensure that the integrity of data.Then, according to data
Group bag rule, the corresponding time segment data chosen in corresponding message queue is parsed, and sets according to organizing needed for bag form obtains
The standby, packet of required time section, the target information that process is obtained is sent in real time/historical data base and is stored, thus
Avoid data redundancy, reduce memory space.
As shown in figure 1, being a kind of flow chart of the embodiment 1 of the data cut-in method of converting equipment of the present invention, the method
May include that
Step 1: obtain the converting equipment measuring point measuring point information that all types of monitoring device of each producer monitors.
Step 2: measuring point measuring point information is converted into the data of key-value form, and sends the data to and respectively set
The standby one-to-one message queue of measuring point is stored.
In the prior art, one-to-one interface server is to the change monitoring with each producer all types of monitoring device
Electric equipment measuring point measuring point information is processed one by one, and the target data after processing is sent in real time/historical data base
Stored.Thus, because the such as reason such as network failure is likely to result in the loss of data in transmission process, thus having influence on prison
Survey the integrity of data.In addition, the measuring point information with regard to monitored equipment usually exists in the form of metadata, occupy
Certain memory space.
In order to solve the above problems, the embodiment of the present invention can be by the change collecting monitoring devices all types of for each producer
The measuring point information of electric equipment changes into the data of key-value form, stores in message queue it is not necessary to enter to this measuring point information
Row is processed one by one, and interface server can obtain desired data from message queue, thus ensureing in real time/historical data base
Integrity to status data storage.Further, since measuring point status data is one-to-one with the message queue that it is stored,
So measuring point information need not be preserved, save memory space.
Preferably, the just mistake with your equipment measuring point measuring point information that all types of monitoring device of each producer of above-mentioned acquisition monitors
Journey, can be periodically obtain by socket interface that all types of monitoring device of each producer monitors just carry your to survey equipment
Point measuring point information.
Specifically, by socket interface often through one pre-setting, can dynamic regulation time window, obtain each
The measuring point information of the converting equipment that type monitoring device collects.
Wherein, in the embodiment of the present invention, message queue can select kafka message queue, its be current storage efficiency
High Distributed Message Queue.
Step 3: according to data set bag rule, the corresponding time segment data chosen in corresponding message queue is parsed, and presses
Obtain the packet of equipment needed thereby, required time section according to group bag form.
Wherein, describe to organize spatial dimension measuring point range information and the time model of bag data in data set bag rule
Enclose time segment information.Because measuring point and message queue are one-to-one it is only necessary to from corresponding message queue, according to
Time range is chosen data and is packaged.
Step 4: the target information that process is obtained is sent in real time/historical data base and is stored.
As shown in Fig. 2 being a kind of structural representation of the embodiment 1 of the data insertion system of converting equipment of the present invention, should
System may include that each producer all types of monitoring devices (in figure monitoring device jc1, monitoring device jc2, monitoring device
jc3... monitoring device jcnThe monitoring device all types of to represent each producer, wherein n be positive integer), socket interface, message team
Row (in figure message queue mq1, message queue mq2, message queue mq3... message queue mqnTo represent all types of with each producer
The one-to-one message queue of monitoring device, wherein n is positive integer) and real-time/historical data base.
Wherein, monitoring device is connected with converting equipment, for detecting the running status of converting equipment, obtains converting equipment
Measuring point information.
Socket interface is connected with monitoring device, for obtaining the measuring point information of the monitored converting equipment of monitoring device, and
This measuring point information integration is become the data output of key-value form.
Message queue, the data for sending over to socket interface stores, thus ensureing the complete of measuring point data
Whole property.
Wherein, this message queue can be kafka message queue.
In real time/historical data base, wraps regular spliced target information by message queue according to group for storage.
As shown in figure 3, being a kind of group bag form schematic diagram of present invention converting equipment data cut-in method, this group bag form
Including: data id, measuring point describe data, time segment data, equipment measuring point data.
Wherein, data id, unique identification data；Measuring point describes data, and the corresponding equipment of data in this packet that describes is surveyed
Point information；Time segment data, describes the initial time of data and end time information in this packet；Equipment measuring point data, by
Measuring point describes in data, with the time period of data description as time interval.
This measuring point data comes solely from measuring point and describes measuring point described by data, and comes solely from time segment data defined
Time period.
Although the above-mentioned accompanying drawing that combines is described to the specific embodiment of the present invention, not model is protected to the present invention
The restriction enclosed, one of ordinary skill in the art should be understood that on the basis of technical scheme, and those skilled in the art are not
Need to pay the various modifications that creative work can make or deformation still within protection scope of the present invention.
Claims (5)
1. a kind of data cut-in method of converting equipment, is characterized in that, comprise the following steps:
Step one: by all types of monitoring devices, the monitoring of converting equipment is obtained with the measuring point information of converting equipment measuring point；
Step 2: the measuring point information of measuring point is converted into the data of consolidation form, and the data is activation of consolidation form is given respectively
Converting equipment measuring point one-to-one kafka message queue is stored；
Step 3: by set in advance group of bag rule, reorganize data according to group bag form from message queue, obtain mesh
Mark packet；
Step 4: the target information processing the target data bag obtaining is sent in real time/historical data base and is stored；
Measuring point information in described step one include oil dissolved gas information in converting equipment, shelf depreciation information, electric quantity information,
Winding deformation information, temperature information and online infrared imaging information；
The measuring point information of the converting equipment that in described step one, all types of monitoring devices collect is sent to by socket interface
Message queue；
In described step 2, in socket interface, the measuring point information integration of converting equipment measuring point is become key-value form
Data；
Group bag form in described step 3 is made up of four partial data splicings: Part I data is data id, unique mark
Data；Part II data describes data for measuring point, describes data corresponding equipment measuring point information in this packet；Part III
Data is time segment data, describes the initial time of data and end time information in this packet；Part IV data is to set
Standby measuring point data, in the equipment measuring point data being described by Part II data, with the time period of Part III data description as when
Between interval data.
2. a kind of data cut-in method of converting equipment as claimed in claim 1, is characterized in that, described socket interface obtains
The measuring point information of the converting equipment that all types of monitoring devices collect particularly as follows: periodically obtained all kinds of by socket interface
The measuring point information of the converting equipment that type monitoring device collects.
3. a kind of data cut-in method of converting equipment as claimed in claim 1, is characterized in that, described socket interface passes through
Pre-set the time window of dynamic regulation can periodically obtain the survey of the converting equipment that all types of monitoring devices collect
Point information.
4. a kind of data cut-in method of converting equipment as claimed in claim 1, is characterized in that, in described step 3, according to
Data set bag rule, the corresponding period data chosen in corresponding message queue is parsed, and sets needed for obtaining according to group bag form
The standby, packet of required time section.
5. a kind of system of the data cut-in method of converting equipment as claimed in claim 1, is characterized in that, comprising:
Socket interface, for obtaining the measuring point information of the converting equipment that monitoring device monitors, and will be whole for described measuring point information
The data of synthesis key-value form；
Message queue, the data for sending to described socket interface stores；
Interface server, for parsing to the data obtaining from described message queue, and according to group bag rule, to described number
According to packaging, obtain described target data bag and export；
In real time/historical data base, the target data bag for sending to described interface server stores.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410738003.5A CN104501848B (en) | 2014-12-04 | 2014-12-04 | Data accessing method and system of substation equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410738003.5A CN104501848B (en) | 2014-12-04 | 2014-12-04 | Data accessing method and system of substation equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN104501848A CN104501848A (en) | 2015-04-08 |
| CN104501848B true CN104501848B (en) | 2017-02-01 |
Family
ID=52943274
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410738003.5A Active CN104501848B (en) | 2014-12-04 | 2014-12-04 | Data accessing method and system of substation equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104501848B (en) |
Families Citing this family (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105245582B (en) * | 2015-09-18 | 2019-07-12 | 北京百度网讯科技有限公司 | The monitoring method and monitoring device of data center |
| CN105740351A (en) * | 2016-01-26 | 2016-07-06 | 云南电网有限责任公司电力科学研究院 | Data fusion method and system of power transmission operation and maintenance equipment |
| CN109412857A (en) * | 2018-11-12 | 2019-03-01 | 山东鲁能智能技术有限公司 | A kind of general type common data structure, gateway machine |
| CN111026460B (en) * | 2019-12-05 | 2023-06-20 | 新奥数能科技有限公司 | Method and device for rapidly allocating points by using regional templates in configuration tool |
Family Cites Families (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20110238374A1 (en) * | 2010-03-23 | 2011-09-29 | Mark Lancaster | Power Line Maintenance Monitoring |
| US20140310302A1 (en) * | 2013-04-12 | 2014-10-16 | Oracle International Corporation | Storing and querying graph data in a key-value store |
| CN103427489A (en) * | 2013-08-20 | 2013-12-04 | 国家电网公司 | Intelligent substation comprehensive monitoring system |
| CN103532959A (en) * | 2013-10-21 | 2014-01-22 | 济南政和科技有限公司 | Cross-platform network communication method |
| CN103605767A (en) * | 2013-11-26 | 2014-02-26 | 国家电网公司 | Data access method and system of power transmission lines |
| CN103838867A (en) * | 2014-03-20 | 2014-06-04 | 网宿科技股份有限公司 | Log processing method and device |
-
2014
- 2014-12-04 CN CN201410738003.5A patent/CN104501848B/en active Active
Also Published As
| Publication number | Publication date |
|---|---|
| CN104501848A (en) | 2015-04-08 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104501848B (en) | Data accessing method and system of substation equipment | |
| CN105187010B (en) | The Intellectualized monitoring and operational system of a kind of photovoltaic plant | |
| CN104950837B (en) | Cloud inventory configuration management system | |
| CN103440367B (en) | Transformer station's panoramic view data modeling method | |
| CN104317800A (en) | Hybrid storage system and method for mass intelligent power utilization data | |
| CN102750406A (en) | Multi-version management method for model set and difference model-based power grid model | |
| CN109347959B (en) | Photovoltaic power plant removes monitored control system | |
| US11063998B2 (en) | System and method for energy management information system reliability assurance | |
| CN105338027A (en) | Method, system and device for cloud storage of video data | |
| CN112186901B (en) | Panoramic sensing monitoring method and system for transformer substation | |
| CN103337011A (en) | Panoramic inversion method of power grid accident based on time scale measurement | |
| CN107548087A (en) | A kind of method and device of warning association analysis | |
| CN110209088A (en) | A kind of configuration monitoring system and method based on HTML5 | |
| CN103605767A (en) | Data access method and system of power transmission lines | |
| CN202205065U (en) | Acquisition and monitoring integrated system for output parameters of electric welding machines | |
| CN105260372B (en) | Method based on real-time data base statistics any time period energy consumption | |
| CN105610911A (en) | Wind power mobile monitoring system and method based on private cloud | |
| CN103633736B (en) | From the on-line monitoring communication means of power transformation substation to main website | |
| CN108710347A (en) | A kind of monitoring cloud platform | |
| CN110334900B (en) | Data processing method | |
| CN103605759B (en) | A kind of sharing method of power grid history state data | |
| CN107317837A (en) | A kind of method and apparatus of data syn-chronization | |
| CN205176932U (en) | Data collection and transmission system for intelligence measurement platform | |
| CN202575584U (en) | Elevator running monitoring internet-of-things system based on 3G communication | |
| CN103475936B (en) | Method for remote monitoring of digital television receiving terminal |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| CP03 | Change of name, title or address |
Address after: 100031 No. 86 West Chang'an Avenue, Beijing, Xicheng District Patentee after: STATE GRID CORPORATION OF CHINA Patentee after: ELECTRIC POWER RESEARCH INSTITUTE OF STATE GRID SHANDONG ELECTRIC POWER Co. Patentee after: Shandong luruan Digital Technology Co.,Ltd. Address before: 250002 Wang Yue Road, Ji'nan City, Shandong Province, No. 2000 Patentee before: State Grid Corporation of China Patentee before: ELECTRIC POWER RESEARCH INSTITUTE OF STATE GRID SHANDONG ELECTRIC POWER Co. Patentee before: SHANDONG LUNENG SOFTWARE TECHNOLOGY Co.,Ltd. |
|
| CP03 | Change of name, title or address |