CN109033126A - Power grid magnanimity telemetry based on real-time PI database inquires application method - Google Patents
Power grid magnanimity telemetry based on real-time PI database inquires application method Download PDFInfo
- Publication number
- CN109033126A CN109033126A CN201810549239.2A CN201810549239A CN109033126A CN 109033126 A CN109033126 A CN 109033126A CN 201810549239 A CN201810549239 A CN 201810549239A CN 109033126 A CN109033126 A CN 109033126A
- Authority
- CN
- China
- Prior art keywords
- telemetry
- database
- power grid
- data
- time
- 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
Abstract
The present invention provides a kind of power grid magnanimity telemetry inquiry application method based on real-time PI database, the second grade inquiry application of the invention power grid magnanimity telemetry, it needs the application under fine data scene to provide data supporting for power grid routine work, lays a good foundation for operation of power networks analysis；The second grade inquiry application of power grid magnanimity telemetry, in the increasing situation of the finenesses such as power grid customer service, operational management, the fine data inquiry of power grid magnanimity telemetry is provided, will can be very good to instruct the development of routine work, and take precautions against failure in possible trouble.
Description
Technical field
The present invention relates to the inquiry application method fields of power grid telemetry, are based on real-time PI more particularly, to one kind
The power grid magnanimity telemetry of database inquires application method.
Background technique
EMS(Energy Management System) it is to realize to the important means of operation of power networks monitoring, operation of power networks can be checked by EMS
Real time data.Limited by database volume, grid operation data only have 15 minutes a point (one day 96 data point) data
Storage.However in face of various dimensions extensive angle analysis demands such as business, production, planning, finance, there is reading inconvenience, analysis precision
The drawbacks such as deficiency.During power grid daily business diagnosis, traditional 15 minutes data points are difficult to meet daily need finely
Data analyze scene under application, such as: such as customer complaint voltage is low, any variation of busbar voltage can be used as analysis according to
According to, station personnel it is to be understood that DC bus-bar voltage with the presence or absence of required for unusual fluctuation, each power supply knows that its power supply is negative in standing
The power grids such as low pressure trip load Analysis when the instantaneous greatest measure of lotus, major network nonloaded line terminal voltage, large area emergency stop valve trip
The special screne analysis of routine work all needs accurate data and curves to support.Based on the above analysis, operation of power networks telemetering is realized
Data second grade inquiry, the data application of each second point can be inquired meet routine work analysis, be instantly there is an urgent need to
The demand solved.
Summary of the invention
The present invention provides a kind of power grid magnanimity telemetry inquiry application method based on real-time PI database, and this method is real
The second grade inquiry of existing power grid telemetry such as device current, voltage history data, needs fine number to meet in power grid routine work
According to the application under scene.
In order to reach above-mentioned technical effect, technical scheme is as follows:
A kind of power grid magnanimity telemetry inquiry application method based on real-time PI database, comprising the following steps:
S1: power grid telemetry obtains: being stored by EMS to power grid real time execution telemetry, during storage
In order to meet the storage of data second class precision and the limitation requirement of database volume；
S2: relational database and time series database type the storage of power grid telemetry: is respectively adopted to store different data letters
Breath；
S3: power grid telemetry is shown: after being stored by relational database and time series database to power grid telemetry,
Corresponding magnanimity telemetry is analyzed and processed, and is analyzed by interface for personnel inquiry.
Further, it is using the process that relational database stores different data informations in the step S2:
Basic information equipment and its point ID in time series database table are stored in relational database, when requiring to look up certain equipment
Telemetry when, the point ID of its time series database table can be found in relational database associations, then pass through method of service and obtain
Required data.
Further, the process for storing different data informations in the step S2 using time series database type is:
It is " sequence " by the point ID that the telemetry of more than the 10 of EMS system ten thousand collection points presses each equipment, longitudinal storage in order
It can accelerate storage and reading efficiency.
Further, the detailed process that power grid telemetry is shown in the step S3 is:
Carry out inquiry and data show interface, " area's sentence ", " substation " belonging to telemetry are inquired in selection first in interface, then
" the telemetering classification " that need to be inquired is selected, " device name " that need to be inquired then is selected, phase finally is set by the query range of selection
" spacing frequency " answered, while in order to consider the factors such as system response time and efficiency, for the query range of different length
Provided with minimum interval frequency, it may be assumed that
Data in 0-15 minutes: minimum 1 second spacing frequency returned data and maximin are supported；
Data in 15-30 minutes: minimum 5 seconds spacing frequency returned datas and maximin are supported；
Data in 30-60 minutes: minimum 30 seconds spacing frequency returned datas and maximin are supported；
Data in 1-24 hours: minimum 60 seconds spacing frequency returned datas and maximin are supported；
Data in 1-30 days: minimum 5 minutes spacing frequency returned datas and maximin are supported；
30 days -1 annual datas: minimum 60 minutes spacing frequency returned datas and maximin are supported；
Greater than 1 annual data: supporting minimum 1 day spacing frequency returned data and maximin.
Further, described not walk in S2, using oracle database by service, from three area's memory mirror of EMS system
Database extracts required equipment account, point number information, is stored in own database.
Further, in the step S3, using PI time series database by service, from three area's memory mirror of EMS system
Database extracts required telemetry intelligence (TELINT), is stored in own database.
Compared with prior art, the beneficial effect of technical solution of the present invention is:
The second grade inquiry application of power grid magnanimity telemetry of the present invention, needs the application under fine data scene for power grid routine work
Data supporting is provided, is laid a good foundation for operation of power networks analysis；The second grade inquiry application of power grid magnanimity telemetry, in power grid
In the increasing situation of the finenesses such as customer service, operational management, the fine data inquiry of power grid magnanimity telemetry is provided,
It will can be very good to instruct the development of routine work, and take precautions against failure in possible trouble.
Detailed description of the invention
Fig. 1 is that the present invention is based on the flow charts of the power grid magnanimity telemetry of real-time PI database inquiry application method；
Fig. 2 is that the present invention is based on the power grid magnanimity telemetries of real-time PI database to inquire application interface.
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 the ruler of actual product
It is very little；
To those skilled in the art, the omitting of some known structures and their instructions in the attached drawings are understandable.
The following further describes the technical solution of the present invention with reference to the accompanying drawings and examples.
Embodiment 1
The present invention is based on the power grid magnanimity telemetry of real-time PI database inquiry application method principles to be: by acquiring to EMS
Power grid real-time telemetry data obtained and stored, during storage in order to meet data storage fineness require and number
Capacity limit is stored according to library, magnanimity telemetry information is divided by using relational database and time series database respectively
Class storage.Magnanimity telemetry carries out fine data displaying after carrying out classification storage again, in order to full during data are shown
Pedal system response speed and the requirement of system data amount, are arranged different data query range different spacing frequencies, simultaneously will
Data are shown by curve form, realize the accurate analysis of data.In addition, being given during data are shown
Power grid telemetry maximum value and minimum value and the time of origin of its response in query range.
Referring to Fig. 1, a kind of power grid magnanimity telemetry inquiry application method based on real-time PI database is used
Specific real-time process is as follows:
All real-time grid telemetries that one area of S1 EMS system acquires real-time data memory memory bank 1:EMS system acquisition are equal
It need to be temporarily stored in one area of EMS system acquisition real time data memory bank.
Three area's memory mirror database 2 of system: since EMS system safety limits, all external systems can not be visited directly
Ask EMS system one area datarams library.Therefore the real-time grid telemetry of all EMS system acquisitions is both needed to through EM system one
Area's memory bank is synchronized to three area's memory mirror database purchase of EMS system.
Relational database (EMS point number and PI point relationship) 3: the electricity obtained from three area's memory mirror database of EMS system
Net telemetry intelligence (TELINT) is classified, and account class basic information is stored in relational database.The present invention uses Oracle data
Required equipment account, point number information are extracted by service, from three area's memory mirror database of EMS system in library, are stored in itself
Database.
Time series database (telemetry is by point and timing storage) 4: it is obtained from three area's memory mirror database of EMS system
Power grid telemetry intelligence (TELINT) classify, the numerical value of power grid telemetry itself is stored in time series database.The present invention is logical
PI time series database is crossed by service, required telemetry intelligence (TELINT) is extracted from three area's memory mirror database of EMS system, is stored in certainly
Body database.
Magnanimity telemetry query service (PI point is obtained by relationship library and inquires data) 5: needing to inquire some website
Telemetry when, by equipment sites ID in relational database analyzing device website account information, pass through equipment sites ID
The analytical equipment website telemetry value in PI time series database.Pass through equipment sites implementation relation database and PI time series data
Data correlation.
Magnanimity telemetry functional application interface 6: the query service according to S5 obtain site apparatus account information and
Its corresponding telemetry value carries out data displaying.During displaying, chart exhibition is carried out to the telemetering numerical value of query range
The when segmentum intercalaris for showing, and maximum value and minimum value in query range being further provided, while also occurring to maximum value and minimum value
Point is shown.As shown in Figure 2.
Other systems integrated data query page 7: by connecting embedded mode, by S6 magnanimity telemetry functional application circle
Face is integrated in other routine work systems, provides quick, convenient and fast query service for utility personnel.
Mobile application integrated data query function 8: other than power grid magnanimity telemetry is integrated in other systems by S7, also
The power grid telemetry of magnanimity is integrated in mobile application module.It is distant to realize that by cell phone application power grid can be realized in utility personnel
The query service of measured data provides property and high efficiency easy to use of the invention significantly.
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 to this hair
The restriction of bright embodiment.For those of ordinary skill in the art, it can also do on the basis of the above description
Other various forms of variations or variation out.There is no necessity and possibility to exhaust all the enbodiments.It is all in the present invention
Spirit and principle within made any modifications, equivalent replacements, and improvements etc., should be included in the guarantor of the claims in the present invention
Within the scope of shield.
Claims (6)
1. a kind of power grid magnanimity telemetry based on real-time PI database inquires application method, which is characterized in that including following
Step:
S1: power grid telemetry obtains: being stored by EMS to power grid real time execution telemetry, during storage
In order to meet the storage of data second class precision and the limitation requirement of database volume；
S2: relational database and time series database type the storage of power grid telemetry: is respectively adopted to store different data letters
Breath；
S3: power grid telemetry is shown: after being stored by relational database and time series database to power grid telemetry,
Corresponding magnanimity telemetry is analyzed and processed, and is analyzed by interface for personnel inquiry.
2. the power grid magnanimity telemetry according to claim 1 based on real-time PI database inquires application method, special
Sign is, is using the process that relational database stores different data informations in the step S2:
Basic information equipment and its point ID in time series database table are stored in relational database, when requiring to look up certain equipment
Telemetry when, the point ID of its time series database table can be found in relational database associations, then pass through method of service and obtain
Required data.
3. the power grid magnanimity telemetry according to claim 2 based on real-time PI database inquires application method, special
Sign is that the process for storing different data informations in the step S2 using time series database type is:
It is " sequence " by the point ID that the telemetry of more than the 10 of EMS system ten thousand collection points presses each equipment, longitudinal storage in order
It can accelerate storage and reading efficiency.
4. the power grid magnanimity telemetry according to claim 3 based on real-time PI database inquires application method, special
Sign is that the detailed process that power grid telemetry is shown in the step S3 is:
Carry out inquiry and data show interface, " area's sentence ", " substation " belonging to telemetry are inquired in selection first in interface, then
" the telemetering classification " that need to be inquired is selected, " device name " that need to be inquired then is selected, phase finally is set by the query range of selection
" spacing frequency " answered, while in order to consider the factors such as system response time and efficiency, for the query range of different length
Provided with minimum interval frequency, it may be assumed that
Data in 0-15 minutes: minimum 1 second spacing frequency returned data and maximin are supported；
Data in 15-30 minutes: minimum 5 seconds spacing frequency returned datas and maximin are supported；
Data in 30-60 minutes: minimum 30 seconds spacing frequency returned datas and maximin are supported；
Data in 1-24 hours: minimum 60 seconds spacing frequency returned datas and maximin are supported；
Data in 1-30 days: minimum 5 minutes spacing frequency returned datas and maximin are supported；
30 days -1 annual datas: minimum 60 minutes spacing frequency returned datas and maximin are supported；
Greater than 1 annual data: supporting minimum 1 day spacing frequency returned data and maximin.
5. the power grid magnanimity telemetry according to claim 4 based on real-time PI database inquires application method, special
Sign is, described not walk in S2, using oracle database by service, extracts from three area's memory mirror database of EMS system
Required equipment account, point number information, are stored in own database.
6. the power grid magnanimity telemetry according to claim 5 based on real-time PI database inquires application method, special
Sign is, in the step S3, using PI time series database by service, extracts from three area's memory mirror database of EMS system
Required telemetry intelligence (TELINT), is stored in own database.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810549239.2A CN109033126A (en) | 2018-05-31 | 2018-05-31 | Power grid magnanimity telemetry based on real-time PI database inquires application method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810549239.2A CN109033126A (en) | 2018-05-31 | 2018-05-31 | Power grid magnanimity telemetry based on real-time PI database inquires application method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109033126A true CN109033126A (en) | 2018-12-18 |
Family
ID=64611812
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810549239.2A Pending CN109033126A (en) | 2018-05-31 | 2018-05-31 | Power grid magnanimity telemetry based on real-time PI database inquires application method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109033126A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111026805A (en) * | 2019-11-08 | 2020-04-17 | 许昌许继软件技术有限公司 | Substation master station system and telemetry data cross-region transmission method |
| CN114205372A (en) * | 2021-12-08 | 2022-03-18 | 南方电网深圳数字电网研究院有限公司 | Data storage method and device of Internet of things |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102682051A (en) * | 2011-12-09 | 2012-09-19 | 江苏省电力公司苏州供电公司 | Method for integrating time series database with intelligent grid scheduling technology support system |
| CN103995807A (en) * | 2013-02-16 | 2014-08-20 | 长沙中兴软创软件有限公司 | Massive data query and secondary processing method based on Web architecture |
| US20160156186A1 (en) * | 2010-07-02 | 2016-06-02 | General Electric Technology Gmbh | Multi-interval dispatch method for enabling dispatchers in power grid control centers to manage changes background |
| CN107330017A (en) * | 2017-06-16 | 2017-11-07 | 云南电网有限责任公司信息中心 | A kind of electric power mass data storage and query and statistical analysis method and its system based on subject example |
-
2018
- 2018-05-31 CN CN201810549239.2A patent/CN109033126A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20160156186A1 (en) * | 2010-07-02 | 2016-06-02 | General Electric Technology Gmbh | Multi-interval dispatch method for enabling dispatchers in power grid control centers to manage changes background |
| CN102682051A (en) * | 2011-12-09 | 2012-09-19 | 江苏省电力公司苏州供电公司 | Method for integrating time series database with intelligent grid scheduling technology support system |
| CN103995807A (en) * | 2013-02-16 | 2014-08-20 | 长沙中兴软创软件有限公司 | Massive data query and secondary processing method based on Web architecture |
| CN107330017A (en) * | 2017-06-16 | 2017-11-07 | 云南电网有限责任公司信息中心 | A kind of electric power mass data storage and query and statistical analysis method and its system based on subject example |
Non-Patent Citations (2)
| Title |
|---|
| 孟祥君等: "智能电网大数据平台及其关键技术研究", 《供用电》 * |
| 岳阳等: "基于Hadoop的电力大数据技术体系研究", 《电力与能源》 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111026805A (en) * | 2019-11-08 | 2020-04-17 | 许昌许继软件技术有限公司 | Substation master station system and telemetry data cross-region transmission method |
| CN114205372A (en) * | 2021-12-08 | 2022-03-18 | 南方电网深圳数字电网研究院有限公司 | Data storage method and device of Internet of things |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101587152B (en) | Power quality monitoring system | |
| CN103532745A (en) | Metering online monitoring system based on power user power consumption information acquisition system | |
| CN102545213A (en) | System and method for managing line loss of power grid in real time | |
| CN108763399B (en) | Multi-source data modeling method suitable for power distribution network containing D-PMU | |
| CN102231171A (en) | Calculation, comparison, analysis and loss reduction method for statistical line loss and theoretical line loss | |
| CN105513328A (en) | Electric meter system based on Wifi cloud services | |
| CN111524027B (en) | Electric power information statistical method, device, equipment and storage medium | |
| CN207473028U (en) | Distribution Fault Location System | |
| Ma et al. | Phase identification of smart meters by spectral clustering | |
| CN106532698B (en) | A kind of Theoretical Line Loss of Distribution Network rate calculation method | |
| CN109033126A (en) | Power grid magnanimity telemetry based on real-time PI database inquires application method | |
| CN113722311A (en) | Power distribution network power failure range positioning method, system, equipment and medium | |
| CN108490285B (en) | Low-voltage transformer area line loss rate calculation method based on voltage drop method | |
| CN106228461B (en) | Low-voltage power supply reliability Accurate Analysis method and system based on Multi-data Source Mining | |
| CN204008812U (en) | A kind of current-leaking measuring device | |
| CN112100223A (en) | Power grid enterprise power equipment marketing and distribution run-through data acquisition and processing method | |
| CN109086896A (en) | The management method and device of test equipment | |
| CN102684307A (en) | Information intelligent layering and propelling method for comprehensively and automatically monitoring centralized control station and transformer substation | |
| CN111367970A (en) | Low-voltage diagnosis system based on data acquired by intelligent electric meter | |
| CN104598713A (en) | Power grid theoretical line loss computation demand data synthesizing method | |
| CN111105322A (en) | Low-voltage power distribution real-time monitoring system | |
| Romero et al. | Web based management system for power quality assessment and detection of critical zones | |
| Tang et al. | Modeling and validation of a distribution system with high PV penetration using zone division method | |
| Yang et al. | Compliance verification and probabilistic analysis of state-wide power quality monitoring data | |
| CN204204051U (en) | The long-range inspection device of electric substation |
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: 20181218 |
|
| RJ01 | Rejection of invention patent application after publication |