A method and system for verifying repeated electricity fee deduction based on data analysis

Abstract

The present invention discloses a method and system for verifying repeated electricity bill deduction based on data analysis, which relates to the field of power information big data processing. The method includes: generating a unique identification code according to the processed data, verifying the identification code through idempotency verification; if the identification code is verified and the deduction operation is processed, then the electricity bill corresponding to the identification code is no longer operated; if the identification code is verified and the deduction operation is not processed, then the electricity bill corresponding to the identification code is cancelled and marked as processed; based on the proportion of lost data volume of electricity bill deduction data, the verification accuracy of repeated electricity bill deduction is determined; if the verification accuracy does not meet the requirements, the transmission frequency of electricity bill deduction data is adjusted; if the stability of the idempotency verification does not meet the requirements, the batch processing data volume of electricity bill deduction data is adjusted. The present invention improves the verification accuracy of repeated electricity bill deduction.

Description

Technical Field

[0001] The present invention relates to the technical field of power information big data processing, and in particular to a method and system for verifying repeated electricity fee deductions based on data analysis. Background Art

[0002] Currently, in the electricity bill collection cooperation between banks and power supply companies, repeated deductions and cancellations may occur due to system errors or operational errors. Therefore, it is necessary to introduce an idempotence verification method to verify before canceling the electricity bill to determine whether it has been processed to avoid repeated deductions on the electricity bill.

[0003] In the prior art, based on big data processing technology, a verification model is constructed to determine whether the electricity bill has been processed for bill problems caused by system errors or operational errors. However, this type of model has some shortcomings. For example, the reliability and accuracy of bill judgment need to be improved.

[0004] Chinese Patent Publication No.: CN113743894A discloses a method and system for establishing a review rule model for reviewing electricity bills, comprising the following steps: Step S1, obtaining an electricity bill of an electricity user, and calculating the electricity bill of the electricity user through a preset calculation rule to obtain corresponding abnormal distribution data, calculation data and reversal and refund data; Step S2, identifying the exemption accounting items in the preset calculation rule corresponding to the abnormal distribution data; Step S3, obtaining the expected effect data corresponding to the preset calculation rule, verifying the calculation data with the expected effect data, and determining whether each accounting item in the calculation data meets the expected effect according to the verification result, and obtaining the verification data of the accounting item; Step S4, obtaining the accounting item data triggered in the electricity bill calculation process according to the reversal and refund data, and obtaining the user file and metering file called in the electricity bill calculation process; Step S5, inputting the exemption condition item, the accounting item data, the user file, the billing file and the verification data of the accounting item as input items into the preset intelligent review rule engine model to obtain the review rule model. It can be seen that the method and system for establishing the review rule model for electricity bill review have technical problems such as electromagnetic interference during the transmission of electricity bill deduction data, which causes some data packets to be lost, resulting in inaccurate idempotence verification and data analysis, thereby causing a decrease in the verification accuracy of repeated electricity bill deductions. Summary of the invention

[0005] To this end, the present invention provides a method and system for verifying duplicate electricity bill deductions based on data analysis, so as to overcome the problem in the prior art that part of the data packets are lost due to electromagnetic interference during the transmission of the electricity bill deduction data, resulting in inaccurate idempotence verification and data analysis, thereby causing a decrease in the verification accuracy of duplicate electricity bill deductions.

[0006] To achieve the above objectives, on the one hand, the present invention provides a method for verifying repeated electricity fee deductions based on data analysis, comprising:

[0007] The collected electricity bill deduction data is cleaned, converted and feature extracted in sequence to output processed data, a unique identification code is generated according to the processed data, and the identification code is verified through idempotence check; if the identification code is verified and it is shown that the deduction operation has been processed, the electricity bill corresponding to the identification code is no longer operated; if the identification code is verified and it is shown that the deduction operation has not been processed, the electricity bill corresponding to the identification code is cancelled and marked as processed; the amount of lost data of the electricity bill deduction data and the total amount of data of the electricity bill deduction data are obtained respectively; the verification accuracy of repeated electricity bill deduction is determined based on the proportion of lost data of the electricity bill deduction data; if the verification accuracy does not meet the requirements, the transmission frequency of the electricity bill deduction data is adjusted or the stability of the idempotence check is determined based on the proportion of lost data of the electricity bill deduction data and the similarity of identification codes generated at different times for the same electricity bill deduction data; if the stability of the idempotence check does not meet the requirements, the batch processing data volume of the electricity bill deduction data is adjusted or the backup period of the electricity bill deduction data is adjusted based on the pass rate of the identification code verification.

[0008] Further, determining the accuracy of the verification of the repeated deduction of the electricity fee includes:

[0009] The amount of lost data of the electricity fee withholding data and the total amount of data of the electricity fee withholding data are obtained respectively, and the proportion of the amount of lost data of the electricity fee withholding data is calculated;

