Methods and Systems for Verification, Correction and Editing of Power Grid Distribution Transformer Marketing Data

Abstract

This invention relates to the technical field of power grid data processing, and provides a method and system for verifying, correcting, and editing marketing data of power grid distribution transformers. Based on the data generation status information of each distribution device's marketing terminal, the system defines data extraction time intervals for each distribution device's marketing terminal, thereby generating several data extraction time intervals for the marketing data. Based on these time intervals, the system extracts and processes ledger data and operational data from the marketing terminal of the distribution device, generating a ledger-operation data package and marking its generation time. Furthermore, the system verifies and compares the ledger data and operational data within the ledger-operation data package to identify missing and erroneous data areas. This facilitates targeted correction and editing of missing and erroneous data in the marketing data, ensuring the credibility of the marketing data and improving the operational stability of power grid distribution equipment.

Description

Technical Field

[0001] This invention relates to the technical field of power grid data processing, and in particular to a method and system for verifying, correcting and editing power grid distribution transformer marketing data. Background Technology

[0002] The marketing end of power grid distribution equipment stores different types of marketing data, including ledger data and equipment operation data. Ledger data records data such as power calculation and electricity fee management for the power grid distribution equipment, while equipment operation data records data such as the operating status and resource scheduling of the distribution equipment. This allows for a comprehensive data representation and recording of the power grid distribution equipment. However, in the actual process of generating and recording marketing data, factors such as inconsistent ledger data format standards and unstable operation of the distribution equipment can lead to data loss or errors. This directly results in incomplete or erroneous marketing data, reducing its credibility and making it impossible to accurately and reliably evaluate the power grid distribution equipment, thus reducing the operational stability of the power grid distribution equipment. Summary of the Invention

[0003] To address the shortcomings of existing technologies, this invention provides a method and system for verifying, correcting, and editing marketing data for power grid distribution transformers. Based on the data generation status information of each distribution device's marketing terminal, it defines data extraction time intervals for each device, thus generating several data extraction time intervals for the marketing terminal and defining the time range for marketing data extraction. Based on these time intervals, it extracts and processes ledger and operational data from the marketing terminal, generating a ledger-operation data package and assigning a unique identifier to the generation time of all data within the ledger-operation data package. Furthermore, it verifies and compares the ledger and operational data within the ledger-operation data package to identify missing and erroneous data areas, facilitating targeted correction and editing of missing and erroneous data in the marketing data, ensuring the reliability of the marketing data, and improving the operational stability of power grid distribution equipment.

[0004] This invention provides a method for verifying, correcting, and editing marketing data of power grid distribution transformers, comprising the following steps:

[0005] Step S1: Monitor all power distribution equipment under the power grid to obtain the marketing terminal data generation status information of each power distribution equipment; based on the marketing terminal data generation status information, define the data extraction time interval for the marketing terminal of the power distribution equipment to generate several data extraction time intervals for the marketing terminal of the power distribution equipment.

[0006] Step S2: Based on the data extraction time interval, extract and process the ledger data and operation data of the marketing end of the power distribution equipment to obtain the corresponding ledger data set and operation data set; perform pairing processing on the ledger data set and the operation data set to obtain several ledger-operation data packages, and perform time stamp processing on all ledger-operation data packages;

[0007] Step S3: Verify and compare the ledger data and operation data under the ledger-operation data package to determine the missing data areas and data error parts in the ledger-operation data package; determine the missing data attribute information of the missing data area based on the data attribute information of the adjacent areas of the missing data area; identify the data error parts and determine the error type information of the data error parts.

[0008] Step S4: Based on the generation time identifier information and data attribute information of the missing data region, perform source data search and supplementation processing on the missing data region; based on the generation time identifier information and error type information of the data error part, perform source data correction and reloading processing on the data error part.

[0009] In one embodiment disclosed in this application, in step S1, all power distribution equipment under the power grid is monitored to obtain the marketing terminal data generation status information of each power distribution equipment; based on the marketing terminal data generation status information, a data extraction time interval is defined for the marketing terminal of the power distribution equipment, thereby generating several data extraction time intervals for the marketing terminal of the power distribution equipment, including:

[0010] Based on the network addresses of all power distribution equipment under the power grid, the marketing terminals of each power distribution equipment are independently monitored to obtain the data generation traffic change information of the marketing terminals; based on the data generation traffic change information, all key time points of data generation in the data generation process of the marketing terminals are determined.

[0011] Based on all key data generation time points, the entire data generation interval of the marketing end is segmented to define the data extraction time interval of the marketing end, thereby generating several data extraction time intervals for the marketing end; effective data generation rate identification processing is performed on each data extraction time interval to obtain the effective data generation rate change information of the data extraction time interval.

[0012] In one embodiment of this application, in step S2, based on the data extraction time interval, ledger data and operational data are extracted from the marketing end of the power distribution equipment to obtain corresponding ledger data sets and operational data sets; the ledger data sets and operational data sets are paired to obtain several ledger-operation data packets, and all ledger-operation data packets are processed to generate time identifiers, including:

[0013] Based on the effective data generation rate change information of the data extraction time interval, the data extraction frequency of the marketing end of the power distribution equipment is determined in the data extraction time interval, so as to extract ledger data and operation data from the marketing end. Then, all the extracted ledger data and all the operation data are arranged in chronological order to form ledger data set and operation data set respectively.

