CN108846490A - A kind of equipment state section generation method based on historical events - Google Patents
A kind of equipment state section generation method based on historical events Download PDFInfo
- Publication number
- CN108846490A CN108846490A CN201810759952.XA CN201810759952A CN108846490A CN 108846490 A CN108846490 A CN 108846490A CN 201810759952 A CN201810759952 A CN 201810759952A CN 108846490 A CN108846490 A CN 108846490A
- Authority
- CN
- China
- Prior art keywords
- section
- historical events
- time
- timestamp
- state
- 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.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 14
- 238000006073 displacement reaction Methods 0.000 claims description 4
- 238000012790 confirmation Methods 0.000 claims description 3
- 238000012545 processing Methods 0.000 claims description 3
- 238000012163 sequencing technique Methods 0.000 claims description 3
- 238000004458 analytical method Methods 0.000 abstract description 9
- 238000012423 maintenance Methods 0.000 abstract description 4
- 238000003012 network analysis Methods 0.000 abstract description 2
- 230000011664 signaling Effects 0.000 description 5
- 238000010937 topological data analysis Methods 0.000 description 2
- PEDCQBHIVMGVHV-UHFFFAOYSA-N Glycerine Chemical compound OCC(O)CO PEDCQBHIVMGVHV-UHFFFAOYSA-N 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012216 screening Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/20—Administration of product repair or maintenance
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/06—Energy or water supply
Landscapes
- Business, Economics & Management (AREA)
- Engineering & Computer Science (AREA)
- Human Resources & Organizations (AREA)
- Economics (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- Health & Medical Sciences (AREA)
- Theoretical Computer Science (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- General Physics & Mathematics (AREA)
- Marketing (AREA)
- Entrepreneurship & Innovation (AREA)
- Quality & Reliability (AREA)
- Operations Research (AREA)
- Public Health (AREA)
- Water Supply & Treatment (AREA)
- General Health & Medical Sciences (AREA)
- Primary Health Care (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The present invention proposes a kind of equipment state section generation method based on historical events, equipment state change histories item of this method by the acquisition to device name and in the period is inquired and is analyzed, the size that the front and back comparison of time is converted into timestamp is compared into problem, generates every 15 minutes in period equipment state sections.The section can facilitate operation maintenance personnel quickly to obtain the state of history sometime node device, solve the problems, such as that Historic Section equipment state low efficiency heavy workload can only could be obtained by the inquiry and manual analysis of historical events in the past.The generation of the section also provides data supporting for the electrical network analysis function of bonding apparatus measuring section.
Description
Technical field
The present invention relates to grid equipment state remote signalling section generation method fields, are based on history more particularly, to one kind
The equipment state section generation method of item.
Background technique
With the development that deepens constantly of automation system for the power network dispatching application, topological analysis becomes in dispatching automation application
More universal application, topological analysis in dispatch automated system often can only in real time or certain several Historic Section into
Row, for telemetry, one section of system every 15 minutes records facilitates operation maintenance personnel to carry out the inquiry of history curve.However,
The position of the switch state for needing to use when analyzing remote signalling state, especially data, system does not carry out Historic Section at present
Storage.This to analyze in accident event or in the analysis of subsequent equipment topological relation, analysis personnel cannot quickly judge
The opening and closing state of switchgear at that time, can only query history item, it is this in conjunction with manual analysis judgement equipment state at that time
Analysis method consumption manpower is larger, and efficiency is lower.
Summary of the invention
The present invention provides a kind of equipment state section generation method based on historical events, and this method forms switchgear one
When discontinuity surface in a period facilitates operation maintenance personnel for sometime point device state is inquired in the period.
In order to reach above-mentioned technical effect, technical scheme is as follows：
A kind of equipment state section generation method based on historical events, which is characterized in that include the following steps：
S1：Confirmation needs the switchgear of generating device state section, searches switchgear title；To needing generating device
The switchgear of state section is counted, and in dispatch automated system database to the implementor name of these switchgears into
Row obtains；
S2：According to device name and the period for needing to generate section, switch changed position historical events are obtained；Divide as needed
The period of analysis and the device name for needing to produce section in S1 are right in dispatch automated system historical events database
The displacement historical events of these switchgears during this period of time are inquired, and the history displacement event of switchgear is obtained；
S3：The historical events corresponding time is converted into timestamp format and is sorted；The historical events that S2 is inquired
The time (being accurate to the second) of middle each historical events is converted to Unix timestamp format, i.e. historical events time and 1970 1
0 divides the number of seconds value differed between 0 second when the moon 1 day 0, and the numerical value bigger expression time the latest, carries out according to the size of timestamp numerical value
Sequence carries out time-sequencing to historical events；
S4：Judge that equipment state in historical events, closure indicate that disconnection is indicated with 0 with 1；It is increased newly after S3 processing result
One column status Bar, is read out the text information in historical events, judges the character in text, if comprising " closing in item
Close " 1 is then written in status Bar, 0 is written in status Bar if including "off" in item；
S5：Within the period for needing generating device state section, it is used as a node within every 15 minutes, will be converted into the time
For timestamp format；Form the every 15 minutes node times needed in period for analyzing, and according to each 15 minutes when
Discontinuity surface generates corresponding Unix timestamp numerical value；
S6：According to device name and timestamp size Ordination historical events, time point is corresponded in corresponding equipment and is put on
Switch changed position state；Switchgear in S1 is analyzed one by one, historical events are read out one by one, is set to the switch
Standby associated historical events are screened, and the time stamp T and status Bar of historical events are read, by historical events time stamp T with
Every 15 minutes timing node timestamp numerical value carries out size comparison, finds out first timing node Tk bigger than time stamp T,
Insert the status Bar numerical value of the item in the section of the corresponding Tk of the switchgear, i.e., 1 or 0；
S7：Completion is carried out to the equipment timing node for not putting on Bitwise in section, all historical events are divided
After the completion of analysis, to each switch, remaining does not have the when discontinuity surface of equipment state to carry out completion, is swept from small to large with timestamp
It retouches, after scanning is to first stateful section, the switch state completion of all timing node sections before the section is should
Section negates；
In section continues to scan on, there is the switch state completion of all timing nodes between the section of switch state at two
For the small when discontinuity surface switch state of timestamp.
Compared with prior art, the beneficial effect of technical solution of the present invention is：
The equipment state section generation method based on historical events that the invention proposes a kind of.By being obtained to device name
It takes and the equipment state change histories item in the period is inquired and analyzed, convert the time for the front and back comparison of time
The size of stamp compares problem, generates every 15 minutes in period equipment state sections.The section can facilitate operation maintenance personnel pair
The state of history sometime node device is quickly obtained, and solving in the past can only inquiry by historical events and people
The problem of work point analysis could obtain Historic Section equipment state low efficiency heavy workload.The generation of the section is also bonding apparatus amount
The electrical network analysis function of surveying section provides data supporting.
Detailed description of the invention
Fig. 1 is the flow chart of the method for the present invention.
Specific embodiment
The attached figures are only used for illustrative purposes and cannot be understood as limitating the patent；
In order to better illustrate this embodiment, the certain components of attached drawing have omission, zoom in or out, and do not represent actual product
Size；
To those skilled in the art, it is to be understood that certain known features and its explanation, which may be omitted, in attached drawing
,
The following further describes the technical solution of the present invention with reference to the accompanying drawings and examples,
Embodiment 1
As shown in Figure 1, a kind of equipment state section generation method based on historical events, includes the following steps：
1) confirmation needs the switchgear of generating device state section, searches switchgear title；Such as it is needed in analysis
The remote signalling section that all 220kV substations get higher switch is obtained, needs to find all 220kV in dispatch automated system and becomes
Power station gets higher the implementor name of switch in systems, and if Foshan station 2201 switchs, the station equipment entitled FSZ.2201DL, Fen Jiang 2202 is opened
The entitled FJZ.2202DL of equipment in relationship system.The required implementor name for generating remote signalling section is obtained.
2) according to device name and the period for needing to generate section, switch changed position historical events are obtained；Such as it needs to give birth to
At 2016-2017 2 years switch remote signalling sections, then historical events table carried out in dispatch automated system historical data base
Condition query, condition include carrying out equipment associated by screening and item to the period belonging to item to screen, i.e., will 1)
In it is accessed that device name is associated with item.
3) the historical events corresponding time is converted into timestamp format and sorted；It will be in the historical events 2) inquired
The time (being accurate to the second) of each historical events is converted to Unix timestamp format, i.e. historical events time and January 1 in 1970
0 divides the number of seconds value differed between 0 second when day 0.The numerical value bigger expression time is arranged according to the size of timestamp numerical value the latest
Sequence carries out time-sequencing to historical events.Such as item " 2016/02/0515:21:53 Foshan station 2201 switch disconnects " thing
It is read out, judges in item the time for 2016/02/0515:21:53, it is converted into timestamp 1454656913, then in thing
1454656913 are written in the timestamp column of item.
4) judge that equipment state in historical events, closure indicate that disconnection is indicated with 0 with 1；Increase one newly after S3 processing result
Column status Bar is read out the text information in historical events, judges the character in text, if in item including " closed "
1 is then written in status Bar, 0 is written in status Bar if including "off" in item.Such as item " 2016/02/
0515:21:53 Foshan station 2201 switch disconnection " item is read out, and judges to include "off" character in item, then the item pair
The state field " 0 " answered, for item " 2016/07/0809:10:20 Foshan station 2201 close the switch " item is read out, sentences
It include " closed " character in disconnected item, then the corresponding state field " 1 " of the item.
5) it within the period for needing generating device state section, is used as a node within every 15 minutes, will be converted into the time
For timestamp format；Every 15 minutes node times in the period for needing to analyze are formed, such as the period for needing to analyze
For on December 31,1 day to 2016 January in 2016, then 1 day 00 January in 2016 is generated:00:00,2016 on January 1,00:15:
00,2016 on January 1,00:30:00 ... 2016 on December 31,23:30:00,2016 on December 31,23:45:00.And root
According to each 15 minutes when discontinuity surfaces, corresponding Unix timestamp numerical value is generated, that is, the timestamp for corresponding to above-mentioned time point is：
1451606400,1451607300,1451608200 ... 1483227000,1483227900.
6) according to device name and timestamp size Ordination historical events, time point is corresponded in corresponding equipment and is put on out
Close Bitwise；Switchgear in S1 is analyzed one by one, historical events are read out one by one, to the switchgear
Associated historical events are screened, and the time stamp T and status Bar of historical events are read, by historical events time stamp T and often
15 minutes timing node timestamp numerical value carries out size comparison, first timing node Tk bigger than time stamp T is found out, at this
The status Bar numerical value (1 or 0) of the item is inserted in the section of the corresponding Tk of switchgear.
Such as：For Foshan station 2201 switch, inquire an item be 2016 2 months 3 days 15 when 26 divide 54 seconds disconnect,
The time stamp T of the item is 1454513214, and state 0 compares the timing node timestamp of the switch, passes through the ratio of size
Compared with, it is known that when discontinuity surface timestamp (Tk) 1454513400 (30 divide 00 second at 2016 2 months 3 days 15) be first compare timestamp
T big timing node, therefore the corresponding section configuration of 2201 switch Tk of Foshan station is inserted 0.
7) completion is carried out to the equipment timing node for not putting on Bitwise in section.All historical events are analyzed
After the completion, to each switch, remaining does not have the when discontinuity surface of equipment state to carry out completion, is scanned from small to large with timestamp,
After scanning is to first stateful section, the switch state completion of all timing node sections before the section is the section
Negate.
Such as：Shape of the switch of Foshan station 2201 in timestamp section 1454513400 (30 divide 00 second at 2016 2 months 3 days 15)
State is 0 (disconnection), and timing node of the switch before the section be not without historical events, then timestamp section 1454513400
The state completion of all sections before is negating for the section configuration, i.e. completion is 1.
In section continues to scan on, there is the switch state completion of all timing nodes between the section of switch state at two
For the small when discontinuity surface switch state of timestamp.
Such as：Shape of the switch of Foshan station 2201 in timestamp section 1454513400 (30 divide 00 second at 2016 2 months 3 days 15)
State is 0 (disconnections), and 1455118200 (30 divide 00 second at 2016 2 months 10 days 15) states are 1 (closure), between the two items
There are 672 sections in total, the switch state and 1454513400 of that small section of the state filling timestamp of these sections
Switch state whole completion between to 1455118200 is 0.
The same or similar label correspond to the same or similar components；
Described in attached drawing positional relationship for only for illustration, should not be understood as the limitation to this patent；
Obviously, the above embodiment of the present invention be only to clearly illustrate example of the present invention, and not be pair
The restriction of embodiments of the present invention may be used also on the basis of the above description for those of ordinary skill in the art
To make other variations or changes in different ways, there is no necessity and possibility to exhaust all the enbodiments, all at this
Made any modifications, equivalent replacements, and improvements etc., should be included in the claims in the present invention within the spirit and principle of invention
Protection scope within.
Claims (1)
1. a kind of equipment state section generation method based on historical events, which is characterized in that include the following steps：
S1：Confirmation needs the switchgear of generating device state section, searches switchgear title；To needing generating device state
The switchgear of section is counted, and is obtained in dispatch automated system database to the implementor name of these switchgears
It takes；
S2：According to device name and the period for needing to generate section, switch changed position historical events are obtained；It analyzes as needed
Period and the device name for needing to produce section in S1, to these in dispatch automated system historical events database
The displacement historical events of switchgear during this period of time are inquired, and the history displacement event of switchgear is obtained；
S3：The historical events corresponding time is converted into timestamp format and is sorted；It is every in the historical events that S2 is inquired
The time (being accurate to the second) of one historical events is converted to Unix timestamp format, i.e. historical events time and on January 1st, 1970
0 divides the number of seconds value differed between 0 second when 0, and the numerical value bigger expression time is ranked up according to the size of timestamp numerical value the latest,
Time-sequencing is carried out to historical events；
S4：Judge that equipment state in historical events, closure indicate that disconnection is indicated with 0 with 1；Increase a column newly after S3 processing result
Status Bar is read out the text information in historical events, judges the character in text, if including " closed " in item
1 is written in status Bar, 0 is written in status Bar if including "off" in item；
S5：Within the period for needing generating device state section, a node is used as within every 15 minutes, when will be converted into the time
Between stab format；Form the every 15 minutes node times needed in period for analyzing, and according to each 15 minutes when be interrupted
Face generates corresponding Unix timestamp numerical value；
S6：According to device name and timestamp size Ordination historical events, time point is corresponded in corresponding equipment and puts on switch
Bitwise；Switchgear in S1 is analyzed one by one, historical events are read out one by one, to the switchgear phase
Associated historical events are screened, and the time stamp T and status Bar of historical events are read, by historical events time stamp T and every 15
Minute timing node timestamp numerical value carry out size comparison, find out first timing node Tk bigger than time stamp T, open at this
It closes and inserts the status Bar numerical value of the item in the section of the corresponding Tk of equipment, i.e., 1 or 0；
S7：Completion is carried out to the equipment timing node for not putting on Bitwise in section, all historical events analyzed
Cheng Hou, to each switch, remaining does not have the when discontinuity surface of equipment state to carry out completion, is scanned from small to large with timestamp, when
It scans to after first stateful section, the switch state completion of all timing node sections before the section is the section
It negates；
In section continues to scan on, when thering is the switch state completion of all timing nodes between the section of switch state to be at two
Between stab small when discontinuity surface switch state.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810759952.XA CN108846490A (en) | 2018-07-11 | 2018-07-11 | A kind of equipment state section generation method based on historical events |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810759952.XA CN108846490A (en) | 2018-07-11 | 2018-07-11 | A kind of equipment state section generation method based on historical events |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108846490A true CN108846490A (en) | 2018-11-20 |
Family
ID=64197020
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810759952.XA Pending CN108846490A (en) | 2018-07-11 | 2018-07-11 | A kind of equipment state section generation method based on historical events |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108846490A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111931980A (en) * | 2020-07-02 | 2020-11-13 | 广东电网有限责任公司 | Line historical load recording method for marking operation mode |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101984421A (en) * | 2010-09-03 | 2011-03-09 | 中国科学院软件研究所 | Real-time database based meteorological element data organization type-in and querying method |
| US20140337461A1 (en) * | 2012-12-13 | 2014-11-13 | Level 3 Communications, Llc | Collector mechanisms in a content delivery network |
| CN104153816A (en) * | 2014-09-04 | 2014-11-19 | 中国矿业大学(北京) | Coal cutter state monitoring method based on black box |
| CN104601646A (en) * | 2014-10-29 | 2015-05-06 | 北京伯仲佳和石油技术开发有限公司 | Oilfield electric power intelligent analyzing and optimizing energy efficiency management system |
| CN105657152A (en) * | 2014-11-28 | 2016-06-08 | 松下电器（美国）知识产权公司 | Remote control method and remote control system |
-
2018
- 2018-07-11 CN CN201810759952.XA patent/CN108846490A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101984421A (en) * | 2010-09-03 | 2011-03-09 | 中国科学院软件研究所 | Real-time database based meteorological element data organization type-in and querying method |
| US20140337461A1 (en) * | 2012-12-13 | 2014-11-13 | Level 3 Communications, Llc | Collector mechanisms in a content delivery network |
| CN104153816A (en) * | 2014-09-04 | 2014-11-19 | 中国矿业大学(北京) | Coal cutter state monitoring method based on black box |
| CN104601646A (en) * | 2014-10-29 | 2015-05-06 | 北京伯仲佳和石油技术开发有限公司 | Oilfield electric power intelligent analyzing and optimizing energy efficiency management system |
| CN105657152A (en) * | 2014-11-28 | 2016-06-08 | 松下电器（美国）知识产权公司 | Remote control method and remote control system |
Non-Patent Citations (1)
| Title |
|---|
| 陈升: ""统一时空电网数据模型与访问技术"", 《计算机系统应用》 * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111931980A (en) * | 2020-07-02 | 2020-11-13 | 广东电网有限责任公司 | Line historical load recording method for marking operation mode |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Mohsenian-Rad et al. | Distribution synchrophasors: Pairing big data with analytics to create actionable information | |
| Von Meier et al. | Precision micro-synchrophasors for distribution systems: A summary of applications | |
| EP3913555A1 (en) | Power distribution network operation aided decision-making analysis system and method | |
| CN107798395A (en) | A kind of power grid accident signal automatic diagnosis method and system | |
| Poudel et al. | Advanced FLISR with intentional islanding operations in an ADMS environment using GridAPPS-D | |
| CN101854652A (en) | Telecommunications network service performance monitoring system | |
| CN102495916A (en) | Multi-application-system panoramic modeling method based on object matching | |
| US20200393501A1 (en) | Systems and methods to analyze waveforms from multiple devices in power systems | |
| CN110363326A (en) | A kind of power grid 110kV route short term curve prediction method | |
| CN108846490A (en) | A kind of equipment state section generation method based on historical events | |
| CN104834305A (en) | Distribution network automated terminal telemetering abnormity analyzing system and method based on DMS system | |
| CN109579913A (en) | A kind of polymorphic monitoring method of distribution transformer and system | |
| CN111753528A (en) | Method and system for checking four-remote information table of transformer substation in unified and standard manner | |
| CN106650011A (en) | System for predicting development trend of ice disaster on power transmission line | |
| Prostejovsky | Increased observability in electric distribution grids: emerging applications promoting the active role of distribution system operators | |
| Song et al. | A new method for processing and application of wide area measurement big data in a power system | |
| CN102608467A (en) | Method and system for transient power quality analysis | |
| CN109687592A (en) | Substation information display control method, device and electronic equipment | |
| CN109672556A (en) | A kind of event alarm system | |
| CN109190941A (en) | A kind of automatic risk-assessment method of grid operation mode | |
| CN108107318A (en) | The localization method and device of user malfunction | |
| CN107357900A (en) | A kind of control method and device of electric power system model versions of data | |
| Yin et al. | Automatic fault analysis and visualization of digital substation event | |
| CN112256872A (en) | Intelligent billing method for transformer substation maintenance work ticket | |
| Kezunovic et al. | Optimized fault location |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20181120 |
|
| RJ01 | Rejection of invention patent application after publication |