[0010] Compare the percentage of lost data of the electricity fee deduction data with a preset first percentage;

[0011] If the proportion of lost data in the electricity fee deduction data is greater than the preset first proportion, it is determined that the verification accuracy of the repeated electricity fee deduction does not meet the requirements.

[0012] Furthermore, the transmission frequency of the electricity fee deduction data is adjusted, including:

[0013] Comparing the percentage of lost data of the electricity fee deduction data with a preset second percentage;

[0014] If the proportion of lost data in the electricity fee deduction data is greater than the preset second proportion, the transmission frequency of the electricity fee deduction data is reduced.

[0015] Further, determining the stability of the idempotence check includes:

[0016] Compare the percentage of lost data of the electricity fee deduction data with the preset first percentage and the preset second percentage respectively;

[0017] If the proportion of lost data in the electricity bill deduction data is greater than the preset first proportion and less than or equal to the preset second proportion, it is preliminarily determined that the stability of the idempotence check does not meet the requirements, and a secondary determination is made on whether the stability of the idempotence check meets the requirements based on the similarity of the identification codes generated at different times for the same electricity bill deduction data.

[0018] Furthermore, the reduction range of the transmission frequency of the electricity fee deduction data is determined by the difference between the proportion of lost data volume of the electricity fee deduction data and a preset second proportion.

[0019] Furthermore, the amount of batch processing data of the electricity fee deduction data is adjusted, including:

[0020] Obtain identification codes generated at different times for the same electricity fee withholding data respectively, and calculate the similarity of the identification codes generated at different times for the same electricity fee withholding data;

[0021] Comparing the similarities of the identification codes generated at different times for the same electricity fee deduction data with a preset first similarity and a preset second similarity respectively;

[0022] If the similarity of the identification codes generated at different times by the same electricity fee deduction data is less than the preset second similarity, the stability of the secondary determination idempotence check does not meet the requirements;

[0023] If the similarity of the identification codes generated at different times by the same electricity fee deduction data is less than the preset first similarity, increasing the batch processing data volume of the electricity fee deduction data;

[0024] If the similarity of the identification codes generated at different times for the same electricity bill deduction data is greater than or equal to the preset first similarity and less than the preset second similarity, it is preliminarily determined that the verification validity of the identification code does not meet the requirements, and a secondary determination is made on whether the verification validity of the identification code meets the requirements based on the pass rate of the identification code verification.

[0025] Furthermore, the increase range of the batch processing data volume of the electricity fee deduction data is determined according to the difference between a preset first similarity and the similarity of identification codes generated at different times for the same electricity fee deduction data.

[0026] Furthermore, the backup period of the electricity fee deduction data is adjusted, including:

[0027] Obtain the number of identification codes that have passed verification and the total number of identification codes respectively, and calculate the pass rate of the identification code verification;

[0028] Comparing the pass rate of the identification code verification with a preset pass rate;

[0029] If the pass rate of the identification code verification is lower than the preset pass rate, it is determined that the verification validity of the identification code does not meet the requirements for the second time, and the backup period of the electricity fee deduction data is increased.

[0030] Furthermore, the increase range of the backup period of the electricity fee deduction data is determined according to the difference between a preset pass rate and a pass rate of the identification code verification.

[0031] On the other hand, the present invention also provides a system for verifying repeated electricity fee deductions based on data analysis, comprising:

[0032] Data collection module, data processing module, identification code generation module, verification module and adjustment module;

[0033] The data collection module is used to collect electricity fee deduction data;

[0034] The data processing module is connected to the data acquisition module and is used to sequentially clean, convert and extract features of the collected electricity fee deduction data to output processed data;

[0035] The identification code generation module is connected to the data processing module and is used to generate a unique identification code according to the processed data;

[0036] The verification module is connected to the identification code generation module, and verifies the identification code through idempotence check, and processes the electricity bill accordingly according to the display result after the identification code passes the verification;

[0037] The adjustment module is respectively connected to the data acquisition module, the data processing module, the identification code generation module and the verification module, and is used to determine the verification accuracy of repeated electricity bill deduction based on the proportion of lost data in the electricity bill deduction data. If the verification accuracy does not meet the requirements, the transmission frequency of the electricity bill deduction data is adjusted or the stability of the idempotence check is determined based on the proportion of lost data in the electricity bill deduction data and the similarity of identification codes generated at different times for the same electricity bill deduction data; if the stability of the idempotence check does not meet the requirements, the batch processing data volume of the electricity bill deduction data is adjusted or the backup period of the electricity bill deduction data is adjusted based on the pass rate of the identification code verification.

