An integrated intelligent system and method for electricity bill financial management and reconciliation

Abstract

The present invention discloses an integrated intelligent system and method for electricity bill financial management and reconciliation. Among them, the method includes the following: obtaining the electricity consumption information, cost information, and financial data of the corresponding user from the database based on the account data; verifying the integrity, accuracy, and consistency of the obtained electricity consumption information, cost information, and financial data; calculating the electricity bill payable by the user; comparing the electricity bill payable by the user with the current account balance to determine whether recharge is required; generating a statement according to the comparison result and feeding back the statement to the user; updating the user account balance after the payment is executed; storing the updated user account balance, the moment of balance change, the execution completion moment corresponding to the payment execution completion, and the payment status into the database after the payment is completed. The present invention significantly improves the efficiency of the financial management process by automatically processing the user's electricity consumption information, cost information, and financial data, and calculating the electricity bill and updating the account balance in real time.

Description

Technical Field

[0001] The present invention relates to the technical field of automated processing systems for electricity bill data, and particularly to an integrated intelligent system and method for electricity bill financial management and reconciliation. Background Art

[0002] With the popularization of smart grids and the increasing demand of users for the convenience of electricity bill management, the traditional manual electricity bill calculation and reconciliation methods are difficult to meet the requirements of efficient and accurate financial management. In response to the above problems, systems for financial management and reconciliation have been proposed in the industry. However, the existing systems mostly have problems such as information silos, lagging data processing, and cumbersome reconciliation, resulting in an increase in financial costs and poor user experience. Summary of the Invention

[0003] In view of the technical problems pointed out in the above background art, the object of the present invention is to provide an integrated intelligent system and method for electricity bill financial management and reconciliation.

[0004] To achieve the object of the present invention, the technical solutions provided by the present invention are as follows:

[0005] In the first aspect

[0006] The present application provides an integrated intelligent method for electricity bill financial management and reconciliation, including the following steps:

[0007] Step S1: Receive the account data input by the user, and preliminarily verify whether the account data is legal; if the verification is legal, obtain the electricity consumption information, cost information, and financial data of the corresponding user from the database based on the account data; the financial data includes the current account balance;

[0008] Step S2: Check the integrity, accuracy, and consistency of the obtained electricity consumption information, cost information, and financial data to obtain the verified electricity consumption information, cost information, and financial data;

[0009] Step S3: Based on the verified electricity consumption information, cost information, and financial data, use a preset electricity bill calculation algorithm to calculate the electricity bill payable by the user; compare the electricity bill payable by the user with the current account balance to check whether recharge is required; according to the comparison result, generate a statement and feedback the statement to the user;

[0010] Step S4: After receiving the payment instruction from the user, if recharge is not required, use the current account balance for payment. After subtracting the electricity bill payable by the user, the payment is completed and the user account balance is updated;

[0011] If recharge is needed, call the API of the third-party payment platform to perform the actual recharge operation. After the recharge is successful, update the user account balance according to the recharge amount; use the current account balance for payment. After subtracting the electricity bill payable by the user, when the payment is completed, update the user account balance.

[0012] Step S5: After the payment is completed, store the updated user account balance, the moment of balance change, the execution completion moment corresponding to the payment completion, and the payment status in the database.

[0013] Among them, the statement includes: user account number, name, contact information, user account balance, electricity bill payable by the user, comparison result of the electricity bill payable by the user and the user account balance, amount needed for recharge, date and time of statement generation, information of the person performing the reconciliation operation, and detailed description of any abnormal situation encountered during the reconciliation process.

[0014] Among them, it also includes step S5: Monitor the operation status of data update, specifically including the following:

[0015] Step S5.1: Obtain the moment of balance change of the user account balance in real time;

[0016] Step S5.2: Obtain the execution completion moment corresponding to the user payment completion in real time;

[0017] Step S5.3: Subtract the execution completion moment corresponding to the payment execution from the moment of balance change to obtain the update response duration of the data update corresponding to the user payment;

[0018] Step S5.4: Obtain the update response duration evaluation coefficient according to the update response duration of the data update; among them, the update response duration evaluation coefficient is obtained through the following formula:

[0019] ;

[0020] Among them, Y represents the update response duration evaluation coefficient; n represents the number of data updates with update response duration delay among all data updates; m represents the number of data updates without update response duration delay among all data updates; T yi represents the i th update response duration corresponding to the data update with update response duration delay; T m represents the maximum allowable update response duration preset to meet the data update efficiency requirement; T yj represents the jThe update response duration corresponding to the data update with no update response duration delay in this instance; T gi Indicates the i Time interval between the data update with update response duration delay in this instance and the i +(1)th data update with update response duration delay; k i Indicates the i Time interval between the data update with update response duration delay in this instance and the i +(1)th data update with update response duration delay, and the number of data updates with no update response duration delay generated during this time interval; T z Indicates the overall time length experienced by all updated data;

[0021] Step S5.5: Used to compare the update response duration evaluation coefficient with a preset evaluation coefficient threshold;

[0022] Step S5.6: Used to perform a running evaluation on the data update running state when the update response duration evaluation coefficient exceeds the preset evaluation coefficient threshold.

[0023] Among them, in step S5.6, performing a running evaluation on the data update running state specifically includes the following:

[0024] Step S5.6.1: Extract the historical running data records corresponding to each data update;

[0025] Step S5.6.2: Extract the target running parameters for running evaluation from the historical running data records, where the target running parameters include: the number of transactions processed per unit time, the number of queries per unit time, the concurrent request failure rate, and the CPU utilization rate; and the unit time is 1 s;