[0014] The ledger data set and the operation data set are subjected to generation time association matching processing. Ledger data and operation data generated at the same time are combined into ledger-operation data packages, and the generation time information of the ledger-operation data packages is added to their corresponding index information, thereby performing generation time identification processing on the ledger-operation data packages.

[0015] In one embodiment disclosed in this application, in step S3, the ledger data and operation data under the ledger-operation data package are checked and compared to determine the data missing areas and data error parts existing in the ledger-operation data package; based on the data attribute information of the adjacent areas of the data missing areas, the missing data attribute information of the data missing areas is determined; the data error parts are identified to determine the error type information of the data error parts, including:

[0016] The ledger data and operation data under the ledger-operation data package are checked for information items to obtain ledger information items and operation information items. Then, the ledger information items and operation information items are compared to determine the missing data areas and data error parts in the ledger-operation data package. The missing data areas refer to the missing information items in the ledger-operation data package, and the data error parts refer to the information items in the ledger-operation data package with incorrect content.

[0017] The missing information item attributes of the data contained in the adjacent areas of the missing data area are compared with the information item distribution list of the ledger-operation data package to determine the missing information item attributes corresponding to the missing data area, and these are used as the data attribute information.

[0018] The data error portion is identified by data content recognition, and the data content that is inconsistent with the information item attributes of the data error portion is determined. The type information of the inconsistent data content is then used as the error type information.

[0019] In one embodiment disclosed in this application, in step S4, source data lookup and supplementation processing is performed on the missing data region based on the generation time identifier information and data attribute information of the missing data region; source data correction and reloading processing is performed on the erroneous data region based on the generation time identifier information and error type information of the erroneous data region, including:

[0020] Based on the generation time identifier information and missing information item attributes of the missing data area, the source data of the original data terminal of the power distribution equipment is searched for the generation time consistent with the generation time identifier information and the information item consistent with the missing information item attributes, and the searched source data is added to the missing data area.

[0021] Based on the generation time identifier information and error type information of the data error portion, the source data of the original data terminal of the power distribution equipment is located and corrected for the generation time consistent with the generation time identifier information and the data content type information consistent with the error type information, and the corrected source data is reloaded into the data error portion.

[0022] This invention also provides a power grid distribution transformer marketing data verification and correction editing system, including:

[0023] The power distribution equipment monitoring module is used to monitor all power distribution equipment under the power grid and obtain the marketing terminal data generation status information of each power distribution equipment.

[0024] The data extraction time interval determination module is used to generate status information based on the marketing terminal data, and to define the data extraction time interval for the marketing terminal of the power distribution equipment, thereby generating several data extraction time intervals for the marketing terminal of the power distribution equipment.

[0025] The marketing data extraction module is used to extract and process ledger data and operation data from the marketing end of the power distribution equipment based on the data extraction time interval, so as to obtain the corresponding ledger data set and operation data set.

[0026] The data packet generation and identification module is used to pair the ledger data set and the operation data set to obtain several ledger-operation data packets, and to perform generation time identification processing on all ledger-operation data packets;

[0027] The data verification and comparison module is used to verify and compare the ledger data and operation data under the ledger-operation data package to determine the missing data areas and data error parts in the ledger-operation data package;

[0028] The data identification module is used to determine the missing data attribute information of the missing data region based on the data attribute information of the adjacent regions of the missing data region; to identify the data error portion and determine the error type information of the data error portion;

[0029] The data missing information filling module is used to perform source data search and filling processing on the data missing information area based on the generation time identifier information and data attribute information of the data missing area.

[0030] The data error correction module is used to perform source data correction and reloading processing on the data error portion based on the generation time identifier information and error type information of the data error portion.

[0031] In one embodiment disclosed in this application, the power distribution equipment monitoring module is used to monitor all power distribution equipment under the power grid and obtain the marketing terminal data generation status information of each power distribution equipment, including:

[0032] Based on the network addresses of all power distribution equipment under the power grid, the marketing terminals of each power distribution equipment are independently monitored to obtain the data generation traffic change information of the marketing terminals; based on the data generation traffic change information, all key time points of data generation in the data generation process of the marketing terminals are determined.

[0033] The data extraction time interval determination module is used to define the data extraction time interval for the marketing end of the power distribution equipment based on the status information generated by the marketing end data, thereby generating several data extraction time intervals for the marketing end of the power distribution equipment, including:

[0034] Based on all key data generation time points, the entire data generation interval of the marketing end is segmented to define the data extraction time interval of the marketing end, thereby generating several data extraction time intervals for the marketing end; effective data generation rate identification processing is performed on each data extraction time interval to obtain the effective data generation rate change information of the data extraction time interval.

[0035] In one embodiment disclosed in this application, the marketing data extraction module is used to extract and process ledger data and operational data from the marketing end of the power distribution equipment based on the data extraction time interval, to obtain corresponding ledger data sets and operational data sets, including:

[0036] Based on the effective data generation rate change information of the data extraction time interval, the data extraction frequency of the marketing end of the power distribution equipment is determined in the data extraction time interval, so as to extract ledger data and operation data from the marketing end. Then, all the extracted ledger data and all the operation data are arranged in chronological order to form ledger data set and operation data set respectively.

[0037] The data packet generation and identification module is used to pair the ledger data set and the operation data set to obtain several ledger-operation data packets, and to perform generation time identification processing on all ledger-operation data packets, including:

[0038] The ledger data set and the operation data set are subjected to generation time association matching processing. Ledger data and operation data generated at the same time are combined into ledger-operation data packages, and the generation time information of the ledger-operation data packages is added to their corresponding index information, thereby performing generation time identification processing on the ledger-operation data packages.

