CN-121981661-A - Multi-source data checking power supply reliability data quality and closed-loop management and control method, system, equipment and medium

CN121981661ACN 121981661 ACN121981661 ACN 121981661ACN-121981661-A

Abstract

The invention discloses a method, a system, equipment and a medium for checking the quality of power supply reliability data and closed-loop management and control of multi-source data, belonging to the technical field of data checking, comprising the steps of acquiring and integrating line power failure data acquired in a plurality of information systems to form power failure source data after de-duplication; the method comprises the steps of obtaining manually-recorded power supply reliability operation data to form power failure data to be checked, comparing event of power failure source data with the power failure data to be checked, checking whether a power failure event is recorded, checking data consistency of the power failure event, identifying deviation event based on the difference of the number of users in power failure, recording the deviation event as data to be corrected and storing the data into a database, dynamically tracking and correcting the data to form a data set to be corrected, and calculating the accuracy of the number of users in power failure data of each power supply unit in a preset time period based on a deviation statistical result. The invention realizes double checking of timeliness and accuracy of data input, and avoids complicated processes of manually acquiring and comparing data.

Inventors

CHEN CHEN
ZHAO YUANYUAN
ZENG RONG
CHEN KAILEI
YANG KUNHUA
FU XINYI
HU TIANSONG
Yuan Xianmei
LI CHANGXING
ZHAO CHAO
LUO XIN
XIONG NAN
ZHANG QILI
CHEN JIASHENG
FAN QIANG
ZHANG YANG
WU PENG
DOU CHEN
HU RONG
MIAO YU
DING JIANGQIAO

Assignees

贵州电网有限责任公司

Dates

Publication Date: 20260505
Application Date: 20251127

Claims (10)

