CN117422410A - Power grid data auditing processing system and method - Google Patents

Abstract

The invention relates to the technical field of data audit processing, in particular to a system and a method for power grid data audit processing, comprising the following steps: the system comprises a data acquisition module, a data storage module, a data processing module, a data transmission module, a data analysis module, a data sharing module and a management module; the method improves the data processing speed in a distributed data processing mode, analyzes the processing result of the same data in a redundant processing mode, ensures the accuracy of the data, simultaneously performs redundant transmission on the data through a power transmission line, reduces the occurrence of data loss, reduces the cost of data transmission, and then performs a decentralization storage mode on the data, reduces the occurrence of malicious tampering of the data, and improves the usability of the system.

Description

Power grid data auditing processing system and method

Technical Field

The invention relates to the technical field of data audit processing, in particular to a system and a method for power grid data audit processing.

Background

The electric power department is a department which reasonably supplies power to the city through the power grid, in order to reasonably use the electric power resources and the expenses, the electric power department periodically carries out financial audit, so that the normal and reasonable use of the expenses and the electric power resources is ensured, and according to the audit result, workers can conveniently arrange the use plan of the electric power resources and the expenses in the next quarter, and the traditional audit method is to audit a large amount of data through the workers, so that the time and the labor are wasted, the audit efficiency is influenced, and errors are easy to occur.

Therefore, an auditing method, a device, a power grid system and a storage medium of the power grid data disclosed in the invention patent with the application number of 202111514675.4, an auditing data comparison analysis management system disclosed in the invention patent with the application number of 201710989334.X and the like appear, and data are audited through a special system, so that the auditing speed is improved, and the error probability is reduced.

However, in the use process, it is found that the accuracy of the power data is poor due to the aging and the remote location of part of the equipment, and the data loss condition easily occurs in the transmission process, while the existing auditing system is inconvenient to detect the accuracy of the power data and the data loss condition, and the usability is poor due to the fact that the data processing speed is reduced due to the fact that the data processing is required to be large, so that a system and a method for auditing the power grid data are needed to improve the problems.

Disclosure of Invention

In order to solve the technical problems, the invention provides the grid data auditing processing system and the grid data auditing processing method, which are used for improving the data processing speed in a distributed data processing mode, analyzing the processing result of the same data in a redundant processing mode, guaranteeing the accuracy of the data, simultaneously carrying out redundant transmission on the data through a power transmission line, reducing the occurrence of data loss, reducing the cost of data transmission, and then carrying out a decentralization storage mode on the data, reducing the occurrence of malicious tampering of the data and improving the usability of the system.

The invention relates to a power grid data auditing processing system, which comprises:

and a data acquisition module: the data of the power equipment, the use data of the power resources and the account data are collected, and the collected data are conveniently transmitted to the storage module;

and the data storage module is used for: classifying the received data according to region division, equipment data, power data and account data, storing for a limited period, and deleting data exceeding the storage period;

and a data processing module: setting the maximum difference between the data processed at this time and the data processed before, judging the data to be abnormal if the data processed at this time exceeds the maximum difference, comparing the data of the power equipment and the use data of the power resources acquired at this time by the 3-group data acquisition module with the use data of the power equipment and the use data of the power resources acquired at the time of the last audit through the 3-group data processing module to obtain a difference, and comparing the obtained difference with the set maximum difference;

and a data transmission module: the processing result of the data processing module and the acquired data are transmitted to the management module by using a power transmission line, and the data sent by the 3 groups of data processing modules are the same, so that the occurrence of data loss is reduced;

and a data analysis module: setting the maximum difference value of 3 groups of data, analyzing and judging the accuracy of the acquired data according to the difference value and the comparison result obtained by the 3 groups of data processing modules for processing the same data, judging the data to be accurate if the difference value of the 3 groups of data meets the requirements or the two groups of data in the 3 groups of data meet the requirements, or judging the data to be abnormal if the two groups of data in the 3 groups of data exceed the maximum difference value, analyzing and processing the accurate data, comparing the data of the power equipment and the use data of the power resource with the account data, and judging whether the data of the power equipment and the use data of the power resource are consistent with the account data or not;

and a data sharing module: transmitting the collected data and analysis judgment results to other power departments for storage, and changing the stored data requires that all power department related management personnel storing the same data agree, and meanwhile, periodically checking the stored data to ensure the consistency of the data in the power departments storing the same data;

and a management module: and managing the login personnel, recording the operation flow of the login personnel, storing the data sent by the data transmission module, the analysis result of the data analysis module and the data transmitted by other power departments, and controlling and managing the data acquisition module, the data storage module, the data processing module, the data transmission module, the data analysis module and the data sharing module.