[0039] In one embodiment disclosed in this application, the data verification and comparison module is used to verify and compare the ledger data and operational data under the ledger-operation data package to determine the missing data areas and data error portions existing in the ledger-operation data package, including:

[0040] The ledger data and operation data under the ledger-operation data package are checked for information items to obtain ledger information items and operation information items. Then, the ledger information items and operation information items are compared to determine the missing data areas and data error parts in the ledger-operation data package. The missing data areas refer to the missing information items in the ledger-operation data package, and the data error parts refer to the information items in the ledger-operation data package with incorrect content.

[0041] The data identification module is used to determine the missing data attribute information of the missing data region based on the data attribute information of the adjacent regions of the missing data region; and to identify the data error portion and determine the error type information of the data error portion, including:

[0042] The missing information item attributes of the data contained in the adjacent areas of the missing data area are compared with the information item distribution list of the ledger-operation data package to determine the missing information item attributes corresponding to the missing data area, and these are used as the data attribute information.

[0043] The data error portion is identified by data content recognition, and the data content that is inconsistent with the information item attributes of the data error portion is determined. The type information of the inconsistent data content is then used as the error type information.

[0044] In one embodiment disclosed in this application, the data missing information filling module is used to perform source data search and filling processing on the data missing area based on the generation time identifier information and data attribute information of the data missing area, including:

[0045] Based on the generation time identifier information and missing information item attributes of the missing data area, the source data of the original data terminal of the power distribution equipment is searched for the generation time consistent with the generation time identifier information and the information item consistent with the missing information item attributes, and the searched source data is added to the missing data area.

[0046] The data error correction module is used to perform source data correction and reloading processing on the data error portion based on the generation time identifier information and error type information of the data error portion, including:

[0047] Based on the generation time identifier information and error type information of the data error portion, the source data of the original data terminal of the power distribution equipment is located and corrected for the generation time consistent with the generation time identifier information and the data content type information consistent with the error type information, and the corrected source data is reloaded into the data error portion.

[0048] Compared to existing technologies, this power grid distribution transformer marketing data verification and correction editing method and system is based on the data generation status information of each distribution equipment's respective marketing end. It defines the data extraction time interval for the marketing end of the distribution equipment, thereby generating several data extraction time intervals for the marketing end of the distribution equipment, thus limiting the time range for marketing data extraction. Based on these data extraction time intervals, it extracts and processes ledger data and operational data from the marketing end of the distribution equipment, generating a ledger-operation data package and assigning a unique identifier to the generation time of all data within the ledger-operation data package. Furthermore, it verifies and compares the ledger data and operational data within the ledger-operation data package to identify missing and erroneous data areas, facilitating targeted correction and editing of missing and erroneous data in the marketing data, ensuring the credibility of the marketing data, and improving the operational stability of the power grid distribution equipment.

[0049] Other features and advantages of the invention will be set forth in the description which follows, and will be apparent in part from the description, or may be learned by practicing the invention. The objects and other advantages of the invention may be realized and obtained by means of the structures particularly pointed out in the written description, claims, and drawings.

[0050] The technical solution of the present invention will be further described in detail below with reference to the accompanying drawings and embodiments. Attached Figure Description

[0051] To more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0052] Figure 1 A flowchart illustrating the power grid distribution transformer marketing data verification and correction editing method provided by this invention;

[0053] Figure 2 This is a schematic diagram of the framework of the power grid distribution transformer marketing data verification and correction editing system provided by the present invention. Detailed Implementation

[0054] The technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of the present invention, and not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of the present invention.

[0055] See Figure 1 This is a flowchart illustrating the power grid distribution transformer marketing data verification and correction editing method provided in an embodiment of the present invention. The power grid distribution transformer marketing data verification and correction editing method includes:

[0056] Step S1: Monitor all power distribution equipment under the power grid to obtain the marketing terminal data generation status information of each power distribution equipment; based on the marketing terminal data generation status information, define the data extraction time interval for the marketing terminal of the power distribution equipment, thereby generating several data extraction time intervals for the marketing terminal of the power distribution equipment.

[0057] Step S2: Based on the data extraction time interval, extract and process the ledger data and operation data of the marketing end of the power distribution equipment to obtain the corresponding ledger data set and operation data set; perform pairing processing on the ledger data set and the operation data set to obtain several ledger-operation data packages, and generate time stamp processing on all ledger-operation data packages;

[0058] Step S3: Verify and compare the ledger data and operation data under the ledger-operation data package to determine the missing data areas and data error parts in the ledger-operation data package; determine the missing data attribute information of the missing data area based on the data attribute information of the adjacent areas; identify the data error parts and determine the error type information of the data error parts.

[0059] Step S4: Based on the generation time identifier and data attribute information of the missing data area, perform source data search and supplementation processing on the missing data area; based on the generation time identifier and error type information of the erroneous data part, perform source data correction and reloading processing on the erroneous data part.

[0060] This method for verifying, correcting, and editing marketing data for power grid distribution transformers is based on the data generation status information of each distribution device's marketing terminal. It defines data extraction time intervals for each distribution device's marketing terminal, thus generating several data extraction time intervals to define the time range for marketing data extraction. Based on these time intervals, it extracts and processes ledger and operational data from the distribution device's marketing terminal, generating a ledger-operation data package and assigning a unique identifier to the generation time of all data within the ledger-operation data package. Furthermore, it verifies and compares the ledger and operational data within the ledger-operation data package to identify missing and erroneous data areas. This facilitates targeted correction and editing of missing and erroneous data in the marketing data, ensuring its reliability and improving the operational stability of the power grid distribution equipment.

