CN103745413B - A kind of electric power operational system primary equipment on-Line Monitor Device model generating method - Google Patents
A kind of electric power operational system primary equipment on-Line Monitor Device model generating method Download PDFInfo
- Publication number
- CN103745413B CN103745413B CN201310711104.9A CN201310711104A CN103745413B CN 103745413 B CN103745413 B CN 103745413B CN 201310711104 A CN201310711104 A CN 201310711104A CN 103745413 B CN103745413 B CN 103745413B
- Authority
- CN
- China
- Prior art keywords
- line monitor
- monitor device
- data
- primary equipment
- 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.)
- Active
Links
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Remote Monitoring And Control Of Power-Distribution Networks (AREA)
Abstract
The present invention relates to electric power operational system correlative technology field, particularly a kind of electric power operational system primary equipment on-Line Monitor Device model generating method, including: the measurement history multidimensional data of described primary equipment on-Line Monitor Device is extracted in timing from the professional system of source, and is saved in the history multidimensional data table of correspondence；Process each described history multidimensional data table, therefrom filter out renewal time up-to-date described measurement history multidimensional data, set up corresponding latest data view；From described latest data view, 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.The present invention realizes when professional system manufacturer cannot provide on-Line Monitor Device model, also can set up on-Line Monitor Device model.
Description
Technical field
The present invention relates to electric power operational system correlative technology field, particularly a kind of electric power operational system once sets
Standby 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, power train
Unified secondary device operational system can effectively improve electrical network and monitor and the level of informatization of operation maintenance, reduces
The workload of operation maintenance personnel, but primary equipment operational system typically requires integrated other professional systems multiple
On-Line Monitor Device data, as system-computed and the foundation of analysis.The most online for other professional systems
Monitoring device data integrated, it is common that according to first setting up model, then the mode that extracted data updates carries out.
Current outer professional system on-Line Monitor Device data integrating method is to the interface requirement of source professional system relatively
High, it is necessary to provide the model of on-Line Monitor Device to obtain interface, after first setting up model, just can carry out the collection of data
Become.Be under normal circumstances this method be the purpose that can complete on-Line Monitor Device data integration.But
Owing to needing integrated on-Line Monitor Device data source systems complexity various, different system manufacturer provides
Data-interface and Data Source the most difference.When professional system manufacturer cannot provide on-line monitoring to fill
When putting model acquisition interface, conventional first model, the mode of rear data just cannot meet this special circumstances
Integrated needs, it is impossible to set up on-Line Monitor Device model.
Summary of the invention
Based on this, it is necessary to on-Line Monitor Device mould cannot be provided for prior art professional system manufacturer
During type, it is impossible to set up the technical problem of on-Line Monitor Device model, it is provided that a kind of electric power operational system once sets
Standby on-Line Monitor Device model generating method.
A kind of electric power operational system primary equipment on-Line Monitor Device model generating method, including:
Step 11, the measurement history that described primary equipment on-Line Monitor Device is extracted in timing from the professional system of source is many
Dimension data, and it is saved in the history multidimensional data table of correspondence；
Step 12, processes each described history multidimensional data table, therefrom filters out the up-to-date described survey of renewal time
Amount history multidimensional data, sets up the corresponding latest data view including device tables of data, described device data
Table generates according to described measurement history multidimensional data；
Step 13, from described latest data view, sets up the device mould of described primary equipment on-Line Monitor Device
Type and observation point model, and safeguard the relation between described mounted cast and described observation point model.
Further, the history multidimensional data table according to described source professional system of described history multidimensional data table divides
Class builds table.
Further, described step 11 specifically includes: timing extracts upper one by ETL from the professional system of source
The measurement history multidimensional data of the secondary described primary equipment on-Line Monitor Device being drawn into this extraction time period,
And it is saved in the history multidimensional data table data of correspondence.
Further, described step 12 specifically includes: according to the measurement history multidimensional being drawn in step 11
The history multidimensional data list structure of data and correspondence, sets up corresponding latest data table view；Described tables of data
View only preserves renewal time up-to-date data, and latest data view structure and described history multidimensional data
Table is identical.
Further, wherein step 13 specifically includes: from described latest data view, according to primary equipment
The reverse modeling rule of on-Line Monitor Device, sets up mounted cast and the survey of described primary equipment on-Line Monitor Device
Point model, and safeguard the relation between described mounted cast and described observation point model.
Further, the described reverse modeling rule of primary equipment on-Line Monitor Device passes through ETL from source specialty system
System extracts.
Further, the described reverse modeling rule of primary equipment on-Line Monitor Device specifically includes:
The monitoring device model of described mounted cast is generated according to the device tables of data in described latest data view
Table 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 the monitoring of described mounted cast
Mounted cast table, specifically includes:
Described monitoring device model table is generated by device data table name REC_BS_ID Yu REC_SENSOR_ID
Interior unique NID；
Described prison is generated with relevant information in SENSORINFO table by device tables of data REC_SENSOR_ID
Survey NAME Yu the PHASE attribute in mounted cast table；
Generated with relevant information in MONITORPOSITIONINFO table by device tables of data REC_BS_ID
LOCATION_NID attribute in described monitoring device model table；
Generated described monitoring device by device tables of data attribute-name REC_BS_ID with REC_SENSOR_ID to survey
Unique NID in point model table；
Described prison is generated with relevant information in SENSORINFO table by device tables of data REC_SENSOR_ID
Survey NAME Yu the GCCDLX attribute in mounted cast table；
DEVICEID is generated by device data table name REC_BS_ID Yu REC_SENSOR_ID, thus can
To get in described monitoring device observation point model table the device ID associated by measuring point；
By device tables of data property value, generate CURVAL；
RES_UPDATE_TIME generates ACTIME；
Current time generates UPDATETIME.
Further, also include:
Use process scheduling instrument by interface bag, operating system command and the script of ETL by step 11～13 tissues
Get up and form different scene；
Make the various sequence of operation on-demand according to the rule of different trigger conditions and definition by the scheduling of scene
Trigger.
The present invention uses the reverse modeling approach by metric data to model and method, by from source professional system
The measurement history multidimensional data of middle extraction described primary equipment on-Line Monitor Device, thus generate primary equipment and exist
The mounted cast of line monitoring device and observation point model, thus realize to provide online professional system manufacturer
During monitoring device model, also can set up on-Line Monitor Device model.
Accompanying drawing explanation
Fig. 1 is the work of the present invention a kind of electric power operational system primary equipment on-Line Monitor Device model generating method
Make flow chart；
Fig. 2 is the schematic diagram of the reverse modeling rule of primary equipment on-Line Monitor Device of one example of the present invention.
Detailed description of the invention
The utility model is described in more detail with specific embodiment below in conjunction with the accompanying drawings.
It is illustrated in figure 1 one electric power operational system primary equipment on-Line Monitor Device model generating method of the present invention
Workflow diagram, including:
Step 11, the measurement history that described primary equipment on-Line Monitor Device is extracted in timing from the professional system of source is many
Dimension data, and it is saved in the history multidimensional data table of correspondence；
Step 12, processes each described history multidimensional data table, therefrom filters out the up-to-date described survey of renewal time
Amount history multidimensional data, sets up the corresponding latest data view including device tables of data, described device data
Table generates according to described measurement history multidimensional data；
Step 13, from described latest data view, sets up the device mould of described primary equipment on-Line Monitor Device
Type and observation point model, and safeguard the relation between described mounted cast and described observation point model.
Wherein in an embodiment, the history according to described source professional system of described history multidimensional data table is many
Dimension data table sort builds table.
Wherein in an embodiment, described step 11 specifically includes: timing passes through ETL from the professional system of source
The measurement history of the described primary equipment on-Line Monitor Device that the extraction last time is drawn into this extraction time period is many
Dimension data, and it is saved in the history multidimensional data table data of correspondence.
Wherein in an embodiment, described step 12 specifically includes: according to the survey being drawn in step 11
Amount history multidimensional data and the history multidimensional data list structure of correspondence, set up corresponding latest data table view；
Described spreadsheet views only preserves renewal time up-to-date data, and latest data view structure is gone through with described
History multidimensional data table is identical.
Wherein in an embodiment, wherein step 13 specifically includes: from described latest data view, root
According to the reverse modeling rule of primary equipment on-Line Monitor Device, set up the dress of described primary equipment on-Line Monitor Device
Put model and observation point model, and safeguard the relation between described mounted cast and described observation point model.
Wherein in an embodiment, the described reverse modeling rule of primary equipment on-Line Monitor Device by ETL from
Source professional system extracts.
Wherein in an embodiment, the described reverse modeling rule of primary equipment on-Line Monitor Device specifically includes:
The monitoring device model of described mounted cast is generated according to the device tables of data in described latest data view
Table and the monitoring device observation point model table of described observation point model.
Wherein in an embodiment, the device tables of data in described latest data view is generated described device mould
The monitoring device model table of type, specifically includes:
Described monitoring device model table is generated by device data table name REC_BS_ID Yu REC_SENSOR_ID
Interior unique NID；
Described prison is generated with relevant information in SENSORINFO table by device tables of data REC_SENSOR_ID
Survey NAME Yu the PHASE attribute in mounted cast table；
Generated with relevant information in MONITORPOSITIONINFO table by device tables of data REC_BS_ID
LOCATION_NID attribute in described monitoring device model table；
Generated described monitoring device by device tables of data attribute-name REC_BS_ID with REC_SENSOR_ID to survey
Unique NID in point model table；
Described prison is generated with relevant information in SENSORINFO table by device tables of data REC_SENSOR_ID
Survey NAME Yu the GCCDLX attribute in mounted cast table；
DEVICEID is generated by device data table name REC_BS_ID Yu REC_SENSOR_ID, thus can
To get in described monitoring device observation point model table the device ID associated by measuring point；
By device tables of data property value, generate CURVAL；
RES_UPDATE_TIME generates ACTIME；
Current time generates UPDATETIME.
Wherein in an embodiment, also include:
Use process scheduling instrument by interface bag, operating system command and the script of ETL by step 11～13 tissues
Get up and form different scene；
Make the various sequence of operation on-demand according to the rule of different trigger conditions and definition by the scheduling of scene
Trigger.
As an example, it is provided that cross-platform ETL technology realizes disparate databases, different pieces of information is originated
Primary equipment on-line equipment metric data access, coordinate modeling rule by the operation of commercial storehouse, automatically simultaneously
Primary equipment on-line equipment model and observation point model is generated in the system commercialization storehouse of this example.
Wherein, ETL is the abbreviation of Extraction-Transformation-Loading, and Chinese is that data carry
Take, change and load.ETL instrument has: OWB (Oracle Warehouse Builder), ODI (Oracle Data
Integrator), Informatic PowerCenter, Trinity, AICloudETL, DataStage,
After electric power operational system gets primary equipment on-Line Monitor Device model and Monitoring Data, in system
Each application just can obtain corresponding data by commercial bank interface and carry out calculating and the analysis of specialty.
It specifically comprises following step:
A) the primary equipment on-Line Monitor Device measurement history multidimensional data in the professional system of source is passed through by timing
ETL is drawn in the historical data table that the system of this example is corresponding；Extraction algorithm ensures that each extraction is only extracted
Historical data in previous extraction time interval；
B) process means by commercial storehouse internal data, set up latest data view: i.e. process each history
Tables of data, filters out the historical data up-to-date time that updates, and sets up corresponding latest data view；
C) use the reverse modeling rule of primary equipment on-Line Monitor Device, from latest data view, set up one
Between the mounted cast of secondary device on-Line Monitor Device and observation point model, and attending device model and observation point model
Relation.
D) using special process scheduling instrument, above step management got up, the most orderly calls,
Complete the renewal of model.
Wherein step a) farther includes: the primary equipment on-Line Monitor Device historical data of the system of this example
The historical data table sort according to origin system of table builds table, and each extraction only extraction last time is drawn into this and takes out
Take the data of time period, such as extraction in 5 minutes once, then only extract the historical data of first 5 minutes.Each
Historical data table will be continuously increased the data record of latest update.
Wherein step b) farther includes: according to different historical data list structures, set up different up-to-date numbers
According to table view；View only preserves renewal time up-to-date data.Latest data view structure and historical data
Table is identical, but only retains renewal time up-to-date data for the record that device id is identical.
Wherein step c) farther includes: the reverse modeling rule of primary equipment on-Line Monitor Device, and this rule is led to
Cross ETL extraction to realize, different for different types of data modeling rule, but it is all based on accompanying drawing 2 institute
Show that fundamental rule carries out data modeling.
Wherein step c) farther includes: polytype device is different according to contained attribute, and modeling rule has
A little different, but basic skills is consistent, as shown in Figure 2, and including: by A class device data table name,
REC_BS_ID, REC_SENSOR_ID be unique NID in generating monitoring device model table；Filled by A class
Put tables of data REC_SENSOR_ID and generate monitoring device model with relevant information in SENSORINFO table
NAME in table, PHASE attribute；By A class device tables of data REC_BS_ID with
In in MONITORPOSITIONINFO table, relevant information generates monitoring device model table
LOCATION_NID attribute；By A class device tables of data attribute A(or B, C...) attribute-name,
REC_BS_ID, REC_SENSOR_ID be unique NID in generating monitoring device observation point model table；By A
Class device tables of data REC_SENSOR_ID generates monitoring device with relevant information in SENSORINFO table
NAME in model table, GCCDLX attribute；By A class device data table name, REC_BS_ID,
REC_SENSOR_ID generates DEVICEID, such that it is able to get the device ID associated by measuring point；By
A class device tables of data attribute A(or B, C...) value, generate CURVAL；RES_UPDATE_TIME
Generate ACTIME；Current time generates UPDATETIME.
Wherein step d) farther includes: process scheduling instrument can be by the interface bag of ETL, operating system
Order, what script etc. was orderly organizes the different scene of formation；Various operation sequence is made by the scheduling of scene
Row can according to different trigger conditions, and definition the on-demand triggering of rule；Make monitoring model online permissible
On-demand holding, updates.
Embodiment described above only have expressed several embodiments of the present utility model, its describe more concrete and
In detail, but therefore can not be interpreted as the restriction to this utility model the scope of the claims.It should be pointed out that,
For the person of ordinary skill of the art, without departing from the concept of the premise utility, it is also possible to
Making some deformation and improvement, these broadly fall into protection domain of the present utility model.Therefore, this utility model
The protection domain of patent should be as the criterion with claims.
Claims (7)
1. an electric power operational system primary equipment on-Line Monitor Device model generating method, it is characterised in that
Including:
Step (11), timing is extracted the measurement of described primary equipment on-Line Monitor Device from the professional system of source and is gone through
History multidimensional data, and it is saved in the history multidimensional data table of correspondence；
Step (12), processes each described history multidimensional data table, therefrom filters out renewal time up-to-date institute
State measurement history multidimensional data, set up the corresponding latest data view including device tables of data, described device
Tables of data generates according to described measurement history multidimensional data；
Step (13), from described latest data view, sets up the dress of described primary equipment on-Line Monitor Device
Put model and observation point model, and safeguard the relation between described mounted cast and described observation point model.
Electric power operational system primary equipment on-Line Monitor Device model generation side the most according to claim 1
Method, it is characterised in that described history multidimensional data table is according to the history multidimensional data table of described source professional system
Table is built in classification.
Electric power operational system primary equipment on-Line Monitor Device model generation side the most according to claim 1
Method, it is characterised in that described step (11) specifically includes: timing is taken out by ETL from the professional system of source
Taking the last time is drawn into the measurement history multidimensional of described primary equipment on-Line Monitor Device of this extraction time period
Data, and it is saved in the history multidimensional data table of correspondence.
Electric power operational system primary equipment on-Line Monitor Device model generation side the most according to claim 1
Method, it is characterised in that described step (12) specifically includes: according to the survey being drawn in step (11)
Amount history multidimensional data and the history multidimensional data list structure of correspondence, set up corresponding latest data table view；
Described spreadsheet views only preserves renewal time up-to-date data, and latest data view structure is gone through with described
History multidimensional data table is identical.
Electric power operational system primary equipment on-Line Monitor Device model generation side the most according to claim 1
Method, it is characterised in that wherein step (13) specifically includes: from described latest data view, according to one
The reverse modeling rule of secondary device on-Line Monitor Device, sets up the device mould of described primary equipment on-Line Monitor Device
Type and observation point model, and safeguard the relation between described mounted cast and described observation point model；Described once set
The standby reverse modeling rule of on-Line Monitor Device specifically includes: according to the device data in described latest data view
Table generates the monitoring device model table of described mounted cast and the monitoring device observation point model of described observation point model
Table.
Electric power operational system primary equipment on-Line Monitor Device model generation side the most according to claim 5
Method, it is characterised in that the described reverse modeling rule of primary equipment on-Line Monitor Device is professional from source by ETL
System extracts.
Electric power operational system primary equipment on-Line Monitor Device model generation side the most according to claim 1
Method, it is characterised in that also include:
Use process scheduling instrument by interface bag, operating system command and the script of ETL by step (11)～(13)
Organize the different scene of formation；
Make the various sequence of operation on-demand according to the rule of different trigger conditions and definition by the scheduling of scene
Trigger.
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 CN103745413A (en) | 2014-04-23 |
| CN103745413B true 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) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110535701B (en) * | 2019-08-30 | 2022-07-01 | 新华三大数据技术有限公司 | Problem positioning method and device |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR100665268B1 (en) * | 2004-10-29 | 2007-01-04 | 한국전력공사 | Electronic watt meter with the intelligent agent |
-
2013
- 2013-12-19 CN CN201310711104.9A patent/CN103745413B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 |
|---|
| 变电站在线监测系统的一体化建模与模型维护;王德文等;《电力系统自动化》;20131210;第37卷(第23期);全文 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103745413A (en) | 2014-04-23 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105278373A (en) | Substation integrated information processing system realizing method | |
| CN103337012B (en) | Towards the multi-threaded intelligent comprehensive alert analysis method of grid equipment monitoring | |
| CN102426525B (en) | Panoramic modeling method of multi-application system | |
| CN102455698B (en) | Automatic control rate and stable rate monitoring system and monitoring method based on tree structure | |
| CN113935562A (en) | Intelligent rating and automatic early warning method for health condition of power equipment | |
| CN105427041A (en) | Standardized maintenance method for reconstruction and extension information point table of running substation | |
| CN105528671B (en) | A kind of power grid Multidimensional Awareness based on big data and safety estimation system and method | |
| CN104063761A (en) | SCADA data development system based on smart grid | |
| CN105631597A (en) | Construction method for transformer substation three-dimensional visual platform | |
| CN104850635A (en) | Auto check and centralized monitoring method for missing data in multi-data source environment | |
| CN105989427A (en) | Equipment status trend analysis and early warning method based on data mining | |
| CN104954181A (en) | Method for warning faults of distributed cluster devices | |
| Hongxun et al. | Data quality assessment for on-line monitoring and measuring system of power quality based on big data and data provenance theory | |
| CN102542400B (en) | The composition maintenance system and method for accurate Calculation cigarette production capacity | |
| CN106229978A (en) | The pre-judging method of platform district low-voltage problem and system | |
| CN103699688B (en) | A kind of terminal model of support terminal user's reliability management of power supply | |
| CN103745413B (en) | A kind of electric power operational system primary equipment on-Line Monitor Device model generating method | |
| CN106157180A (en) | The early warning system of platform district low-voltage problem | |
| CN105335824B (en) | Distribution network failure repairing command methods and system based on data center | |
| CN108512217B (en) | A kind of safe operation of electric network hidden danger intelligent identification Method | |
| CN106127602A (en) | A kind of stealing discrimination method based on yojan outlier algorithm and device | |
| CN103413249A (en) | Transformer substation equipment state assessment method based on computational formula | |
| CN104933519A (en) | Relay protection device condition-based maintenance aided decision making system | |
| CN112330489A (en) | Power supply station digital architecture design method based on TOGAF | |
| Lin et al. | Research on IoT perception technology of renewable energy based on edge computing |
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 |