Power grid distribution transformer marketing data checking and correction editing method and system

Abstract

The invention relates to the technical field of power grid data processing, and provides a power grid distribution transformer marketing data verification and correction editing method and system, and the method comprises the steps: generating state information based on the data of the marketing ends of all power distribution equipment, carrying out the data extraction time interval delimitation of the marketing ends of the power distribution equipment, and carrying out the verification and correction editing of the marketing ends; generating a plurality of data extraction time intervals related to the marketing end of the power distribution equipment, and extracting a limited time range for marketing data; based on the data extraction time interval, carrying out machine account data and operation data extraction processing on the marketing end of the power distribution equipment, generating a machine account-operation data packet, and carrying out time identifier generation processing on the machine account-operation data packet; the machine account data and the operation data subordinate to the machine account-operation data packet are checked and compared to determine a data missing area and a data error part existing in the machine account-operation data packet, so that the data missing and the data error in the marketing data can be corrected and edited in a targeted manner subsequently, the credibility of the marketing data is ensured, and the marketing efficiency is improved. And the operation stability of power grid distribution equipment is improved.

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of power grid data processing, in particular to a power grid distribution transformer marketing data checking and correction editing method and system. BACKGROUND

[0002] The marketing end of the power grid distribution equipment is used to save different types of marketing data such as account data and equipment operation data, wherein the account data is used to record data such as power calculation and electricity management of the power grid distribution equipment, and the equipment operation data is used to record data such as working state and resource scheduling of the distribution equipment, so that the marketing data can comprehensively characterize and record the power grid distribution equipment. In the actual marketing data generation recording process, due to the influence of factors such as inconsistent account data format standards and unstable distribution equipment work, the marketing data may have problems such as loss or error, which directly leads to defects such as incomplete or incorrect marketing data, reduces the credibility of the marketing data, and cannot accurately and reliably evaluate the power grid distribution equipment by using the marketing data, and reduces the operation stability of the power grid distribution equipment. SUMMARY

[0003] In view of the defects in the prior art, the present application provides a power grid distribution transformer marketing data checking and correction editing method and system, which generates state information of each marketing end of all distribution equipment based on the marketing end data of each distribution equipment, divides the data extraction time interval of the marketing end of the distribution equipment, and generates a plurality of data extraction time intervals about the marketing end of the distribution equipment to limit the time range for marketing data extraction; based on the data extraction time interval, the account data and operation data of the marketing end of the distribution equipment are extracted and processed, and the account-operation data package is generated and the generation time is marked, so as to realize the unique identification of all data generation times under the account-operation data package; the account data and operation data under the account-operation data package are also checked and compared to determine the data missing area and data error part of the account-operation data package, so as to facilitate subsequent targeted correction and editing of data missing and data error in the marketing data, ensure the credibility of the marketing data, and improve the operation stability of the power grid distribution equipment.

[0004] The present application provides a power grid distribution transformer marketing data checking and correction editing method, which comprises the following steps: Step S1, listening to all distribution equipment under the power grid to obtain state information of each marketing end data generation of all distribution equipment; based on the marketing end data generation state information, the data extraction time interval of the marketing end of the distribution equipment is divided to generate a plurality of data extraction time intervals about the marketing end of the distribution equipment; Step S2, based on the data extraction time interval, the marketing end of the power distribution equipment is carried out account data and running data extraction processing, the corresponding account data set and running data set are obtained; the account data set and the running data set are paired, a plurality of account-running data packages are obtained, and time identification processing is carried out on all account-running data packages; Step S3, the account data and running data belonging to the account-running data package are checked and contrasted, the data missing area and data error part of the account-running data package are determined; 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, and the error type information of the data error part is determined; Step S4, based on the generation time identification information and data attribute information of the data missing area, source data searching and supplementing processing is carried out on the data missing area; based on the generation time identification information and error type information of the data error part, source data correction and reloading processing is carried out on the data error part.