1. A multi-source data checking power supply reliability data quality and closed-loop control method is characterized by comprising the steps of, Acquiring and integrating line power failure data acquired in a plurality of information systems, and filtering repeated acquired data of the same line and the same power failure event in the plurality of information systems to form power failure source data after duplication removal; acquiring manually-entered power supply reliability operation data to form power failure data to be checked; based on the line identification information and the power failure time, carrying out event comparison on the power failure source data and the power failure to-be-checked data, and checking whether the power failure event is recorded; data consistency checking is carried out on the power failure event, and deviation events are identified based on the difference of the number of users in power failure; recording the deviation event as data to be corrected, storing the data into a database, and dynamically tracking and correcting the data to form a data set to be corrected; And calculating the accuracy rate of the number of units when the power is off for each power supply unit in a preset time period based on the deviation statistical result, and carrying out data quality early warning prompt on units with accuracy rate lower than a threshold value.
2. The method for checking and controlling the power supply reliability data quality and closed loop according to claim 1, wherein the steps of obtaining and integrating the line power failure data collected in the information systems, filtering repeated collected data of the same line and the same power failure event in the information systems to form power failure source data after de-duplication comprise, Acquiring line power failure event data acquired in a plurality of information systems in a statistical time period; Identifying effective line outage events based on preset judging conditions, and constructing effective outage data sets of a plurality of systems; according to the line identification information and the power failure time, filtering repeated data of power failure events in a plurality of information systems, and eliminating repeated records; and taking the de-duplicated power failure event data as power failure source data.
3. The method for checking the power supply reliability data quality and controlling the closed loop by using the multi-source data according to claim 2, wherein the step of obtaining the manually entered power supply reliability operation data to form the power failure data to be checked comprises the steps of, Acquiring power supply reliability operation event data manually recorded in a statistical time period; Extracting key information of each operation event; And constructing the extracted information into the data to be checked in the power failure.
4. A multi-source data checking power supply reliability data quality and closed loop control method according to claim 3, wherein said checking whether the power failure event is entered comprises comparing the power failure source data with the data to be checked for power failure based on the line identification information and the power failure time, The key information is used as a matching basis, and the power failure source data and the power failure data to be checked are compared piece by piece; identifying an event which is covered by the data to be checked in the power failure source data, and marking the event as an entered event; And identifying an uncovered event in the power outage source data, and marking the uncovered event as an uncorrupted event.
5. The method for checking the power supply reliability data quality and closed-loop control of multi-source data according to claim 4, wherein said checking the data consistency of the outage event, identifying the deviation event based on the difference of the number of users in the outage event comprises, Confirming event correspondence of the two types of data based on the line name, line code, belonging unit, power failure time and power restoration time fields contained in the power failure source data and the line name, line code, belonging unit, power failure time, power restoration time and power failure time user number fields contained in the data to be checked in the power failure; after the event correspondence is confirmed, based on the data comparison between the power failure time household number field of the data to be checked in the power failure and the power failure time household number field of the power failure source data, the difference of the power failure time household numbers of the power failure event is identified; And marking the power failure event containing the difference as a deviation event according to the comparison result, and incorporating the power failure event into the time-account deviation statistical range.
6. The method for checking the power supply reliability data quality and controlling the closed loop of the multi-source data according to claim 5, wherein the recording the deviation event as the data to be corrected and storing the data in the database, dynamically tracking and correcting the data to form a data set to be corrected comprises, Based on the recognition result of the house number deviation in the power failure, constructing a deviation event as data to be corrected, and writing the data into a database to be corrected; Continuously maintaining and updating the data to be corrected in the data base to be corrected, re-acquiring the power failure time household number field recorded in the power failure data to be checked in a preset time period, and comparing the power failure time household number field with the power failure time household number field in the power failure source data; And updating the data state according to the comparison result, if the deviation of the number of users does not exceed a preset threshold value during power failure, removing the corresponding event from the database, and if the deviation of the number of users still exceeds the preset threshold value, continuing to keep until the next round of tracking rectification to form a dynamically updated data set to be rectified.
7. The method for checking the power supply reliability data quality and controlling the closed loop by using the multi-source data according to claim 6, wherein the calculating the accuracy of the number of units of power failure data in each power supply unit in a preset time period based on the deviation statistical result and performing data quality early warning prompt on the units with the accuracy lower than a threshold value comprises, Summarizing all power failure time account number deviation information recorded in the database to be rectified, and calculating the accuracy of the power failure data account number of a power supply unit in a preset time period by combining the total amount of power failure time account number fields in the power failure source data; Carrying out statistical analysis on the accuracy of the number of units when the power failure data of different power supply units are generated, and identifying the power supply units with the accuracy lower than a preset threshold; And outputting power supply reliability data quality early warning prompt information to a power supply unit with the accuracy lower than a preset threshold.
8. The multi-source data checking power supply reliability data quality and closed-loop management and control system is characterized by comprising a power failure source data acquisition module, a power failure data acquisition module to be checked, an input comparison module, a consistency check module, a rectification tracking module and an accuracy evaluation module, wherein the multi-source data checking power supply reliability data quality and closed-loop management and control system is applied to any one of the claims 1-7; The power failure source data acquisition module is used for acquiring and integrating the line power failure data acquired in the information systems, filtering repeated acquired data of the same line and the same power failure event in the information systems, and forming duplicate-removed power failure source data; The power failure to-be-checked data acquisition module is used for acquiring manually-recorded power supply reliability operation data to form power failure to-be-checked data; The input comparison module is used for carrying out event comparison on the power failure source data and the power failure to-be-checked data based on the line identification information and the power failure time, and checking whether the power failure event is input or not; the consistency checking module is used for carrying out data consistency checking on the power failure event and identifying deviation events based on the difference of the number of users in power failure; The correction tracking module is used for recording deviation events as data to be corrected and storing the data into the database, and dynamically tracking and correcting the data to form a data set to be corrected; The accuracy evaluation module is used for calculating the accuracy of the number of units when the power supply unit fails in the preset time period based on the deviation statistical result, and carrying out data quality early warning prompt on the unit with the accuracy lower than the threshold value.
9. A computer device comprising a memory and a processor, the memory storing a computer program, characterized in that the processor, when executing the computer program, implements the steps of a multi-source data checking power supply reliability data quality and closed loop management method according to any one of claims 1 to 7.
10. A computer readable storage medium having stored thereon a computer program, wherein the computer program when executed by a processor performs the steps of a multi-source data checking power supply reliability data quality and closed loop management method as claimed in any one of claims 1 to 7.