[0061] Preferably, in step S1, all power distribution equipment under the power grid is monitored to obtain the marketing terminal data generation status information of each power distribution equipment; based on the marketing terminal data generation status information, a data extraction time interval is defined for the marketing terminal of the power distribution equipment, thereby generating several data extraction time intervals for the marketing terminal of the power distribution equipment, including:

[0062] Based on the network addresses of all power distribution equipment under the power grid, the marketing terminals of each power distribution equipment are independently monitored to obtain the data generation traffic change information of the marketing terminal; based on the data generation traffic change information, the key time points of data generation of the marketing terminal in the data generation process are determined.

[0063] Based on all key data generation time points, the entire data generation interval of the marketing end is segmented to define the data extraction time interval for the marketing end, thereby generating several data extraction time intervals for the marketing end; effective data generation rate identification processing is performed on each data extraction time interval to obtain information on the change of effective data generation rate for that data extraction time interval.

[0064] In the above technical solution, the power grid includes different types of power distribution equipment. Each power distribution device operates independently and generates different types of marketing data during its operation. However, the data generation process is not characterized by a stable data flow; more marketing data is generated in some time periods, while less is generated in others. To accurately extract the marketing data from the power distribution equipment, the marketing end (i.e., the marketing data generation end) of the power distribution equipment is independently monitored based on its network address. This allows for the acquisition of data generation flow variation information for that end. Based on this flow variation information, the time points corresponding to the peak data generation flows during the marketing data generation process are determined, serving as the key time points for all data generation during that process. Then, using these key time points as a dividing line, the entire data generation interval of that marketing end is segmented, generating several data extraction time intervals for that end. This avoids the problem of excessive marketing data generated within a single extraction time interval, which could hinder effective and accurate extraction. Furthermore, effective data generation rate identification processing is performed on all data extraction time intervals to obtain effective data generation rate change information for each data extraction time interval. This effective data generation rate change information refers to the change information of the generation rate (amount of data generated per unit time) of non-garbled data within the data extraction time interval, thus providing a reliable basis for subsequent data extraction.

[0065] Preferably, in step S2, based on the data extraction time interval, the marketing end of the power distribution equipment is processed to extract ledger data and operational data to obtain corresponding ledger data sets and operational data sets; the ledger data sets and operational data sets are paired to obtain several ledger-operation data packets, and all ledger-operation data packets are processed to generate time stamps, including:

[0066] Based on the effective data generation rate change information of the data extraction time interval, the data extraction frequency of the marketing end of the power distribution equipment is determined in the data extraction time interval. In this way, ledger data and operation data are extracted from the marketing end. Then, all the extracted ledger data and all the operation data are arranged in chronological order to form ledger data set and operation data set respectively.

[0067] The ledger data set and the operation data set are processed by the generation time association matching process. Ledger data and operation data generated at the same time are combined into ledger-operation data package, and the generation time information of the ledger-operation data package is added to its corresponding index information, thereby performing generation time identification processing on the ledger-operation data package.

[0068] In the above technical solution, the data extraction frequency for the marketing end of the power distribution equipment is determined based on the change information of the effective data generation rate within the data extraction time interval. Generally, the higher the effective data generation rate, the higher the corresponding data extraction frequency for the marketing end, thus ensuring that the marketing data generated by the marketing end can be extracted in a timely manner and avoiding any omissions in marketing data extraction. Then, all extracted ledger data and all operational data are arranged in chronological order to form ledger data sets and operational data sets respectively, ensuring the orderliness of the data within the ledger data sets and operational data sets. Furthermore, the ledger data sets and operational data sets undergo generation time association matching processing. Ledger data and operational data generated at the same time are grouped into ledger-operation data packages. This facilitates subsequent data verification by comparing ledger data and operational data generated at the same time. The generation time information of the ledger-operation data package is added to its corresponding index information, thereby performing generation time identification processing on the ledger-operation data package, allowing the ledger-operation data package to clearly identify its own generation time.

[0069] Preferably, in step S3, the ledger data and operational data under the ledger-operation data package are checked and compared to determine the missing data areas and erroneous data portions in the ledger-operation data package; based on the data attribute information of the adjacent areas of the missing data area, the missing data attribute information of the missing data area is determined; the erroneous data portions are identified to determine the error type information of the erroneous data portions, including:

[0070] The ledger data and operational data under the ledger-operation data package are checked for information items to obtain ledger information items and operational information items. Then, the ledger information items and operational information items are compared to determine the missing data areas and data errors in the ledger-operation data package. The missing data areas refer to the missing information items in the ledger-operation data package, and the data errors refer to the information items in the ledger-operation data package that have content errors.

[0071] Compare the information item attributes of the data contained in the adjacent areas of the missing data area with the information item distribution list of the ledger-operation data package to determine the missing information item attributes corresponding to the missing data area, and use this as the data attribute information;

[0072] The data content of the erroneous part is identified to determine the data content whose information item attributes are inconsistent with those of the erroneous part, and the type information of the inconsistent data content is determined as the error type information.

