Electricity charge financial management and account checking integrated intelligent system and method

Through the intelligent electricity bill financial management system, the user's electricity consumption information and financial data are automatically processed, and the efficiency and accuracy of traditional electricity bill calculation and reconciliation methods are solved, and the rapid and accurate electricity bill calculation and payment processing are achieved, reducing financial Cost and labor costs improve user experience and system stability.

CN119067795AActive Publication Date: 2024-12-03STATE GRID TIANJIN ELECTRIC POWER COMPANY +1
View PDF 8 Cites 0 Cited by

Patent Information

Application Number
CN202411564019.9
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-11-05
Publication Date
2024-12-03
Estimated Expiration
2044-11-05

AI Technical Summary

Technical Problem

Traditional manual electricity bill calculation and reconciliation methods are difficult to meet the needs of efficient and accurate financial management, and there are problems such as information islands, lagging data processing, and cumbersome reconciliation, resulting in rising financial costs and poor user experience.

Method used

Provide an integrated intelligent system and method for electricity bill financial management and reconciliation. By receiving user account data, preliminary verification, data verification, electricity bill calculation, payment processing and status monitoring are carried out, automated processing and real-time updates are realized, and manual dependence is reduced and Risk of error.

Benefits of technology

It significantly improves the efficiency of the financial management process, reduces human errors and delays, reduces financial costs, improves user experience and reconciliation accuracy, supports decision-making analysis and improves service quality.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN119067795A_ABST
    Figure CN119067795A_ABST
Patent Text Reader

Abstract

The invention discloses an electric charge financial management and account checking integrated intelligent system and method. The method comprises the following steps: acquiring power consumption information, cost information and financial data of a corresponding user from a database based on account data; integrity, accuracy and consistency verification is carried out on the obtained electricity utilization information, the cost information and the financial data; calculating the electric charge paid by the user; comparing the electric charge paid by the user with the current account balance, and comparing whether recharging is needed or not; generating a reconciliation statement according to a comparison result, and feeding back the reconciliation statement to the user; after payment is completed, the balance of the user account is updated; and after payment is completed, the updated user account balance, the balance change moment, the execution completion moment corresponding to payment execution completion and the payment state are stored in a database. According to the invention, by automatically processing the electricity consumption information, the cost information and the financial data of the user, calculating the electric charge and updating the account balance in real time, the efficiency of the financial management process is remarkably improved.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the technical field of automatic processing systems for electricity fee data, and in particular to an intelligent system and method for integrating electricity fee financial management and reconciliation. Background Art

[0002] With the popularization of smart grids and the increasing demand for convenient electricity bill management, the traditional manual electricity bill calculation and reconciliation method can no longer meet the needs of efficient and accurate financial management. In response to the above problems, the industry has proposed a system for financial management and reconciliation. However, the existing systems often have problems such as information islands, lagging data processing, and cumbersome reconciliation, which leads to increased financial costs and poor user experience. Summary of the invention

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

[0004] To achieve the purpose of the present invention, the technical solution provided by the present invention is as follows: First aspect This application provides an integrated intelligent method for electricity fee financial management and reconciliation, including the following steps: 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.

[0005] The statement includes: user account, name, contact information, user account balance, electricity bill payable by the user, comparison result between 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.

[0006] The step S5 includes 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 execution 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: ; in, Y Indicates the update response time evaluation coefficient; n Indicates the number of data updates that have update response time delay among all data updates; m Indicates the number of data updates without any update response time delay among all data updates; T yi Indicates i The update response time corresponding to the data update that has experienced the update response time delay; T m Indicates the preset maximum allowable update response time that meets the data update efficiency requirements; T yj Indicates j The update response time corresponding to the data update without any update response time delay; T gi Indicates i The data update that occurs the delay of update response time is the same as the i +1 The time interval between data updates that have a delay in update response time; k i Indicates i The data update that occurs the delay of update response time is the same as the i+1 number of data updates without update response time delay in the time interval between data updates 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 status.