Description

Multi-source data checking power supply reliability data quality and closed-loop management and control method, system, equipment and medium Technical Field The invention relates to the technical field of data checking, in particular to a multi-source data checking power supply reliability data quality and closed-loop control method, system, equipment and medium. Background The power supply reliability index is used as an important index for obtaining power in government commercial environment evaluation, and can reflect the continuous power supply capability of a power supply enterprise to a user. The improvement of the power supply reliability also becomes a great challenge for power supply enterprises. The power supply reliability operation data reflect the operation information data of the power supply system and the power supply user, embody the operation level and the management level of the power supply system, and are the basis for developing power supply reliability index statistics, data analysis application and success assessment. The power supply reliability operation data in the power grid management platform is recorded by basic operation and maintenance personnel, is limited by the skill level of the operation and maintenance personnel, and also has the problems of low accuracy and poor timeliness of the power supply reliability data recording caused by power failure simulation errors and inaccuracy, and meanwhile has the problems of a large amount of supplementary recording data, repeated correction data and the like of the operation and maintenance personnel. The problem causes poor data quality improvement effect, increases the workload of basic-level operation and maintenance personnel, and has low working efficiency. The timeliness and accuracy of automatic checking power supply reliability operation data input are realized by integrating the power failure data of the distribution network collected in the metering automation system, the power distribution operation support system and the dispatching OMS (Outage MANAGEMENT SYSTEM) system (dispatching power failure management system) and comparing the power failure data with manually input data of a power grid management platform, closed-loop tracking management and control are performed on the condition of carrying out rectification on problem data, and the improvement of the power supply reliability data quality is promoted. Disclosure of Invention In view of the above problems, the present invention provides a method, a system, a device and a medium for checking the quality of power supply reliability data and controlling closed loop of multi-source data. Therefore, the invention solves the technical problems that how to input the power supply reliability operation data in the power grid management platform by means of basic operation and maintenance personnel, is limited by the skill level of the operation and maintenance personnel, and has bad timeliness and low accuracy of the power supply reliability data input caused by the problems of power failure simulation errors and inaccuracy, and simultaneously has the problems of large quantity of data complement, repeated data correction and the like of the operation and maintenance personnel. The technical scheme includes that the multi-source data checking power supply reliability data quality and closed loop control method comprises the steps of obtaining line power failure data collected in a plurality of information systems, integrating the line power failure data, filtering repeated collected data of the same line and the same power failure event in the plurality of information systems to form duplicate power failure source data, obtaining manually recorded power supply reliability operation data to form power failure data to be checked, comparing the power failure source data with the power failure data to be checked on the basis of line identification information and power failure time to check whether the power failure event is recorded, checking data consistency of the power failure event, identifying deviation events on the basis of difference of the number of units in power failure, recording the deviation events as the data to be corrected, storing the data into a database, dynamically tracking and correcting the data to form a data set to be corrected, calculating the accuracy of the power failure data of each power supply unit in a preset time period on the basis of deviation statistics results, and giving a data quality early warning prompt to units with the accuracy lower than a threshold. The method comprises the steps of acquiring line outage data acquired in a plurality of information systems, integrating the line outage data acquired in the information systems, filtering repeated acquisition data of the same line and the same outage event in the information systems to form de-duplicated outage source data, acquiring line outage event data acquired in the information sy