[0026] Step S5.6.3: Obtain the first concurrent processing ability evaluation coefficient by using the number of transactions processed per unit time and the number of queries per unit time; among them, the first concurrent processing ability evaluation coefficient is obtained through the following formula:

[0027] ;

[0028] Among them, G 01 Indicates the first concurrent processing ability evaluation coefficient; s Indicates the number of unit times experienced; C 01io Indicates the i o Number of transactions processed per unit time corresponding to the C02io represents the number of unit time queries corresponding to the i o th unit time; c 01 and c 02 represent the first adjustment factor and the second adjustment factor respectively, and the first adjustment factor and the second adjustment factor are obtained through the following formula:

[0029] ;

[0030] ;

[0031] where C 01max and C 02max represent the maximum value of the number of unit time transactions and the maximum value of the number of unit time queries respectively; C 02m represents the quantity of the number of unit time queries corresponding to the maximum value of the number of unit time transactions; C 01m represents the quantity of the number of unit time transactions corresponding to the maximum value of the number of unit time queries;

[0032] Step S5.6.4: Obtain the second concurrent processing ability evaluation coefficient by using the concurrent request failure rate and the CPU utilization rate; where, the second concurrent processing ability evaluation coefficient is obtained through the following formula:

[0033] ;

[0034] where G 02 represents the second concurrent processing ability evaluation coefficient; P 01io represents the i o th concurrent request failure rate corresponding to the unit time; P 02io represents the i o th CPU utilization rate corresponding to the unit time; P 01max and P 02max represent the maximum value of the concurrent request failure rate and the maximum value of the CPU utilization rate respectively; P 02m represents the CPU utilization rate value corresponding to the unit time of the maximum value of the concurrent request failure rate; P 01mThe concurrent request failure rate value corresponding to the unit time representing the maximum value of the CPU utilization rate number;

[0035] Step S5.6.5: Obtain a comprehensive concurrent processing capacity evaluation parameter by using the first concurrent processing capacity evaluation coefficient and the second concurrent processing capacity evaluation coefficient, where the comprehensive concurrent processing capacity evaluation parameter is obtained through the following formula:

[0036] ;

[0037] where G represents the comprehensive concurrent processing capacity evaluation parameter;

[0038] Step S5.6.6: Compare the comprehensive concurrent processing capacity evaluation parameter with a preset evaluation parameter threshold; when the comprehensive concurrent processing capacity evaluation parameter is lower than the preset evaluation parameter threshold, an alarm for abnormal data update is given.

[0039] Second aspect

[0040] The present invention provides an integrated intelligent system for electricity bill financial management and reconciliation, including the following units: a data acquisition unit, a data verification unit, a statement generation unit, a payment unit, and a data storage unit;

[0041] The data acquisition unit is used to receive the account data input by the user and perform a preliminary verification on whether the account data is legal; if the verification is legal, the corresponding user's electricity consumption information, cost information, and financial data are obtained from the database based on the account data; the financial data includes the current account balance;

[0042] The data verification unit is used to perform integrity, accuracy, and consistency verification on the obtained electricity consumption information, cost information, and financial data to obtain the verified electricity consumption information, cost information, and financial data;

[0043] The statement generation unit is used to calculate the electricity bill payable by the user based on the verified electricity consumption information, cost information, and financial data by using a preset electricity bill calculation algorithm; compare the electricity bill payable by the user with the current account balance to check whether recharge is required; generate a statement according to the comparison result and feedback the statement to the user;

[0044] The payment unit is used to, after receiving the user's payment instruction, if recharge is not required, use the current account balance for payment, subtract the electricity bill payable by the user, and after the payment is completed, update the user's account balance; if recharge is required, call the API of the third-party payment platform to perform the actual recharge operation, and after the recharge is successful, update the user's account balance according to the recharge amount; use the current account balance for payment, subtract the electricity bill payable by the user, and after the payment is completed, update the user's account balance;

[0045] The data storage unit is used to store the updated user account balance, the time when the balance changes, the execution completion time corresponding to the completion of payment execution, and the payment status into the database after the payment is completed.

[0046] Among them, the statement includes: user account number, name, contact information, user account balance, electricity bill payable by the user, comparison result of the electricity bill payable by the user and the user account balance, amount to be recharged, date and time when the statement is generated, personnel information for performing the reconciliation operation, and detailed description of any abnormal situation encountered during the reconciliation process.

[0047] Among them, it further includes a status monitoring unit, and the status monitoring unit is used to monitor the operation status of data update, specifically including the following:

[0048] Step S5.1: Obtain the time when the balance of the user account balance changes in real time;

[0049] Step S5.2: Obtain the execution completion time corresponding to the completion of the user payment execution in real time;

[0050] Step S5.3: Subtract the execution completion time corresponding to the completion of the payment from the time when the balance changes to obtain the update response duration of the data update corresponding to the user payment;

[0051] Step S5.4: Obtain an update response duration evaluation coefficient according to the update response duration of the data update; among them, the update response duration evaluation coefficient is obtained through the following formula:

[0052] ;

[0053] Among them, Y represents the update response duration evaluation coefficient; n represents the number of data updates with update response duration delay among all data updates; m represents the number of data updates without update response duration delay among all data updates; T yi represents the i th update response duration corresponding to the data update with update response duration delay; T m represents the maximum allowable update response duration that meets the data update efficiency requirement; T yj represents the j th update response duration corresponding to the data update without update response duration delay; T gi represents the i th data update with update response duration delay and the iThe time interval between data updates with a +1 - time occurrence of a delay in the update response duration; k i Indicates the i th data update with a delay in the update response duration and the i number of data updates without a delay in the update response duration generated during the time interval between the +1 - th data update with a delay in the update response duration; T z Indicates the overall time length experienced by all updated data;

