Power outage analysis and processing method and system based on big data

Abstract

The present invention provides a power outage judgment and processing method based on big data, which belongs to the field of communication technology. It includes: selecting a power outage event to be processed from a database; conducting power outage judgment and processing on the power outage event according to the power outage physical topology model of the power grid equipment, and obtaining a judgment result; when the power outage event is the power outage event of the electric meter: obtaining the information of the electric meter that reported the power outage event of the electric meter; when the power outage event of the electric meter belongs to a valid power outage event, finding the meter box to which the electric meter belongs according to the power outage physical topology model, and counting the number of electric meters under the meter box that have reported the valid power outage event; when the number of electric meters accounts for more than 30% of the total number of electric meters in the meter box, randomly selecting two electric meters under the meter box that have not reported the power outage event for transparent reading; if the transparent reading operation is unsuccessful, or it is found that the two electric meters that have not reported the power outage event have a power outage event within 24 hours, it is determined that the judgment result of the electric meter power outage event is a power outage of the meter box.

Description

Technical Field

[0001] The present invention relates to the field of communication technology, and in particular to a power outage analysis and processing method and system based on big data. Background Art

[0002] The transmission structure of the low-voltage power grid is composed of lines, stations, transformers, boxes and households. When a low-voltage power user experiences a power outage, the household meter will report the power outage message. Since the power outage may be caused by damage to a single household meter, power outage in the meter box where the household meter is located, or power outages of transformers, stations and lines, the power system should monitor and analyze the causes according to the power outages of each device in the power grid, so as to quickly and accurately repair it and minimize the power outage time for users.

[0003] When a power outage occurs, household meters and public transformer terminals may not have enough power to send alarms, resulting in failure to report power outages; when a power outage occurs in a substation, the clock may be lost, resulting in errors in the time of the power outage event and duplicate reports. There are serious problems of duplicate reporting, false reporting, and missed reporting of power outage and power-on events of on-site equipment. The power outage data is directly pushed to the power supply service command system without any analysis and processing, which will lead to a high misjudgment rate of power outage events, making it difficult to achieve refined judgment of power outage events, and unable to effectively support the efficient implementation of proactive emergency repair work. Summary of the invention

[0004] In view of this, the present invention provides a power outage analysis and processing method and system based on big data to solve the problem that it is difficult to achieve refined analysis of power outage events and cannot effectively support the efficient implementation of proactive emergency repair work.

[0005] The technical solution adopted by the embodiment of the present invention to solve the technical problem is:

[0006] A power outage analysis and processing method based on big data, comprising:

[0007] Select a power outage event to be processed from the database, wherein the power outage event includes a meter power outage event and a public transformer terminal power outage event;

[0008] Performing power outage analysis and processing on the power outage event according to the power outage physical topology model of the power grid equipment to obtain an analysis result, wherein the power outage physical topology model is composed of lines, substations, public transformer terminals, meter boxes, and electric meters;

[0009] When the power outage event is the power outage event of the electric meter, the power outage analysis and processing of the power outage event according to the power outage physical topology model of the power grid equipment includes:

[0010] Obtaining information of the electric meter that reported the electric meter power outage event;

[0011] In the case where the power outage event of the electric meter is a valid power outage event, the meter box to which the electric meter belongs is found according to the power outage physical topology model, and the number of electric meters under the meter box that have reported the valid power outage event during the time period when the power outage event of the electric meter occurs is counted;

[0012] When the number of electric meters that have reported the effective power outage event accounts for more than 30% of the total number of electric meters in the meter box, two electric meters under the meter box that have not reported the power outage event are randomly selected for meter reading;

[0013] If the through-reading operation of the two electric meters that have not reported a power outage event is unsuccessful, or if the through-reading operation finds that the two electric meters that have not reported a power outage event have a power outage event within 24 hours, then the judgment result of the power outage event of the electric meter is determined to be a power outage of the meter box;

[0014] Complete the power outage event records of all the electric meters under the meter box that have not reported power outage events;

[0015] When the power outage event to be processed is the power outage event of the public transformer terminal, the power outage analysis and processing of the power outage event according to the power outage physical topology model of the power grid equipment includes:

[0016] Obtaining information of the public transformer terminal that reported the power outage event of the public transformer terminal;

[0017] In the case where the power outage event of the public transformer terminal belongs to the valid power outage event, finding the substation area to which the public transformer terminal belongs according to the power outage physical topology model, and counting the total number of public transformer terminals under the substation area;

[0018] When the total number of the public transformer terminals is greater than 1, the number of electric meters in the substation area that have reported the valid power outage event during the time period when the power outage event of the public transformer terminal occurs is counted;

[0019] When the number of electric meters that have reported the effective power outage event accounts for more than 60% of the total number of electric meters in the substation, call all public transformer terminals in the substation to test, and determine whether all public transformer terminals in the substation have experienced the effective power outage event within the time period when the public transformer terminal power outage event occurs;

[0020] When all the public transformer terminals in the substation area experience the effective power outage event within the time period when the power outage event of the public transformer terminal occurs, it is determined that the substation area to which the public transformer terminal belongs has a power outage, and the power outage event records of all the power outage event meter boxes under the substation area that have not reported power outage events are completed;

[0021] Find out the line to which the substation belongs according to the power outage physical topology model;