[0007] Among them, 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: ; in, G 01 Indicates the first concurrent processing capability evaluation coefficient; s Indicates the number of time units that have passed; C 01io Indicates i o The number of transactions per unit time corresponding to the unit time; C 02io Indicates 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: ; ; in, C 01max and C 02maxThey represent the maximum number of transactions per unit time and the maximum number of queries per unit time respectively; C 02m Indicates 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: ; in, G 02 Indicates the second concurrent processing capability evaluation coefficient; P 01io Indicates i o Concurrent request failure rate per unit time; P 02io Indicates i o CPU utilization corresponding to unit time; P 01max and P 02max They represent the maximum concurrent request failure rate and the maximum CPU utilization respectively; P 02m Indicates 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.

[0008] Second aspect The present invention provides an integrated intelligent system for electricity fee financial management and account reconciliation, comprising the following units: a data acquisition unit, a data verification unit, a statement generation unit, a payment unit, and a 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, after receiving the payment instruction from the user, use the current account balance to make payment if recharging is not required, and after deducting the electricity fee payable by the user, the payment is completed and the user account balance is updated; if recharging is required, call the API of the third-party payment platform to perform the actual recharging operation, and after the recharging is successful, update the user account balance according to the recharge amount; use the current account balance to make payment, 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 completion, and the payment status in the database after the payment is completed.

[0009] The statement includes: user account, name, contact information, user account balance, electricity bill payable by the user, comparison result between 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.

[0010] The system also includes a status monitoring unit, which is used to monitor the data update operation status, 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 execution 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: ; in, Y Indicates the update response time evaluation coefficient; n Indicates the number of data updates that have update response time delay among all data updates; m Indicates the number of data updates without any update response time delay among all data updates; T yi Indicates i The update response time corresponding to the data update that has experienced the update response time delay; T m Indicates the preset maximum allowable update response time that meets the data update efficiency requirements; T yj Indicates j The update response time corresponding to the data update without any update response time delay; T gi Indicates i The data update that occurs the delay of update response time is the same as the i +1 The time interval between data updates that have a delay in update response time; k i Indicates i The data update that occurs the delay of update response time is the same as the i +1 number of data updates without update response time delay in the time interval between data updates 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 status.

[0011] Among them, 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: ; in, G 01 Indicates the first concurrent processing capability evaluation coefficient; s Indicates the number of time units that have passed; C 01io Indicates i o The number of transactions per unit time corresponding to the unit time; C 02io Indicates 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: ; ; in, 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 Indicates 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: ; in, G 02 Indicates the second concurrent processing capability evaluation coefficient; P 01io Indicates i o Concurrent request failure rate per unit time; P 02io Indicates i oCPU utilization corresponding to unit time; P 01max and P 02max They represent the maximum concurrent request failure rate and the maximum CPU utilization respectively; P 02m Indicates 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.

[0012] Compared with the prior art, the present invention significantly improves the efficiency of the financial management process by automatically processing user electricity usage information, cost information and financial data, and calculating electricity charges and updating account balances in real time. Traditional manual or semi-automatic methods require a lot of manpower and time to process these data, while the system can complete these tasks quickly and accurately, reducing human errors and delays. In addition, the automated and integrated system reduces dependence on human resources, thereby reducing labor costs, and can realize functions such as real-time query, online payment and automatic reconciliation, thereby improving financial management efficiency and reducing financial costs. By comparing the statements, users can timely understand the electricity usage and expense expenditure, which is convenient for reconciliation and adjustment of consumption habits. In addition, the present invention can process and update data in real time, reducing additional expenses such as paper documents and postage, further reducing financial costs, significantly improving financial management efficiency, reducing financial costs, enhancing user experience, promoting reconciliation accuracy, supporting decision analysis and improving service quality. BRIEF DESCRIPTION OF THE DRAWINGS