[0054] Step S5.5: Used to compare the update response duration evaluation coefficient with a preset evaluation coefficient threshold;

[0055] Step S5.6: Used to perform a running evaluation on the data update running state when the update response duration evaluation coefficient exceeds the preset evaluation coefficient threshold.

[0056] Among them, in step S5.6, performing a running evaluation on the data update running state specifically includes the following:

[0057] Step S5.6.1: Extract the historical running data records corresponding to each data update;

[0058] Step S5.6.2: Extract the target running parameters for performing the running evaluation from the historical running data records, where the target running parameters include: the number of transactions processed per unit time, the number of queries per unit time, the concurrent request failure rate, and the CPU utilization rate; and the unit time is 1s;

[0059] Step S5.6.3: Obtain the first concurrent processing ability evaluation coefficient using the number of transactions processed per unit time and the number of queries per unit time; among them, the first concurrent processing ability evaluation coefficient is obtained through the following formula:

[0060] ;

[0061] Among them, G 01 represents the first concurrent processing ability evaluation coefficient; s represents the number of unit times experienced; C 01io Indicates the i o th unit - time - corresponding number of transactions processed per unit time; C 02io Indicates the i o th unit - time - corresponding number of queries per unit time; c 01 and c 02respectively represent a first adjustment factor and a second adjustment factor, and the first adjustment factor and the second adjustment factor are obtained by the following formula:

[0062] ;

[0063] ;

[0064] wherein, C 01max and C 02max respectively represent the maximum value of the number of transaction processes per unit time and the maximum value of the number of queries per unit time; C 02m represents the number of unit time queries corresponding to the maximum value of the number of transaction processes per unit time in the unit time; C 01m represents the number of unit time transaction processes corresponding to the maximum value of the number of queries per unit time in the unit time;

[0065] Step S5.6.4: Obtain a second concurrent processing ability evaluation coefficient by using the concurrent request failure rate and the CPU utilization rate; wherein, the second concurrent processing ability evaluation coefficient is obtained by the following formula:

[0066] ;

[0067] wherein, G 02 represents the second concurrent processing ability evaluation coefficient; P 01io represents the i o th unit time corresponding concurrent request failure rate; P 02io represents the i o th unit time corresponding CPU utilization rate; P 01max and P 02max respectively represent the maximum value of the concurrent request failure rate and the maximum value of the CPU utilization rate; P 02m represents the CPU utilization rate value corresponding to the unit time of the maximum value of the concurrent request failure rate; P 01m represents the concurrent request failure rate value corresponding to the unit time of the maximum value of the CPU utilization rate number;

[0068] Step S5.6.5: Obtain a comprehensive concurrent processing ability evaluation parameter by using the first concurrent processing ability evaluation coefficient and the second concurrent processing ability evaluation coefficient, wherein, the comprehensive concurrent processing ability evaluation parameter is obtained by the following formula:

[0069] ;

[0070] Among them, G represents the comprehensive concurrency processing ability evaluation parameter;

[0071] Step S5.6.6: Compare the comprehensive concurrency processing ability evaluation parameter with a preset evaluation parameter threshold; when the comprehensive concurrency processing ability evaluation parameter is lower than the preset evaluation parameter threshold, an alarm for abnormal data update is given.

[0072] Compared with the prior art, the present invention significantly improves the efficiency of the financial management process by automatically processing user electricity consumption information, expense information, and financial data, and calculating electricity bills and updating account balances in real time. Traditional manual or semi-automated methods require a large amount of manpower and time to process this data, while this system can quickly and accurately complete these tasks, reducing human errors and delays; in addition, the automated and integrated system reduces the dependence on human resources, thereby reducing labor costs, and can realize functions such as real-time query, online payment, and automatic reconciliation, improving the financial management efficiency and reducing the financial cost. By comparing the statements, users can timely understand the electricity consumption situation and expense expenditure situation, facilitating reconciliation and adjusting consumption habits, and can process and update data in real time, reducing additional expenditures such as paper documents and mailing costs, further reducing the financial cost, significantly improving the financial management efficiency, reducing the financial cost, enhancing the user experience, promoting the reconciliation accuracy, supporting decision-making analysis, and improving the service quality. Brief Description of the Drawings

[0073] Figure 1 It is a schematic flowchart of the method provided by the embodiment of the present application. Detailed Embodiment

[0074] Next, with reference to the drawings in the embodiments of the present invention, the technical solutions in the embodiments of the present invention are clearly and completely described. Obviously, the described embodiments are only a part of the embodiments of the present invention, rather than all the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those of ordinary skill in the art without creative efforts belong to the scope of protection of the present invention.

[0075] As Figure 1 shown, an integrated intelligent method for electricity bill financial management and reconciliation provided by this embodiment includes the following steps:

[0076] Step S1: Receive the account data input by the user and conduct a preliminary verification on whether the account data is legal; if the verification is legal, obtain the electricity consumption information, fee information, and financial data of the corresponding user from the database based on the account data; the financial data includes the current account balance, historical transaction records, financial statements, etc., and the historical transaction records include the payment time, payment amount, etc.

[0077] It should be noted that the account data includes the user account number, name, contact information, etc.; the electricity consumption information includes the electricity consumption, electricity consumption period, start time of electricity consumption, end time of electricity consumption, electricity consumption peak value, electricity consumption valley value, etc.; the fee information includes the basic electricity fee and the stepped electricity price, etc.

[0078] It should be noted that if the format of the account data input by the user is correct, continue to process and perform the next operation, and the user gets feedback, such as showing "The format is correct, and the account information is being verified...".