[0038] Compared with the prior art, the beneficial effect of the present invention lies in that the method of the present invention adjusts the transmission frequency of the electricity bill withholding data according to the proportion of lost data in the electricity bill withholding data. Since some data packets are lost due to radio wave interference or electromagnetic interference in the process of transmitting the electricity bill withholding data to the data processing location, the data is incomplete, which leads to inaccuracy in idempotence verification and data analysis. By reducing the transmission frequency of the electricity bill withholding data, the amount of data transmitted in each time period is reduced, and the probability of data packet loss is reduced. The batch processing data volume of the electricity bill withholding data is adjusted according to the similarity of the identification codes generated at different times for the same electricity bill withholding data. Since rounding errors may occur when performing floating-point operations in the process of processing the electricity bill withholding data, This situation causes the data precision to be lost, resulting in inaccurate data conversion results, which in turn leads to inconsistent data formats, which in turn leads to problems in the generation of identification codes. By increasing the amount of batch processing data for electricity bill deduction data, the impact of each data point on the overall result is reduced, thereby reducing the impact of rounding errors on the overall result. By adjusting the backup period of electricity bill deduction data according to the pass rate of identification code verification, the system may be attacked by network viruses during operation, resulting in tampering of electricity bill deduction data, which in turn leads to verification failure or abnormality when verifying the identification code. By increasing the backup period of electricity bill deduction data, the frequency of backup data is reduced, the possibility of data tampering is reduced, and the accuracy of verification of repeated electricity bill deductions is improved.

[0039] Furthermore, the method of the present invention adjusts the transmission frequency of the electricity bill deduction data by setting a preset first ratio and a preset second ratio. Since some data packets are lost due to radio wave interference or electromagnetic interference in the process of transmitting the electricity bill deduction data to the data processing location, the data is incomplete, which leads to inaccurate idempotence verification and data analysis. By reducing the transmission frequency of the electricity bill deduction data, the amount of data transmitted in each time period is reduced, the probability of data packet loss is reduced, and the accuracy of verification of repeated electricity bill deductions is further improved.

[0040] Furthermore, the method of the present invention adjusts the batch processing data volume of the electricity bill withholding data by setting a preset first similarity and a preset second similarity. Since rounding errors may occur when performing floating-point operations in the process of processing the electricity bill withholding data, resulting in loss of data precision, inaccurate data conversion results, and further inconsistent data formats, which in turn cause problems in the generation of identification codes. By increasing the batch processing data volume of the electricity bill withholding data, the influence of each data point on the overall result is reduced, thereby reducing the influence of rounding errors on the overall result, and further improving the verification accuracy of repeated electricity bill withholding.

[0041] Furthermore, the method of the present invention adjusts the backup period of the electricity bill withholding data by setting a preset pass rate. Since the system may be attacked by network viruses during operation, the electricity bill withholding data may be tampered with, which may lead to verification failure or abnormality when verifying the identification code. By increasing the backup period of the electricity bill withholding data, the frequency of backing up data is reduced, the possibility of data tampering is reduced, and the accuracy of verification of repeated electricity bill withholding is further improved. BRIEF DESCRIPTION OF THE DRAWINGS

[0042] Figure 1 This is an overall flow chart of a method for verifying repeated electricity fee deductions based on data analysis according to an embodiment of the present invention;

[0043] Figure 2 It is a logic flow chart of a method for verifying repeated electricity fee deductions based on data analysis according to an embodiment of the present invention;

[0044] Figure 3 A specific flow chart of a process for adjusting the transmission frequency of electricity fee withholding data in a method for verifying repeated electricity fee withholding based on data analysis according to an embodiment of the present invention;

[0045] Figure 4 The present invention is an overall structural block diagram of a system for verifying repeated electricity fee deductions based on data analysis according to an embodiment of the present invention. DETAILED DESCRIPTION

[0046] In order to make the objects and advantages of the present invention more clearly understood, the present invention is further described below in conjunction with embodiments; it should be understood that the specific embodiments described herein are only used to explain the present invention and are not used to limit the present invention.

[0047] The preferred embodiments of the present invention are described below with reference to the accompanying drawings. It should be understood by those skilled in the art that these embodiments are only used to explain the technical principles of the present invention and are not intended to limit the protection scope of the present invention.

[0048] It should be noted that, in the description of the present invention, terms such as "up", "down", "left", "right", "inside" and "outside" indicating directions or positional relationships are based on the directions or positional relationships shown in the drawings. This is merely for the convenience of description and does not indicate or imply that the device or element must have a specific orientation, be constructed and operated in a specific orientation. Therefore, it cannot be understood as a limitation on the present invention.

[0049] In addition, it should be noted that in the description of the present invention, unless otherwise clearly specified and limited, the terms "installed", "connected", and "connected" should be understood in a broad sense, for example, it can be a fixed connection, a detachable connection, or an integral connection; it can be a mechanical connection or an electrical connection; it can be a direct connection, or it can be indirectly connected through an intermediate medium, or it can be the internal communication of two components. For those skilled in the art, the specific meanings of the above terms in the present invention can be understood according to specific circumstances.