[0013] Figure 1 A schematic diagram of the method flow provided in an embodiment of the present application. DETAILED DESCRIPTION

[0014] The following is a clear and complete description of the technical solutions in the embodiments of the present invention in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0015] like Figure 1 As shown, this embodiment provides an integrated intelligent method for electricity fee financial management and reconciliation, including the following steps: Step S1: Receive the account data entered by the user and perform preliminary verification on whether the account data is legal; if the verification is legal, obtain the electricity usage 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 and historical transaction records, financial statements, etc. The historical transaction records include payment time, payment amount, etc.

[0016] It should be noted that the account data includes user account, name and contact information; the electricity usage information includes electricity consumption, electricity usage period and start time, end time, peak electricity consumption, valley electricity consumption, etc.; the cost information includes basic electricity charges and tiered electricity prices, etc.

[0017] It should be noted that if the format of the account data input by the user is correct, the process will continue and the next step will be performed, and the user will receive feedback, such as "The format is correct, verifying the account information..."; If the account data format entered by the user is incorrect, the system prompts an error and asks the user to re-enter the data. The user receives an error prompt, such as "Input format is incorrect. Please enter correct account information.", and after multiple verification failures, the account lock and security warning mechanism are triggered to prevent malicious attempts; 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; It should be noted that if the verification is successful and the data is confirmed to be correct, the user is allowed to proceed to the next step and the user receives feedback, such as "Data verification is successful, loading information..."; If the verification fails and the data is found to have problems with completeness, accuracy or consistency, the user is prevented from proceeding to the next step and receives an error message, such as "Data verification failed, please check your information", which triggers the audit process to resolve the data problem. 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.

[0018] Preferably, 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 of statement generation, information of the person performing the reconciliation operation and detailed description of any abnormal situations encountered during the reconciliation process.

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

[0020] Preferably, the method further includes step S5: 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 execution 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: ; in, Y Indicates the update response time evaluation coefficient; nIndicates the number of data updates that have update response time delay among all data updates; m Indicates the number of data updates without any update response time delay among all data updates; T yi Indicates i The update response time corresponding to the data update that has experienced the update response time delay; T m Indicates the preset maximum allowable update response time that meets the data update efficiency requirements; T yj Indicates j The update response time corresponding to the data update without any update response time delay; T gi Indicates i The data update that occurs the delay of update response time is the same as the i +1 The time interval between data updates that have a delay in update response time; k i Indicates i The data update that occurs the delay of update response time is the same as the i +1 number of data updates without update response time delay in the time interval between data updates 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 status.

[0021] It should be noted that the above scheme realizes real-time monitoring of changes in user account balances and the moment when payment is completed, ensuring the timeliness and accuracy of data, and can accurately calculate the response time of data updates corresponding to user payments, providing basic data for evaluating data update efficiency; the update response time evaluation coefficient acquisition module calculates a comprehensive evaluation coefficient by comprehensively considering factors such as update response time, delay times, non-delay times, time intervals, etc., which can fully reflect the efficiency and quality of data updates. The calculated update response time evaluation coefficient is compared with the preset evaluation coefficient threshold to realize intelligent data update efficiency evaluation; when the evaluation coefficient exceeds the threshold, the data update operation parameters will be further evaluated, which helps to timely discover and solve potential problems 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 data update operation parameters also help to improve the overall stability and reliability of the system.

[0022] In summary, this technical solution achieves comprehensive optimization of user payment data updates through real-time monitoring, data update efficiency evaluation, intelligent comparison and evaluation, and improves user experience and system stability.