[0005] In an embodiment of the present application, in the step S1, all power distribution equipment belonging to the power grid is listened to, and the respective marketing end data generation state information of all power distribution equipment is obtained; based on the marketing end data generation state information, the data extraction time interval of the marketing end of the power distribution equipment is determined, so as to generate a plurality of data extraction time intervals about the marketing end of the power distribution equipment, including: Based on the respective network addresses of all power distribution equipment belonging to the power grid, the respective marketing end of all power distribution equipment is independently listened to, and the data generation flow change information of the marketing end is obtained; 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 whole data generation interval of the marketing end is segmented, so as to determine the data extraction time interval of the marketing end, thereby generating a plurality of data extraction time intervals about the marketing end; the effective data generation rate of all data extraction time intervals is identified respectively, and the effective data generation rate change information of the data extraction time interval is obtained.

[0006] In an embodiment of the present application, in the step S2, based on the data extraction time interval, the marketing end of the power distribution equipment is carried out account data and running data extraction processing, the corresponding account data set and running data set are obtained; the account data set and the running data set are paired, a plurality of account-running data packages are obtained, and time identification processing is carried out on all account-running data packages, including: generate rate change information of valid data based on the data extraction time interval, determine the data extraction frequency of the marketing side of the power distribution equipment in the data extraction time interval, extract the account data and operation data from the marketing side, and then sort all the account data and all the operation data in chronological order to form an account data set and an operation data set, respectively; Perform time generation correlation matching processing on the account data set and the operation data set, group the account data and operation data generated at the same time into an account-operation data packet, and add 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.

[0007] In one embodiment of the present application, in step S3, the account data and operation data belonging to the account-operation data packet are checked 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 information item and the operation information item are obtained by checking the information item of the account data and the operation data belonging to the account-operation data packet; then the account information item and the operation information item are compared to determine the data missing area and the 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; the data error part refers to the information item with content error in the account-operation data packet; Compare the information item attribute of the data contained in the adjacent area of the data missing area 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; Identify the data content of the data error part to determine the inconsistent data content with the information item attribute of the data error part, and determine the type information of the inconsistent data content, which is used as the error type information.

[0008] In one embodiment of the present application, in step S4, based on the generation time identification information and the 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 the error type information of the data error part, the source data of the data error part is corrected and reloaded, including: Based on the generation time identification information and the missing information item attribute of the data missing area, the original data end of the power distribution equipment is subjected to source data searching about the generation time consistent with the generation time identification information and the information item consistent with the missing information item attribute, and the searched source data is supplemented to the data missing area; 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 subjected to source data positioning and correction 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.

[0009] The application also provides a power grid distribution transformer marketing data checking and correction editing system, comprising: A power distribution equipment monitoring module is configured to monitor all power distribution equipment under the power grid to obtain respective marketing end data generation state information of all power distribution equipment. A data extraction time interval determination module is configured to determine data extraction time intervals of the marketing end of the power distribution equipment based on the marketing end data generation state information, thereby generating a plurality of data extraction time intervals of the marketing end of the power distribution equipment. A marketing data extraction module is configured to extract account data and operation data of the marketing end of the power distribution equipment based on the data extraction time intervals, thereby obtaining a corresponding account data set and an operation data set. A data packet generation and identification module is configured to pair the account data set and the operation data set, thereby obtaining a plurality of account-operation data packets, and to perform generation time identification on all account-operation data packets. A data checking and contrasting module is configured to check and contrast the account data and the operation data of the account-operation data packet, thereby determining data missing areas and data error parts of the account-operation data packet. A data recognition module is configured to determine missing data attribute information of the data missing area based on data attribute information of adjacent areas of the data missing area, and to recognize the data error part to determine error type information of the data error part. A data missing supplement module is configured to search for source data of the data missing area based on the generation time identification information and the data attribute information of the data missing area, and to supplement the searched source data to the data missing area. A data error correction module is configured to correct the data error part based on the generation time identification information and the error type information of the data error part, and to reload the corrected source data to the data error part.