[0022] Determine whether the proportion of the number of substations where effective power outages occur on the line is greater than 60%;

[0023] When the number of areas with effective power outage events under the line accounts for more than 60%, it is determined that the line to which the area belongs is out of power, and the power outage event records of all areas under the line that have not reported power outage events are completed;

[0024] The analysis result of the power outage event of the public transformer terminal is determined to be a power outage of the line to which the public transformer terminal belongs.

[0025] Preferably, after obtaining the meter information for reporting the power outage event of the meter, and before finding out the meter box to which the meter belongs according to the power outage physical topology model, the method further includes:

[0026] Performing a deduplication operation based on the information of the power outage event of the electric meter to eliminate duplicate event reporting messages in the database;

[0027] Performing time validity judgment based on the information of the power outage event of the electric meter;

[0028] When the time validity judgment result of the electric meter power outage event is valid, reading the electric meter to determine whether the electric meter power outage event belongs to the valid power outage event;

[0029] If the through-reading operation on the electric meter is unsuccessful, or if the through-reading operation finds that the electric meter has a power outage event within 24 hours, it is determined that the power outage event of the electric meter belongs to the valid power outage event.

[0030] Preferably, after randomly selecting two electric meters under the meter box that have not reported a power outage event for transparent reading, the method further includes:

[0031] If it is found through the through-reading operation that at least one of the two electric meters that have not reported a power outage event does not have a power outage event within the 24 hours, then the judgment result of the electric meter power outage event is determined to be a single-meter power outage.

[0032] Preferably, after counting the number of electric meters under the meter box that have reported the valid power outage event within the time period when the electric meter power outage event occurs, the method further includes:

[0033] When the number of electric meters that have reported the valid power outage event accounts for no more than 30% of the total number of electric meters in the meter box, the analysis result of the electric meter power outage event is determined to be a single-meter power outage.

[0034] Preferably, after obtaining the public transformer terminal information for reporting the power outage event of the public transformer terminal and before finding out the substation to which the public transformer terminal belongs according to the power outage physical topology model, the method further includes:

[0035] Performing a deduplication operation based on the information of the power outage event of the public transformer terminal to eliminate duplicate event reporting messages in the database;

[0036] Performing time validity judgment based on the information of the power outage event of the public transformer terminal;

[0037] When the time validity judgment result of the power outage event of the public transformer terminal is valid, reading any two meter boxes under the public transformer terminal to determine whether the power outage event of the public transformer terminal belongs to the valid power outage event;

[0038] If the through-reading operation of the arbitrary two meter boxes is unsuccessful, or if the through-reading operation finds that the arbitrary two meter boxes both have power failure events within the 24 hours, it is determined that the power failure event of the public transformer terminal belongs to the valid power failure event.

[0039] Preferably, after transparently copying any two meter boxes under the public transformer terminal, the method further includes:

[0040] If it is found through the transparent reading operation that at least one of the two meter boxes does not have a power failure event within the 24 hours, then the judgment result of the power failure event of the public transformer terminal is determined to be a single terminal power failure;

[0041] After counting the number of electric meters in the substation area that have reported the effective power outage event during the time period when the public transformer terminal power outage event occurs, the method further includes:

[0042] When the number of electric meters that have reported the valid power outage event accounts for no more than 60% of the total number of electric meters in the substation, the analysis result of the public transformer terminal power outage event is determined to be a single-terminal power outage.

[0043] Preferably, after determining whether the proportion of the number of areas where effective power outage events occur on the line is greater than 60%, the method further includes:

[0044] When the number of substations where effective power outages occur under the line accounts for no more than 60%, the judgment result of the public transformer terminal power outage event is determined to be a substation power outage.

[0045] Preferably, after determining that the result of the analysis of the power outage event of the public transformer terminal is that the line to which the public transformer terminal belongs is out of power, the method further includes:

[0046] When the power outage event of the electric meter is an invalid power outage event, calculating the frequency of the electric meter reporting the invalid power outage event;

[0047] When the frequency of the electric meter reporting the invalid power outage event is higher than a preset frequency threshold, adding the electric meter information to a blacklist;

[0048] An on-site operation and maintenance prompt message is generated according to the blacklist, and the on-site operation and maintenance prompt message includes the electric meter information.

[0049] Preferably, after generating the on-site operation and maintenance prompt message according to the blacklist, the method further includes:

[0050] Extracting the electric meter information in the blacklist;

[0051] Calculating the frequency of the electric meter reporting the invalid power outage event;

[0052] When the frequency of the invalid power outage event reported by the electric meter is not higher than the preset frequency threshold, the electric meter information is removed from the blacklist.

[0053] Furthermore, a power outage analysis and processing system based on big data is also provided, including a power outage event effectiveness analysis module, a power outage real-time accurate analysis module, and a power outage intelligent completion analysis module, wherein:

[0054] The power outage event validity analysis module is used to read the power outage event; and is also used to analyze whether the power outage event is a valid power outage event;

[0055] The real-time and accurate power outage analysis module is used to analyze and process the power outage event according to the power outage physical topology model of the power grid equipment to obtain the analysis result;

[0056] The power outage intelligent completion analysis module is used to complete the power outage event records of all substations, public transformer terminals, meter boxes, and electric meters that have not reported power outage events according to the analysis results;

[0057] When the power outage event is a power outage event of the electric meter,