[0023] Preferably, in step S5.6, the data update operation status is evaluated, specifically including the following: Step S5.6.1: extract the historical operation data records corresponding to each data update; It should be noted that the historical operation data record includes at least: user information, specific time of each data update, account balance update list, payment update list, account balance before and after update, payment status, abnormal situation record and data update operation status, etc.; 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: ; in, G 01 Indicates the first concurrent processing capability evaluation coefficient; s Indicates the number of time units that have passed; C 01io Indicatesi o The number of transactions per unit time corresponding to the unit time; C 02io Indicates 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: ; ; in, 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 Indicates 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: ; in, G 02 Indicates the second concurrent processing capability evaluation coefficient; P 01io Indicates i o Concurrent request failure rate per unit time; P 02io Indicates i o CPU utilization corresponding to unit time; P 01max and P 02max They represent the maximum concurrent request failure rate and the maximum CPU utilization respectively; P 02m Indicates 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.

[0024] It should be noted that by extracting key parameters (number of transactions per unit time, number of queries per unit time, concurrent request failure rate and CPU utilization) from historical operation data records, this solution can conduct a refined evaluation of the concurrent processing capability of the system. When calculating the first concurrent processing capability evaluation coefficient, dynamic adjustment factors (first adjustment factor and second adjustment factor) are introduced. These adjustment factors are dynamically adjusted according to the maximum value and corresponding value of historical data, so that the evaluation coefficient is more in line with the actual operation situation and the accuracy of the evaluation is improved. Not only the number of transactions and queries is considered, but also the concurrent request failure rate and CPU utilization are included, so as to comprehensively evaluate the concurrent processing capability of the system from multiple dimensions. By comparing the comprehensive concurrent processing capability evaluation parameters with the preset thresholds, real-time monitoring of the system operation status is achieved. Once the comprehensive evaluation parameters are lower than the preset threshold, an abnormal alarm is triggered, which helps to timely discover and deal with potential problems and ensure the stable operation of the system. The comprehensive concurrent processing capability evaluation parameters provided can serve as an important basis for system optimization and decision-making, helping the operation and maintenance team or developers to identify performance bottlenecks and guide resource allocation and the formulation of system optimization strategies.

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

[0026] In addition, this embodiment also provides an integrated intelligent system for electricity fee 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; 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, after receiving the payment instruction from the user, use the current account balance to make payment if recharging is not required, and after deducting the electricity fee payable by the user, the payment is completed and the user account balance is updated; if recharging is required, call the API of the third-party payment platform to perform the actual recharging operation, and after the recharging is successful, update the user account balance according to the recharge amount; use the current account balance to make payment, 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 completion, and the payment status in the database after the payment is completed.

[0027] Preferably, 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 of statement generation, information of the person performing the reconciliation operation and detailed description of any abnormal situations encountered during the reconciliation process.

[0028] Preferably, 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 execution 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: ; in, Y Indicates the update response time evaluation coefficient; n Indicates the number of data updates that have update response time delay among all data updates; mIndicates the number of data updates without any update response time delay among all data updates; T yi Indicates i The update response time corresponding to the data update that has experienced the update response time delay; T m Indicates the preset maximum allowable update response time that meets the data update efficiency requirements; T yj Indicates j The update response time corresponding to the data update without any update response time delay; T gi Indicates i The data update that occurs the delay of update response time is the same as the i +1 The time interval between data updates that have a delay in update response time; k i Indicates i The data update that occurs the delay of update response time is the same as the i +1 number of data updates without update response time delay in the time interval between data updates 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 status.

[0029] Preferably, in step S5.6, the data update operation status is evaluated, specifically including 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: ; in, G 01 Indicates the first concurrent processing capability evaluation coefficient; sIndicates the number of time units that have passed; C 01io Indicates i o The number of transactions per unit time corresponding to the unit time; C 02io Indicates 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: ; ; in, 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 Indicates 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: ; in, G 02 Indicates the second concurrent processing capability evaluation coefficient; P 01io Indicates i o Concurrent request failure rate per unit time; P 02io Indicates i o CPU utilization corresponding to unit time; P 01max and P 02max They represent the maximum concurrent request failure rate and the maximum CPU utilization respectively; P 02m Indicates the CPU utilization value per unit time corresponding to the maximum concurrent request failure rate; P 01mIndicates 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.