[0050] See also Figure 1 , Figure 2 , Figure 3 as well as Figure 4 As shown, they are respectively an overall flow chart of a method and system for checking repeated electricity charge deductions based on data analysis, a logic flow chart, a specific flow chart of a process for adjusting the transmission frequency of electricity charge deduction data, and an overall structural block diagram. A method for checking repeated electricity charge deductions based on data analysis of the present invention comprises:

[0051] Step S1, sequentially cleaning, converting and feature extracting the collected electricity fee deduction data to output processed data, generating a unique identification code according to the processed data, and verifying the identification code through idempotence check;

[0052] Step S2, if the identification code is verified and it is shown that the deduction operation has been processed, no further operation is performed on the electricity bill corresponding to the identification code;

[0053] Step S3, if the identification code is verified and it is shown that the deduction operation has not been processed, the electricity bill corresponding to the identification code is cancelled and marked as processed;

[0054] Step S4, respectively obtaining the amount of lost data of the electricity fee withholding data and the total amount of data of the electricity fee withholding data;

[0055] Step S5, determining the verification accuracy of repeated electricity charge deduction based on the percentage of lost data in the electricity charge deduction data;

[0056] Step S6, if the verification accuracy does not meet the requirements, the transmission frequency of the electricity fee withholding data is adjusted or the stability of the idempotence verification is determined based on the proportion of lost data of the electricity fee withholding data and the similarity of identification codes generated at different times for the same electricity fee withholding data;

[0057] Step S7: If the stability of the idempotence check does not meet the requirement, the batch processing data volume of the electricity fee deduction data is adjusted or the backup period of the electricity fee deduction data is adjusted based on the pass rate of the identification code verification.

[0058] Specifically, the electricity bill withholding data includes the user's name, electricity bill number, and withholding amount.

[0059] Specifically, the processed data includes bill amount, deduction time, and deduction status.

[0060] Specifically, idempotence checking is to ensure that multiple executions of the same request will not produce additional impacts or side effects through certain verification methods when processing system or service requests. In this verification method, the system will check the unique identifier or specific attributes of the request to determine whether the request has been processed, thereby avoiding repeated processing of the same request.

[0061] In implementation, the method of the present invention adjusts the transmission frequency of the electricity bill withholding data according to the proportion of lost data in the electricity bill withholding data. Since some data packets are lost due to radio wave interference or electromagnetic interference in the process of transmitting the electricity bill withholding data to the data processing location, the data is incomplete, which leads to inaccuracy in idempotence verification and data analysis. By reducing the transmission frequency of the electricity bill withholding data, the amount of data transmitted in each time period is reduced, and the probability of data packet loss is reduced. By adjusting the batch processing data volume of the electricity bill withholding data according to the similarity of identification codes generated at different times for the same electricity bill withholding data, since rounding errors may occur when performing floating-point operations in the process of processing the electricity bill withholding data, This causes the data to be lost in precision, resulting in inaccurate data conversion results, which in turn causes inconsistent data formats, which in turn causes problems in the generation of identification codes. By increasing the amount of batch processing data for electricity bill deduction data, the impact of each data point on the overall result is reduced, thereby reducing the impact of rounding errors on the overall result. By adjusting the backup period of electricity bill deduction data based on the pass rate of identification code verification, the system may be attacked by network viruses during operation, causing the electricity bill deduction data to be tampered with, which in turn causes verification failure or abnormalities when verifying the identification code. By increasing the backup period of electricity bill deduction data, the frequency of backing up data is reduced, the possibility of data tampering is reduced, and the accuracy of verification of repeated electricity bill deductions is improved.

[0062] Specifically, determining the accuracy of the verification of the repeated deduction of the electricity fee includes:

[0063] The amount of lost data of the electricity fee withholding data and the total amount of data of the electricity fee withholding data are obtained respectively, and the proportion of the amount of lost data of the electricity fee withholding data is calculated;

[0064] Compare the percentage of lost data of the electricity fee deduction data with a preset first percentage;

[0065] If the proportion of lost data in the electricity fee deduction data is greater than the preset first proportion, it is determined that the verification accuracy of the repeated electricity fee deduction does not meet the requirements.

[0066] It can be understood that the three intervals corresponding to the preset first proportion Q1 and the preset second proportion Q2 correspond to three situations respectively. The first interval is Q≤Q1, corresponding to the situation where the verification accuracy of repeated electricity bill deduction meets the requirements; the second interval is Q1<Q≤Q2, corresponding to the situation where rounding errors may occur when performing floating-point operations in the process of processing electricity bill deduction data, resulting in loss of data precision, inaccurate data conversion results, and then inconsistent data formats, which leads to problems in the generation of identification codes; the second interval is Q>Q2, corresponding to the situation where radio wave interference or electromagnetic interference causes part of the data packets to be lost in the process of transmitting the electricity bill deduction data to the data processing location, resulting in incomplete data, and inaccurate idempotence verification and data analysis. In practice, the range of Q1 is generally [0.15, 0.25], and the range of Q2 is generally [0.25, 0.35].