[0079] If the format of the account data input by the user is incorrect, the system prompts an error and requires the user to re-enter. The user gets an error prompt, such as showing "The input format is incorrect. Please enter the correct account information.", and after multiple verification failures, trigger the account locking and security warning mechanism to prevent malicious attempts.

[0080] Step S2: Conduct checks on the integrity, accuracy, and consistency of the obtained electricity consumption information, fee information, and financial data to obtain the verified electricity consumption information, fee information, and financial data.

[0081] It should be noted that if the verification is successful and the data is confirmed to be correct, allow the user to perform the next operation, and the user gets feedback, such as showing "The data verification is successful, and the information is being loaded...".

[0082] If the verification fails and it is found that there are integrity, accuracy, or consistency problems with the data, prevent the user from performing the next operation. The user gets an error prompt, such as showing "The data verification fails. Please check your information.", and trigger the audit process to solve the data problem.

[0083] Step S3: Based on the verified electricity consumption information, fee information, and financial data, use a preset electricity fee calculation algorithm to calculate the electricity fee that the user should pay; compare the electricity fee that the user should pay with the current account balance to check whether recharge is needed; according to the comparison result, generate a statement and feedback the statement to the user.

[0084] Step S4: After receiving the user's payment instruction, if recharge is not needed, use the current account balance for payment. After subtracting the electricity fee that the user should pay, the payment is completed, and the user's account balance is updated.

[0085] If recharge is needed, call the API of the third-party payment platform to perform the actual recharge operation. After the recharge is successful, update the user account balance according to the recharge amount; use the current account balance for payment. After subtracting the electricity bill payable by the user, when the payment is completed, update the user account balance.

[0086] Step S5: After the payment is completed, store the updated user account balance, the time of balance change, the execution completion time corresponding to the completion of payment execution, and the payment status in the database.

[0087] Preferably, the statement includes: user account number, name, contact information, user account balance, electricity bill payable by the user, comparison result of the electricity bill payable by the user and the user account balance, amount needed to recharge, date and time of statement generation, information of the person performing the reconciliation operation, and detailed description of any abnormal situation encountered during the reconciliation process.

[0088] It should be noted that the abnormal situations include: the account balance in the database does not match the actual balance; unable to obtain the total amount of electricity bill payable or account balance data; the reconciliation module encounters system errors or failures during execution; the account is locked, frozen, or in other abnormal account states; errors occur during the payment process, such as payment failure, duplicate payment, etc.

[0089] Preferably, it further includes step S5: monitor the running status of data update, specifically including the following:

[0090] Step S5.1: Obtain the time of balance change of the user account balance in real time;

[0091] Step S5.2: Obtain the execution completion time corresponding to the completion of the user payment execution in real time;

[0092] Step S5.3: Subtract the execution completion time corresponding to the completion of the payment execution from the time of balance change to obtain the update response duration of the data update corresponding to the user payment;

[0093] Step S5.4: Obtain the update response duration evaluation coefficient according to the update response duration of the data update; wherein, the update response duration evaluation coefficient is obtained through the following formula:

[0094] ;

[0095] Wherein, Y represents the update response duration evaluation coefficient; n represents the number of data updates with update response duration delay among all data updates; m represents the number of data updates without update response duration delay among all data updates; T yi represents the iThe update response duration corresponding to the data update with a delay in the update response duration for the second occurrence; T m Represents the maximum allowable update response duration preset to meet the data update efficiency requirement; T yj Represents the j Update response duration corresponding to the data update without a delay in the update response duration for the nth time; T gi Represents the i Time interval between the data update with a delay in the update response duration for the nth time and the data update with a delay in the update response duration for the (n + 1)th time; i +1th occurrence of data update with a delay in the update response duration; k i Represents the i Time interval between the data update with a delay in the update response duration for the nth time and the data update with a delay in the update response duration for the (n + 1)th time, and the number of data updates without a delay in the update response duration generated during this time interval; i +1th occurrence of data update with a delay in the update response duration; T z Represents the overall time length experienced by all updated data;

[0096] Step S5.5: Used to compare the update response duration evaluation coefficient with a preset evaluation coefficient threshold;

[0097] Step S5.6: Used to perform a running evaluation on the data update running state when the update response duration evaluation coefficient exceeds the preset evaluation coefficient threshold.

[0098] It should be noted that through the above solution, real-time monitoring of the change in the user account balance and the moment when the payment is executed is achieved, ensuring the timeliness and accuracy of the data. The response duration of the data update corresponding to the user payment can be accurately calculated, providing basic data for evaluating the data update efficiency; the update response duration evaluation coefficient acquisition module calculates a comprehensive evaluation coefficient by comprehensively considering factors such as the update response duration, the number of delays, the number of non-delays, and the time interval. This coefficient can comprehensively reflect the efficiency and quality of the data update. Comparing the calculated update response duration evaluation coefficient with the preset evaluation coefficient threshold realizes intelligent evaluation of the data update efficiency; when the evaluation coefficient exceeds the threshold, further running evaluation of the data update running parameters will be carried out, which helps to discover and solve potential problems in a timely manner and optimize the data update process. Through real-time monitoring, efficiency evaluation, and optimization suggestions, this technical solution can significantly improve the user payment experience and reduce problems caused by data update delays. At the same time, continuous monitoring and evaluation of the data update running parameters also contribute to improving the overall stability and reliability of the system.

[0099] In summary, through means such as real-time monitoring, data update efficiency evaluation, intelligent comparison and evaluation, etc., this technical solution has achieved a comprehensive optimization of user payment data update, improving user experience and system stability.

[0100] Preferably, in step S5.6, a running evaluation is performed on the data update running state, which specifically includes the following:

[0101] Step S5.6.1: Extract the historical running data records corresponding to each data update;