[0010] In one embodiment of the present application, the power distribution equipment monitoring module is configured to monitor all power distribution equipment under the power grid, obtain respective marketing end data generation state information of all 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 monitored to obtain data generation traffic change information of the marketing end; based on the data generation traffic 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 configured to determine the data extraction time interval of the marketing end of the power distribution equipment based on the marketing end data generation state information, and 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; all data extraction time intervals are respectively subjected to effective data generation rate identification processing to obtain effective data generation rate change information of the data extraction time interval.

[0011] In one embodiment of the present application, the marketing data extraction module is configured to extract account data and operation data of the marketing end of the power distribution equipment based on the data extraction time interval, obtain a 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 equipment in the data extraction time interval is determined, thereby extracting account data and operation data from the marketing end, and then arranging all extracted account data and operation data in chronological order to form an account data set and an 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, the account data and the 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, thereby performing generation time identification processing on the account-operation data packet.

[0012] In one embodiment of the present disclosure, the data checking and contrasting module is configured to check and contrast the account data and the operation data belonging to the account-operation data package, and determine the data missing area and the data error part existing in the account-operation data package, comprising: checking and contrasting the information items of the account data and the operation data belonging to the account-operation data package respectively to obtain account information items and operation information items; and then contrasting the contents of the account information items and the operation information items to determine the data missing area and the data error part existing in the account-operation data package; wherein the data missing area refers to the information item content missing in the account-operation data package; and the data error part refers to the information item with content error existing in the account-operation data package. 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, comprising: comparing the information item attribute of the data contained in the adjacent area of the data missing area with the information item distribution list of the account-operation data package to determine the missing information item attribute corresponding to the data missing area, which is used as the data attribute information; identifying the data content of the data error part to determine the data content inconsistent with the information item attribute of the data error part, and determine the type information of the inconsistent data content, which is used as the error type information.

[0013] In one embodiment of the present disclosure, the data missing supplement module is configured to perform source data searching and supplement processing on the data missing area based on the generation time identification information and the data attribute information of the data missing area, comprising: performing source data searching on the original data end of the power distribution equipment about the generation time consistent with the generation time identification information and the information item consistent with the missing information item attribute of the data missing area based on the generation time identification information and the missing information item attribute of the data missing area, and supplementing the found source data to the data missing area; The data error correction module is configured to perform source data correction and reloading processing on the data error part based on the generation time identification information and the error type information of the data error part, comprising: performing source data positioning and correction on the original data end of the power distribution equipment 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 of the data error part based on the generation time identification information and the error type information of the data error part, and reloading the corrected source data to the data error part.

[0014] Compared with the prior art, the power distribution transformer marketing data checking and correction editing method and system generate state information based on the respective marketing end data of all power distribution equipment, perform data extraction time interval division on the marketing end of the power distribution equipment, thereby generating a plurality of data extraction time intervals about the marketing end of the power distribution equipment, and define a time range for marketing data extraction; based on the data extraction time interval, perform account data and operation data extraction processing on the marketing end of the power distribution equipment, and generate an account-operation data packet and perform generation time identification processing thereon, to realize unique identification of all data generation times under the account-operation data packet; also check and compare the account data and operation data under the account-operation data packet, determine the data missing area and data error part existing in the account-operation data packet, facilitate subsequent targeted correction editing of data missing and data errors in the marketing data, ensure the credibility of the marketing data, and improve the operation stability of the power distribution equipment.

[0015] Other features and advantages of the present application will be set forth in the following description, and in part will become apparent to those skilled in the art from the description, or can be learned by practice of the present application. The objects and other advantages of the present application can be realized and attained by means of the instrumentalities particularly pointed out in the written description and claims hereof as well as the appended drawings.

[0016] The technical solutions of the present application will be further described in detail below with the help of the accompanying drawings and examples. BRIEF DESCRIPTION OF DRAWINGS