[0067] Preferably, the preferred embodiment of the preset first proportion Q1 is 0.2, and the preferred embodiment of the preset second proportion Q2 is 0.3.

[0068] Specifically, the percentage of lost data in electricity bill deduction data is denoted as Q.

[0069] In implementation, the method of the present invention determines the verification accuracy of repeated deductions of electricity bills by setting a preset first ratio and a preset second ratio, thereby reducing the impact of the decreased verification stability of repeated deductions of electricity bills due to inaccurate judgment of the verification accuracy of repeated deductions of electricity bills, and further improving the verification accuracy of repeated deductions of electricity bills.

[0070] Specifically, the calculation formula for the percentage of lost data in the electricity fee deduction data is:

[0071] ,

[0072] Among them, Q is the percentage of lost data of the electricity bill withholding data, T1 is the lost data volume of the electricity bill withholding data, and T2 is the total data volume of the electricity bill withholding data.

[0073] Specifically, the transmission frequency of electricity fee deduction data is adjusted, including:

[0074] Comparing the percentage of lost data of the electricity fee deduction data with a preset second percentage;

[0075] If the proportion of lost data in the electricity fee deduction data is greater than the preset second proportion, the transmission frequency of the electricity fee deduction data is reduced.

[0076] Specifically, determining the stability of the idempotence check includes:

[0077] Compare the percentage of lost data of the electricity fee deduction data with the preset first percentage and the preset second percentage respectively;

[0078] If the proportion of lost data in the electricity bill deduction data is greater than the preset first proportion and less than or equal to the preset second proportion, it is preliminarily determined that the stability of the idempotence check does not meet the requirements, and a secondary determination is made on whether the stability of the idempotence check meets the requirements based on the similarity of the identification codes generated at different times for the same electricity bill deduction data.

[0079] Specifically, the reduction range of the transmission frequency of the electricity fee deduction data is determined by the difference between the proportion of lost data volume of the electricity fee deduction data and a preset second proportion.

[0080] Specifically, the calculation formula for the reduced transmission frequency of electricity fee deduction data is:

[0081] ,

[0082] Among them, V' is the reduced transmission frequency of the electricity bill withholding data, V is the current transmission frequency of the electricity bill withholding data, A is the minimum unit proportion for adjusting the transmission frequency of the electricity bill withholding data, and v is the transmission frequency of the electricity bill withholding data when the proportion of lost data of the electricity bill withholding data is the minimum unit proportion.

[0083] In practice, the value of A is generally 0.35 to 0.45, and preferably, the preferred embodiment of A is 0.4.

[0084] In implementation, the optional range of the value of v is [3min, 5min]. Preferably, when the transmission frequency of the electricity fee deduction data is greater than 4min, incomplete data may be caused. Therefore, the preferred embodiment of v is 4min.

[0085] For example, the electricity bill is verified using the electricity bill repeated deduction verification method based on data analysis, where V = 5min, Q = 0.5, and V' = =3min.

[0086] In implementation, the method of the present invention adjusts the transmission frequency of the electricity bill deduction data by setting a preset first ratio and a preset second ratio. Since some data packets are lost due to radio wave interference or electromagnetic interference in the process of transmitting the electricity bill deduction data to the data processing location, the data is incomplete, which leads to inaccurate idempotence verification and data analysis. By reducing the transmission frequency of the electricity bill deduction data, the amount of data transmitted in each time period is reduced, the probability of data packet loss is reduced, and the accuracy of verification of repeated electricity bill deductions is further improved.

[0087] Specifically, the amount of batch processing of electricity fee deduction data is adjusted, including:

[0088] Obtain identification codes generated at different times for the same electricity fee withholding data respectively, and calculate the similarity of the identification codes generated at different times for the same electricity fee withholding data;

[0089] Comparing the similarities of the identification codes generated at different times for the same electricity fee deduction data with a preset first similarity and a preset second similarity respectively;

[0090] If the similarity of the identification codes generated at different times by the same electricity fee deduction data is less than the preset second similarity, the stability of the secondary determination idempotence check does not meet the requirements;

[0091] If the similarity of the identification codes generated at different times by the same electricity fee deduction data is less than the preset first similarity, increasing the batch processing data volume of the electricity fee deduction data;

[0092] If the similarity of the identification codes generated at different times for the same electricity bill deduction data is greater than or equal to the preset first similarity and less than the preset second similarity, it is preliminarily determined that the verification validity of the identification code does not meet the requirements, and a secondary determination is made on whether the verification validity of the identification code meets the requirements based on the pass rate of the identification code verification.