[0102] It should be noted that the historical running data records at least include: user information, the specific time when each data update occurs, the account balance update list, the payment update list, the account balance before and after the update, the payment status, the abnormal situation record, and the data update running state, etc.;

[0103] Step S5.6.2: Extract the target running parameters for running evaluation from the historical running data records, where the target running parameters include: the number of transactions processed per unit time, the number of queries per unit time, the concurrent request failure rate, and the CPU utilization rate; and the unit time is 1s;

[0104] Step S5.6.3: Obtain the first concurrent processing ability evaluation coefficient by using the number of transactions processed per unit time and the number of queries per unit time; where the first concurrent processing ability evaluation coefficient is obtained through the following formula:

[0105] ;

[0106] Where G 01 represents the first concurrent processing ability evaluation coefficient; s represents the number of unit times experienced; C 01io represents the i o th unit time corresponding number of transactions processed per unit time; C 02io represents the i o th unit time corresponding number of queries per unit time; c 01 and c 02 respectively represent the first adjustment factor and the second adjustment factor, and the first adjustment factor and the second adjustment factor are obtained through the following formula:

[0107] ;

[0108] ;

[0109] Among them, C 01max and C 02max respectively represent the maximum value of the number of transactions processed per unit time and the maximum value of the number of queries per unit time; C 02m represents the number of queries per unit time corresponding to the maximum value of the number of transactions processed per unit time; C 01m represents the number of transactions processed per unit time corresponding to the maximum value of the number of queries per unit time;

[0110] Step S5.6.4: Obtain a second concurrent processing ability evaluation coefficient by using the concurrent request failure rate and the CPU utilization rate; among them, the second concurrent processing ability evaluation coefficient is obtained through the following formula:

[0111] ;

[0112] Among them, G 02 represents the second concurrent processing ability evaluation coefficient; P 01io represents the i o concurrent request failure rate corresponding to the nth unit time; P 02io represents the i o CPU utilization rate corresponding to the nth unit time; P 01max and P 02max respectively represent the maximum value of the concurrent request failure rate and the maximum value of the CPU utilization rate; P 02m represents the CPU utilization rate value corresponding to the unit time of the maximum value of the concurrent request failure rate; P 01m represents the concurrent request failure rate value corresponding to the unit time of the maximum value of the CPU utilization rate;

[0113] Step S5.6.5: Obtain a comprehensive concurrent processing ability evaluation parameter by using the first concurrent processing ability evaluation coefficient and the second concurrent processing ability evaluation coefficient, where the comprehensive concurrent processing ability evaluation parameter is obtained through the following formula:

[0114] ;

[0115] Among them, G represents the comprehensive concurrent processing ability evaluation parameter;

[0116] Step S5.6.6: Compare the comprehensive concurrent processing ability evaluation parameter with a preset evaluation parameter threshold; when the comprehensive concurrent processing ability evaluation parameter is lower than the preset evaluation parameter threshold, an alarm for abnormal data update is given.

[0117] It should be noted that by extracting the key parameters (number of transactions processed per unit time, number of queries per unit time, concurrent request failure rate, and CPU utilization rate) from the historical operation data records, this solution can accurately evaluate the concurrent processing ability of the system. When calculating the first concurrent processing ability evaluation coefficient, dynamic adjustment factors (the first adjustment factor and the second adjustment factor) are introduced, and these adjustment factors are dynamically adjusted according to the maximum value and corresponding values of the historical data, making the evaluation coefficient more in line with the actual operation situation and improving the accuracy of the evaluation. It not only considers the number of transaction processing and queries, but also incorporates the concurrent request failure rate and CPU utilization rate, thus comprehensively evaluating the concurrent processing ability of the system from multiple dimensions. By comparing the comprehensive concurrent processing ability evaluation parameter with the preset threshold, real-time monitoring of the system operation status is achieved. Once the comprehensive evaluation parameter is lower than the preset threshold, an abnormal alarm is triggered, which helps to promptly discover and handle potential problems and ensure the stable operation of the system. The provided comprehensive concurrent processing ability evaluation parameter can be used as an important basis for system optimization and decision-making, helping the operation and maintenance team or developers identify performance bottlenecks and guiding the formulation of resource allocation and system optimization strategies.

[0118] In summary, through refined data analysis and multi-dimensional performance evaluation, this technical solution provides strong technical support for the stable operation and continuous optimization of the system.

[0119] In addition, this embodiment also provides an integrated intelligent system for electricity bill financial management and reconciliation, including the following units: a data acquisition unit, a data verification unit, a statement generation unit, a payment unit, and a data storage unit;

[0120] The data acquisition unit is used to receive the account data input by the user and preliminarily verify whether the account data is legal; if the verification is legal, the corresponding user's electricity consumption information, cost information, and financial data are obtained from the database based on the account data; the financial data includes the current account balance;

[0121] The data verification unit is used to verify the integrity, accuracy, and consistency of the obtained electricity consumption information, cost information, and financial data to obtain the verified electricity consumption information, cost information, and financial data;

[0122] The statement generation unit is used to calculate the electricity bill payable by the user based on the verified electricity consumption information, cost information, and financial data by using a preset electricity bill calculation algorithm; compare the electricity bill payable by the user with the current account balance to check whether recharge is required; generate a statement according to the comparison result and feedback the statement to the user;

[0123] The payment unit is used to, after receiving the user's payment instruction, if recharge is not required, use the current account balance for payment. After subtracting the electricity bill payable by the user, the payment is completed and the user's account balance is updated; if recharge is required, call the API of the third-party payment platform to perform the actual recharge operation. After the recharge is successful, update the user's account balance according to the recharge amount; use the current account balance for payment. After subtracting the electricity bill payable by the user, the payment is completed and the user's account balance is updated;