[0058] The power outage event validity analysis module is used to determine whether the power outage event of the electric meter is the valid power outage event;

[0059] The real-time and accurate power outage analysis module is used to find out the meter box to which the meter belongs according to the power outage physical topology model when the meter power outage event belongs to the effective power outage event, and count the number of meters under the meter box that have reported the effective power outage event during the time period when the meter power outage event occurs; when the number of meters that have reported the effective power outage event accounts for more than 30% of the total number of meters in the meter box, randomly select two meters under the meter box that have not reported the power outage event for transparent reading; if the transparent reading operation of the two meters that have not reported the power outage event is unsuccessful, or if the transparent reading operation finds that the two meters that have not reported the power outage event have a power outage event within 24 hours, then the analysis result of the meter power outage event is determined to be a meter box power outage;

[0060] The real-time and accurate power outage assessment module is used to complete the power outage event records of all the electric meters under the meter box that have not reported power outage events.

[0061] It can be seen from the above technical scheme that an embodiment of the present invention provides a method and system for power outage analysis and processing based on big data, which specifically performs power outage analysis and processing on power outage events according to the power outage physical topology model of power grid equipment to obtain an analysis result. Specifically, when the power outage event is a meter power outage event, the information of the meter that reports the meter power outage event is obtained; when the meter power outage event is a valid power outage event, the meter box to which the meter belongs is found according to the power outage physical topology model, and the number of meters that have reported valid power outage events under the meter box during the time period when the meter power outage event occurred is counted. ; When the number of meters that have reported valid power outage events accounts for more than 30%, two meters under the meter box that have not reported power outage events are randomly selected for transparent reading; if the transparent reading operation of the two meters that have not reported power outage events is unsuccessful, or if the transparent reading operation finds that the two meters that have not reported power outage events have power outage events within 24 hours, the judgment result of the meter power outage event is determined to be a power outage in the meter box, and the power outage event records of all meters under the meter box that have not reported power outage events are completed; in addition, when the power outage event to be processed is a power outage event at the public transformer terminal, the public transformer terminal information that reported the power outage event at the public transformer terminal is obtained, When the power outage event of the public transformer terminal is a valid power outage event, the substation to which the public transformer terminal belongs is found according to the power outage physical topology model, and the number of public transformer terminals that have reported valid power outage events in the substation during the time period when the power outage event of the public transformer terminal occurred is counted; when the number of public transformer terminals that have reported valid power outage events accounts for more than 60%, all public transformer terminals in the substation are called for testing, and it is determined whether all public transformer terminals in the substation have valid power outage events during the time period when the power outage event of the public transformer terminal occurred; when all public transformer terminals in the substation have reported valid power outage events during the time period when the power outage event of the public transformer terminal occurred When there is an effective power outage event in the section, determine that the substation to which the public transformer terminal belongs has a power outage, and complete the power outage event records of all the power outage event boxes under the substation that have not reported a power outage event; find out the line to which the substation belongs according to the power outage physical topology model; determine whether the number of substations with effective power outage events under the line accounts for more than 60%; when the number of substations with effective power outage events under the line accounts for more than 60%, determine that the line to which the substation belongs has a power outage, and complete the power outage event records of all the substations under the line that have not reported a power outage event; determine that the judgment result of the power outage event of the public transformer terminal is a power outage on the line to which the public transformer terminal belongs. Through the method of the present invention, it is possible to achieve a refined judgment of power outage events and effectively support the efficient implementation of proactive emergency repair work. BRIEF DESCRIPTION OF THE DRAWINGS

[0062] Figure 1 This is the first flow chart of the power outage analysis and processing method based on big data of the present invention.

[0063] Figure 2 This is the second flow chart of the power outage analysis and processing method based on big data of the present invention.

[0064] Figure 3 This is the first structural diagram of the power outage analysis and processing system based on big data of the present invention.

[0065] Figure 4 This is a workflow diagram of the power outage analysis and processing system based on big data of the present invention. DETAILED DESCRIPTION

[0066] The technical scheme and technical effects of the present invention are further elaborated in detail below in conjunction with the accompanying drawings of the present invention.

[0067] The present invention provides a power outage analysis and processing method based on big data, and the specific steps include:

[0068] Step S1, selecting a power outage event to be processed from a database, the power outage event including a meter power outage event and a public transformer terminal power outage event;

[0069] Step S2, conducting power outage analysis and processing on the power outage event according to the power outage physical topology model of the power grid equipment to obtain the analysis result. The power outage physical topology model consists of lines, substations, public transformer terminals, meter boxes, electric meters and their upper and lower subordinate relationships.

[0070] like Figure 1 As shown, when the power outage event to be processed is a meter power outage event, the power outage analysis and processing of the power outage event according to the power outage physical topology model of the power grid equipment includes:

[0071] Step S11, obtaining the meter information of the reported power outage event;

[0072] Step S12, when the power outage event of the electric meter is a valid power outage event, find out the meter box to which the electric meter belongs according to the power outage physical topology model, and count the number of electric meters that have reported valid power outage events under the meter box during the time period when the power outage event of the electric meter occurs;

[0073] Step S13: when the number of electric meters that have reported effective power outage events accounts for more than 30% of the total number of electric meters in the meter box, two electric meters that have not reported power outage events under the meter box are randomly selected for transparent reading;