[0017] In order to more clearly illustrate the technical solutions in the embodiments of the present application or the prior art, the accompanying drawings needed to be used in the embodiments or the prior art description will be briefly introduced. Obviously, the accompanying drawings in the following description are only some embodiments of the present application, and other accompanying drawings can be obtained by those skilled in the art without any creative effort.

[0018] Figure 1 The flowchart of the power grid transformer marketing data checking and correction editing method provided by the present application is shown in the figure. Figure 2 The frame diagram of the power grid transformer marketing data checking and correction editing system provided by the present application is shown in the figure. DETAILED DESCRIPTION

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

[0020] Referring to Figure 1 A flowchart of an electric power grid distribution transformer marketing data checking and correction editing method provided by an embodiment of the present application. The electric power grid distribution transformer marketing data checking and correction editing method comprises: Step S1, listening to all distribution equipment under the electric power grid to obtain respective marketing end data generation state information of all distribution equipment; based on the marketing end data generation state information, defining a data extraction time interval for the marketing end of the distribution equipment to generate a plurality of data extraction time intervals for the marketing end of the distribution equipment; Step S2, based on the data extraction time interval, performing account data and running data extraction processing on the marketing end of the distribution equipment to obtain a corresponding account data set and a running data set; pairing the account data set and the running data set to obtain a plurality of account-running data packages, and performing generation time identification processing on all account-running data packages; Step S3, checking and comparing the account data and the running data under the account-running data package to determine a data missing area and a data error part existing in the account-running data package; based on the data attribute information of the adjacent area of the data missing area, determining the missing data attribute information of the data missing area; identifying the data error part to determine the error type information of the data error part; Step S4, based on the generation time identification information and the data attribute information of the data missing area, performing source data searching and supplementing processing on the data missing area; based on the generation time identification information and the error type information of the data error part, performing source data correction and reloading processing on the data error part.

[0021] The electric power grid distribution transformer marketing data checking and correction editing method defines a data extraction time interval for the marketing end of the distribution equipment based on the respective marketing end data generation state information of all distribution equipment to generate a plurality of data extraction time intervals for the marketing end of the distribution equipment, thereby limiting the time range for marketing data extraction; based on the data extraction time interval, performing account data and running data extraction processing on the marketing end of the distribution equipment, and generating account-running data packages and performing generation time identification processing thereon to realize unique identification of all data generation times under the account-running data packages; also checking and comparing the account data and the running data under the account-running data package to determine a data missing area and a data error part existing in the account-running data package, thereby 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 operation stability of the electric power grid distribution equipment.

[0022] Preferably, in the step S1, all power distribution devices under the power grid are monitored to obtain respective marketing end data generation state information of all power distribution devices; based on the marketing end data generation state information, a data extraction time interval of the marketing end of the power distribution device is determined to generate several data extraction time intervals of the marketing end of the power distribution device, including: Based on respective network addresses of all power distribution devices under the power grid, the respective marketing ends of all power distribution devices are independently monitored to obtain data generation flow change information of the marketing end; based on the data generation flow change information, all data generation key time points of the marketing end in the data generation process are determined; 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 several data extraction time intervals of the marketing end; the effective data generation rate change information of the data extraction time interval is obtained by identifying the effective data generation rate of all data extraction time intervals.

[0023] In the above technical solution, the power grid includes different types of power distribution devices, each of which works independently and forms different types of marketing data in the working process. The process of forming marketing data by the power distribution device is not a stable data flow. More marketing data is formed in a certain time period, and less marketing data is formed in another time period. In order to accurately extract the marketing data of the power distribution device, the marketing end (i.e. the marketing data generation end) of the power distribution device is independently monitored according to the network address of the power distribution device to obtain the data generation flow change information of the marketing end. According to the data generation flow change information, the time points corresponding to all data generation flow peaks in the marketing data generation process of the marketing end are determined as all data generation key time points in the data generation process of the marketing end. The entire data generation interval of the marketing end is segmented based on all data generation key time points, thereby generating several data extraction time intervals of the marketing end. This can avoid excessive marketing data generated in the data extraction time interval and cannot be effectively and accurately extracted. In addition, the effective data generation rate change information of the data extraction time interval is obtained by identifying the effective data generation rate of all data extraction time intervals. The effective data generation rate change information refers to the generation rate (amount of generated data per unit time) change information of non-random code data in the data extraction time interval, thereby providing a reliable basis for subsequent data extraction.