[0124] The data storage unit is used to store the updated user account balance, the balance change time, the execution completion time corresponding to the payment completion, and the payment status into the database after the payment is completed.

[0125] Preferably, the statement includes: user account number, name, contact information, user account balance, electricity bill payable by the user, comparison result of the electricity bill payable by the user and the user account balance, recharge amount required, date and time of statement generation, information of the person performing the reconciliation operation, and detailed description of any abnormal situation encountered during the reconciliation process.

[0126] Preferably, it further includes a status monitoring unit, and the status monitoring unit is used to monitor the data update operation status, specifically including the following:

[0127] Step S5.1: Obtain the balance change time of the user account balance in real time;

[0128] Step S5.2: Obtain the execution completion time corresponding to the user payment completion in real time;

[0129] Step S5.3: Subtract the balance change time from the execution completion time corresponding to the payment completion to obtain the update response duration of the data update corresponding to the user payment;

[0130] Step S5.4: Obtain the update response duration evaluation coefficient according to the update response duration of the data update; wherein, the update response duration evaluation coefficient is obtained through the following formula:

[0131] ;

[0132] Wherein, Y represents the update response duration evaluation coefficient; n represents the number of data updates with update response duration delay among all data updates;m Indicates the number of data updates with a delay in the update response duration among all data updates; T yi Indicates the i update response duration corresponding to the data update with a delay in the update response duration for the T m Indicates the maximum allowable update response duration preset to meet the data update efficiency requirement; T yj Indicates the j update response duration corresponding to the data update without a delay in the update response duration for the T gi Indicates the i time interval between the data update with a delay in the update response duration for the i th time and the data update with a delay in the update response duration for the k i Indicates the i time interval between the data update with a delay in the update response duration for the i th time and the data update with a delay in the update response duration for the T z Indicates the overall time length that all updated data has been running;

[0133] Step S5.5: Used to compare the update response duration evaluation coefficient with a preset evaluation coefficient threshold;

[0134] Step S5.6: Used to perform a running evaluation on the data update running state when the update response duration evaluation coefficient exceeds the preset evaluation coefficient threshold.

[0135] Preferably, in step S5.6, performing a running evaluation on the data update running state specifically includes the following:

[0136] Step S5.6.1: Extract the historical running data records corresponding to each data update;

[0137] Step S5.6.2: Extract the target running parameters for performing the running evaluation from the historical running data records, where the target running parameters include: the number of transactions processed per unit time, the number of queries per unit time, the concurrent request failure rate, and the CPU utilization rate; and the unit time is 1 s;

[0138] Step S5.6.3: Obtain the first concurrent processing ability evaluation coefficient by using the number of transactions processed per unit time and the number of queries per unit time; where the first concurrent processing ability evaluation coefficient is obtained through the following formula:

[0139] ;

[0140] Among them, G 01 represents the first concurrent processing ability evaluation coefficient; s represents the number of unit time experienced; C 01io represents the number of unit time transactions corresponding to the i o th unit time; C 02io represents the number of unit time queries corresponding to the i o th unit time; c 01 and c 02 represent the first adjustment factor and the second adjustment factor respectively, and the first adjustment factor and the second adjustment factor are obtained through the following formula:

[0141] ;

[0142] ;

[0143] Among them, C 01max and C 02max represent the maximum value of the number of unit time transactions and the maximum value of the number of unit time queries respectively; C 02m represents the number of unit time queries corresponding to the maximum value of the number of unit time transactions; C 01m represents the number of unit time transactions corresponding to the maximum value of the number of unit time queries;

[0144] Step S5.6.4: Obtain the second concurrent processing ability evaluation coefficient by using the concurrent request failure rate and the CPU utilization rate; among them, the second concurrent processing ability evaluation coefficient is obtained through the following formula:

[0145] ;

[0146] Among them, G 02 represents the second concurrent processing ability evaluation coefficient; P 01io represents the i o th unit time corresponding concurrent request failure rate; P 02io represents the i oCPU utilization rate corresponding to a unit time; P 01max and P 02max respectively represent the maximum value of the concurrent request failure rate and the maximum value of the CPU utilization rate; P 02m represents the CPU utilization rate value corresponding to the unit time of the maximum value of the concurrent request failure rate; P 01m represents the concurrent request failure rate value corresponding to the unit time of the maximum value of the CPU utilization rate;

[0147] Step S5.6.5: Obtain a comprehensive concurrent processing capacity evaluation parameter by using the first concurrent processing capacity evaluation coefficient and the second concurrent processing capacity evaluation coefficient, where the comprehensive concurrent processing capacity evaluation parameter is obtained by the following formula:

[0148] ;

[0149] where G represents the comprehensive concurrent processing capacity evaluation parameter;

[0150] Step S5.6.6: Compare the comprehensive concurrent processing capacity evaluation parameter with a preset evaluation parameter threshold; when the comprehensive concurrent processing capacity evaluation parameter is lower than the preset evaluation parameter threshold, an alarm for abnormal data update is given.

[0151] Finally, it should be noted that the above embodiments are only used for exemplifying and explaining the present invention, and are not intended to limit the present invention to the scope of the described embodiments. In addition, those skilled in the art can understand that the present invention is not limited to the above embodiments, and more variations and modifications can be made according to the teachings of the present invention, and these variations and modifications all fall within the scope claimed by the present invention.

Claims