Preferably, the data acquisition module includes:

the power equipment data acquisition module: collecting the running condition, maintenance condition and running time of the power equipment;

the power resource data acquisition module: collecting generated energy, electric power distribution conditions and user electric power use conditions;

financial account data acquisition module: daily records of power equipment data and power resource data are collected.

Preferably, the data storage module includes:

classification unit: classifying the received data according to the classification of the region, the equipment data, the power data and the account data;

and a storage unit: the classified data are stored regularly;

cleaning unit: data that exceeds the shelf life is deleted.

Preferably, the data processing unit:

threshold setting unit: taking 20% of the values acquired during the last audit as the maximum difference value, and then calculating the accurate value of the maximum difference value;

comparison unit: and comparing the current data with the last data to obtain a difference value, and comparing the difference value with a maximum difference value to judge whether the difference value is abnormal data or not.

Preferably, the data transmission module includes:

a conversion unit: converting the data of the non-digital signals into digital signals;

a transmission unit: the data is transmitted in the power transmission line by adopting a communication mode of PLC-IoT.

Preferably, the data analysis module includes:

deep learning processor: judging the accuracy of the data according to the processing result of the data processing module by using a training qualified model by adopting a PyTorch frame and a cyclic neural network, and judging whether the data of the power equipment and the use data of the power resource are consistent with the account data or not according to the data of the power equipment and the use data of the power resource and the account data, and separating out problem data;

database: storing training data of the model;

and a grouping module: and the problem data are picked out, and are grouped according to different units in the power department, so that responsibility is conveniently divided.

Preferably, the data sharing module includes:

a wireless transmission unit: transmitting the collected data and analysis and judgment results to other power departments for storage, and receiving the data transmitted by the other power departments;

and a data security module: the stored data is checked periodically to ensure consistency of the data in the power sector storing the same data.

Preferably, the data security module includes:

random decimation unit: randomly decimating a part of data in the power departments storing the same data and transmitting the data to other power departments;

data comparison unit: comparing the decimated data with locally stored data, and detecting whether the data are consistent;

an early warning unit: the inconsistent data gives an alarm to remind the staff to verify the problem.

Preferably, the management module includes:

a login personnel management module: checking identity record of the login personnel and recording the operation flow of the login personnel;

and a data management module: storing the collected data, analysis results and data transmitted by other power departments;

and the control management module: and the data acquisition module, the data storage module, the data processing module, the data transmission module, the data analysis module and the data sharing module are controlled and managed.

Preferably, the auditing method of the power grid data auditing system comprises the following steps:

s1, managing login personnel through a management module, recording the operation flow of the login personnel, and adjusting parameters of a data acquisition module, a data storage module, a data processing module, a data transmission module, a data analysis module and a data sharing module;

s2, acquiring data of the power equipment, use data of the power resources and account data through a data acquisition module, conveniently transmitting the acquired data to a storage module, classifying the received data according to region division, equipment data, power data and account data through the data storage module, storing for a limited period, and deleting data exceeding a storage period;

s3, setting the maximum difference between the data processed at this time and the data processed before through a data processing module, judging the data to be abnormal if the data processed at this time exceeds the maximum difference, comparing the data of the power equipment collected at this time and the use data of the power resource collected at the last time with the use data of the power equipment collected at the time of auditing through 3 groups of data processing modules to obtain a difference value, comparing the obtained difference value with the set maximum difference value, transmitting the processing result of the data processing modules and the collected data to a management module through a data transmission module by using a power transmission line, and reducing the occurrence of a data loss condition because the data sent by 3 groups of data processing modules are the same;

s4, setting the maximum difference value of 3 groups of data through a data analysis module, analyzing and judging the accuracy of the acquired data according to the difference value and the comparison result obtained by the 3 groups of data processing modules for processing the same data, judging the data to be accurate if the difference value of 3 groups of data meets the requirements or two groups of data in 3 groups of data meet the requirements, or judging the data to be abnormal if the two groups of data in 3 groups of data exceed the maximum difference value, analyzing and processing the accurate data, comparing the data of the power equipment and the use data of the power resource with the account data, and judging whether the data of the power equipment and the use data of the power resource are consistent with the account data;

s5, transmitting the acquired data and analysis and judgment results to other power departments for storage through a data sharing module, wherein all power department related management personnel storing the same data are required to agree on the stored data for modification, and meanwhile, the stored data are checked regularly to ensure the consistency of the data in the power departments storing the same data;