[0074] Step S14, if the transparent reading operation of the two electric meters that have not reported the power outage event is unsuccessful, or if the transparent reading operation finds that the two electric meters that have not reported the power outage event have a power outage event within 24 hours, then the judgment result of the electric meter power outage event is determined to be a meter box power outage;

[0075] Step S15, completing the power outage event records of all the electric meters under the meter box that have not reported a power outage event;

[0076] Furthermore, before step S12, it is necessary to perform deduplication and validity judgment based on the power outage event of the electric meter, and the specific steps include: performing deduplication operation based on the information of the power outage event of the electric meter to eliminate the duplicate event report messages in the database; performing time validity judgment based on the information of the power outage event of the electric meter; when the time validity judgment result of the power outage event of the electric meter is valid, the electric meter is read to determine whether the power outage event of the electric meter is a valid power outage event; if the reading operation of the electric meter is unsuccessful, or the reading operation finds that the electric meter has a power outage event within 24 hours, then the power outage event of the electric meter is determined to be a valid power outage event. The time validity judgment is to determine the validity of the power outage event and avoid repeated reporting due to internal clock errors of the equipment.

[0077] Furthermore, when the number of meters that have reported valid power outage events under the meter box during the time period when the meter power outage event occurred is counted in step S12 and the proportion is no more than 30%, it is determined that the analysis result of the meter power outage event is a single-meter power outage.

[0078] Furthermore, in step S13, after performing a transparent reading operation on two random meters under the meter box that have not reported a power outage event, if it is found that at least one of the two meters that have not reported a power outage event has not had a power outage event within 24 hours, the judgment result of the meter power outage event is determined to be a single-meter power outage.

[0079] like Figure 2 As shown, when the power outage event to be processed is a power outage event at a public transformer terminal, the power outage analysis and processing of the power outage event according to the power outage physical topology model of the power grid equipment includes:

[0080] Step S21, obtaining the public transformer terminal information that reports the public transformer terminal power outage event;

[0081] Step S22, when the power outage event of the public transformer terminal is a valid power outage event, find out the substation area to which the public transformer terminal belongs according to the power outage physical topology model, and count the total number of public transformer terminals in the substation area;

[0082] Step S23, when the total number of public transformer terminals is greater than 1, the number of electric meters that have reported valid power outage events in the substation area during the time period when the power outage event of the public transformer terminal occurs is counted;

[0083] Step S24: when the number of meters that have reported effective power outage events accounts for more than 60% of the total number of meters in the area, call all public transformer terminals in the area to test, and determine whether all public transformer terminals in the area have effective power outage events in the time period when the public transformer terminal power outage event occurs;

[0084] Step S25, when all public transformer terminals in the substation area have effective power outage events within the time period when the power outage event of the public transformer terminal occurs, determine that the substation area to which the public transformer terminal belongs has a power outage, and complete the power outage event records of all unreported power outage event boxes under the substation area;

[0085] Step S26, finding the line to which the outage area belongs according to the power outage physical topology model;

[0086] Step S27, determining whether the proportion of the number of areas where effective power outage events occur under the line is greater than 60%;

[0087] Step S28, when the number of areas with effective power outage events under the line accounts for more than 60%, it is determined that the line to which the area belongs is out of power, and the power outage event records of all areas under the line that have not reported power outage events are completed;

[0088] Step S29, determining that the result of the analysis of the power outage event of the public transformer terminal is that the line to which the public transformer terminal belongs has a power outage.

[0089] Furthermore, before step S22, it is also necessary to perform deduplication and validity judgment based on the power outage event of the public transformer terminal. The specific steps include: performing deduplication based on the information of the power outage event of the public transformer terminal to eliminate duplicate event reporting messages in the database; performing time validity judgment based on the information of the power outage event of the public transformer terminal; when the time validity judgment result of the power outage event of the public transformer terminal is valid, transparently scan any two meter boxes under the public transformer terminal to determine whether the power outage event of the public transformer terminal is a valid power outage event; if the transparent scanning operation of any two meter boxes is unsuccessful, or if the transparent scanning operation finds that any two meter boxes have power outage events within 24 hours, then the power outage event of the public transformer terminal is determined to be a valid power outage event. Further, after the above-mentioned transparent scanning of any two meter boxes under the public transformer terminal, if the transparent scanning operation finds that at least one of the two meter boxes does not have a power outage event within 24 hours, then the judgment result of the power outage event of the public transformer terminal is determined to be a single terminal power outage.

[0090] Furthermore, when the number of electric meters that have reported effective power outage events in step S22 accounts for no more than 60% of the total number of electric meters in the substation, the result of the analysis of the public transformer terminal power outage event is determined to be a single terminal power outage.

[0091] Furthermore, when the number of public transformer terminals under the substation is counted as 1 in step S23, it can be directly determined that the analysis result is a power outage in the substation.

[0092] Furthermore, when the number of substations where effective power outages occur under the statistical line in step S27 accounts for no more than 60%, the analysis result of the public transformer terminal power outage event is determined to be a substation power outage.

[0093] Furthermore, the present invention performs the following processing steps for the situation where the electric meter equipment frequently reports invalid power outage events: when the electric meter power outage event is an invalid power outage event, calculate the frequency of the electric meter reporting invalid power outage events; when the frequency of the electric meter reporting invalid power outage events is higher than a preset frequency threshold, add the electric meter information to a blacklist; generate an on-site operation and maintenance prompt message based on the blacklist list, and the on-site operation and maintenance prompt message includes the electric meter information.