1. An intelligent method for integrated electricity fee financial management and reconciliation, characterized in that: The steps include: Step S1: receiving the account data input by the user, and preliminarily verifying whether the account data is legal; if the verification is legal, obtaining the corresponding user's electricity usage information, cost information and financial data from the database based on the account data; the financial data includes the current account balance; Step S2: Verify the integrity, accuracy and consistency of the acquired electricity usage information, cost information and financial data to obtain verified electricity usage information, cost information and financial data; Step S3: Based on the verified electricity usage information, cost information and financial data, the user's electricity fee payable is calculated using a preset electricity fee calculation algorithm; the user's electricity fee payable is compared with the current account balance to determine whether recharge is required; a statement is generated based on the comparison result, and the statement is fed back to the user; Step S4: After receiving the user's payment instruction, if recharging is not required, the current account balance is used for payment, and after deducting the electricity fee payable by the user, the payment is completed and the user's account balance is updated; If recharge is required, the API of the third-party payment platform is called to perform the actual recharge operation. After the recharge is successful, the user account balance is updated according to the recharge amount. The current account balance is used for payment, and after deducting the electricity fee payable by the user, the payment is completed and the user account balance is updated. Step S5: After the payment is completed, the updated user account balance and balance change time, the execution completion time corresponding to the payment execution, and the payment status are stored in the database; The step S5 is also included: monitoring the data update operation status, which specifically includes the following: Step S5.1: Obtain the balance change time of the user account balance in real time; Step S5.2: Obtain the execution completion time corresponding to the user payment completion in real time; Step S5.3: Subtract the execution completion time corresponding to the payment execution from the balance change time to obtain the update response time of the data update corresponding to the user payment; Step S5.4: Obtain an update response time evaluation coefficient according to the update response time of the data update; wherein the update response time evaluation coefficient is obtained by the following formula: Where Y represents the update response time evaluation coefficient; n represents the number of data updates with update response time delay among all data updates; m represents the number of data updates without update response time delay among all data updates; T yi represents the update response time corresponding to the data update with the i-th update response time delay; T m Indicates the preset maximum allowable update response time that meets the data update efficiency requirements; T yj represents the update response time corresponding to the jth data update without update response time delay; T gi k represents the time interval between the data update with the i-th update response time delay and the data update with the i+1-th update response time delay; i represents the number of data updates without update response time delay in the time interval between the i-th data update with update response time delay and the i+1-th data update with update response time delay; T z Indicates the total length of time that all update data has been running; Step S5.5: used to compare the update response time evaluation coefficient with a preset evaluation coefficient threshold; Step S5.6: when the update response time evaluation coefficient exceeds a preset evaluation coefficient threshold, an operation evaluation is performed on the data update operation state; In step S5.6, the data update operation status is evaluated, which specifically includes the following: Step S5.6.1: extract the historical operation data records corresponding to each data update; Step S5.6.2: extracting target operation parameters for operation evaluation from the historical operation data records, wherein the target operation parameters include: number of transactions per unit time, number of queries per unit time, concurrent request failure rate and CPU utilization; and the unit time is 1s; Step S5.6.3: Obtain a first concurrent processing capability evaluation coefficient using the number of transactions processed per unit time and the number of queries per unit time; wherein the first concurrent processing capability evaluation coefficient is obtained by the following formula: Among them, G 01 represents the first concurrent processing capability evaluation coefficient; s represents the number of unit time experienced; C 01io Indicates the i o The number of transactions per unit time corresponding to the unit time; C 02io Indicates the i o The number of queries per unit time corresponding to the unit time; c 01 and c 02 represent the first adjustment factor and the second adjustment factor respectively, and the first adjustment factor and the second adjustment factor are obtained by the following formula: Among them, C 01max and C 02max They represent the maximum number of transactions per unit time and the maximum number of queries per unit time respectively; C 02m The number of queries per unit time corresponding to the maximum number of transactions per unit time; C 01m Indicates the number of transactions per unit time corresponding to the maximum number of queries per unit time; Step S5.6.4: Obtain a second concurrent processing capability evaluation coefficient using the concurrent request failure rate and the CPU utilization rate; wherein the second concurrent processing capability evaluation coefficient is obtained by the following formula: Among them, G 02 Indicates the second concurrent processing capability evaluation coefficient; P 01io Indicates the i o The concurrent request failure rate corresponding to the unit time; P 02io Indicates the i o The CPU utilization rate corresponding to the unit time; P 01max and P 02max They represent the maximum concurrent request failure rate and the maximum CPU utilization respectively; P 02m The CPU utilization value per unit time corresponding to the maximum concurrent request failure rate; P 01m Indicates the concurrent request failure rate per unit time corresponding to the maximum value of CPU utilization; Step S5.6.5: Obtain a comprehensive concurrent processing capability evaluation parameter using the first concurrent processing capability evaluation coefficient and the second concurrent processing capability evaluation coefficient, wherein the comprehensive concurrent processing capability evaluation parameter is obtained by the following formula: Among them, G represents the comprehensive concurrent processing capability evaluation parameter; Step S5.6.6: Compare the comprehensive concurrent processing capability evaluation parameter with a preset evaluation parameter threshold; when the comprehensive concurrent processing capability evaluation parameter is lower than the preset evaluation parameter threshold, a data update abnormality alarm is issued.

2. According to claim 1, an intelligent method for integrated electricity fee financial management and reconciliation is characterized in that: The statement includes: user account, name, contact information, user account balance, electricity bill payable by the user, comparison result of the electricity bill payable by the user and the user account balance, amount required to be recharged, date and time when the statement was generated, information of the person performing the reconciliation operation and detailed description of any abnormal situations encountered during the reconciliation process.