[0073] In the above technical solution, the ledger data and operation data under the ledger-operation data package each correspond to relevant information items. These information items are related to the actual working conditions of the power distribution equipment. The ledger information items and operation information items are compared to identify the missing data areas and data errors in the ledger-operation data package. For example, all ledger information items and all operation information items are compared. If there is an inconsistency between the two types of information items, it is determined that there is a missing data area and data error in a certain ledger information item or operation item, thereby conducting a comprehensive screening of the ledger-operation data package. Then, the attributes of the information items in the adjacent areas of the missing data area are compared with the information item distribution list of the ledger-operation data package to determine the missing information item attributes corresponding to the missing data area. The data content of the data error is identified to determine the data content that is inconsistent with the information item attributes of the data error and to determine the type information of the inconsistent data content, thereby comprehensively identifying the data defects in the ledger-operation data package.

[0074] Preferably, in step S4, based on the generation time identifier information and data attribute information of the missing data region, source data search and supplementation processing is performed on the missing data region; based on the generation time identifier information and error type information of the erroneous data portion, source data correction and reloading processing is performed on the erroneous data portion, including:

[0075] Based on the generation time identifier information and missing information item attributes of the missing data area, the source data of the original data terminal of the power distribution equipment is searched for the generation time consistent with the generation time identifier information and the information item consistent with the missing information item attributes, and the searched source data is added to the missing data area.

[0076] Based on the generation time identifier information and error type information of the data error portion, the source data of the original data terminal of the power distribution equipment is located and corrected for the generation time consistent with the generation time identifier information and the data content type information consistent with the error type information, and the corrected source data is reloaded into the data error portion.

[0077] In the above technical solution, based on the generation time identifier information and missing information item attributes of the missing data area, the source data of the power distribution equipment is searched for the generation time consistent with the generation time identifier information and the information item consistent with the missing information item attributes. This can complete the corresponding missing data area and improve the reliability of the data. Furthermore, based on the generation time identifier information and error type information of the data error part, the source data of the power distribution equipment is located and corrected for the generation time consistent with the generation time identifier information and the type information of the data content consistent with the error type information. The corrected source data is then reloaded into the data error part. This can perform targeted data error correction and improve the accuracy of the data.

[0078] See Figure 2 This is a schematic diagram of the framework of the power grid distribution transformer marketing data verification, correction, and editing system provided in an embodiment of the present invention. The power grid distribution transformer marketing data verification, correction, and editing system includes:

[0079] The power distribution equipment monitoring module is used to monitor all power distribution equipment under the power grid and obtain the marketing terminal data generation status information of each power distribution equipment.

[0080] The data extraction time interval determination module is used to generate status information based on the marketing terminal data, and to define the data extraction time interval for the marketing terminal of the power distribution equipment, thereby generating several data extraction time intervals for the marketing terminal of the power distribution equipment.

[0081] The marketing data extraction module is used to extract and process the ledger data and operation data of the marketing end of the power distribution equipment based on the data extraction time interval, so as to obtain the corresponding ledger data set and operation data set.

[0082] The data packet generation and identification module is used to pair the ledger data set and the running data set to obtain several ledger-running data packets, and to perform generation time identification processing on all ledger-running data packets;

[0083] The data verification and comparison module is used to verify and compare the ledger data and operational data under the ledger-operation data package to determine the missing data areas and data errors in the ledger-operation data package;

[0084] The data identification module is used to determine the missing data attribute information of the missing data area based on the data attribute information of the adjacent areas of the missing data area; and to identify the erroneous part of the data and determine the error type information of the erroneous part of the data.

[0085] The data missing information filling module is used to search for and fill in the source data for the missing data area based on the generation time identifier information and data attribute information of the missing data area.

[0086] The data error correction module is used to perform source data correction and reloading processing on the data error portion based on the generation time identifier information and error type information of the data error portion.

[0087] This power grid distribution transformer marketing data verification and correction editing system generates status information based on the marketing terminal data of each distribution device. It defines data extraction time intervals for the marketing terminals of distribution devices, thus creating several data extraction time intervals for each device, defining the time range for marketing data extraction. Based on these time intervals, it extracts and processes ledger and operational data from the marketing terminals of the distribution devices, generating a ledger-operation data package and assigning a unique identifier to the generation time of all data within the ledger-operation data package. Furthermore, it verifies and compares the ledger and operational data within the ledger-operation data package to identify missing and erroneous data areas. This facilitates targeted correction and editing of missing and erroneous data in the marketing data, ensuring its reliability and improving the operational stability of the power grid distribution equipment.

[0088] Preferably, the power distribution equipment monitoring module is used to monitor all power distribution equipment under the power grid, and obtain the marketing terminal data generation status information of each power distribution equipment, including:

[0089] Based on the network addresses of all power distribution equipment under the power grid, the marketing terminals of each power distribution equipment are independently monitored to obtain the data generation traffic change information of the marketing terminal; based on the data generation traffic change information, the key time points of data generation of the marketing terminal in the data generation process are determined.

[0090] The data extraction time interval determination module is used to generate status information based on the marketing terminal data, and to define the data extraction time interval for the marketing terminal of the power distribution equipment, thereby generating several data extraction time intervals for the marketing terminal of the power distribution equipment, including:

[0091] Based on all key data generation time points, the entire data generation interval of the marketing end is segmented to define the data extraction time interval for the marketing end, thereby generating several data extraction time intervals for the marketing end; effective data generation rate identification processing is performed on each data extraction time interval to obtain information on the change of effective data generation rate for that data extraction time interval.