[0094] Furthermore, on-site staff can perform on-site troubleshooting for faulty meters based on operation and maintenance prompt messages. After the meters resume normal operation, the system performs the following processing: extracting meter information from the blacklist; calculating the frequency of invalid power outage events reported by the meter; and removing the meter information from the blacklist when the frequency of invalid power outage events reported by the meter is no higher than a preset frequency threshold.

[0095] The method of the present invention can systematically analyze and judge the power outage time, provide accurate analysis results, and improve the efficiency of power grid maintenance and operation.

[0096] Furthermore, if Figure 3 As shown, the present invention also provides a power outage analysis and processing system based on big data, including a power outage event effectiveness analysis module 31, a power outage real-time accurate analysis module 32, and a power outage intelligent completion analysis module 33, wherein:

[0097] The power outage event validity analysis module 31 is used to read the power outage event; it is also used to analyze whether the power outage event is a valid power outage event; it is also used to further write the analysis result of the power outage event into the database of the data layer; the power outage event message is obtained from the message bus.

[0098] The real-time and accurate power outage judgment module 32 is used to judge the power outage event according to the power outage physical topology model of the power grid equipment and obtain the judgment result; it is used to read the model and valid event data from the data layer at regular intervals, and write the judgment results into the database in batches;

[0099] The power outage intelligent completion analysis module 33 is used to read the analysis results from the database, and complete the power outage event records for all substations, public transformer terminals, meter boxes, and electric meters that have not reported power outage events based on the analysis results.

[0100] Specifically, when the power outage event is a meter power outage event,

[0101] The power outage event validity analysis module 31 is used to determine whether the power outage event of the electric meter is a valid power outage event; specifically: deduplication operation is performed based on the information of the power outage event of the electric meter to eliminate duplicate event reporting messages in the database; time validity judgment is performed based on the information of the power outage event of the electric meter; when the time validity judgment result of the power outage event of the electric meter is valid, the electric meter is read to determine whether the power outage event of the electric meter is a valid power outage event; if the through-reading operation of the electric meter is unsuccessful, or the through-reading operation finds that the electric meter has a power outage event within 24 hours, the power outage event of the electric meter is determined to be a valid power outage event.

[0102] The real-time and accurate power outage judgment module 32 is used to find out the meter box to which the meter belongs according to the power outage physical topology model when the power outage event of the meter is a valid power outage event, and count the number of meters under the meter box that have reported valid power outage events during the time period when the power outage event of the meter occurs; when the number of meters that have reported valid power outage events accounts for more than 30% of the total number of meters in the meter box, randomly select two meters under the meter box that have not reported power outage events for transparent reading; if the transparent reading operation of the two meters that have not reported power outage events is unsuccessful, or if the transparent reading operation finds that the two meters that have not reported power outage events If the meter involved in the power outage event has a power outage event within 24 hours, the result of the meter power outage event is determined to be a meter box power outage; if the number of meters under the meter box that have reported valid power outage events during the time period when the meter power outage event occurred accounts for no more than 30%, the result of the meter power outage event is determined to be a single-meter power outage; after performing a transparent reading operation on two random meters under the meter box that have not reported a power outage event, if it is found that at least one of the two meters that have not reported a power outage event has not had a power outage event within 24 hours, the result of the meter power outage event is determined to be a single-meter power outage.

[0103] The real-time and accurate power outage assessment module 33 is used to complete the power outage event records of all the electric meters under the meter box that have not reported power outage events.

[0104] The system performs validity analysis on batch power-off and power-on events as follows: batch read the original data of power-off and power-on events in the data layer HBASE; use the Spark computing engine and validity analysis rules to pre-process the events; and finally write the processing results into HBASE in batches.

[0105] The system analyzes and processes batch power-off and power-on events as follows: define scheduled tasks to batch read effective power-off and power-on events of devices in HBASE; use the Spark computing engine to match the distribution network and power-off analysis model to perform real-time power-off analysis; and write the analysis results into HBASE in batches.

[0106] Specifically, when the power outage event is a power outage event at a public transformer terminal,

[0107] The power outage event validity analysis module 31 is used to determine whether the power outage event at the public transformer terminal is a valid power outage event; specifically: perform deduplication based on the information of the power outage event at the public transformer terminal to eliminate duplicate event reporting messages in the database; perform time validity judgment based on the information of the power outage event at the public transformer terminal; when the time validity judgment result of the power outage event at the public transformer terminal is valid, read any two meter boxes under the public transformer terminal to determine whether the power outage event at the public transformer terminal is a valid power outage event; if the reading operation of any two meter boxes is unsuccessful, or if the reading operation finds that any two meter boxes have power outage events within 24 hours, then the power outage event at the public transformer terminal is determined to be a valid power outage event. Furthermore, after the above reading operation of any two meter boxes under the public transformer terminal, if the reading operation finds that at least one of the two meter boxes does not have a power outage event within 24 hours, then the judgment result of the power outage event at the public transformer terminal is determined to be a single terminal power outage.