and S6, storing the data sent by the data transmission module, the analysis result of the data analysis module and the data transmitted by other power departments through the management module.

Compared with the prior art, the invention has the beneficial effects that:

1. the data processing speed is improved in a distributed data processing mode, and the processing result of the same data is analyzed in a redundant data processing mode, so that the accuracy of the data is ensured;

2. the data is transmitted in a redundancy way through the power transmission line, so that the occurrence of data loss is reduced, and the data is transmitted through the power transmission line by adopting a PLC-IoT communication mode, so that the cost of data transmission is reduced;

3. the data is subjected to a decentralization storage mode, and periodic comparison detection is carried out, so that the occurrence of malicious tampering of the data is reduced.

Drawings

FIG. 1 is a schematic diagram of a system for auditing and processing grid data according to the present invention;

FIG. 2 is a schematic diagram of a data acquisition module according to the present invention;

FIG. 3 is a schematic diagram of a data storage module according to the present invention;

FIG. 4 is a schematic diagram of the structure of the data processing module of the present invention;

fig. 5 is a schematic structural diagram of a data transmission module according to the present invention;

fig. 6 is a schematic diagram of a data transmission module according to the present invention;

FIG. 7 is a schematic diagram of a data analysis module according to the present invention;

FIG. 8 is a schematic diagram of a data sharing module according to the present invention;

fig. 9 is a schematic structural view of the management module of the present invention.

Detailed Description

In order that the invention may be readily understood, a more complete description of the invention will be rendered by reference to the appended drawings. This invention may be embodied in many different forms and is not limited to the embodiments described herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete.

Examples

As shown in fig. 1 to 9, comprising:

and a data acquisition module: the data of the power equipment, the use data of the power resources and the account data are collected, and the collected data are conveniently transmitted to the storage module;

and the data storage module is used for: classifying the received data according to region division, equipment data, power data and account data, storing for a limited period, and deleting data exceeding the storage period;

and a data processing module: setting the maximum difference between the data processed at this time and the data processed before, judging the data to be abnormal if the data processed at this time exceeds the maximum difference, comparing the data of the power equipment and the use data of the power resources acquired at this time by the 3-group data acquisition module with the use data of the power equipment and the use data of the power resources acquired at the time of the last audit through the 3-group data processing module to obtain a difference, and comparing the obtained difference with the set maximum difference;

and a data transmission module: the processing result of the data processing module and the acquired data are transmitted to the management module by using a power transmission line, and the data sent by the 3 groups of data processing modules are the same, so that the occurrence of data loss is reduced;

and a data analysis module: setting the maximum difference value of 3 groups of data, analyzing and judging the accuracy of the acquired data according to the difference value and the comparison result obtained by the 3 groups of data processing modules for processing the same data, judging the data to be accurate if the difference value of the 3 groups of data meets the requirements or the two groups of data in the 3 groups of data meet the requirements, or judging the data to be abnormal if the two groups of data in the 3 groups of data exceed the maximum difference value, analyzing and processing the accurate data, comparing the data of the power equipment and the use data of the power resource with the account data, and judging whether the data of the power equipment and the use data of the power resource are consistent with the account data or not;

and a data sharing module: transmitting the collected data and analysis judgment results to other power departments for storage, and changing the stored data requires that all power department related management personnel storing the same data agree, and meanwhile, periodically checking the stored data to ensure the consistency of the data in the power departments storing the same data;

and a management module: managing the login personnel, recording the operation flow of the login personnel, storing the data sent by the data transmission module, the analysis result of the data analysis module and the data transmitted by other power departments, and controlling and managing the data acquisition module, the data storage module, the data processing module, the data transmission module, the data analysis module and the data sharing module;

the data acquisition module comprises:

the power equipment data acquisition module: collecting the running condition, maintenance condition and running time of the power equipment;

the power resource data acquisition module: collecting generated energy, electric power distribution conditions and user electric power use conditions;

financial account data acquisition module: acquiring daily records of power equipment data and power resource data;

the data storage module includes:

classification unit: classifying the received data according to the classification of the region, the equipment data, the power data and the account data;

and a storage unit: the classified data are stored regularly;

cleaning unit: deleting data exceeding the storage period;

the data processing unit:

threshold setting unit: taking 20% of the values acquired during the last audit as the maximum difference value, and then calculating the accurate value of the maximum difference value;

comparison unit: comparing the current data with the last data to obtain a difference value, and comparing the difference value with a maximum difference value to judge whether the difference value is abnormal data or not;

the data transmission module comprises:

a conversion unit: converting the data of the non-digital signals into digital signals;