[0024] Preferably, in the step S2, based on the data extraction time interval, the marketing side of the power distribution equipment is subjected to account data and operation data extraction processing to obtain corresponding account data set and operation data set; the account data set and the operation data set are subjected to pairing processing to obtain a plurality of account-operation data packages, and the all account-operation data packages are subjected to generation time identification processing, including: Based on the effective data generation rate change information of the data extraction time interval, the data extraction frequency of the marketing side of the power distribution equipment in the data extraction time interval is determined, so as to extract the account data and the operation data from the marketing side, and then all the extracted account data and all the operation data are arranged in chronological order to form the account data set and the operation data set respectively; The account data set and the operation data set are subjected to generation time correlation matching processing, the account data and the operation data generated at the same time are combined to form an account-operation data package, and the generation time information of the account-operation data package is added to the corresponding index information, so that the account-operation data package is subjected to generation time identification processing.

[0025] In the above technical scheme, based on the effective data generation rate change information of the data extraction time interval, the data extraction frequency of the marketing side of the power distribution equipment in the data extraction time interval is determined, generally, the greater the effective data generation rate, the greater the data extraction frequency of the marketing side, so that the marketing data generated by the marketing side can be extracted in time, and the situation of missing marketing data extraction is avoided. Then all the extracted account data and all the operation data are arranged in chronological order to form the account data set and the operation data set respectively, so as to ensure the order of the internal data of the account data set and the operation data set. The account data set and the operation data set are subjected to generation time correlation matching processing, the account data and the operation data generated at the same time are combined to form an account-operation data package, so that the account data and the operation data generated at the same time can be checked by each other in the subsequent data checking, and the generation time information of the account-operation data package is added to the corresponding index information, so that the account-operation data package is subjected to generation time identification processing, so that the account-operation data package can clearly indicate its generation time.

[0026] Preferably, in the step S3, the account data and the operation data belonging to the account-operation data package are checked and compared to determine the data missing area and the data error part of the account-operation 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, including: The account data and the operation data under the account-operation data package are respectively subjected to information item checking to obtain account information items and operation information items; the account information items and the operation information items are subjected to content comparison processing to determine a data missing area and a data error part existing in the account-operation data package; the data missing area refers to missing information item content of the account-operation data package; and the data error part refers to an information item with content error existing in the account-operation data package. 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 package 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.

[0027] In the above technical solution, the account data and the operation data under the account-operation data package correspond to respective information items, the information items are related to the actual working condition of the power distribution equipment, the account information items and the operation information items are subjected to content comparison processing to determine the data missing area and the data error part existing in the account-operation data package, for example, all the account information items and all the operation information items are compared, if there is inconsistency between the two types of information items, it is determined that there is a data missing area corresponding to a certain account information item or operation information item and a data error part therein, so that the account-operation data package is comprehensively screened; 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 package to determine the missing information item attribute corresponding to the data missing area, and 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, so that the data defects existing in the account-operation data package are comprehensively identified.

[0028] Preferably, in the 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 equipment 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 missing area. 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 subjected to source data positioning and correction 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.

[0029] In the above technical solution, based on the generation time identification information and the missing information item attribute of the data missing area, the original data end of the power distribution equipment is subjected to source data searching about the generation time consistent with the generation time identification information and the information item consistent with the missing information item attribute, so that the data missing area can be completed and the reliability of the data is improved; and 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 subjected to source data positioning and correction 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, so that the data error correction can be targeted and the correctness of the data is improved.