[0108] The real-time and accurate power outage judgment module 32 is used to find out the substation to which the public transformer terminal belongs according to the power outage physical topology model when the power outage event at the public transformer terminal is a valid power outage event, and count the total number of public transformer terminals in the substation; when the total number of public transformer terminals is greater than 1, count the number of electric meters in the substation that have reported valid power outage events during the time period when the public transformer terminal power outage event occurred; when the number of electric meters that have reported valid power outage events accounts for no more than 60% of the total number of electric meters in the substation, determine that the judgment result of the public transformer terminal power outage event is a single-terminal power outage; when the number of electric meters that have reported valid power outage events accounts for more than 60% of the total number of electric meters in the substation, call all public transformer terminals in the substation, and judge whether all public transformer terminals in the substation are Whether there are effective power outage events in the time period when the public transformer terminal power outage event occurs; when all public transformer terminals in the substation area have effective power outage events in the time period when the public transformer terminal power outage event occurs, determine that the substation area to which the public transformer terminal belongs has a power outage; find out the line to which the substation area belongs according to the power outage physical topology model; determine whether the proportion of substations with effective power outage events under the line is greater than 60%; when the proportion of substations with effective power outage events under the line is not greater than 60%, determine that the judgment result of the public transformer terminal power outage event is a substation power outage; when the proportion of substations with effective power outage events under the line is greater than 60%, determine that the line to which the substation area belongs has a power outage. Determine that the judgment result of the public transformer terminal power outage event is a power outage on the line to which the public transformer terminal belongs;

[0109] The real-time and accurate power outage assessment module 33 is used to complete the power outage event records of all the meter boxes under the substation that have not reported power outage events; it is also used to complete the power outage event records of all substations under the line that have not reported power outage events.

[0110] Furthermore, the system of the present invention handles the situation where the electric meter device frequently reports invalid power outage events as follows:

[0111] The invalid power outage event management module 34 is used to calculate the frequency of the meter reporting invalid power outage events when the power outage event of the meter is an invalid power outage event; when the frequency of the meter reporting invalid power outage events is higher than the preset frequency threshold, the meter information is added to the blacklist; based on the blacklist list, an on-site operation and maintenance prompt message is generated, and the on-site operation and maintenance prompt message includes the meter information.

[0112] Furthermore, on-site staff can perform on-site troubleshooting on the faulty meter according to the operation and maintenance prompt message. After the meter works normally again, the system performs the following processing:

[0113] The invalid power outage event management module 34 is used to extract the meter information in the blacklist; calculate the frequency of the meter reporting invalid power outage events; when the frequency of the meter reporting invalid power outage events is not higher than a preset frequency threshold, remove the meter information from the blacklist.

[0114] like Figure 4 As shown, Figure 4 Shown Figure 3 The analysis and judgment process of the system shown in the figure shows that when a power outage event occurs, the system can be divided into five analysis and judgment units, namely, meter power outage analysis, meter box power outage analysis, public transformer terminal power outage analysis, substation power outage analysis and line power outage analysis, and power outage analysis is carried out step by step.

[0115] For the power outage analysis of the electric meter, first deduplication and time validity verification are performed, and then the power outage event of the electric meter is read. If the reading is successful and there is no power outage event within 24 hours, the power outage event is an invalid power outage event. If the reading is unsuccessful, or a power outage event is found within 24 hours, the power outage event is determined to be a valid power outage event, and further enter the power outage analysis of the meter box.

[0116] For the analysis of power outages in meter boxes, first check the number of valid power outage events reported by the meters under the same meter box. If the proportion of valid power outages is not higher than 30%, the final analysis result is determined to be a single-meter power outage. If the proportion of valid power outages is higher than 30%, randomly read the meters under 2 meter boxes that have not reported power outages. If there are meters that have successfully read the information and have no power outage events within 24 hours, the final analysis result is determined to be a single-meter power outage. If the reading is unsuccessful, or a power outage event is found within 24 hours, the analysis result is determined to be a meter box power outage, and the power outage event data of all meters under the meter box are completed.

[0117] For the power outage analysis of the public transformer terminal, firstly, deduplication and time validity check are performed, and then the power outage events of any two meter boxes of the public transformer terminal are read. If the reading is successful and there is no power outage event within 24 hours, then the power outage event is invalid. If the reading is successful or unsuccessful, or a power outage event is found within 24 hours, then the power outage event is determined to be a valid power outage event, and the power outage event data of all meter boxes under the public transformer terminal are completed, and further power outage analysis is carried out in the substation area.

[0118] For the power outage analysis of the substation, we can first analyze the number of public transformer terminals in the substation where the public transformer terminals are located. If there is only one public transformer terminal under the substation, the final analysis result can be directly determined to be a single-terminal power outage; if there are at least two public transformer terminals under the substation, then the proportion of the number of electric meters reporting valid power outage events under the substation is counted. If the proportion of the number of electric meters reporting valid power outage events under the substation is higher than 60%, the substation is confirmed to have a power outage; if the proportion is not higher than 60%, all public transformer terminals under the substation are called to determine whether all public transformer terminals have experienced a power outage event. If all public transformer terminals have experienced a power outage event, the substation is confirmed to have a power outage; if there are public transformer terminals that have not experienced a power outage event, the final analysis result is determined to be a single-terminal power outage. After confirming the power outage in the substation, complete the power outage event data of all public transformer terminals under the substation, and further enter the line power outage analysis;

