CN104501848A - Data accessing method and system of substation equipment - Google Patents
Data accessing method and system of substation equipment Download PDFInfo
- Publication number
- CN104501848A CN104501848A CN201410738003.5A CN201410738003A CN104501848A CN 104501848 A CN104501848 A CN 104501848A CN 201410738003 A CN201410738003 A CN 201410738003A CN 104501848 A CN104501848 A CN 104501848A
- Authority
- CN
- China
- Prior art keywords
- data
- measuring point
- equipment
- converting equipment
- information
- 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.)
- Granted
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, be specifically related to a kind of data cut-in method and system of converting equipment.
Background technology
At present, in order to ensure power grid security, stable, Effec-tive Function, usually can carry out converting equipment status monitoring, and the equipment measuring point data monitored is stored in real time/historical data base, for equipment fault early-warning and monitoring provide analysis data.In actual monitoring scene, come from each producer and have various types of monitoring equipment due to monitoring equipment, the form of the equipment measuring point information monitored is inconsistent.And the equipment measuring point data of section sometime cannot be intercepted as requested dynamically.Therefore, prior art is generally the various types of monitoring equipment design interface server respectively of each producer, processes equipment measuring point data; And will, all equipment measuring point datas are all stored in real time/historical data base according to time sequencing.But, due to used interface number of servers and type various, cause cost of development higher.And in order to preserve armamentarium measuring point data, causing data bulk redundancy, taking storage space.
Summary of the invention
For solving the deficiency that prior art exists, the invention discloses a kind of data cut-in method and system of converting equipment, the application achieves the consolidation form of the measuring point information to the converting equipment that all types of monitoring equipment of each producer monitors, store as required, improve the efficiency of management, reduce storage space.
For achieving the above object, concrete scheme of the present invention is as follows:
A data cut-in method for converting equipment, comprises the following steps:
Step one: carry out monitoring the measuring point information obtaining converting equipment to converting equipment by all types of monitoring equipment;
Step 2: data measuring point information being converted to consolidation form, and these data are sent to each converting equipment measuring point one to one message queue store;
Step 3: by the group bag rule preset, reorganize data according to group packet format from message queue, obtain target data bag;
Step 4: send in real time/historical data base to store the target information processing the target data bag obtained.
The measuring point information of the converting equipment that in described step one, all types of monitoring equipment collects is sent to message queue by Socket interface.
Measuring point information in described step one comprises oil dissolved gas information in converting equipment, shelf depreciation information, electric quantity information, winding deformation information, temperature information, online infrared imaging information etc.
In described step 2, the measuring point information integration of converting equipment measuring point is become the data of key-value form in Socket interface.
In described step 2, the data of consolidation form are sent to each converting equipment measuring point one to one Kafka message queue store.
The measuring point information that described Socket interface obtains the converting equipment that all types of monitoring equipment collects is specially: the measuring point information periodically being obtained the converting equipment that all types of monitoring equipment collects by Socket interface.
Described Socket interface periodically obtains the measuring point information of the converting equipment that all types of monitoring equipment collects by the time window that a dynamic pre-set regulates.
In described step 3, according to data group bag rule, the corresponding period data chosen in corresponding message queue is resolved, and obtains the packet of equipment needed thereby, required time section according to group packet format.
Described group of packet format is spliced by four partial datas and forms: Part I data are data id, unique identification data; Part II data are measuring point data of description, describe the equipment measuring point information that data in this packet are corresponding; Part III data are time period data, describe initial time and the end time information of data in this packet; Part IV data are equipment measuring point data, and this measuring point data comes from the measuring point described by Part II measuring point data of description, and comes from the time period of Part III time period data defined.
A data insertion system for converting equipment, comprising:
Socket interface, for obtaining the measuring point information of the converting equipment that monitoring equipment monitors, and becomes the data of key-value form by described measuring point information integration;
Message queue, stores for the data sent described Socket interface;
Interface server, for resolving the data obtained from described message queue, and according to group bag rule, packages to described data, obtains described target data bag and export;
In real time/historical data base, stores for the target data bag sent described interface server.
Beneficial effect of the present invention:
The application is encapsulated by the measuring point information of the converting equipment to all types of monitoring equipment collection of each producer obtained, obtain the data of key-value form, and these data are stored into equipment measuring point one to one message queue in store, ensure the complete of measuring point information.Then, by the group bag rule preset, from message queue, reorganize data according to group packet format, obtain target data bag, target data bag is sent in real time/history data store.Thus achieve the uniform format management of the equipment measuring point information to all types of monitoring equipment monitoring of each producer, and store data on demand, reduce data redundancy.
Accompanying drawing explanation
Fig. 1 is the process flow diagram of the embodiment of a kind of converting equipment data cut-in method of the present invention;
Fig. 2 is the structural representation of the embodiment of a kind of converting equipment data insertion system of the present invention;
Fig. 3 is the group packet format schematic diagram of a kind of converting equipment data cut-in method of the present invention.
Embodiment:
Below in conjunction with accompanying drawing, the present invention is described in detail:
The embodiment of the invention discloses a kind of data cut-in method and system of converting equipment, the data of key-value form are become by the converting equipment measuring point measuring point information integration obtaining all types of monitoring equipment collection of each producer, and these data are sent to each equipment measuring point one to one message queue store, thus ensure that the integrality of data.Then, according to data group bag rule, the corresponding time period data chosen in corresponding message queue are resolved, and the packet of equipment needed thereby, required time section is obtained according to group packet format, in real time/historical data base is sent to store by processing the target information obtained, thus avoid data redundancy, reduce storage space.
As shown in Figure 1, be the process flow diagram of the embodiment 1 of the data cut-in method of a kind of converting equipment of the present invention, the method can comprise:
Step 1: obtain the converting equipment measuring point measuring point information that all types of monitoring equipment of each producer monitors.
Step 2: data measuring point measuring point information being converted to key-value form, and these data are sent to each equipment measuring point one to one message queue store.
In the prior art, with each producer all types of monitoring equipment one to one interface server be that the converting equipment measuring point measuring point information monitored is processed one by one, and send in real time/historical data base to store the target data after process.Thus, because the such as reason such as network failure may cause the loss of data in process of transmitting, thus the integrality of Monitoring Data is had influence on.In addition, the measuring point information about monitored equipment generally exists in the form of metadata, occupies certain storage space.
In order to solve the problem, the embodiment of the present invention changes into the data of key-value form by the measuring point information of the converting equipment collected by monitoring equipments all types of for each producer, be stored in message queue, do not need to process one by one this measuring point information, interface server can obtain desired data from message queue, thus ensures the integrality that in real time/historical data base stores status data.In addition, because measuring point status data and its message queue stored are one to one, so without the need to preserving measuring point information, save storage space.
Preferably, the process just with your equipment measuring point measuring point information that all types of monitoring equipment of each producer of above-mentioned acquisition monitors, can be periodically obtain that all types of monitoring equipment of each producer monitors by Socket interface be just with your equipment measuring point measuring point information.
Concrete, by Socket interface often through the time window that pre-set a, dynamic regulates, obtain the measuring point information of the converting equipment that all types of monitoring equipment collects.
Wherein, in the embodiment of the present invention, message queue can select Kafka message queue, and it is the Distributed Message Queue that current storage efficiency is the highest.
Step 3: according to data group bag rule, the corresponding time period data chosen in corresponding message queue are resolved, obtains the packet of equipment needed thereby, required time section according to group packet format.
Wherein, spatial dimension---measuring point range information and time range---the time period information of group bag data is described in data group bag rule.Because measuring point and message queue are one to one, only need from corresponding message queue, choose data according to time range and package.
Step 4: send in real time/historical data base to store by processing the target information obtained.
As shown in Figure 2, be the structural representation of the embodiment 1 of the data insertion system of a kind of converting equipment of the present invention, this system can comprise: all types of monitoring equipment of each producer (uses monitoring equipment JC in figure
1, monitoring equipment JC
2, monitoring equipment JC
3monitoring equipment JC
nrepresent the monitoring equipment that each producer is all types of, wherein n is positive integer), Socket interface, message queue (use message queue MQ in figure
1, message queue MQ
2, message queue MQ
3message queue MQ
nrepresent the monitoring equipment one to one message queue all types of with each producer, wherein n is positive integer) and in real time/historical data base.
Wherein, monitoring equipment is connected with converting equipment, for detecting the running status of converting equipment, obtains the measuring point information of converting equipment.
Socket interface is connected with monitoring equipment, for obtain monitoring equipment monitor the measuring point information of converting equipment, and become by this measuring point information integration the data of key-value form to export.
Message queue, stores for the data sended over Socket interface, thus ensures the integrality of measuring point data.
Wherein, this message queue can be Kafka message queue.
In real time/historical data base, for storing by message queue according to the regular spliced target information of group bag.
As shown in Figure 3, be the group packet format schematic diagram of a kind of converting equipment data cut-in method of the present invention, this group packet format comprises: data id, measuring point data of description, time period data, equipment measuring point data.
Wherein, data id, unique identification data; Measuring point data of description, describes the equipment measuring point information that data in this packet are corresponding; Time period data, describe initial time and the end time information of data in this packet; Equipment measuring point data, by measuring point data of description, the time period described with data is the time interval.
This measuring point data only comes from the measuring point described by measuring point data of description, and only comes from the time period of time period data defined.
By reference to the accompanying drawings the specific embodiment of the present invention is described although above-mentioned; but not limiting the scope of the invention; one of ordinary skill in the art should be understood that; on the basis of technical scheme of the present invention, those skilled in the art do not need to pay various amendment or distortion that creative work can make still within protection scope of the present invention.
Claims (10)
1. a data cut-in method for converting equipment, is characterized in that, comprises the following steps:
Step one: the measuring point information by all types of monitoring equipment, the monitoring of converting equipment being obtained to converting equipment measuring point;
Step 2: the data measuring point information of measuring point being converted to consolidation form, and these data are sent to each converting equipment measuring point one to one message queue store;
Step 3: by the group bag rule preset, reorganize data according to group packet format from message queue, obtain target data bag;
Step 4: send in real time/historical data base to store the target information processing the target data bag obtained.
2. the data cut-in method of a kind of converting equipment as claimed in claim 1, is characterized in that, the measuring point information of the converting equipment that in described step one, all types of monitoring equipment collects is sent to message queue by Socket interface.
3. the data cut-in method of a kind of converting equipment as claimed in claim 1, is characterized in that, in described step 2, the measuring point information integration of converting equipment measuring point is become the data of key-value form in Socket interface.
4. the data cut-in method of a kind of converting equipment as claimed in claim 1, is characterized in that, in described step 2, the data of consolidation form are sent to each converting equipment measuring point one to one Kafka message queue store.
5. the data cut-in method of a kind of converting equipment as claimed in claim 2, it is characterized in that, the measuring point information that described Socket interface obtains the converting equipment that all types of monitoring equipment collects is specially: the measuring point information periodically being obtained the converting equipment that all types of monitoring equipment collects by Socket interface.
6. the data cut-in method of a kind of converting equipment as claimed in claim 5, is characterized in that, described Socket interface periodically obtains the measuring point information of the converting equipment that all types of monitoring equipment collects by the time window that the dynamic pre-set regulates.
7. the data cut-in method of a kind of converting equipment as claimed in claim 1, it is characterized in that, in described step 3, according to data group bag rule, the corresponding period data chosen in corresponding message queue is resolved, and obtains the packet of equipment needed thereby, required time section according to group packet format.
8. the data cut-in method of a kind of converting equipment as claimed in claim 1, is characterized in that, described group of packet format is spliced by four partial datas and form: Part I data are data id, unique identification data; Part II data are measuring point data of description, describe the equipment measuring point information that data in this packet are corresponding; Part III data are time period data, describe initial time and the end time information of data in this packet; Part IV data are equipment measuring point data, in the equipment measuring point data described by Part II data, and the data that the time period described with Part III data is the time interval.
9. the data cut-in method of a kind of converting equipment as claimed in claim 1, it is characterized in that, the measuring point information in described step one comprises oil dissolved gas information in converting equipment, shelf depreciation information, electric quantity information, winding deformation information, temperature information and online infrared imaging information.
10. the system of the data cut-in method of a kind 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 equipment monitors, and becomes the data of key-value form by described measuring point information integration;
Message queue, stores for the data sent described Socket interface;
Interface server, for resolving the data obtained from described message queue, and according to group bag rule, packages to described data, obtains described target data bag and export;
In real time/historical data base, stores for the target data bag sent described interface server.
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 true CN104501848A (en) | 2015-04-08 |
| CN104501848B 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) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105245582A (en) * | 2015-09-18 | 2016-01-13 | 北京百度网讯科技有限公司 | Data center monitoring method and device |
| 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 |
| CN111026460A (en) * | 2019-12-05 | 2020-04-17 | 新奥数能科技有限公司 | Method and device for quickly matching points by using area template in configuration tool |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP2369718A2 (en) * | 2010-03-23 | 2011-09-28 | Southwire Company | Power line maintenance monitoring |
| 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 |
| WO2014169265A1 (en) * | 2013-04-12 | 2014-10-16 | Oracle International Corporation | Storing and querying graph data in a key-value store |
-
2014
- 2014-12-04 CN CN201410738003.5A patent/CN104501848B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP2369718A2 (en) * | 2010-03-23 | 2011-09-28 | Southwire Company | Power line maintenance monitoring |
| WO2014169265A1 (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 |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105245582A (en) * | 2015-09-18 | 2016-01-13 | 北京百度网讯科技有限公司 | Data center monitoring method and device |
| 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 |
| CN111026460A (en) * | 2019-12-05 | 2020-04-17 | 新奥数能科技有限公司 | Method and device for quickly matching points by using area template in configuration tool |
| CN111026460B (en) * | 2019-12-05 | 2023-06-20 | 新奥数能科技有限公司 | Method and device for rapidly allocating points by using regional templates in configuration tool |
Also Published As
| Publication number | Publication date |
|---|---|
| CN104501848B (en) | 2017-02-01 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8396963B2 (en) | Networked devices for monitoring utility usage and methods of using the same | |
| CN104501848A (en) | Data accessing method and system of substation equipment | |
| CN105338027A (en) | Method, system and device for cloud storage of video data | |
| CN111221700B (en) | Cluster node state monitoring method, device, equipment and readable storage medium | |
| CN109521702A (en) | A kind of method and server monitoring dcs operating status | |
| CN202550669U (en) | Data acquisition system for power equipment | |
| CN103390933A (en) | Central detection method of distributed data acquisition mode of dispatching automation system | |
| CN110995785A (en) | Low-voltage distribution network cloud platform based on Internet of things | |
| CN103813141A (en) | Video comprehensive monitoring system and monitoring method based on stream media | |
| CN105450997A (en) | Cloud storage based video monitoring system | |
| CN111835083A (en) | Power supply information monitoring system, method and device, computer equipment and storage medium | |
| CN105467907A (en) | Automatic inspection system and method | |
| 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 | |
| CN103778501A (en) | Accident inversion system and accident inversion method of electric power dispatching automation system | |
| CN110209088A (en) | A kind of configuration monitoring system and method based on HTML5 | |
| CN206149401U (en) | Face identification monitored control system based on big data framework | |
| CN202815533U (en) | Hydropower station monitoring system based on cloud computing | |
| CN110334900B (en) | Data processing method | |
| CN104134168A (en) | Data management system | |
| CN103605759B (en) | A kind of sharing method of power grid history state data | |
| CN103546566A (en) | Power distribution network operation data processing method and system based on distributed storage and distributed computation | |
| KR101698997B1 (en) | System and method for integrated energy management | |
| CN104022917A (en) | Cloud bridge monitoring method | |
| KR102453852B1 (en) | Sensor data processing system |
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 | ||
| 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. |