[0093] It can be understood that the three intervals corresponding to the preset first similarity P1 and the preset second similarity P2 correspond to three situations respectively. The first interval is P<P1, which corresponds to the situation that rounding errors may occur when performing floating-point operations in the process of processing electricity bill deduction data, resulting in loss of data precision, inaccurate data conversion results, and inconsistent data formats, which leads to problems in the generation of identification codes; the second interval is P1≤P<P2, which corresponds to the situation that the system may be attacked by network viruses during operation, resulting in tampering of electricity bill deduction data, and then causing verification failure or abnormality when verifying the identification code; the third interval is P≥P2, which corresponds to the situation that the stability of idempotence verification meets the requirements. In practice, the range of P1 is generally [75%, 85%], and the range of P2 is generally [85%, 95%].

[0094] Preferably, the preferred embodiment of the preset first similarity P1 is 80%, and the preferred embodiment of the preset second similarity P2 is 90%.

[0095] Specifically, the similarity of the identification codes generated at different times for the same electricity fee deduction data is denoted as P.

[0096] In implementation, the method of the present invention performs a secondary judgment on the stability of the idempotence check by setting a preset first similarity and a preset second similarity, thereby reducing the impact of a decrease in the accuracy of the verification of repeated deductions of electricity bills due to inaccurate secondary judgment on the stability of the idempotence check, and further improving the accuracy of the verification of repeated deductions of electricity bills.

[0097] Specifically, the increase range of the batch processing data volume of the electricity fee deduction data is determined according to the difference between the preset first similarity and the similarity of the identification code generated at different times for the same electricity fee deduction data.

[0098] Specifically, the calculation formula for the increased batch processing data volume of electricity fee deduction data is:

[0099] ,

[0100] Among them, H' is the batch processing data volume of the increased electricity bill withholding data, H is the current batch processing data volume of the electricity bill withholding data, B is the minimum unit similarity for adjusting the batch processing data volume of the electricity bill withholding data, and h is the batch processing data volume of the electricity bill withholding data when the similarity of the identification codes generated at different times for the same electricity bill withholding data is the minimum unit similarity.

[0101] In practice, the value of B is generally 45% to 55%, and preferably, the preferred embodiment of B is 50%.

[0102] In implementation, the optional value range of h is [750Byte, 850Byte]. Preferably, when the batch processing data volume of electricity fee deduction data is less than 800Byte, inaccurate data conversion may occur. Therefore, the preferred embodiment of h is 800Byte.

[0103] For example, the electricity bill is verified using the electricity bill duplicate deduction verification method based on data analysis, where H = 700Byte, P = 70%, and H' = =860Byte.

[0104] In implementation, the method of the present invention adjusts the batch processing data volume of the electricity bill deduction data by setting a preset first similarity and a preset second similarity. Since rounding errors may occur when performing floating-point operations in the process of processing the electricity bill deduction data, resulting in loss of data precision, inaccurate data conversion results, and further inconsistent data formats, which leads to problems in the generation of identification codes. By increasing the batch processing data volume of the electricity bill deduction data, the impact of each data point on the overall result is reduced, thereby reducing the impact of rounding errors on the overall result, and further improving the verification accuracy of repeated electricity bill deductions.

[0105] Specifically, the backup period of electricity fee deduction data is adjusted, including:

[0106] Obtain the number of identification codes that have passed verification and the total number of identification codes respectively, and calculate the pass rate of the identification code verification;

[0107] Comparing the pass rate of the identification code verification with a preset pass rate;

[0108] If the pass rate of the identification code verification is lower than the preset pass rate, it is determined that the verification validity of the identification code does not meet the requirements for the second time, and the backup period of the electricity fee deduction data is increased.

[0109] It can be understood that the two intervals corresponding to the preset pass rate Y0 correspond to two situations. The first interval is Y<Y0, which means that the system may be attacked by network viruses during operation, resulting in tampering of the electricity fee deduction data, and then causing verification failure or abnormality when verifying the identification code; the second interval is Y≥Y0, which means that the verification validity of the corresponding identification code meets the requirements. In practice, the range of Y0 is generally [85%, 95%].

[0110] Preferably, the preferred embodiment of the preset pass rate Y0 is 90%.

[0111] Specifically, the pass rate of identification code verification is recorded as Y.

[0112] Specifically, the formula for calculating the pass rate of identification code verification is:

[0113] ,

[0114] Among them, Y is the pass rate of identification code verification, K1 is the number of identification codes that have passed verification, and K2 is the total number of identification codes.

[0115] In implementation, the method of the present invention performs a secondary determination on the verification validity of the identification code by setting a preset pass rate, thereby reducing the impact of a decrease in the verification accuracy of repeated deductions of electricity bills due to inaccurate secondary determination of the verification validity of the identification code, and further improving the verification accuracy of repeated deductions of electricity bills.