a transmission unit: transmitting data in a power transmission line by adopting a PLC-IoT communication mode;

the data analysis module comprises:

deep learning processor: judging the accuracy of the data according to the processing result of the data processing module by using a training qualified model by adopting a PyTorch frame and a cyclic neural network, and judging whether the data of the power equipment and the use data of the power resource are consistent with the account data or not according to the data of the power equipment and the use data of the power resource and the account data, and separating out problem data;

database: storing training data of the model;

and a grouping module: the problem data are picked out, and the problem data are grouped according to different units in the electric power department, so that responsibility is conveniently divided;

the data sharing module includes:

a wireless transmission unit: transmitting the collected data and analysis and judgment results to other power departments for storage, and receiving the data transmitted by the other power departments;

and a data security module: periodically checking the stored data to ensure the consistency of the data in the power departments storing the same data;

the data security module includes:

random decimation unit: randomly decimating a part of data in the power departments storing the same data and transmitting the data to other power departments;

data comparison unit: comparing the decimated data with locally stored data, and detecting whether the data are consistent;

an early warning unit: sending out an alarm when the data are inconsistent, and reminding a worker to verify the problem;

the management module comprises:

a login personnel management module: checking identity record of the login personnel and recording the operation flow of the login personnel;

and a data management module: storing the collected data, analysis results and data transmitted by other power departments;

and the control management module: and the data acquisition module, the data storage module, the data processing module, the data transmission module, the data analysis module and the data sharing module are controlled and managed.

Those skilled in the art will readily recognize that such operations are performed in accordance with the accompanying instructions and without undue burden from those skilled in the art.

All technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this invention belongs. The terminology used herein in the description of the invention is for the purpose of describing particular embodiments only and is not intended to be limiting of the invention. The term "and/or" as used herein includes any and all combinations of one or more of the associated listed items.

The foregoing is merely a preferred embodiment of the present invention, and it should be noted that it will be apparent to those skilled in the art that modifications and variations can be made without departing from the technical principles of the present invention, and these modifications and variations should also be regarded as the scope of the invention.

Claims (10)

1. A grid data audit processing system, comprising:

and a data acquisition module: the data of the power equipment, the use data of the power resources and the account data are collected, and the collected data are conveniently transmitted to the storage module;

and the data storage module is used for: classifying the received data according to region division, equipment data, power data and account data, storing for a limited period, and deleting data exceeding the storage period;

and a data processing module: setting the maximum difference between the data processed at this time and the data processed before, judging the data to be abnormal if the data processed at this time exceeds the maximum difference, comparing the data of the power equipment and the use data of the power resources acquired at this time by the 3-group data acquisition module with the use data of the power equipment and the use data of the power resources acquired at the time of the last audit through the 3-group data processing module to obtain a difference, and comparing the obtained difference with the set maximum difference;

and a data transmission module: the processing result of the data processing module and the acquired data are transmitted to the management module by using a power transmission line, and the data sent by the 3 groups of data processing modules are the same, so that the occurrence of data loss is reduced;

and a data analysis module: setting the maximum difference value of 3 groups of data, analyzing and judging the accuracy of the acquired data according to the difference value and the comparison result obtained by the 3 groups of data processing modules for processing the same data, judging the data to be accurate if the difference value of the 3 groups of data meets the requirements or the two groups of data in the 3 groups of data meet the requirements, or judging the data to be abnormal if the two groups of data in the 3 groups of data exceed the maximum difference value, analyzing and processing the accurate data, comparing the data of the power equipment and the use data of the power resource with the account data, and judging whether the data of the power equipment and the use data of the power resource are consistent with the account data or not;

and a data sharing module: transmitting the collected data and analysis judgment results to other power departments for storage, and changing the stored data requires that all power department related management personnel storing the same data agree, and meanwhile, periodically checking the stored data to ensure the consistency of the data in the power departments storing the same data;

and a management module: and managing the login personnel, recording the operation flow of the login personnel, storing the data sent by the data transmission module, the analysis result of the data analysis module and the data transmitted by other power departments, and controlling and managing the data acquisition module, the data storage module, the data processing module, the data transmission module, the data analysis module and the data sharing module.

2. A grid data auditing processing system as defined in claim 1, wherein said data acquisition module comprises:

the power equipment data acquisition module: collecting the running condition, maintenance condition and running time of the power equipment;

the power resource data acquisition module: collecting generated energy, electric power distribution conditions and user electric power use conditions;

financial account data acquisition module: daily records of power equipment data and power resource data are collected.

3. A grid data auditing processing system as defined in claim 1, wherein said data storage module comprises:

classification unit: classifying the received data according to the classification of the region, the equipment data, the power data and the account data;

and a storage unit: the classified data are stored regularly;

cleaning unit: data that exceeds the shelf life is deleted.

4. A grid data auditing processing system as defined in claim 1, wherein said data processing unit:

threshold setting unit: taking 20% of the values acquired during the last audit as the maximum difference value, and then calculating the accurate value of the maximum difference value;

comparison unit: and comparing the current data with the last data to obtain a difference value, and comparing the difference value with a maximum difference value to judge whether the difference value is abnormal data or not.

5. A grid data auditing processing system as defined in claim 1, wherein said data transmission module comprises:

a conversion unit: converting the data of the non-digital signals into digital signals;

a transmission unit: the data is transmitted in the power transmission line by adopting a communication mode of PLC-IoT.

6. A grid data auditing processing system as defined in claim 1, wherein said data analysis module comprises:

deep learning processor: judging the accuracy of the data according to the processing result of the data processing module by using a training qualified model by adopting a PyTorch frame and a cyclic neural network, and judging whether the data of the power equipment and the use data of the power resource are consistent with the account data or not according to the data of the power equipment and the use data of the power resource and the account data, and separating out problem data;

database: storing training data of the model;

and a grouping module: and the problem data are picked out, and are grouped according to different units in the power department, so that responsibility is conveniently divided.

7. A grid data auditing processing system as defined in claim 1, wherein said data sharing module comprises:

a wireless transmission unit: transmitting the collected data and analysis and judgment results to other power departments for storage, and receiving the data transmitted by the other power departments;

and a data security module: the stored data is checked periodically to ensure consistency of the data in the power sector storing the same data.

8. A grid data auditing processing system as defined in claim 7, wherein said data security module comprises:

random decimation unit: randomly decimating a part of data in the power departments storing the same data and transmitting the data to other power departments;

data comparison unit: comparing the decimated data with locally stored data, and detecting whether the data are consistent;

an early warning unit: the inconsistent data gives an alarm to remind the staff to verify the problem.

9. A grid data auditing processing system as defined in claim 1, wherein said management module comprises:

a login personnel management module: checking identity record of the login personnel and recording the operation flow of the login personnel;

and a data management module: storing the collected data, analysis results and data transmitted by other power departments;

and the control management module: and the data acquisition module, the data storage module, the data processing module, the data transmission module, the data analysis module and the data sharing module are controlled and managed.

10. An audit processing method for a grid data audit processing system according to any of claims 1 to 9 including the steps of:

s1, managing login personnel through a management module, recording the operation flow of the login personnel, and adjusting parameters of a data acquisition module, a data storage module, a data processing module, a data transmission module, a data analysis module and a data sharing module;

s2, acquiring data of the power equipment, use data of the power resources and account data through a data acquisition module, conveniently transmitting the acquired data to a storage module, classifying the received data according to region division, equipment data, power data and account data through the data storage module, storing for a limited period, and deleting data exceeding a storage period;

s3, setting the maximum difference between the data processed at this time and the data processed before through a data processing module, judging the data to be abnormal if the data processed at this time exceeds the maximum difference, comparing the data of the power equipment collected at this time and the use data of the power resource collected at the last time with the use data of the power equipment collected at the time of auditing through 3 groups of data processing modules to obtain a difference value, comparing the obtained difference value with the set maximum difference value, transmitting the processing result of the data processing modules and the collected data to a management module through a data transmission module by using a power transmission line, and reducing the occurrence of a data loss condition because the data sent by 3 groups of data processing modules are the same;

s4, setting the maximum difference value of 3 groups of data through a data analysis module, analyzing and judging the accuracy of the acquired data according to the difference value and the comparison result obtained by the 3 groups of data processing modules for processing the same data, judging the data to be accurate if the difference value of 3 groups of data meets the requirements or two groups of data in 3 groups of data meet the requirements, or judging the data to be abnormal if the two groups of data in 3 groups of data exceed the maximum difference value, analyzing and processing the accurate data, comparing the data of the power equipment and the use data of the power resource with the account data, and judging whether the data of the power equipment and the use data of the power resource are consistent with the account data;

s5, transmitting the acquired data and analysis and judgment results to other power departments for storage through a data sharing module, wherein all power department related management personnel storing the same data are required to agree on the stored data for modification, and meanwhile, the stored data are checked regularly to ensure the consistency of the data in the power departments storing the same data;

and S6, storing the data sent by the data transmission module, the analysis result of the data analysis module and the data transmitted by other power departments through the management module.