[0030] Finally, it should be noted that the above embodiments are only used to illustrate and explain 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 of the protection claimed by the present invention.

Claims

1. An intelligent method for integrated electricity bill financial management and reconciliation, It is 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.

2. According to claim 1, an intelligent method for integrated electricity fee financial management and reconciliation, It 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. According to claim 2, an intelligent method for integrated electricity fee financial management and reconciliation, It is characterized in that 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 execution 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: ; in, Y Indicates the update response time evaluation coefficient; n Indicates the number of data updates that have update response time delay among all data updates; m Indicates the number of data updates without any update response time delay among all data updates; T yi Indicates i The update response time corresponding to the data update that has experienced the update response time delay; T m Indicates the preset maximum allowable update response time that meets the data update efficiency requirements; T yj Indicates j The update response time corresponding to the data update without any update response time delay; T gi Indicates i The data update that occurs the delay of update response time is the same as the i +1 The time interval between data updates that have a delay in update response time; k i Indicates i The data update that occurs the delay of update response time is the same as the i +1 number of data updates without update response time delay in the time interval between data updates 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 status.

4. According to claim 3, an intelligent method for integrated electricity fee financial management and reconciliation, It is characterized in that 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: ; in, G 01 Indicates the first concurrent processing capability evaluation coefficient; s Indicates the number of time units that have passed; C 01io Indicates i o The number of transactions per unit time corresponding to the unit time; C 02io Indicates 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: ; ; in, 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 Indicates 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: ; in, G 02 Indicates the second concurrent processing capability evaluation coefficient; P 01io Indicates i o Concurrent request failure rate per unit time; P 02io Indicates i o CPU utilization corresponding to unit time; P 01max and P 02max They represent the maximum concurrent request failure rate and the maximum CPU utilization respectively; P 02m Indicates 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.

5. An integrated intelligent system for electricity fee financial management and reconciliation, It is 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 completion, and the payment status in the database after the payment is completed.

6. An intelligent system for integrated electricity fee financial management and reconciliation according to claim 5, It 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.

7. An intelligent system for integrated electricity fee financial management and reconciliation according to claim 6, It is characterized in that 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 execution 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: ; in, Y Indicates the update response time evaluation coefficient; n Indicates the number of data updates that have update response time delay among all data updates; m Indicates the number of data updates without any update response time delay among all data updates; T yi Indicates i The update response time corresponding to the data update that has experienced the update response time delay; T m Indicates the preset maximum allowable update response time that meets the data update efficiency requirements; T yj Indicates j The update response time corresponding to the data update without any update response time delay; T gi Indicates i The data update that occurs the delay of update response time is the same as the i +1 The time interval between data updates that have a delay in update response time; k i Indicates i The data update that occurs the delay of update response time is the same as the i +1 number of data updates without update response time delay in the time interval between data updates 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 status.

8. An intelligent system for integrated electricity fee financial management and reconciliation according to claim 7, It is characterized in that 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: ; in, G 01 Indicates the first concurrent processing capability evaluation coefficient; s Indicates the number of time units that have passed; C 01io Indicates i o The number of transactions per unit time corresponding to the unit time; C 02io Indicates 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: ; ; in, 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 Indicates 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: ; in, G 02 Indicates the second concurrent processing capability evaluation coefficient; P 01io Indicates i o Concurrent request failure rate per unit time; P 02io Indicates i o CPU utilization corresponding to unit time; P 01max and P 02max They represent the maximum concurrent request failure rate and the maximum CPU utilization respectively; P 02m Indicates 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.

Citation Information

Patent Citations

  • Electricity selling system and method for electric vehicle

    CN106781043A

  • Electricity consumption management method and system

    CN107172080A

  • Expense management system and method based on smart electric meter

    CN107533780A

  • Data table processing method and device

    CN108509455A

  • Charging transaction management method and system based on block chain

    CN113222763A