3. An integrated intelligent system for electricity fee financial management and reconciliation, characterized in that: It includes the following units: data acquisition unit, data verification unit, statement generation unit, payment unit, and data storage unit; The data acquisition unit is used to receive the account data input by the user and perform preliminary verification on whether the account data is legal; if the verification is legal, the corresponding user's electricity usage information, cost information and financial data are obtained from the database based on the account data; the financial data includes the current account balance; The data verification unit is used to verify the integrity, accuracy and consistency of the acquired electricity usage information, cost information and financial data to obtain the verified electricity usage information, cost information and financial data; The statement generation unit is used to calculate the electricity fee payable by the user based on the verified electricity usage information, cost information and financial data using a preset electricity fee calculation algorithm; compare the electricity fee payable by the user with the current account balance to check whether recharging is required; generate a statement based on the comparison result, and feed the statement back to the user; The payment unit is used to receive the user's payment instruction, if no recharge is required, use the current account balance to pay, deduct the electricity fee payable by the user, and the payment is completed, and the user's account balance is updated; If recharge is required, the API of the third-party payment platform is called to perform the actual recharge operation. After the recharge is successful, the user account balance is updated according to the recharge amount. The current account balance is used for payment, and after deducting the electricity fee payable by the user, the payment is completed and the user account balance is updated. The data storage unit is used to store the updated user account balance and balance change time, the execution completion time corresponding to the payment execution, and the payment status in the database after the payment is completed; It also includes a status monitoring unit, which is used to monitor the data update operation status, specifically including the following: Step S5.1: Obtain the balance change time of the user account balance in real time; Step S5.2: Obtain the execution completion time corresponding to the user payment completion in real time; Step S5.3: Subtract the execution completion time corresponding to the payment execution from the balance change time to obtain the update response time of the data update corresponding to the user payment; Step S5.4: Obtain an update response time evaluation coefficient according to the update response time of the data update; wherein the update response time evaluation coefficient is obtained by the following formula: Where Y represents the update response time evaluation coefficient; n represents the number of data updates with update response time delay among all data updates; m represents the number of data updates without update response time delay among all data updates; T yi represents the update response time corresponding to the data update with the i-th update response time delay; T m Indicates the preset maximum allowable update response time that meets the data update efficiency requirements; T yj represents the update response time corresponding to the jth data update without update response time delay; T gi k represents the time interval between the data update with the i-th update response time delay and the data update with the i+1-th update response time delay; i represents the number of data updates without update response time delay in the time interval between the i-th data update with update response time delay and the i+1-th data update with update response time delay; T z Indicates the total length of time that all update data has been running; Step S5.5: used to compare the update response time evaluation coefficient with a preset evaluation coefficient threshold; Step S5.6: when the update response time evaluation coefficient exceeds a preset evaluation coefficient threshold, an operation evaluation is performed on the data update operation state; In step S5.6, the data update operation status is evaluated, which specifically includes the following: Step S5.6.1: extract the historical operation data records corresponding to each data update; Step S5.6.2: extracting target operation parameters for operation evaluation from the historical operation data records, wherein the target operation parameters include: number of transactions per unit time, number of queries per unit time, concurrent request failure rate and CPU utilization; and the unit time is 1s; Step S5.6.3: Obtain a first concurrent processing capability evaluation coefficient using the number of transactions processed per unit time and the number of queries per unit time; wherein the first concurrent processing capability evaluation coefficient is obtained by the following formula: Among them, G 01 represents the first concurrent processing capability evaluation coefficient; s represents the number of unit time experienced; C 01io Indicates the i o The number of transactions per unit time corresponding to the unit time; C 02io Indicates the i o The number of queries per unit time corresponding to the unit time; c 01 and c 02 represent the first adjustment factor and the second adjustment factor respectively, and the first adjustment factor and the second adjustment factor are obtained by the following formula: Among them, C 01max and C 02max They represent the maximum number of transactions per unit time and the maximum number of queries per unit time respectively; C 02m The number of queries per unit time corresponding to the maximum number of transactions per unit time; C 01m Indicates the number of transactions per unit time corresponding to the maximum number of queries per unit time; Step S5.6.4: Obtain a second concurrent processing capability evaluation coefficient using the concurrent request failure rate and the CPU utilization rate; wherein the second concurrent processing capability evaluation coefficient is obtained by the following formula: Among them, G 02 Indicates the second concurrent processing capability evaluation coefficient; P 01io Indicates the i o The concurrent request failure rate corresponding to the unit time; P 02io Indicates the i o The CPU utilization rate corresponding to the unit time; P 01max and P 02max They represent the maximum concurrent request failure rate and the maximum CPU utilization respectively; P 02m The CPU utilization value per unit time corresponding to the maximum concurrent request failure rate; P 01m Indicates the concurrent request failure rate per unit time corresponding to the maximum value of CPU utilization; Step S5.6.5: Obtain a comprehensive concurrent processing capability evaluation parameter using the first concurrent processing capability evaluation coefficient and the second concurrent processing capability evaluation coefficient, wherein the comprehensive concurrent processing capability evaluation parameter is obtained by the following formula: Among them, G represents the comprehensive concurrent processing capability evaluation parameter; Step S5.6.6: Compare the comprehensive concurrent processing capability evaluation parameter with a preset evaluation parameter threshold; when the comprehensive concurrent processing capability evaluation parameter is lower than the preset evaluation parameter threshold, a data update abnormality alarm is issued.

4. The intelligent system for integrated electricity fee financial management and reconciliation according to claim 3 is characterized in that: The statement includes: user account, name, contact information, user account balance, electricity bill payable by the user, comparison result of the electricity bill payable by the user and the user account balance, amount required to be recharged, date and time when the statement was generated, information of the person performing the reconciliation operation and detailed description of any abnormal situations encountered during the reconciliation process.

Images