[0116] Specifically, the increase range of the backup period of the electricity fee deduction data is determined according to the difference between the preset pass rate and the pass rate of the identification code verification.

[0117] Specifically, the calculation formula for the increased backup period of electricity fee deduction data is:

[0118] ,

[0119] Among them, L' is the increased backup period of electricity bill withholding data, L is the current backup period of electricity bill withholding data, C is the minimum unit pass rate for adjusting the backup period of electricity bill withholding data, and l is the backup period of electricity bill withholding data when the pass rate of identification code verification is the minimum unit pass rate.

[0120] In practice, the value of C is generally 75% to 85%. Preferably, the preferred embodiment of C is 80%.

[0121] In implementation, the optional value range of l is [4h, 6h]. Preferably, when the backup period of electricity fee deduction data is less than 5h, it may cause abnormalities when verifying the identification code. Therefore, the preferred embodiment of l is 5h.

[0122] For example, the electricity bill is verified using the electricity bill repeated deduction verification method based on data analysis, where L=4h, Y=70%, and L'= =5.25h.

[0123] In implementation, the method of the present invention adjusts the backup period of electricity bill withholding data by setting a preset pass rate. Since the system may be attacked by network viruses during operation, the electricity bill withholding data may be tampered with, which may lead to verification failure or abnormality when verifying the identification code. By increasing the backup period of electricity bill withholding data, the frequency of backing up data is reduced, the possibility of data tampering is reduced, and the accuracy of verification of repeated electricity bill withholding is further improved.

[0124] In one embodiment, the present invention further provides a system for verifying repeated electricity fee deductions based on data analysis, comprising:

[0125] Data collection module, data processing module, identification code generation module, verification module and adjustment module;

[0126] The data collection module is used to collect electricity fee deduction data;

[0127] The data processing module is connected to the data acquisition module and is used to sequentially clean, convert and extract features of the collected electricity fee deduction data to output processed data;

[0128] The identification code generation module is connected to the data processing module and is used to generate a unique identification code according to the processed data;

[0129] The verification module is connected to the identification code generation module, and verifies the identification code through idempotence check, and processes the electricity bill accordingly according to the display result after the identification code passes the verification;

[0130] The adjustment module is respectively connected to the data acquisition module, the data processing module, the identification code generation module and the verification module, and is used to determine the verification accuracy of repeated electricity bill deduction based on the proportion of lost data in the electricity bill deduction data. If the verification accuracy does not meet the requirements, the transmission frequency of the electricity bill deduction data is adjusted or the stability of the idempotence check is determined based on the proportion of lost data in the electricity bill deduction data and the similarity of identification codes generated at different times for the same electricity bill deduction data; if the stability of the idempotence check does not meet the requirements, the batch processing data volume of the electricity bill deduction data is adjusted or the backup period of the electricity bill deduction data is adjusted based on the pass rate of the identification code verification.

[0131] So far, the technical solutions of the present invention have been described in conjunction with the preferred embodiments shown in the accompanying drawings. However, it is easy for those skilled in the art to understand that the protection scope of the present invention is obviously not limited to these specific embodiments. Without departing from the principle of the present invention, those skilled in the art can make equivalent changes or substitutions to the relevant technical features, and the technical solutions after these changes or substitutions will fall within the protection scope of the present invention.

Claims

1. A method for verifying repeated electricity fee deductions based on data analysis, characterized in that: The following steps are involved: The collected electricity fee deduction data is cleaned, converted, and feature extracted in sequence to output processed data, a unique identification code is generated according to the processed data, and the identification code is verified through idempotence check; If the identification code is verified and it is shown that the deduction operation has been processed, no further operation will be performed on the electricity bill corresponding to the identification code; If the identification code is verified and the deduction operation is not processed, the electricity bill corresponding to the identification code is cancelled and marked as processed; The amount of lost data and the total amount of electricity fee deduction data are obtained respectively; Determine the accuracy of the verification of repeated electricity bill deductions based on the percentage of lost data in the electricity bill deduction data; If the verification accuracy does not meet the requirements, the transmission frequency of the electricity fee withholding data is adjusted or the stability of the idempotence verification is determined based on the proportion of lost data of the electricity fee withholding data and the similarity of identification codes generated at different times for the same electricity fee withholding data; If the stability of the idempotence check does not meet the requirements, the batch processing data volume of the electricity fee deduction data is adjusted or the backup period of the electricity fee deduction data is adjusted based on the pass rate of the identification code verification; The step of adjusting the batch processing data volume of the electricity fee deduction data includes: Obtain identification codes generated at different times for the same electricity fee withholding data respectively, and calculate the similarity of the identification codes generated at different times for the same electricity fee withholding data; Comparing the similarities of the identification codes generated at different times for the same electricity fee deduction data with a preset first similarity and a preset second similarity respectively; If the similarity of the identification codes generated at different times by the same electricity fee deduction data is less than the preset second similarity, the stability of the secondary determination idempotence check does not meet the requirements; If the similarity of the identification codes generated at different times by the same electricity fee deduction data is less than the preset first similarity, increasing the batch processing data volume of the electricity fee deduction data; If the similarity of the identification codes generated at different times for the same electricity bill deduction data is greater than or equal to the preset first similarity and less than the preset second similarity, it is preliminarily determined that the verification validity of the identification code does not meet the requirements, and a secondary determination is made on whether the verification validity of the identification code meets the requirements based on the pass rate of the identification code verification.