[0092] In the above technical solution, the power grid includes different types of power distribution equipment. Each power distribution device operates independently and generates different types of marketing data during its operation. However, the data generation process is not characterized by a stable data flow; more marketing data is generated in some time periods, while less is generated in others. To accurately extract the marketing data from the power distribution equipment, the marketing end (i.e., the marketing data generation end) of the power distribution equipment is independently monitored based on its network address. This allows for the acquisition of data generation flow variation information for that end. Based on this flow variation information, the time points corresponding to the peak data generation flows during the marketing data generation process are determined, serving as the key time points for all data generation during that process. Then, using these key time points as a dividing line, the entire data generation interval of that marketing end is segmented, generating several data extraction time intervals for that end. This avoids the problem of excessive marketing data generated within a single extraction time interval, which could hinder effective and accurate extraction. Furthermore, effective data generation rate identification processing is performed on all data extraction time intervals to obtain effective data generation rate change information for each data extraction time interval. This effective data generation rate change information refers to the change information of the generation rate (amount of data generated per unit time) of non-garbled data within the data extraction time interval, thus providing a reliable basis for subsequent data extraction.

[0093] Preferably, the marketing data extraction module is used to extract and process ledger data and operational data from the marketing end of the power distribution equipment based on the data extraction time interval, to obtain corresponding ledger data sets and operational data sets, including:

[0094] Based on the effective data generation rate change information of the data extraction time interval, the data extraction frequency of the marketing end of the power distribution equipment is determined in the data extraction time interval. In this way, ledger data and operation data are extracted from the marketing end. Then, all the extracted ledger data and all the operation data are arranged in chronological order to form ledger data set and operation data set respectively.

[0095] The data packet generation and identification module is used to pair the ledger data set and the operational data set to obtain several ledger-operation data packets, and to perform generation time identification processing on all ledger-operation data packets, including:

[0096] The ledger data set and the operation data set are processed by the generation time association matching process. Ledger data and operation data generated at the same time are combined into ledger-operation data package, and the generation time information of the ledger-operation data package is added to its corresponding index information, thereby performing generation time identification processing on the ledger-operation data package.

[0097] In the above technical solution, the data extraction frequency for the marketing end of the power distribution equipment is determined based on the change information of the effective data generation rate within the data extraction time interval. Generally, the higher the effective data generation rate, the higher the corresponding data extraction frequency for the marketing end, thus ensuring that the marketing data generated by the marketing end can be extracted in a timely manner and avoiding any omissions in marketing data extraction. Then, all extracted ledger data and all operational data are arranged in chronological order to form ledger data sets and operational data sets respectively, ensuring the orderliness of the data within the ledger data sets and operational data sets. Furthermore, the ledger data sets and operational data sets undergo generation time association matching processing. Ledger data and operational data generated at the same time are grouped into ledger-operation data packages. This facilitates subsequent data verification by comparing ledger data and operational data generated at the same time. The generation time information of the ledger-operation data package is added to its corresponding index information, thereby performing generation time identification processing on the ledger-operation data package, allowing the ledger-operation data package to clearly identify its own generation time.

[0098] Preferably, the data verification and comparison module is used to verify and compare the ledger data and operational data under the ledger-operation data package, and to determine the missing data areas and data error parts in the ledger-operation data package, including:

[0099] The ledger data and operational data under the ledger-operation data package are checked for information items to obtain ledger information items and operational information items. Then, the ledger information items and operational information items are compared to determine the missing data areas and data errors in the ledger-operation data package. The missing data areas refer to the missing information items in the ledger-operation data package, and the data errors refer to the information items in the ledger-operation data package that have content errors.

[0100] This data recognition module is used to determine the missing data attribute information of the missing data region based on the data attribute information of the adjacent regions; and to identify the erroneous part of the data and determine the error type information of the erroneous part, including:

[0101] Compare the information item attributes of the data contained in the adjacent areas of the missing data area with the information item distribution list of the ledger-operation data package to determine the missing information item attributes corresponding to the missing data area, and use this as the data attribute information;

[0102] The data content of the erroneous part is identified to determine the data content whose information item attributes are inconsistent with those of the erroneous part, and the type information of the inconsistent data content is determined as the error type information.

[0103] In the above technical solution, the ledger data and operation data under the ledger-operation data package each correspond to relevant information items. These information items are related to the actual working conditions of the power distribution equipment. The ledger information items and operation information items are compared to identify the missing data areas and data errors in the ledger-operation data package. For example, all ledger information items and all operation information items are compared. If there is an inconsistency between the two types of information items, it is determined that there is a missing data area and data error in a certain ledger information item or operation item, thereby conducting a comprehensive screening of the ledger-operation data package. Then, the attributes of the information items in the adjacent areas of the missing data area are compared with the information item distribution list of the ledger-operation data package to determine the missing information item attributes corresponding to the missing data area. The data content of the data error is identified to determine the data content that is inconsistent with the information item attributes of the data error and to determine the type information of the inconsistent data content, thereby comprehensively identifying the data defects in the ledger-operation data package.

[0104] Preferably, the data missing information filling module is used to perform source data search and filling processing on the data missing area based on the generation time identifier information and data attribute information of the data missing area, including:

[0105] Based on the generation time identifier information and missing information item attributes of the missing data area, the source data of the original data terminal of the power distribution equipment is searched for the generation time consistent with the generation time identifier information and the information item consistent with the missing information item attributes, and the searched source data is added to the missing data area.

[0106] This data error correction module is used to perform source data correction and reloading processing on the data error portion based on the generation time identifier information and error type information of the data error portion, including:

[0107] Based on the generation time identifier information and error type information of the data error portion, the source data of the original data terminal of the power distribution equipment is located and corrected for the generation time consistent with the generation time identifier information and the data content type information consistent with the error type information, and the corrected source data is reloaded into the data error portion.

[0108] In the above technical solution, based on the generation time identifier information and missing information item attributes of the missing data area, the source data of the power distribution equipment is searched for the generation time consistent with the generation time identifier information and the information item consistent with the missing information item attributes. This can complete the corresponding missing data area and improve the reliability of the data. Furthermore, based on the generation time identifier information and error type information of the data error part, the source data of the power distribution equipment is located and corrected for the generation time consistent with the generation time identifier information and the type information of the data content consistent with the error type information. The corrected source data is then reloaded into the data error part. This can perform targeted data error correction and improve the accuracy of the data.

[0109] As can be seen from the above embodiments, the power grid distribution transformer marketing data verification and correction editing method and system, based on the data generation status information of each distribution equipment's respective marketing end, defines the data extraction time interval for the marketing end of the distribution equipment, thereby generating several data extraction time intervals for the marketing end of the distribution equipment, limiting the time range for marketing data extraction; based on the data extraction time intervals, the system extracts and processes ledger data and operational data from the marketing end of the distribution equipment, generates a ledger-operation data package, and performs generation time identification processing on it, realizing a unique identifier for the generation time of all data under the ledger-operation data package; it also verifies and compares the ledger data and operational data under the ledger-operation data package, identifies the missing data areas and data errors in the ledger-operation data package, facilitating subsequent targeted correction and editing of data missing and data errors in the marketing data, ensuring the credibility of the marketing data, and improving the operational stability of the power grid distribution equipment.

[0110] Obviously, those skilled in the art can make various modifications and variations to this invention without departing from its spirit and scope. Therefore, if these modifications and variations fall within the scope of the claims of this invention and their equivalents, this invention also intends to include these modifications and variations.

Claims

1. A method for grid-to-customer marketing data verification and correction editing, characterized in that, It comprises the following steps: Step S1, all power distribution equipment under the grid are monitored to obtain the marketing end data generation state information of all power distribution equipment; based on the marketing end data generation state information, the marketing end of the power distribution equipment is divided into data extraction time intervals to generate several data extraction time intervals about the marketing end of the power distribution equipment, including: Based on the network address of all power distribution equipment under the grid, the marketing end of all power distribution equipment is independently monitored to obtain the data generation flow change information of the marketing end; based on the data generation flow change information, all data generation key time points in the data generation process of the marketing end are determined; Based on all data generation key time points, the entire data generation interval of the marketing end is segmented for data extraction time interval division of the marketing end, thereby generating several data extraction time intervals about the marketing end; the effective data generation rate change information of all data extraction time intervals is obtained by effective data generation rate identification processing of all data extraction time intervals; Step S2, based on the data extraction time interval, the marketing end of the power distribution equipment is subjected to account data and operating data extraction processing to obtain the corresponding account data set and operating data set; the account data set and the operating data set are paired to obtain several account-operating data packages, and the generation time identification processing of all account-operating data packages is performed; Step S3, the account data and operating data under the account-operating data package are checked and compared to determine the data missing area and data error part of the account-operating data package; based on the data attribute information of the adjacent area of the data missing area, the missing data attribute information of the data missing area is determined; the data error part is identified to determine the error type information of the data error part; Step S4, based on the generation time identification information and data attribute information of the data missing area, the source data of the data missing area is searched and supplemented; based on the generation time identification information and error type information of the data error part, the source data of the data error part is corrected and reloaded.

2. The power grid distribution transformer marketing data verification and correction editing method of claim 1, characterized in that: In the step S2, based on the data extraction time interval, the marketing end of the power distribution equipment is subjected to account data and operating data extraction processing to obtain the corresponding account data set and operating data set; the account data set and the operating data set are paired to obtain several account-operating data packages, and the generation time identification processing of all account-operating data packages is performed, including: Generating time interval-based effective data generation rate change information, determining the data extraction frequency of the marketing end of the power distribution device in the data extraction time interval, extracting account data and operation data from the marketing end, and arranging all the extracted account data and all the operation data in chronological order to form an account data set and an operation data set, respectively; Performing generation time correlation matching processing on the account data set and the operation data set, grouping the account data and operation data generated at the same time into an account-operation data packet, and adding the generation time information of the account-operation data packet to the corresponding index information, thereby performing generation time identification processing on the account-operation data packet.

3. The power grid distribution transformer marketing data verification and correction editing method of claim 2, wherein: In step S3, the account data and operation data belonging to the account-operation data packet are verified and compared to determine the data missing area and data error part of the account-operation data packet; Based on the data attribute information of the adjacent area of the data missing area, the missing data attribute information of the data missing area is determined; The data error part is identified to determine the error type information of the data error part, including: The account data and operation data belonging to the account-operation data packet are respectively verified to obtain account information items and operation information items; the account information items and the operation information items are then compared to determine the data missing area and the data error part of the account-operation data packet; the data missing area refers to the missing information item content of the account-operation data packet; and the data error part refers to the information item with content error in the account-operation data packet; The information item attribute of the data contained in the adjacent area of the data missing area is compared with the information item distribution list of the account-operation data packet to determine the missing information item attribute corresponding to the data missing area, which is used as the data attribute information; The data content of the data error part is identified to determine the data content inconsistent with the information item attribute of the data error part, and the type information of the inconsistent data content is determined, which is used as the error type information.