[0119] For line power outage assessment, it is necessary to determine whether the number of substations experiencing power outages under the line accounts for more than 60%. If the proportion is more than 60%, the final assessment result is determined to be line power outage, and the power outage data of all substations under the line is completed; if the proportion is not more than 60%, the final assessment result is determined to be substation power outage.

[0120] In the system of the present invention, the power outage physical topology model generates a medium and low voltage power grid topology map based on the existing substation archives, line archives, substation archives, terminal archives, meter box archives, metering point archives, user archives, and electric meter archives of PMS, power grid GIS, and marketing. By associating the real-time power outage and power-on event information of terminals and electric meters, the power grid topology single-line diagram is used to display the relationship between the line-substation-terminal-meter box-household meter and the real-time power outage and power-on situation in real time, realizing a panoramic visualization of power outage and restoration, and providing auxiliary support for the monitoring of power supply reliability indicators.

[0121] In the system of the present invention, historical data and batch data of power outages are accessed to the big data platform using the Sqoop tool, and real-time data is collected to the big data platform using a real-time data collection tool (Kafka+Storm / Flink).

[0122] In the present invention, the system realizes the validity analysis of power-off and power-on events through stream processing technology: the big data platform processes each batch of events with a reporting time greater than T-3 minutes and less than T-13 minutes, and uses stream processing technology to conduct real-time analysis on whether the power-off and power-on time is complete, whether the time sequence is logical, whether it is reported repeatedly, whether it is reported frequently, etc., and filters unreasonable event data. For the reasonably reported power-off time, the power-off time of any two meters under the terminal is read, and then the validity of the event is analyzed.

[0123] In the present invention, the system realizes real-time analysis of power outages based on big data technology: through the big data platform Flink+Hbase technology, batch processing of power outage data is realized, and the efficiency of calculation is improved in a streaming computing manner to meet the requirements of real-time analysis and accurate judgment of power outage events.

[0124] In the present invention, the system can realize intelligent completion of power outage events based on the power outage physical topology model: the power outage fault area and the impact range are judged by using the power outage judgment rules, the topological archive relationship of each device, etc., the number of power outage events reported by medium and low voltage equipment (terminals, electric energy meters) is counted, and a power outage physical topology model is established. The model has a reliable power outage event collection integrity analysis and automatic completion method. Through distributed storage (HBASE) and memory parallel computing technology (SPARK) methods, power outage events and archive information are collected and pre-processed in the form of archive wide tables, and power outage effectiveness analysis is performed according to the set rules. According to the power grid topology and the planned power outage and fault power outage judgment results, the effectiveness and integrity of the power outage events automatically reported by the collection terminal are analyzed, and the terminal and meter power outage events that are falsely reported or missed are completed and marked, forming accurate, effective and complete medium voltage user power outage event data, and providing data reference for subsequent equipment abnormality analysis.

[0125] What is disclosed above is only a preferred embodiment of the present invention, which certainly cannot be used to limit the scope of rights of the present invention. A person skilled in the art can understand that all or part of the processes of the above embodiments and equivalent changes made according to the claims of the present invention still fall within the scope of the invention.

Claims

1. A power outage analysis and processing method based on big data, characterized in that: include: Select a power outage event to be processed from the database, wherein the power outage event includes a meter power outage event and a public transformer terminal power outage event; Performing power outage analysis and processing on the power outage event according to the power outage physical topology model of the power grid equipment to obtain an analysis result, wherein the power outage physical topology model is composed of lines, substations, public transformer terminals, meter boxes, and electric meters; When the power outage event is the power outage event of the electric meter, the power outage analysis and processing of the power outage event according to the power outage physical topology model of the power grid equipment includes: Obtaining information of the electric meter that reported the electric meter power outage event; In the case where the power outage event of the electric meter is a valid power outage event, the meter box to which the electric meter belongs is found according to the power outage physical topology model, and the number of electric meters under the meter box that have reported the valid power outage event during the time period when the power outage event of the electric meter occurs is counted; When the number of electric meters that have reported the effective power outage event accounts for more than 30% of the total number of electric meters in the meter box, two electric meters under the meter box that have not reported the power outage event are randomly selected for meter reading; If the through-reading operation of the two electric meters that have not reported a power outage event is unsuccessful, or if the through-reading operation finds that the two electric meters that have not reported a power outage event have a power outage event within 24 hours, then the judgment result of the power outage event of the electric meter is determined to be a power outage of the meter box; Complete the power outage event records of all the electric meters under the meter box that have not reported the power outage event according to the topological relationship in the power outage physical topology model; When the power outage event is a power outage event of the public transformer terminal, the power outage analysis and processing of the power outage event according to the power outage physical topology model of the power grid equipment includes: Obtaining information of the public transformer terminal that reported the power outage event of the public transformer terminal; In the case where the power outage event of the public transformer terminal belongs to the valid power outage event, finding the substation area to which the public transformer terminal belongs according to the power outage physical topology model, and counting the total number of public transformer terminals under the substation area; When the total number of the public transformer terminals is greater than 1, the number of electric meters in the substation area that have reported the valid power outage event during the time period when the power outage event of the public transformer terminal occurs is counted; When the number of electric meters that have reported the effective power outage event accounts for more than 60% of the total number of electric meters in the substation, call all public transformer terminals in the substation to test, and determine whether all public transformer terminals in the substation have experienced the effective power outage event within the time period when the public transformer terminal power outage event occurs; When all the public transformer terminals in the substation area experience the effective power outage event within the time period when the power outage event of the public transformer terminal occurs, it is determined that the substation area to which the public transformer terminal belongs has a power outage, and the power outage event records of all the power outage event meter boxes under the substation area that have not reported power outage events are completed; Find out the line to which the substation belongs according to the power outage physical topology model; Determine whether the proportion of the number of substations where effective power outages occur on the line is greater than 60%; When the number of areas with effective power outage events under the line accounts for more than 60%, it is determined that the line to which the area belongs is out of power, and the power outage event records of all areas under the line that have not reported power outage events are completed; The analysis result of the power outage event of the public transformer terminal is determined to be a power outage of the line to which the public transformer terminal belongs.