2. The method for verifying repeated electricity fee deductions based on data analysis according to claim 1, characterized in that: Determining the accuracy of the verification of the repeated deduction of the electricity fee includes: The amount of lost data of the electricity fee withholding data and the total amount of data of the electricity fee withholding data are obtained respectively, and the proportion of the amount of lost data of the electricity fee withholding data is calculated; Compare the percentage of lost data of the electricity fee deduction data with a preset first percentage; If the proportion of lost data in the electricity fee deduction data is greater than the preset first proportion, it is determined that the verification accuracy of the repeated electricity fee deduction does not meet the requirements.

3. The method for verifying repeated electricity fee deductions based on data analysis according to claim 2, characterized in that: Adjust the transmission frequency of electricity fee deduction data, including: Comparing the percentage of lost data of the electricity fee deduction data with a preset second percentage; If the proportion of lost data in the electricity fee deduction data is greater than the preset second proportion, the transmission frequency of the electricity fee deduction data is reduced.

4. The method for verifying repeated electricity fee deductions based on data analysis according to claim 3 is characterized in that: Determining the stability of the idempotence check includes: Compare the percentage of lost data of the electricity fee deduction data with the preset first percentage and the preset second percentage respectively; If the proportion of lost data in the electricity bill deduction data is greater than the preset first proportion and less than or equal to the preset second proportion, it is preliminarily determined that the stability of the idempotence check does not meet the requirements, and a secondary determination is made on whether the stability of the idempotence check meets the requirements based on the similarity of the identification codes generated at different times for the same electricity bill deduction data.

5. The method for verifying repeated electricity fee deductions based on data analysis according to claim 3 is characterized in that: The reduction range of the transmission frequency of the electricity fee deduction data is determined by the difference between the proportion of lost data volume of the electricity fee deduction data and a preset second proportion.

6. The method for verifying repeated electricity fee deductions based on data analysis according to claim 1, characterized in that: The increase range of the batch processing data volume of the electricity fee deduction data is determined according to the difference between the preset first similarity and the similarity of the identification code generated at different times for the same electricity fee deduction data.

7. The method for verifying repeated electricity fee deductions based on data analysis according to claim 6, characterized in that: Adjust the backup period of electricity fee deduction data, including: Obtain the number of identification codes that have passed verification and the total number of identification codes respectively, and calculate the pass rate of the identification code verification; Comparing the pass rate of the identification code verification with a preset pass rate; If the pass rate of the identification code verification is lower than the preset pass rate, it is determined that the verification validity of the identification code does not meet the requirements for the second time, and the backup period of the electricity fee deduction data is increased.

8. The method for verifying repeated electricity fee deductions based on data analysis according to claim 7 is characterized in that: The increase range of the backup period of the electricity fee deduction data is determined according to the difference between the preset pass rate and the pass rate of the identification code verification.

9. A system for verifying repeated electricity charge deductions using the method for verifying repeated electricity charge deductions based on data analysis according to any one of claims 1 to 8, characterized in that: include: Data collection module, data processing module, identification code generation module, verification module and adjustment module; The data collection module is used to collect electricity fee deduction data; The data processing module is connected to the data acquisition module and is used to sequentially clean, convert and extract features of the collected electricity fee deduction data to output processed data; The identification code generation module is connected to the data processing module and is used to generate a unique identification code according to the processed data; The verification module is connected to the identification code generation module, and verifies the identification code through idempotence check, and processes the electricity bill accordingly according to the display result after the identification code passes the verification; The adjustment module is respectively connected to the data acquisition module, the data processing module, the identification code generation module and the verification module, and is used to determine the verification accuracy of repeated electricity bill deduction based on the proportion of lost data in the electricity bill deduction data. If the verification accuracy does not meet the requirements, the transmission frequency of the electricity bill deduction data is adjusted or the stability of the idempotence check is determined based on the proportion of lost data in the electricity bill deduction data and the similarity of identification codes generated at different times for the same electricity bill deduction data; if the stability of the idempotence check does not meet the requirements, the batch processing data volume of the electricity bill deduction data is adjusted or the backup period of the electricity bill deduction data is adjusted based on the pass rate of the identification code verification.

Images