4. The power grid distribution transformer marketing data verification and correction editing method of claim 3, wherein: In step S4, based on the generation time identification information and the data attribute information of the data missing area, source data searching and supplementing processing is performed on the data missing area; Based on the generation time identification information and the error type information of the data error part, source data correction and reloading processing is performed on the data error part, including: Based on the generation time identification information and the missing information item attribute of the data missing area, source data searching is performed on the original data end of the power distribution device with respect to the generation time consistent with the generation time identification information and the information item consistent with the missing information item attribute, and the found source data is supplemented to the data missing area. Based on the generation time identification information and error type information of the data error part, the original data end of the power distribution equipment is positioned and corrected with respect to the source data of the generation time consistent with the generation time identification information and the type information of the data content consistent with the error type information, and the corrected source data is reloaded to the data error part.

5. A grid-to-customer marketing data verification and correction editing system, characterized by, Comprise: The power distribution equipment listening module is used for listening to all power distribution equipment under the power grid to obtain the marketing end data generation state information of each power distribution equipment, including: Based on the network address of each power distribution equipment under the power grid, the marketing end of each power distribution equipment is independently listened to to obtain the data generation flow change information of the marketing end; based on the data generation flow change information, all data generation key time points in the data generation process of the marketing end are determined; The data extraction time interval determination module is used for determining the data extraction time interval of the marketing end of the power distribution equipment based on the marketing end data generation state information, to generate a plurality of data extraction time intervals of the marketing end of the power distribution equipment, including: Based on all data generation key time points, the entire data generation interval of the marketing end is segmented to determine the data extraction time interval of the marketing end, thereby generating a plurality of data extraction time intervals of the marketing end; the effective data generation rate change information of all data extraction time intervals is identified to obtain the effective data generation rate change information of the data extraction time interval; The marketing data extraction module is used for extracting the account data and operation data of the marketing end of the power distribution equipment based on the data extraction time interval to obtain the corresponding account data set and operation data set; The data packet generation and identification module is used for pairing the account data set and the operation data set to obtain a plurality of account-operation data packets, and performing generation time identification processing on all account-operation data packets; The data checking and contrasting module is used for checking and contrasting the account data and operation data under the account-operation data packet to determine the data missing area and data error part of the account-operation data packet; The data identification module is used for determining the missing data attribute information of the data missing area based on the data attribute information of the adjacent area of the data missing area; identifying the data error part to determine the error type information of the data error part; The data missing supplement module is used for supplementing the source data of the data missing area based on the generation time identification information and data attribute information of the data missing area; The data error correction module is used for correcting and reloading the source data of the data error part based on the generation time identification information and error type information of the data error part.

6. The power grid distribution variable marketing data checking and correction editing system of claim 5, wherein: The marketing data extraction module is configured to extract account data and operation data from the marketing end of the power distribution device based on the data extraction time interval, to obtain corresponding account data set and operation data set, including: Based on the effective data generation rate change information of the data extraction time interval, the data extraction frequency of the marketing end of the power distribution device in the data extraction time interval is determined, and the account data and operation data are extracted from the marketing end, and all extracted account data and operation data are sorted in chronological order to form account data set and operation data set, respectively; The data packet generation and identification module is configured to pair the account data set and the operation data set to obtain a plurality of account-operation data packets, and perform generation time identification processing on all account-operation data packets, including: The account data set and the operation data set are subjected to generation time correlation matching processing, and the account data and operation data generated at the same time are combined to form an account-operation data packet, and the generation time information of the account-operation data packet is added to the corresponding index information, so that the account-operation data packet is subjected to generation time identification processing.

7. The power grid distribution transformer marketing data verification and correction editing system of claim 6, wherein: The data verification comparison module is configured to verify and compare the account data and operation data belonging to the account-operation data packet to determine the data missing area and data error part of the account-operation data packet, including: The account data and operation data belonging to the account-operation data packet are subjected to information item verification to obtain account information item and operation information item, and the account information item and the operation information item are subjected to content comparison processing to determine the data missing area and data error part of the account-operation data packet; wherein the data missing area refers to the missing information item content of the account-operation data packet; and the data error part refers to the information item with content error in the account-operation data packet; The data recognition module is configured to determine the missing data attribute information of the data missing area based on the data attribute information of the adjacent area of the data missing area, and identify the data error part to determine the error type information of the data error part, including: The information item attribute of the data contained in the adjacent area of the data missing area is compared with the information item distribution list of the account-operation data packet to determine the missing information item attribute corresponding to the data missing area as the data attribute information; The data content of the data error part is identified to determine the data content inconsistent with the information item attribute of the data error part, and the type information of the inconsistent data content is determined as the error type information.

8. The power grid distribution transformer marketing data verification and correction editing system of claim 7, wherein: The data loss supplement module is used for source data searching and supplementing processing of the data loss area based on the generation time identification information and data attribute information of the data loss area, and includes: Based on the generation time identification information and the missing information item attribute of the data loss area, the original data end of the power distribution equipment is searched for source data about the generation time consistent with the generation time identification information and the information item consistent with the missing information item attribute, and the found source data is supplemented to the data loss area; The data error correction module is used for source data correction and reloading processing of the data error part based on the generation time identification information and error type information of the data error part, and includes: Based on the generation time identification information and the error type information of the data error part, the original data end of the power distribution equipment is positioned and corrected for source data about the generation time consistent with the generation time identification information and the type information of the data content consistent with the error type information, and the corrected source data is reloaded to the data error part.

Images