2. The method for analyzing and processing power outages based on big data according to claim 1, characterized in that: After acquiring the meter information for reporting the power outage event of the meter, and before finding out the meter box to which the meter belongs according to the power outage physical topology model, the method further includes: Performing a deduplication operation based on the information of the power outage event of the electric meter to eliminate duplicate event reporting messages in the database; Performing time validity judgment based on the information of the power outage event of the electric meter; When the time validity judgment result of the electric meter power outage event is valid, reading the electric meter to determine whether the electric meter power outage event belongs to the valid power outage event; If the through-reading operation on the electric meter is unsuccessful, or if the through-reading operation finds that the electric meter has a power outage event within 24 hours, it is determined that the power outage event of the electric meter belongs to the valid power outage event.

3. The method for analyzing and processing power outages based on big data according to claim 1, characterized in that: After randomly selecting two electric meters under the meter box that have not reported a power outage event for transparent reading, the method further includes: If it is found through the through-reading operation that at least one of the two electric meters that have not reported a power outage event does not have a power outage event within the 24 hours, then the judgment result of the electric meter power outage event is determined to be a single-meter power outage.

4. The method for analyzing and processing power outages based on big data according to claim 1, characterized in that: After counting the number of electric meters under the meter box that have reported the valid power outage event within the time period when the electric meter power outage event occurs, the method further includes: When the number of electric meters that have reported the valid power outage event accounts for no more than 30% of the total number of electric meters in the meter box, the analysis result of the electric meter power outage event is determined to be a single-meter power outage.

5. The method for analyzing and processing power outages based on big data according to claim 1, characterized in that: After acquiring the public transformer terminal information for reporting the power outage event of the public transformer terminal and before finding out the substation area to which the public transformer terminal belongs according to the power outage physical topology model, the method further includes: Performing a deduplication operation based on the information of the power outage event of the public transformer terminal to eliminate duplicate event reporting messages in the database; Performing time validity judgment based on the information of the power outage event of the public transformer terminal; When the time validity judgment result of the power outage event of the public transformer terminal is valid, reading any two meter boxes under the public transformer terminal to determine whether the power outage event of the public transformer terminal belongs to the valid power outage event; If the through-reading operation of the arbitrary two meter boxes is unsuccessful, or if the through-reading operation finds that the arbitrary two meter boxes both have power failure events within the 24 hours, it is determined that the power failure event of the public transformer terminal belongs to the valid power failure event.

6. The method for analyzing and processing power outages based on big data according to claim 5, characterized in that: After the transparent copying of any two meter boxes under the public transformer terminal, the method further includes: If it is found through the transparent reading operation that at least one of the two meter boxes does not have a power failure event within the 24 hours, then the judgment result of the power failure event of the public transformer terminal is determined to be a single terminal power failure; After counting the number of electric meters in the substation area that have reported the effective power outage event during the time period when the public transformer terminal power outage event occurs, the method further includes: When the number of electric meters that have reported the valid power outage event accounts for no more than 60% of the total number of electric meters in the substation, the analysis result of the public transformer terminal power outage event is determined to be a single-terminal power outage.

7. The method for analyzing and processing power outages based on big data according to claim 1, characterized in that: After determining whether the proportion of the number of areas where effective power outages occur on the line is greater than 60%, the method further includes: When the number of substations where effective power outages occur under the line accounts for no more than 60%, the judgment result of the public transformer terminal power outage event is determined to be a substation power outage.

8. The method for analyzing and processing power outages based on big data according to claim 1, characterized in that: After determining that the result of the analysis of the power outage event of the public transformer terminal is that the line to which the public transformer terminal belongs has a power outage, the method further includes: When the power outage event of the electric meter is an invalid power outage event, calculating the frequency of the electric meter reporting the invalid power outage event; When the frequency of the electric meter reporting the invalid power outage event is higher than a preset frequency threshold, adding the electric meter information to a blacklist; An on-site operation and maintenance prompt message is generated according to the blacklist, and the on-site operation and maintenance prompt message includes the electric meter information.

9. The method for analyzing and processing power outages based on big data according to claim 8, characterized in that: After the on-site operation and maintenance prompt message is generated according to the blacklist, the method further includes: Extracting the electric meter information in the blacklist; Calculating the frequency of the electric meter reporting the invalid power outage event; When the frequency of the electric meter reporting the invalid power outage event is not higher than the preset frequency threshold, the electric meter information is removed from the blacklist.

10. A power outage analysis and processing system based on big data, characterized in that: Used to implement the method according to any one of claims 1 to 9.

Images