[0030] Reference Figure 2 The power grid distribution marketing data checking and correction editing system provided by the embodiment of the application has the following advantages. The power distribution equipment monitoring module is configured to monitor all power distribution equipment under the power grid to obtain the marketing end data generation state information of each power distribution equipment. The data extraction time interval determination module is configured to determine the data extraction time interval of the marketing end of the power distribution equipment based on the marketing end data generation state information, so as to generate a plurality of data extraction time intervals of the marketing end of the power distribution equipment. The marketing data extraction module is configured to extract the account data and the operation data of the marketing end of the power distribution equipment based on the data extraction time interval, so as to obtain the corresponding account data set and operation data set. The data packet generation and identification module is configured to pair the account data set and the operation data set, obtain a plurality of account-operation data packets, and identify the generation time of all account-operation data packets. The data checking and comparison module is configured to check and compare the account data and the operation data of the account-operation data packet to determine the data missing area and the data error part of 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 recognize the data error part to determine the error type information of the data error part. a data loss supplement module, configured to perform source data searching and supplement processing on the data loss area based on the generation time identification information and the data attribute information of the data loss area; a data error correction module, configured to perform source data correction and reloading processing on the data error part based on the generation time identification information and the error type information of the data error part.

[0031] The power grid distribution equipment marketing data checking and correction editing system generates state information of respective marketing end data of all distribution equipment, divides data extraction time intervals for the marketing end of the distribution equipment, generates a plurality of data extraction time intervals for the marketing end of the distribution equipment, and defines a time range for marketing data extraction; based on the data extraction time intervals, performs account data and operation data extraction processing on the marketing end of the distribution equipment, generates an account-operation data packet, and performs generation time identification processing thereon, to realize unique identification of all data generation times of the account-operation data packet; the account-operation data packet also performs checking and comparison on the account data and the operation data, determines data loss areas and data error parts of the account-operation data packet, facilitates subsequent targeted correction and editing of data loss and data error in the marketing data, ensures the credibility of the marketing data, and improves the operation stability of the power grid distribution equipment.

[0032] Preferably, the distribution equipment monitoring module is configured to monitor all distribution equipment under the power grid to obtain respective marketing end data generation state information of all distribution equipment, including: based on respective network addresses of all distribution equipment under the power grid, independently monitoring respective marketing ends of all distribution equipment to obtain data generation flow change information of the marketing end; based on the data generation flow change information, determining all data generation key time points of the marketing end in the data generation process; The data extraction time interval determination module is configured to divide data extraction time intervals for the marketing end of the distribution equipment based on the marketing end data generation state information, to generate a plurality of data extraction time intervals for the marketing end of the distribution equipment, including: based on all data generation key time points, performing segmentation processing on the entire data generation interval of the marketing end, to divide data extraction time intervals for the marketing end, thereby generating a plurality of data extraction time intervals for the marketing end; performing effective data generation rate identification processing on all data extraction time intervals, to obtain effective data generation rate change information of the data extraction time interval.

[0033] In the technical solution, the power grid comprises different types of power distribution equipment, each of which works independently and generates different types of marketing data during work. The process of generating marketing data by the power distribution equipment is not stable in data flow, and more marketing data is generated in some time periods and less marketing data is generated in other time periods. In order to accurately extract the marketing data of the power distribution equipment, the marketing end (i.e. the marketing data generation end) of the power distribution equipment is independently monitored according to the network address of the power distribution equipment to obtain data generation flow change information of the marketing end, and then the time points corresponding to all data generation flow peaks in the marketing data generation process of the marketing end are determined according to the data generation flow change information, which are used as all data generation key time points in the data generation process of the marketing end. The entire data generation interval of the marketing end is segmented based on all data generation key time points for segmentation processing, thereby generating a plurality of data extraction time intervals related to the marketing end. In this way, it can be avoided that too much marketing data is generated in the data extraction time interval and cannot be effectively and accurately extracted. In addition, the effective data generation rate of all data extraction time intervals is identified respectively to obtain effective data generation rate change information of the data extraction time interval, wherein the effective data generation rate change information refers to the generation rate (amount of generated data per unit time) change information of non-random code data in the data extraction time interval, thereby providing a reliable basis for subsequent data extraction.

