CN103745413A - Model generation method for primary-device online monitoring device of electric-power operational system - Google Patents
Model generation method for primary-device online monitoring device of electric-power operational system Download PDFInfo
- Publication number
- CN103745413A CN103745413A CN201310711104.9A CN201310711104A CN103745413A CN 103745413 A CN103745413 A CN 103745413A CN 201310711104 A CN201310711104 A CN 201310711104A CN 103745413 A CN103745413 A CN 103745413A
- Authority
- CN
- China
- Prior art keywords
- data
- line monitor
- primary equipment
- monitor device
- model
- 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
Images
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Remote Monitoring And Control Of Power-Distribution Networks (AREA)
Abstract
The invention relates to the technical field related to an electric-power operational system and particularly relates to a generation method for a primary-device online monitoring device of the electric-power operational system. The method includes: measurement history multidimensional data of the primary-device online monitoring device is extracted from a source professional system regularly and saved in corresponding history multi-dimensional data tables; each history multi-dimensional data table is processed and measurement history multi-dimensional data with the newest update time is selected to establish a corresponding newest data view; from the newest data view, a device model and a measurement-point model of the primary-device online monitoring device are established and a relation between the device model and the measurement-point model is maintained. The model generation method for the primary-device online monitoring device of the electric-power operational system is still capable of realizing establishment of an online monitoring device model when professional system manufacturers are incapable of providing an online monitoring device model.
Description
Technical field
The present invention relates to electric power O&M system correlative technology field, particularly a kind of electric power O&M system primary equipment on-Line Monitor Device model generating method.
Background technology
Along with the continuous expansion of electrical network scale, electrical network monitors and operation maintenance workload increases day by day, electric system primary equipment O&M system can effectively improve the level of informatization of electrical network supervision and operation maintenance, reduce O&M personnel's workload, but primary equipment O&M system needs the on-Line Monitor Device data of integrated multiple other professional systems conventionally, as the foundation of system-computed and analysis.At present integrated for other professional system on-Line Monitor Device data, normally according to first setting up model, then the mode that extracted data is upgraded is carried out.
Current outer professional system on-Line Monitor Device data integrating method is higher to the interface requirement of source professional system, must provide the model of on-Line Monitor Device to obtain interface, just can carry out the integrated of data after first setting up model.That this method is the object that can complete on-Line Monitor Device data integration under normal circumstances.But because the on-Line Monitor Device Data Source system complex that needs are integrated is various, also equal difference to some extent of the data-interface that different system manufacturers provides and Data Source.When professional system manufacturer cannot provide on-Line Monitor Device model to obtain interface, conventional first model, the mode of rear data just cannot meet the integrated needs of this special circumstances, cannot set up on-Line Monitor Device model.
Summary of the invention
Based on this, be necessary for prior art, when professional system manufacturer cannot provide on-Line Monitor Device model, cannot set up the technical matters of on-Line Monitor Device model, a kind of electric power O&M system primary equipment on-Line Monitor Device model generating method is provided.
A kind of electric power O&M system primary equipment on-Line Monitor Device model generating method, comprising:
Further, the historical multidimensional data table sort according to described source professional system of described historical multidimensional data table is built table.
Further, described step 11 specifically comprises: timing is extracted the last historical multidimensional data of measurement that is drawn into this described primary equipment on-Line Monitor Device that extracts the time period by ETL from the professional system of source, and is kept at corresponding historical multidimensional data table data.
Further, described step 12 specifically comprises: according to the historical multidimensional data of the measurement being drawn in step 11 and corresponding historical multidimensional data list structure, set up corresponding latest data table view; In described spreadsheet views, only preserve up-to-date data update time, and latest data view structure is identical with described historical multidimensional data table.
Further, wherein step 13 specifically comprises: from described latest data view, according to the reverse modeling rule of primary equipment on-Line Monitor Device, set up mounted cast and the observation point model of described primary equipment on-Line Monitor Device, and safeguard the relation between described mounted cast and described observation point model.
Further, the reverse modeling rule of described primary equipment on-Line Monitor Device extracts from the professional system of source by ETL.
Further, the reverse modeling rule of described primary equipment on-Line Monitor Device specifically comprises:
According to the device tables of data in described latest data view, generate the monitoring device model table of described mounted cast and the monitoring device observation point model table of described observation point model.
Further, the device tables of data in described latest data view is generated to the monitoring device model table of described mounted cast, specifically comprises:
By device data table name REC_BS_ID and REC_SENSOR_ID, generate NID unique in described monitoring device model table;
By relevant information in device tables of data REC_SENSOR_ID and SENSORINFO table, generate NAME and the PHASE attribute in described monitoring device model table;
By relevant information in device tables of data REC_BS_ID and MONITORPOSITIONINFO table, generate the LOCATION_NID attribute in described monitoring device model table;
By device tables of data attribute-name REC_BS_ID and REC_SENSOR_ID, generate NID unique in described monitoring device observation point model table;
By relevant information in device tables of data REC_SENSOR_ID and SENSORINFO table, generate NAME and the GCCDLX attribute in described monitoring device model table;
By device data table name REC_BS_ID and REC_SENSOR_ID, generate DEVICEID, thereby can get the associated device ID of measuring point in described monitoring device observation point model table;
By device tables of data property value, generate CURVAL;
RES_UPDATE_TIME generates ACTIME;
Current time generates UPDATETIME.
Further, also comprise:
Adopt process scheduling instrument that interface bag, operating system command and the script of ETL are organized and formed different scenes by step 11～13;
By the scheduling of scene, the various sequences of operation are triggered as required according to the rule of different trigger conditions and definition.
The present invention adopts by metric data reverse modeling approach and the method to model, by extract the historical multidimensional data of measurement of described primary equipment on-Line Monitor Device from the professional system of source, thereby generate mounted cast and the observation point model of primary equipment on-Line Monitor Device, thereby realize when professional system manufacturer cannot provide on-Line Monitor Device model, also can set up on-Line Monitor Device model.
Accompanying drawing explanation
Fig. 1 is the workflow diagram of a kind of electric power O&M of the present invention system primary equipment on-Line Monitor Device model generating method;
Fig. 2 is the schematic diagram of the reverse modeling rule of primary equipment on-Line Monitor Device of an example of the present invention.
Embodiment
Below in conjunction with the drawings and specific embodiments, the present invention will be further described in detail.
The workflow diagram that is illustrated in figure 1 a kind of electric power O&M of the present invention system primary equipment on-Line Monitor Device model generating method, comprising:
In an embodiment, the historical multidimensional data table sort according to described source professional system of described historical multidimensional data table is built table therein.
Therein in an embodiment, described step 11 specifically comprises: timing is extracted the last historical multidimensional data of measurement that is drawn into this described primary equipment on-Line Monitor Device that extracts the time period by ETL from the professional system of source, and is kept at corresponding historical multidimensional data table data.
In an embodiment, described step 12 specifically comprises therein: according to the historical multidimensional data of the measurement being drawn in step 11 and corresponding historical multidimensional data list structure, set up corresponding latest data table view; In described spreadsheet views, only preserve up-to-date data update time, and latest data view structure is identical with described historical multidimensional data table.
Therein in an embodiment, wherein step 13 specifically comprises: from described latest data view, according to the reverse modeling rule of primary equipment on-Line Monitor Device, set up mounted cast and the observation point model of described primary equipment on-Line Monitor Device, and safeguard the relation between described mounted cast and described observation point model.
In an embodiment, the reverse modeling rule of described primary equipment on-Line Monitor Device extracts from the professional system of source by ETL therein.
In an embodiment, the reverse modeling rule of described primary equipment on-Line Monitor Device specifically comprises therein:
According to the device tables of data in described latest data view, generate the monitoring device model table of described mounted cast and the monitoring device observation point model table of described observation point model.
In an embodiment, the device tables of data in described latest data view is generated to the monitoring device model table of described mounted cast therein, specifically comprises:
By device data table name REC_BS_ID and REC_SENSOR_ID, generate NID unique in described monitoring device model table;
By relevant information in device tables of data REC_SENSOR_ID and SENSORINFO table, generate NAME and the PHASE attribute in described monitoring device model table;
By relevant information in device tables of data REC_BS_ID and MONITORPOSITIONINFO table, generate the LOCATION_NID attribute in described monitoring device model table;
By device tables of data attribute-name REC_BS_ID and REC_SENSOR_ID, generate NID unique in described monitoring device observation point model table;
By relevant information in device tables of data REC_SENSOR_ID and SENSORINFO table, generate NAME and the GCCDLX attribute in described monitoring device model table;
By device data table name REC_BS_ID and REC_SENSOR_ID, generate DEVICEID, thereby can get the associated device ID of measuring point in described monitoring device observation point model table;
By device tables of data property value, generate CURVAL;
RES_UPDATE_TIME generates ACTIME;
Current time generates UPDATETIME.
In an embodiment, also comprise therein:
Adopt process scheduling instrument that interface bag, operating system command and the script of ETL are organized and formed different scenes by step 11～13;
By the scheduling of scene, the various sequences of operation are triggered as required according to the rule of different trigger conditions and definition.
As an example, provide cross-platform ETL technology to realize disparate databases, the primary equipment on-line equipment metric data access in different pieces of information source, by commercial storehouse cooperation modeling rule, automatically in the commercial storehouse of system of this example, generate primary equipment on-line equipment model and observation point model simultaneously.
Wherein, ETL is the abbreviation of Extraction-Transformation-Loading, and Chinese is that data are extracted, change and load.ETL instrument has: OWB (Oracle Warehouse Builder), ODI (Oracle Data Integrator), Informatic PowerCenter, Trinity, AICloudETL, DataStage,
Electric power O&M system acquisition is after primary equipment on-Line Monitor Device model and Monitoring Data, and each application in system just can be obtained corresponding data by commercial bank interface and be carried out professional calculating and analysis.
It specifically comprises following step:
A) timing measures historical multidimensional data by the primary equipment on-Line Monitor Device in the professional system of source and is drawn in historical data table corresponding to the system of this example by ETL; Extraction algorithm guarantees that each extraction only extracts the historical data in the previous extraction time interval;
B) by commercial storehouse internal data, process means, set up latest data view: process each historical data table, the historical data up-to-date update time is filtered out, set up corresponding latest data view;
C) use the reverse modeling rule of primary equipment on-Line Monitor Device, from latest data view, set up mounted cast and the observation point model of primary equipment on-Line Monitor Device, and the relation between attending device model and observation point model.
D) use special process scheduling instrument, above step is managed, orderly calling, completes the renewal of model on time.
Wherein step a) further comprises: the historical data table sort according to origin system of the primary equipment on-Line Monitor Device historical data table of the system of this example is built table, extract at every turn and only extract the last data that are drawn into this extraction time period, as 5 minutes extract once, so only extract the historical data of first 5 minutes.In each historical data table, the data recording of latest update will constantly be increased.
Wherein step b) further comprises: according to different historical data list structures, set up different latest data table views; In view, only preserve up-to-date data update time.Latest data view structure is identical with historical data table, but only retains up-to-date data update time for the identical record of device id.
Wherein step c) further comprises: the reverse modeling rule of primary equipment on-Line Monitor Device, this rule extracts realization by ETL, different for dissimilar data modeling rule, but all based on primitive rule shown in accompanying drawing 2, carries out data modeling.
Wherein step c) further comprises: polytype device is according to contained attribute difference, some difference of modeling rule, but basic skills is consistent, as shown in Figure 2, comprise: by category-A device data table name, REC_BS_ID, REC_SENSOR_ID generates unique NID in monitoring device model table; By relevant information in category-A device tables of data REC_SENSOR_ID and SENSORINFO table, generate the NAME in monitoring device model table, PHASE attribute; By relevant information in category-A device tables of data REC_BS_ID and MONITORPOSITIONINFO table, generate the LOCATION_NID attribute in monitoring device model table; By category-A device tables of data attribute A(or B, C...) attribute-name, REC_BS_ID, REC_SENSOR_ID generates unique NID in monitoring device observation point model table; By relevant information in category-A device tables of data REC_SENSOR_ID and SENSORINFO table, generate the NAME in monitoring device model table, GCCDLX attribute; By category-A device data table name, REC_BS_ID, REC_SENSOR_ID generates DEVICEID, thereby can get the associated device ID of measuring point; By category-A device tables of data attribute A(or B, C...) value, generate CURVAL; RES_UPDATE_TIME generates ACTIME; Current time generates UPDATETIME.
Wherein step d) further comprises: process scheduling instrument can be by the interface bag of ETL, operating system command, and organizing that script etc. are orderly forms different scenes; By the scheduling of scene, make the various sequences of operation can be according to different trigger conditions, and the rule of definition trigger as required; Make monitoring model online can keep as required upgrading.
The above embodiment has only expressed several embodiment of the present invention, and it describes comparatively concrete and detailed, but can not therefore be interpreted as the restriction to the scope of the claims of the present invention.It should be pointed out that for the person of ordinary skill of the art, without departing from the inventive concept of the premise, can also make some distortion and improvement, these all belong to protection scope of the present invention.Therefore, the protection domain of patent of the present invention should be as the criterion with claims.
Claims (9)
1. an electric power O&M system primary equipment on-Line Monitor Device model generating method, is characterized in that, comprising:
Step (11), the historical multidimensional data of measurement of described primary equipment on-Line Monitor Device is extracted in timing from the professional system of source, and is kept at corresponding historical multidimensional data table;
Step (12), process each described historical multidimensional data table, therefrom filter out the up-to-date historical multidimensional data of described measurement update time, set up the corresponding latest data view that comprises device tables of data, described device tables of data generates according to the historical multidimensional data of described measurement;
Step (13), from described latest data view, sets up mounted cast and the observation point model of described primary equipment on-Line Monitor Device, and safeguards the relation between described mounted cast and described observation point model.
2. electric power O&M system primary equipment on-Line Monitor Device model generating method according to claim 1, is characterized in that, the historical multidimensional data table sort according to described source professional system of described historical multidimensional data table is built table.
3. electric power O&M system primary equipment on-Line Monitor Device model generating method according to claim 1, it is characterized in that, described step (11) specifically comprises: timing is extracted the last historical multidimensional data of measurement that is drawn into this described primary equipment on-Line Monitor Device that extracts the time period by ETL from the professional system of source, and is kept at corresponding historical multidimensional data table data.
4. electric power O&M system primary equipment on-Line Monitor Device model generating method according to claim 1, it is characterized in that, described step (12) specifically comprises: according to the historical multidimensional data of the measurement being drawn in step (11) and corresponding historical multidimensional data list structure, set up corresponding latest data table view; In described spreadsheet views, only preserve up-to-date data update time, and latest data view structure is identical with described historical multidimensional data table.
5. electric power O&M system primary equipment on-Line Monitor Device model generating method according to claim 1, it is characterized in that, wherein step (13) specifically comprises: from described latest data view, according to the reverse modeling rule of primary equipment on-Line Monitor Device, set up mounted cast and the observation point model of described primary equipment on-Line Monitor Device, and safeguard the relation between described mounted cast and described observation point model.
6. electric power O&M system primary equipment on-Line Monitor Device model generating method according to claim 5, is characterized in that, the reverse modeling rule of described primary equipment on-Line Monitor Device extracts from the professional system of source by ETL.
7. electric power O&M system primary equipment on-Line Monitor Device model generating method according to claim 5, is characterized in that, the reverse modeling rule of described primary equipment on-Line Monitor Device specifically comprises:
According to the device tables of data in described latest data view, generate the monitoring device model table of described mounted cast and the monitoring device observation point model table of described observation point model.
8. electric power O&M system primary equipment on-Line Monitor Device model generating method according to claim 7, is characterized in that, the device tables of data in described latest data view is generated to the monitoring device model table of described mounted cast, specifically comprises:
By device data table name REC_BS_ID and REC_SENSOR_ID, generate NID unique in described monitoring device model table;
By relevant information in device tables of data REC_SENSOR_ID and SENSORINFO table, generate NAME and the PHASE attribute in described monitoring device model table;
By relevant information in device tables of data REC_BS_ID and MONITORPOSITIONINFO table, generate the LOCATION_NID attribute in described monitoring device model table;
By device tables of data attribute-name REC_BS_ID and REC_SENSOR_ID, generate NID unique in described monitoring device observation point model table;
By relevant information in device tables of data REC_SENSOR_ID and SENSORINFO table, generate NAME and the GCCDLX attribute in described monitoring device model table;
By device data table name REC_BS_ID and REC_SENSOR_ID, generate DEVICEID, thereby can get the associated device ID of measuring point in described monitoring device observation point model table;
By device tables of data property value, generate CURVAL;
RES_UPDATE_TIME generates ACTIME;
Current time generates UPDATETIME.
9. electric power O&M system primary equipment on-Line Monitor Device model generating method according to claim 1, is characterized in that, also comprises:
Adopt process scheduling instrument that interface bag, operating system command and the script of ETL are organized and formed different scenes by step (11)～(13);
By the scheduling of scene, the various sequences of operation are triggered as required according to the rule of different trigger conditions and definition.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310711104.9A CN103745413B (en) | 2013-12-19 | 2013-12-19 | A kind of electric power operational system primary equipment on-Line Monitor Device model generating method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310711104.9A CN103745413B (en) | 2013-12-19 | 2013-12-19 | A kind of electric power operational system primary equipment on-Line Monitor Device model generating method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103745413A true CN103745413A (en) | 2014-04-23 |
| CN103745413B CN103745413B (en) | 2016-11-23 |
Family
ID=50502428
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310711104.9A Active CN103745413B (en) | 2013-12-19 | 2013-12-19 | A kind of electric power operational system primary equipment on-Line Monitor Device model generating method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103745413B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110535701A (en) * | 2019-08-30 | 2019-12-03 | 新华三大数据技术有限公司 | A kind of positioning problems method and device |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060095209A1 (en) * | 2004-10-29 | 2006-05-04 | Jang Moon J | Electronic power-measurement device with intelligent agent |
| CN102510127A (en) * | 2011-10-21 | 2012-06-20 | 南京南瑞继保电气有限公司 | Method for unifying models of on-line monitored first and secondary equipment of power grid |
| CN103150599A (en) * | 2013-03-07 | 2013-06-12 | 江苏大学 | Electric energy quality data monitoring and management system model |
| CN103207613A (en) * | 2013-04-26 | 2013-07-17 | 武汉聪源科技有限责任公司 | Data integration system for grid state detection, and implementation method of data integration system |
| CN103427489A (en) * | 2013-08-20 | 2013-12-04 | 国家电网公司 | Intelligent substation comprehensive monitoring system |
-
2013
- 2013-12-19 CN CN201310711104.9A patent/CN103745413B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060095209A1 (en) * | 2004-10-29 | 2006-05-04 | Jang Moon J | Electronic power-measurement device with intelligent agent |
| CN102510127A (en) * | 2011-10-21 | 2012-06-20 | 南京南瑞继保电气有限公司 | Method for unifying models of on-line monitored first and secondary equipment of power grid |
| CN103150599A (en) * | 2013-03-07 | 2013-06-12 | 江苏大学 | Electric energy quality data monitoring and management system model |
| CN103207613A (en) * | 2013-04-26 | 2013-07-17 | 武汉聪源科技有限责任公司 | Data integration system for grid state detection, and implementation method of data integration system |
| CN103427489A (en) * | 2013-08-20 | 2013-12-04 | 国家电网公司 | Intelligent substation comprehensive monitoring system |
Non-Patent Citations (1)
| Title |
|---|
| 王德文等: "变电站在线监测系统的一体化建模与模型维护", 《电力系统自动化》 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110535701A (en) * | 2019-08-30 | 2019-12-03 | 新华三大数据技术有限公司 | A kind of positioning problems method and device |
| CN110535701B (en) * | 2019-08-30 | 2022-07-01 | 新华三大数据技术有限公司 | Problem positioning method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103745413B (en) | 2016-11-23 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102662946B (en) | The method and system of change is recorded in a kind of automatic monitoring data storehouse | |
| CN105278373A (en) | Method for realizing comprehensive information processing system of transformer substation | |
| CN102799789B (en) | The main equipment model foundation of a kind of hydraulic power plant, storage and synchronous method | |
| KR20140142167A (en) | Systems and methods for synchronizing geographic information system (gis) network models | |
| CN103955865A (en) | Scheduled and faulted power outage range visualization method based on information interaction | |
| CN113722311A (en) | Power distribution network power failure range positioning method, system, equipment and medium | |
| CN103455554A (en) | Intelligent power distribution network model base system | |
| EP2897401A1 (en) | Method and device for guaranteeing consistency of planning data | |
| CN106325162A (en) | Embedded intelligent electromechanical equipment condition monitoring system | |
| CN104820890A (en) | Electric power dispatching equipment model and power grid production equipment information integration method | |
| CN104063761A (en) | SCADA data development system based on smart grid | |
| CN106229978A (en) | The pre-judging method of platform district low-voltage problem and system | |
| CN103986790A (en) | Monitoring and warning method of infrastructures of cloud data center | |
| CN103699688B (en) | Terminal model for supporting power supply reliability management of terminal user | |
| CN107562485A (en) | A kind of method and device of automatic data collection patch data | |
| CN103745413A (en) | Model generation method for primary-device online monitoring device of electric-power operational system | |
| CN103778501A (en) | Accident inversion system and accident inversion method of electric power dispatching automation system | |
| CN104112183B (en) | The intelligent scheduling model management system and management method of intelligent substation plug and play | |
| CN108564261A (en) | Method, apparatus and computer equipment are determined based on the power information of work ticket | |
| CN104866943A (en) | CIM/E file-based distributed data acquisition system main and standby dispatch synchronization method | |
| CN108512217B (en) | A kind of safe operation of electric network hidden danger intelligent identification Method | |
| Zhang et al. | Visualization of distribution level voltage magnitude pattern trend in EI system using FNET data | |
| CN105427543A (en) | Temperature early warning method and system based on smart grid | |
| CN103605759B (en) | A kind of sharing method of power grid history state data | |
| CN103178519B (en) | The method of power oscillation of power system disturbing source is located in real time based on SCADA data |
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 |