CN107622078B - Method for monitoring health state of power consumption information acquisition equipment in real time - Google Patents
Method for monitoring health state of power consumption information acquisition equipment in real time Download PDFInfo
- Publication number
- CN107622078B CN107622078B CN201710624026.7A CN201710624026A CN107622078B CN 107622078 B CN107622078 B CN 107622078B CN 201710624026 A CN201710624026 A CN 201710624026A CN 107622078 B CN107622078 B CN 107622078B
- Authority
- CN
- China
- Prior art keywords
- data
- serial number
- continuous
- information
- electric energy
- 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
- 238000000034 method Methods 0.000 title claims abstract description 32
- 238000012544 monitoring process Methods 0.000 title claims abstract description 18
- 230000036541 health Effects 0.000 title claims abstract description 8
- 238000007405 data analysis Methods 0.000 claims description 10
- 230000008569 process Effects 0.000 claims description 10
- 238000004458 analytical method Methods 0.000 claims description 8
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 claims description 8
- 238000009826 distribution Methods 0.000 claims description 4
- 238000012423 maintenance Methods 0.000 claims description 4
- 238000004519 manufacturing process Methods 0.000 claims description 4
- 238000003860 storage Methods 0.000 claims description 4
- 230000005540 biological transmission Effects 0.000 claims description 3
- 238000004364 calculation method Methods 0.000 claims description 3
- 238000013500 data storage Methods 0.000 claims description 3
- 230000010354 integration Effects 0.000 claims description 3
- 239000013307 optical fiber Substances 0.000 claims description 3
- 230000002159 abnormal effect Effects 0.000 claims description 2
- 238000012790 confirmation Methods 0.000 claims description 2
- 238000001914 filtration Methods 0.000 claims 2
- 238000012163 sequencing technique Methods 0.000 claims 1
- 238000011144 upstream manufacturing Methods 0.000 claims 1
- 125000004122 cyclic group Chemical group 0.000 abstract description 2
- 230000005611 electricity Effects 0.000 description 23
- 238000007726 management method Methods 0.000 description 5
- 238000004891 communication Methods 0.000 description 2
- 238000010586 diagram Methods 0.000 description 2
- 238000007689 inspection Methods 0.000 description 2
- 230000002265 prevention Effects 0.000 description 2
- 238000012545 processing Methods 0.000 description 2
- 238000011160 research Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000003862 health status Effects 0.000 description 1
- 238000013508 migration Methods 0.000 description 1
- 230000005012 migration Effects 0.000 description 1
- 238000005065 mining Methods 0.000 description 1
Images
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Selective Calling Equipment (AREA)
Abstract
The invention relates to a method for monitoring power consumption equipment in real time, in particular to a method for monitoring the health state of power consumption information acquisition equipment in real time, aiming at the timeliness that each numerical value is adopted for cyclic traversal in the prior art, the efficiency is very low, hardware resources are seriously consumed, and the data requirement cannot be met.
Description
Technical Field
The invention relates to a method for monitoring power consumption equipment in real time, in particular to a method for monitoring the health state of power consumption information acquisition equipment in real time.
Background
Big data applications have been trending, and the "big data age" has come. The power system is gradually developed to build an intelligent power grid, the data in the power industry is greatly increased, the application of a new generation of internet represented by big data and cloud computing in the power system is wider, the data is the core of big data application, the accuracy and timeliness of power consumption information data have an important support function on important decisions of the power system, and a stable data and efficient acquisition method is required to be provided for realizing accurate and timely data.
The normal operation of the acquisition device is required to be ensured when the accuracy and the comprehensiveness of the data are influenced, and the fault can be timely repaired to ensure the timeliness of the data.
The traditional electricity utilization information acquisition method generally adopts the defects of low efficiency of manual acquisition and infrared acquisition, untimely data input into a system, low electricity utilization fault feedback time, low efficiency and the like, so that the real-time monitoring of the health condition of the electricity utilization equipment is difficult to realize, and the development trend in the field also develops towards the direction of online real-time monitoring. The user electricity consumption information acquisition system realizes electricity consumption monitoring, ladder pricing, load management and line loss analysis by acquiring and analyzing electricity consumption data of a distribution transformer and a terminal user, acquires real-time electricity consumption information of the user by adopting the electricity consumption information acquisition equipment, and finally achieves the purposes of automatic meter reading, off-peak electricity consumption, electricity consumption inspection (electricity stealing prevention), load prediction, electricity consumption cost saving and the like. However, in the actual application process, the situations that the electricity consumption information acquisition is discontinuously failed and the equipment state is unavailable due to various reasons such as network, equipment, severe weather and the like can occur, and the timeliness of automatic meter reading is influenced. Therefore, it is particularly necessary to find a method for monitoring the monitoring state of the power consumption information acquisition device in real time.
Disclosure of Invention
The user electricity consumption information acquisition system realizes electricity consumption monitoring, ladder pricing, load management and line loss analysis by acquiring and analyzing electricity consumption data of a distribution transformer and a terminal user, acquires real-time electricity consumption information of the user by adopting the electricity consumption information acquisition equipment, and finally achieves the purposes of automatic meter reading, off-peak electricity consumption, electricity consumption inspection (electricity stealing prevention), load prediction, electricity consumption cost saving and the like. Massive and diverse data resources provide good conditions for deep analysis of data, and can be innovated and applied around related business researches of power grid production, operation management and high-quality service, meanwhile, the work of improving data processing performance, mining data value, converting data into assets and the like is carried out, massive data information value is mined by applying a big data technology, and the problems of low data processing efficiency, weak analysis capability and the like of the existing core business system can be effectively solved.
However, in the actual application process, the situations that the electricity consumption information acquisition is discontinuously failed and the equipment state is unavailable due to various reasons such as network, equipment, severe weather and the like can occur, and the timeliness of automatic meter reading is influenced.
The data of the electric energy meter can be collected by a station terminal, a special transformer terminal, a public transformer terminal and a low-voltage centralized meter reading terminal through a communication medium. After various acquisition terminals acquire data to the electric energy meter at regular time, the acquisition terminals can feed back the acquisition state, namely success or failure.
In the actual operation process, if the acquisition terminal fails to acquire for more than three times continuously, an alarm is needed to prompt fault information of the electric energy meter of the area to which the power grid management belongs, and the purpose of monitoring the power utilization information acquisition equipment in real time is achieved.
A method for monitoring the health state of power consumption information acquisition equipment in real time conventionally comprises the following steps:
step 1, data acquisition: the method comprises the steps that data of the electric energy meter are collected in real time through a collecting terminal, and electric energy information of a metering device is collected;
step 2, data transmission: after data acquisition is finished, transmitting the data related to the acquired electric quantity back to the front-end server through the optical fiber, the 4g network, the special line and the related network components;
step 3, data storage: the front-end processor transmits collected data back to the production library server cluster through the intranet firewall equipment and a data link;
step 4, data integration: formatting and integrating the stored related electric energy data, and unifying data standards;
step 5, data analysis: by establishing a storage process, performing circular traversal on each value to judge whether the values are continuous or not; through the matching use of the lag and the lead functions in the oracle database, the method for extracting the relevant data does not need to carry out circular traversal on the numerical values, calculates the difference value in a migration mode, judges the numerical value to be continuous, greatly improves the efficiency of data analysis and calculates the analysis result;
and 6, data output: and outputting the calculation result and sending a signal to an execution device.
Compared with the prior art beneficial effect: in the prior art, the daily increment of the operation electric energy data can reach tens of millions, so that the efficiency is very low when each value is subjected to cyclic traversal, the hardware resource consumption is serious, and the timeliness of data requirements cannot be met.
Drawings
FIG. 1 data structure diagram
FIG. 2 data flow diagram
Detailed Description
The data of the electric energy meter can be collected by a station terminal, a special transformer terminal, a public transformer terminal and a low-voltage centralized meter reading terminal through a communication medium. After various acquisition terminals acquire data to the electric energy meter at regular time, the acquisition terminals can feed back the acquisition state, namely success or failure.
In the actual operation process, if the acquisition terminal fails to acquire for more than three times continuously, an alarm is needed to prompt fault information of the electric energy meter of the area to which the power grid management belongs, and the purpose of monitoring the power utilization information acquisition equipment in real time is achieved.
A method for monitoring the health state of power consumption information acquisition equipment in real time comprises the following specific implementation modes:
step 1, data acquisition: the method comprises the steps that data of the electric energy meter are collected in real time through a collecting terminal, and electric energy information of a metering device is collected;
step 2, data transmission: after data acquisition is finished, transmitting relevant data of the acquired electric energy back to the front-end server through the optical fiber, the 4g network, the special line and the relevant network components;
step 3, data storage: the front-end processor transmits the collected electric energy data back to the production library server cluster through the intranet firewall equipment and a data link;
step 4, data integration: formatting and integrating the stored related electric energy data, and unifying data standards;
step 5, data analysis: by establishing a storage process, performing circular traversal on each value to judge whether the values are continuous or not; through deep research on a data algorithm, the method for extracting relevant data through matching use of lag and lead functions in an oracle database is invented, the method does not need to carry out circular traversal on numerical values, difference values are calculated through an offset mode, the numerical values are judged to be continuous, the data analysis efficiency is greatly improved, and the analysis result is calculated;
and 6, data output: and outputting the calculation result and sending a signal to an execution device.
A method for monitoring the health status of power consumption information acquisition equipment in real time, wherein the step 5 is implemented by the following steps (fig. 2):
(1) acquiring information by the terminal, and formatting the information data;
(2) judging the continuous failure information sequence and the number of the acquisition equipment through the data analysis component;
(3) the suspected problem equipment is pushed to warning platforms in various cities;
(4) whether the equipment is faulty or not is judged manually, and equipment fault confirmation operation is carried out;
(5) and the confirmed fault equipment information is pushed to a relevant responsible maintenance department to carry out work order distribution and maintenance work.
In the step 5, the step (2) is specifically implemented to judge the information sequence which continuously fails and the number of the acquisition equipment which the data analysis component belongs to, and is realized by comparing the serial numbers of the equipment state information which is returned in real time aiming at the same terminal, and judging whether the serial numbers are continuous or not, so that in the actual operation, a row is added in a field, the serial number is shifted downwards by one bit, the current serial number is different from the serial number which is shifted downwards, and if the difference value is less than 3, the abnormal signal can be judged to be continuous;
examples are as follows:
in case of the same terminal name, date, terminal number:
(serial-offset downward-3 or offset upward-3)
Taking the part of flowing water as suspected flowing water;
wherein, 3 of (serial number-downward offset serial number-3 or upward offset serial number-3) or 3 of > -3 is a settable threshold value, if you want to extract absolutely continuous serial data, 3 can be changed to 1;
the specific implementation example statements are as follows:
Claims (1)
1. a method for monitoring the health state of power consumption information acquisition equipment in real time is characterized by comprising the following steps: step 1, data acquisition: the method comprises the steps that data of the electric energy meter are collected in real time through a collecting terminal, and electric energy information of a metering device is collected; step 2, data transmission: after data acquisition is finished, transmitting relevant data of the acquired electric energy back to the front-end server through the optical fiber, the 4g network, the special line and the relevant network components; step 3, data storage: the front-end processor transmits the collected electric energy data back to the production library server cluster through the intranet firewall equipment and a data link; step 4, data integration: formatting and integrating the stored electric energy related data, and unifying data standards; step 5, data analysis: judging whether the numerical values are continuous or not by establishing a storage process, and calculating an analysis result; and 6, data output: outputting the calculation result and sending a signal to an execution device;
step 5, analyzing data, namely extracting relevant data by matching lag and lead functions in an oracle database, wherein the method does not need to perform circular traversal on numerical values, calculates difference values in an offset mode, judges the numerical values to be continuous, greatly improves the efficiency of data analysis and calculates analysis results;
and 5, analyzing data, wherein the specific implementation steps are as follows: (1) acquiring information by the terminal, and formatting the information data; (2) judging the continuous failure information sequence and the number of the acquisition equipment through the data analysis component; (3) the suspected problem equipment is pushed to warning platforms in various cities; (4) whether the equipment is faulty or not is judged manually, and equipment fault confirmation operation is carried out; (5) the confirmed fault equipment information is pushed to a relevant responsible maintenance department, and work order distribution and maintenance work are carried out;
step 5, analyzing data, specifically implementing the step (2) of judging continuous failure information sequences and the numbers of the acquisition devices through a data analysis component, wherein the following operations are realized, aiming at the same terminal, comparing the upstream and downstream serial numbers of the device state information returned in real time, and judging whether the serial numbers are continuous or not, so that in the actual operation, a row is added in a field, the serial number is shifted downwards by one bit, the current serial number is differed from the downstream serial number, and if the difference value is less than =3, the continuation of abnormal signals can be judged;
in case of the same terminal name, date, terminal number:
(water number-offset running water downwards < =3 or offset running water upwards-water number < = 3)
Taking the part of flowing water as suspected flowing water;
wherein < =3 or > =3 in (stream number-downward offset stream number < =3 or upward offset stream number-stream number < = 3) is a settable threshold, if want to extract absolutely continuous stream, change 3 to 1;
the specific implementation process is as follows:
respectively acquiring the number of the fault occurrence electric energy meter, the ID information of the power supply station area, the fault occurrence date and the ID of the fault occurrence equipment from the number of the fault occurrence electric energy meter, the ID information of the power supply station area, the fault occurrence date and the ID of the fault occurrence equipment;
setting a continuous starting serial number, a continuous ending serial number and a continuous interval according to the serial number of the fault occurrence, and acquiring the quantity of the continuous serial numbers;
and (3) utilizing the lag function to downwards offset the filtered continuous serial numbers by 1-bit serial numbers, wherein the specific process is as follows: acquiring the serial number of the electric energy meter with the fault,
the power supply station area ID information is acquired,
the date on which the failure occurred is acquired,
the ID of the failure occurrence device is acquired,
acquiring the serial number of the fault occurrence,
offset downward by a 1-bit serial number,
is shifted up by a 1-bit serial number,
if the running number minus the downward offset value is greater than 1 or the downward offset value is null, the target data is 1
Or if the serial number value subtracted from the upward offset is larger than 1 or the upward offset value is null, the target data is 2
Otherwise, resetting the threshold value and determining the continuous interval, wherein the output result is 0;
the specific process of using the bag and the lead function together is as follows:
acquiring the serial number of the electric energy meter with the fault,
the power supply station area ID information is acquired,
the date on which the failure occurred is acquired,
the ID of the failure occurrence device is acquired,
acquiring the serial number of the fault occurrence,
the method comprises the steps of grouping according to the electric energy meter number and the station area ID, sequencing according to the electric energy meter number, the station area ID, the fault occurrence date, the fault occurrence equipment ID and the fault occurrence serial number, and upwardly offsetting the serial number by 1 bit through a lag function;
the method comprises the steps that grouping is carried out according to the electric energy meter number and the station area ID, sorting is carried out according to the electric energy meter number, the station area ID, the fault occurrence date, the fault occurrence equipment ID and the fault occurrence serial number, and the serial number is shifted downwards by 1 bit through a lead function; which comprises the following steps:
the power supply station area ID information is acquired,
the date on which the failure occurred is acquired,
the ID of the failure occurrence device is acquired,
acquiring the serial number of the fault occurrence,
acquiring the serial number of the electric energy meter with the fault,
reading a fault information list;
at the same time, the fault classification is filtered,
the failure data is obtained within 7 days of the operation,
the information which is put in storage is filtered,
the information in the assessment range is filtered,
lines less than or equal to 1 after filtering the serial number minus the serial number shifted down by 1 bit,
filtering the rows with the serial number less than or equal to 1 after the serial number which is shifted upwards by 1 bit is subtracted,
acquiring continuous identification data;
obtaining the last continuous serial number in the filtered continuous serial numbers;
and judging how many continuous records are needed, wherein the current continuous times are judged to be 3.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710624026.7A CN107622078B (en) | 2017-07-27 | 2017-07-27 | Method for monitoring health state of power consumption information acquisition equipment in real time |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710624026.7A CN107622078B (en) | 2017-07-27 | 2017-07-27 | Method for monitoring health state of power consumption information acquisition equipment in real time |
Publications (2)
Publication Number | Publication Date |
---|---|
CN107622078A CN107622078A (en) | 2018-01-23 |
CN107622078B true CN107622078B (en) | 2021-07-13 |
Family
ID=61088744
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201710624026.7A Active CN107622078B (en) | 2017-07-27 | 2017-07-27 | Method for monitoring health state of power consumption information acquisition equipment in real time |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN107622078B (en) |
Families Citing this family (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN108769076B (en) * | 2018-07-06 | 2023-12-05 | 北京绪水互联科技有限公司 | Data acquisition system, method and device with network isolation function |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN105046930A (en) * | 2015-06-29 | 2015-11-11 | 赖玉春 | Remote automatic meter recording system |
CN105699716A (en) * | 2016-03-31 | 2016-06-22 | 从兴技术有限公司 | Electric power consumption equipment metering and acquiring method, socket and electric power consumption equipment metering and acquiring system |
CN106341467A (en) * | 2016-08-30 | 2017-01-18 | 国网江苏省电力公司电力科学研究院 | State analysis method of power utilization information collector based on big data parallel computing |
Family Cites Families (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US6988025B2 (en) * | 2000-11-28 | 2006-01-17 | Power Measurement Ltd. | System and method for implementing XML on an energy management device |
-
2017
- 2017-07-27 CN CN201710624026.7A patent/CN107622078B/en active Active
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN105046930A (en) * | 2015-06-29 | 2015-11-11 | 赖玉春 | Remote automatic meter recording system |
CN105699716A (en) * | 2016-03-31 | 2016-06-22 | 从兴技术有限公司 | Electric power consumption equipment metering and acquiring method, socket and electric power consumption equipment metering and acquiring system |
CN106341467A (en) * | 2016-08-30 | 2017-01-18 | 国网江苏省电力公司电力科学研究院 | State analysis method of power utilization information collector based on big data parallel computing |
Also Published As
Publication number | Publication date |
---|---|
CN107622078A (en) | 2018-01-23 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN105740975B (en) | A kind of equipment deficiency assessment and prediction technique based on data correlation relation | |
CN107895176B (en) | Fog calculation system and method for wide-area monitoring and diagnosis of hydroelectric machine group | |
CN107180314B (en) | Operation and maintenance business model modeling method based on primary and secondary system incidence relation | |
CN104360208A (en) | Acquisition failure analyzing and processing method of electricity utilization information acquisition operating and maintaining system | |
CN104410163B (en) | A kind of safety in production based on electric energy management system and power-economizing method | |
CN109949178B (en) | Method for judging and complementing power failure event of medium-voltage distribution network based on support vector machine | |
CN105548744A (en) | Substation equipment fault identification method based on operation-detection large data and system thereof | |
CN111160791A (en) | Abnormal user identification method based on GBDT algorithm and factor fusion | |
CN103679556A (en) | System and method for intelligently diagnosing distribution transform terminal power failure warning | |
CN106771448A (en) | A kind of electric energy meter shunting anti-electricity-theft early warning analysis method of analysis | |
CN110095661B (en) | Distribution transformer high-voltage side open-phase fault first-aid repair method | |
CN109491339B (en) | Big data-based substation equipment running state early warning system | |
CN115395643A (en) | Low-voltage distribution network fault early warning positioning device and system based on full data acquisition and state perception | |
CN113641667B (en) | Data abnormity monitoring system and method of distributed big data acquisition platform | |
CN114928168A (en) | Offshore platform unmanned data edge computing device | |
CN103529337B (en) | The recognition methods of nonlinear correlation relation between equipment failure and electric quantity information | |
CN109613372B (en) | Power grid fault diagnosis method based on multi-element power grid database | |
CN109581115B (en) | Power distribution network low-voltage diagnosis system and diagnosis method | |
CN107622078B (en) | Method for monitoring health state of power consumption information acquisition equipment in real time | |
CN204945365U (en) | Gate energy meter supervising device | |
CN110555583A (en) | method for uniformly processing wide-area operation data of intelligent power grid dispatching control system | |
CN109443395B (en) | Method and system for judging whether energy consumption intensity multipoint measurement difference value exceeds limit value | |
CN104598713A (en) | Power grid theoretical line loss computation demand data synthesizing method | |
CN106600144A (en) | Anti-electricity-theft early warning analysis method with single anomaly analysis | |
CN106814268A (en) | A kind of big data analysis method based on intermittent defect |
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 | ||
GR01 | Patent grant | ||
GR01 | Patent grant |