[0034] Preferably, the marketing data extraction module is configured to extract account data and operation data of the marketing end of the power distribution equipment based on the data extraction time interval to obtain a corresponding account data set and an 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 equipment in the data extraction time interval is determined, and the account data and the operation data are extracted from the marketing end. All extracted account data and all operation data are arranged in chronological order to form an account data set and an 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 association matching processing, and the account data and the operation data generated at the same time are combined to form an account-operation data packet. The generation time information of the account-operation data packet is added to the corresponding index information, thereby performing generation time identification processing on the account-operation data packet.

[0035] In the technical solution, the data extraction frequency of the marketing end of the power distribution equipment in the data extraction time interval is determined based on the valid data generation rate change information of the data extraction time interval. Generally, the greater the valid data generation rate, the greater the data extraction frequency of the marketing end, so that the marketing data generated by the marketing end can be extracted in time, and the situation of missing marketing data extraction is avoided. Then, all the account data and all the running data are respectively grouped into an account data set and a running data set according to the time sequence, so as to ensure the order of the data in the account data set and the running data set. The account data set and the running data set are further subjected to generation time correlation matching processing, and the account data and the running data generated at the same time are grouped into an account-running data package. This facilitates subsequent data checking of the account data and the running data generated at the same time as each other, and the generation time information of the account-running data package is added to the corresponding index information, so that the account-running data package is subjected to generation time identification processing, and the account-running data package can clearly indicate its generation time.

[0036] Preferably, the data checking and contrasting module is configured to check and contrast the account data and the running data belonging to the account-running data package, determine a data missing area and a data error part existing in the account-running data package, and include: checking and contrasting information items of the account data and the running data belonging to the account-running data package to obtain account information items and running information items; and contrasting the account information items and the running information items to determine the data missing area and the data error part existing in the account-running data package; wherein the data missing area refers to missing information item contents of the account-running data package; and the data error part refers to information items with content errors in the account-running data package. The data recognition module is configured to determine missing data attribute information of the data missing area based on data attribute information of adjacent areas of the data missing area, and identify the data error part to determine error type information of the data error part, and include: comparing information item attributes of data contained in adjacent areas of the data missing area with an information item distribution list of the account-running data package to determine missing information item attributes corresponding to the data missing area, and use the missing information item attributes as the data attribute information; identifying data contents of the data error part to determine data contents inconsistent with information item attributes of the data error part, and determine type information of the inconsistent data contents, and use the type information as the error type information.

[0037] In the technical solution, the account data and the operation data under the account-operation data package respectively correspond to corresponding information items, the information items are related to the actual working conditions of the power distribution equipment, the account information items and the operation information items are subjected to content comparison processing, the data missing area and the data error part of the account-operation data package are determined, for example, all the account information items and all the operation information items are compared, if there is inconsistency between the two types of information items, it is determined that there is a data missing area corresponding to a certain account information item or operation information item and a data error part therein, so that the account-operation data package is comprehensively screened; the information item attributes of the data contained in the adjacent area of the data missing area are compared with the information item distribution list of the account-operation data package, the missing information item attributes corresponding to the data missing area are determined, the data content of the data error part is identified, the data content inconsistent with the information item attributes of the data error part is determined, and the type information of the inconsistent data content is determined, so that the data defects of the account-operation data package are comprehensively identified.

[0038] Preferably, the data missing supplement module is configured to perform source data searching and supplement processing on the data missing area based on the generation time identification information and the data attribute information of the data missing area, including: perform source data searching on the original data end of the power distribution equipment about the generation time consistent with the generation time identification information and the information item consistent with the missing information item attribute based on the generation time identification information and the missing information item attribute of the data missing area, and supplement the found source data to the data missing area; The data error correction module is configured to perform source data correction and reloading processing on the data error part based on the generation time identification information and the error type information of the data error part, including: perform source data positioning and correction on the original data end of the power distribution equipment 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 based on the generation time identification information and the error type information of the data error part, and reload the corrected source data to the data error part.

[0039] In the technical solution, based on the generation time identifier information and the missing information item attribute of the data missing area, the original data end of the power distribution equipment is subjected to source data searching about the generation time consistent with the generation time identifier information and the information item consistent with the missing information item attribute, so that the data missing area can be completed, and the reliability of the data is improved. Based on the generation time identifier information and the error type information of the data error part, the original data end of the power distribution equipment is subjected to source data positioning and correction about the generation time consistent with the generation time identifier 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, so that the data error correction can be targeted, and the correctness of the data is improved.

[0040] From the above embodiment, the power grid distribution transformer marketing data checking and correction editing method and system can generate state information based on the respective marketing end data of all power distribution equipment, divide the data extraction time interval of the marketing end of the power distribution equipment, generate a plurality of data extraction time intervals about the marketing end of the power distribution equipment, and define the time range for marketing data extraction. Based on the data extraction time interval, the account data and the running data of the marketing end of the power distribution equipment are extracted and processed, and the account-running data packet is generated and subjected to generation time identifier processing, so that the unique identification of all data generation times under the account-running data packet is realized. The account data and the running data under the account-running data packet are also checked and compared to determine the data missing area and the data error part of the account-running data packet, so that the subsequent targeted correction and editing of the data missing and the data error in the marketing data are facilitated, the credibility of the marketing data is ensured, and the operation stability of the power grid distribution equipment is improved.

[0041] Obviously, those skilled in the art can make various modifications and variations to the present application without departing from the spirit and scope of the present application. Thus, if these modifications and variations of the present application fall within the scope of the claims of the present application and their equivalent technologies, the present application also intends to include these modifications and variations.

Claims

1. A method for verifying, correcting, and editing marketing data of power grid distribution transformers, characterized in that... It includes the following steps: 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. 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; 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; Based on the data attribute information of the adjacent regions of the missing data region, the missing data attribute information of the missing data region is determined; The data error portion is identified, and the error type information of the data error portion is determined; 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 portion, the source data correction and reloading process is performed on the data error portion.

2. The method for verifying, correcting, and editing power grid distribution transformer marketing data as described in claim 1, characterized in that: 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: 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. 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.

3. The method for verifying, correcting, and editing power grid distribution transformer marketing data as described in claim 2, characterized in that: 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 identifiers, 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 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. 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.

4. The method for verifying, correcting, and editing power grid distribution transformer marketing data as described in claim 3, characterized in that: In step S3, the ledger data and operation data under the ledger-operation data package are checked and compared to determine the missing data areas and data error parts in the ledger-operation data package; Based on the data attribute information of the adjacent regions of the missing data region, the missing data attribute information of the missing data region is determined; Identifying the erroneous portions of the data and determining the error type information of the erroneous portions includes: 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. 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. 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.

5. The method for verifying, correcting, and editing power grid distribution transformer marketing data as described in claim 4, characterized in that: 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 data error portion, the data error portion undergoes source data correction and reloading processing, including: 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. 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.

6. A power grid distribution transformer marketing data verification, correction, and editing system, characterized in that: include: 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. 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. 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. 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; 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; 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; The data error portion is identified, and the error type information of the data error portion is determined; 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. 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.

7. The power grid distribution transformer marketing data verification and correction editing system as described in claim 6, characterized in that: 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: 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. 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: 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.

8. The power grid distribution transformer marketing data verification and correction editing system as described in claim 7, characterized in that: 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: 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. 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: 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.

9. The power grid distribution transformer marketing data verification and correction editing system as described in claim 8, characterized in that: 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 erroneous data portions in the ledger-operation data package, including: 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. 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: 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. 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.

10. The power grid distribution transformer marketing data verification and correction editing system as described in claim 9, characterized in that: 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: 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. 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: 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.

Images