A charging data processing method and device, and a storage medium

Abstract

The application provides a charging data processing method and device and a storage medium, and relates to the technical field of telecommunication charging. A batch deduction calculation process of first service transaction data is performed to obtain first batch data; first real-time data is read, and a first difference account in which the first batch data and the first real-time data are different is screened out by comparing the first batch data and the first real-time data of the same account; whether the proportion of the first difference account in the total account is less than a preset proportion threshold is judged; if yes, a real-time deduction calculation process of second service transaction data is performed to obtain second real-time data, and the second real-time data is written in a temporary table; and if no, the first batch data is written in the temporary table. The method provided by the application solves the problems of a large number of data read-write times, great calculation pressure, and long processing time caused by the fact that charging data processing work can only be performed at the first day of each natural month at dawn and the fact that charging data is complicated.

Description

Technical Field

[0001] This application relates to telecommunications billing technology, and more particularly to a billing data processing method, device and storage medium. Background Technology

[0002] The billing system for telecommunications companies is the core of the Business & Operation Support System (BOSS). Within a fixed time period each calendar month, it completes the deduction of bills for the previous month and obtains the ledger balance. In billing data processing, firstly, using the account as the basic operation unit, it iterates through all ledgers for that account in the database. During this process, it iterates through all bills in that ledger to obtain batch bills for that account. Secondly, it calculates batch deductions for these bills. Finally, the audited calculation results are added to the database.

[0003] Billing data processing can only be carried out in the early morning of the first day of each calendar month. The billing data is complex, resulting in a large number of data read and write operations, high computational pressure, and long processing time. Summary of the Invention

[0004] This application provides a billing data processing method, device, and storage medium to solve the problems of high data read / write frequency, high computational pressure, and long processing time caused by the fact that billing data processing can only be carried out in the early morning of the first day of each calendar month and that the billing data is complex.

[0005] Firstly, this application provides a billing data processing method, which includes:

[0006] Read the first business transaction data of all accounts within a preset time period from the business transaction database, execute the batch deduction calculation process of the first business transaction data, and obtain the first batch data of all accounts within the preset time period.

[0007] Read the first real-time data of all accounts up to the end of the preset time period from the temporary table, compare the first batch data and the first real-time data of the same account, and filter out the first difference accounts that are different from the first batch data and the first real-time data.

[0008] Determine whether the proportion of the first difference account to all accounts is less than a preset proportion threshold;

[0009] If so, read the second business transaction data of the first difference account within a preset time period from the business transaction database, execute the real-time deduction calculation process of the second business transaction data, obtain the second real-time data of the first difference account within the preset time period, and write the second real-time data into a temporary table;

[0010] If not, write the first batch of data into the temporary table.

[0011] In one possible design, before writing the second real-time data to the temporary table, the following is also included:

[0012] Delete the data for the first difference account from the temporary table;

[0013] Correspondingly, before writing the first batch of data to the temporary table, the following steps are also included:

[0014] Delete all account data from the temporary table.

[0015] In one possible design, after determining whether the proportion of the first difference account to all accounts is less than a preset proportion threshold, the following steps are also included:

[0016] Write data to a temporary table in the business transaction database.

[0017] In one possible design, before reading the first batch of business transaction data for all accounts within a preset time period from the business transaction database, executing the batch deduction calculation process for the first business transaction data, and obtaining the first batch of data for all accounts within the preset time period, the following steps are also included:

[0018] Receive notification messages from the business transaction database, which include the location of the third business transaction data where the data has changed;

[0019] According to the prompt message, read the third business transaction data from the business transaction database;

[0020] The process of real-time deduction calculation of the third business transaction data is executed to obtain the third real-time data of data changes;

[0021] Write the third real-time data into the temporary table.

[0022] In one possible design, after reading the first real-time data of all accounts up to the end of a preset time period from a temporary table, comparing the first batch data and the first real-time data of the same account, and filtering out the first difference accounts where the first batch data and the first real-time data differ, the following steps are also included:

[0023] Determine whether the first difference account has been selected;

[0024] If so, issue an alarm.

[0025] In one possible design, a natural month consists of one or at least one non-overlapping preset time period.

[0026] In one possible design, it is determined whether the first difference account is selected within a consecutive preset number of calendar months;

[0027] If not, starting from the next calendar month, write the third real-time data into the business transaction database;

[0028] Correspondingly, after executing the real-time deduction calculation process for the third business transaction data and obtaining the third real-time data on data changes, it also includes:

[0029] Read the fourth business transaction data of all accounts for the current calendar day from the business transaction database;

[0030] The process of batch deduction calculation for the fourth business transaction data is executed to obtain the second batch of data for all accounts on the current calendar day.

[0031] Read the fourth real-time data of all accounts up to the end of the current calendar day from the business transaction database;

[0032] Compare the second batch of data and the fourth real-time data for the same account;

[0033] Determine whether a second discrepancy account is identified where the second batch of data and the fourth real-time data differ.

[0034] If so, issue an alarm.

[0035] Secondly, this application provides a telecommunications enterprise billing system, which includes:

[0036] The first data processing module is used to read the first business transaction data of all accounts within a preset time period from the business transaction database, execute the batch deduction calculation process of the first business transaction data, obtain the first batch data of all accounts within the preset time period, and write the first batch data into a temporary table.

[0037] The second data processing module is used to read the second business transaction data of the first difference account within a preset time period from the business transaction database, execute the real-time deduction calculation process of the second business transaction data, obtain the second real-time data of the first difference account within the preset time period, and write the second real-time data into a temporary table.

[0038] The third data processing module is used to read the first real-time data of all accounts up to the end of the preset time period from the temporary table, compare the first batch data and the first real-time data of the same account, filter out the first difference accounts that are different from the first batch data and the first real-time data, and determine whether the proportion of the first difference accounts to all accounts is less than the preset proportion threshold.

[0039] Thirdly, this application provides an electronic device, including a processor and a memory communicatively connected to the processor;

[0040] The memory stores instructions that the computer executes;

[0041] The processor executes computer-executable instructions stored in memory to implement a steering control method.

[0042] Fourthly, this application provides a computer-readable storage medium storing computer-executable instructions, which, when executed by a processor, are used to implement a steering control method.

[0043] This application provides a billing data processing method, device, and storage medium that reads and processes first business transaction data and first real-time data to obtain first batch data and second real-time data, and writes the first batch data or the second real-time data into a temporary table. This achieves the following technical effects: by acquiring real-time data, it solves the problem that billing data processing can only be performed at midnight on the first day of each calendar month, and that the billing data is complex; by comparing the first batch data and the first real-time data for the same account, it solves the problem of auditing all real-time data of the previous calendar month at midnight on the first day of each calendar month; and by writing the second real-time data or the first batch data into a temporary table, it solves the problem of inaccurate real-time data. Attached Figure Description

[0044] To more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are some embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0045] Figure 1 Flowchart of the billing data processing method provided in the embodiments of this application Figure 1 ;

[0046] Figure 2 A flowchart illustrating the testing phase of the billing data processing method provided in this application embodiment. Figure 2 ;

[0047] Figure 3 A flowchart illustrating the third real-time data writing process within a calendar month provided in this application embodiment. Figure 3 ;

[0048] Figure 4 A flowchart illustrating the fifth real-time data audit provided in this application embodiment. Figure 4 ;

[0049] Figure 5 A flowchart illustrating the audit of the eighth real-time data provided in this application embodiment. Figure 5 ;

[0050] Figure 6A flowchart illustrating the formal stage of the billing data processing method provided in this application embodiment. Figure 6 ;

[0051] Figure 7 Schematic diagram of the hardware structure of the electronic device provided in the embodiments of this application Figure 1 .

[0052] Explanation of reference numerals in the attached figures:

[0053] 10-Electronic device; 11-Processor; 12-Memory; 13-Communication component; 14-Bus. Detailed Implementation

[0054] Exemplary embodiments will now be described in detail, examples of which are illustrated in the accompanying drawings. When the following description relates to the drawings, unless otherwise indicated, the same numerals in different drawings represent the same or similar elements. The embodiments described in the following exemplary embodiments do not represent all embodiments consistent with this application. Rather, they are merely examples of apparatuses and methods consistent with some aspects of this application as detailed in the appended claims, and not all embodiments. All other embodiments obtained by those skilled in the art based on the embodiments of this invention without inventive effort are within the scope of protection of this invention.

[0055] First, the relevant concepts or terms involved in this application will be explained:

[0056] Business transaction data refers to account billing. Business transaction data includes voice bills generated when providing call services, SMS messages generated when providing SMS services, and data traffic generated when providing mobile communication services.

[0057] Batch deduction calculation process: This refers to the calculation process for obtaining batch data. The main logic includes: at the end of a time period, processing and auditing the backlog of account bills for that time period to obtain the overall account bill; using the account balance in the ledger before the start of the time period, deducting the bill consumption in the overall account bill to obtain the account balance as of the end of the time period, i.e., batch data.

[0058] Real-time deduction calculation process: This refers to the calculation process that obtains real-time data. The main logic includes: processing and auditing account statements in real-time to obtain real-time account statements; using the account balance from the previous time period to deduct expenses from the real-time account statements to obtain the real-time account balance, i.e., real-time data.

[0059] Figure 1 Flowchart of the billing data processing method provided in the embodiments of this application Figure 1 .like Figure 1 As shown, the method includes:

[0060] S101. Read the first business transaction data of all accounts within a preset time period from the business transaction database, execute the batch deduction calculation process of the first business transaction data, and obtain the first batch data of all accounts within the preset time period.

[0061] Specifically, real-time data acquisition is used to address the issue that billing data processing can only be performed at midnight on the first day of each calendar month, and that the billing data is complex.

[0062] During the testing phase of this method, real-time data needs to be audited to ensure the accuracy of the calculation results. To avoid auditing all real-time data of the previous calendar month at midnight on the first day of each calendar month, the real-time data within a calendar month will be audited multiple times, with each audit only covering a preset time period.

[0063] At the end of the preset time period, the first business transaction data is read from the business transaction database. The first business transaction data refers to the business transaction data of all accounts at all times and in all formats within the preset time period; the business transaction database is a database that stores business transaction data, real-time data, and batch data. The batch deduction calculation process for the first business transaction data is executed, and a full account audit is performed to obtain the first batch data. The first batch data refers to the batch data of all accounts up to the end of the preset time period.

[0064] S102. Read the first real-time data of all accounts up to the end of the preset time period from the temporary table, compare the first batch data and the first real-time data of the same account, and filter out the first difference accounts that are different from the first batch data and the first real-time data.

[0065] Specifically, since the batch deduction calculation process is a mature and stable existing technology, the batch deduction calculation results are accurate and reliable. Furthermore, the first batch data and the first real-time data share the same time point, account type, and data type. By comparing the first batch data and the first real-time data for each account in the full set of accounts, the first discrepancy accounts are identified. Here, the first real-time data refers to the real-time data of all accounts up to the end of the preset time period; the temporary table is a data table that temporarily stores both real-time and batch data; and the first discrepancy account refers to an account whose first batch data and first real-time data differ.

[0066] S103. Determine whether the proportion of the first difference account to all accounts is less than the preset proportion threshold;

[0067] Specifically, the accuracy of the first real-time data is determined by comparing the proportion of the first difference account to the total number of accounts with the preset proportion threshold.

[0068] S104. If so, read the second business transaction data of the first difference account within a preset time period from the business transaction database, execute the real-time deduction calculation process of the second business transaction data, obtain the second real-time data of the first difference account within the preset time period, and write the second real-time data into the temporary table.

[0069] Specifically, if the ratio is less than the ratio threshold, it indicates that there is no system defect in the real-time deduction calculation process, and the first difference account is caused by other system defects. In this case, accurate real-time data can be obtained by re-executing the real-time deduction calculation process.

[0070] Retrieves the second business transaction data from the business transaction database. The second business transaction data refers to the business transaction data of the first difference account at various times and in various forms within a preset time period. Executes the real-time deduction calculation process for the second business transaction data to obtain the second real-time data, which is then written to a temporary table. The second real-time data refers to the real-time data of the first difference account up to the end of the preset time period.

[0071] S105. If not, write the first batch of data into the temporary table;

[0072] Specifically, if the ratio is not less than the ratio threshold, it indicates that there is a system defect in the real-time deduction calculation process, and the first difference account is caused by the system defect in the real-time deduction calculation process. In this case, even if the real-time deduction calculation process is re-executed, accurate real-time data cannot be obtained.

[0073] To ensure the accuracy of the calculation results, the first batch of data is directly written to a temporary table.

[0074] This embodiment provides a billing data processing method that reads and processes first business transaction data and first real-time data to obtain first batch data and second real-time data, and writes the first batch data or the second real-time data into a temporary table. This achieves the following technical effects: by acquiring real-time data, it solves the problem that billing data processing can only be performed at midnight on the first day of each calendar month, and that the billing data is complex; by comparing the first batch data and the first real-time data for the same account, it solves the problem of auditing all real-time data of the previous calendar month at midnight on the first day of each calendar month; and by writing the second real-time data or the first batch data into a temporary table, it solves the problem of inaccurate real-time data.

[0075] The following specific embodiment will be used to describe in detail a billing data processing method of this application.

[0076] Figure 2 A flowchart illustrating the testing phase of the billing data processing method provided in this application embodiment. Figure 2 ;

[0077] Figure 3A flowchart illustrating the third real-time data writing process within a calendar month provided in this application embodiment. Figure 3 ;

[0078] Figure 4 A flowchart illustrating the fifth real-time data audit provided in this application embodiment. Figure 4 ;

[0079] Figure 5 A flowchart illustrating the audit of the eighth real-time data provided in this application embodiment. Figure 5 ;

[0080] Figure 6 A flowchart illustrating the formal stage of the billing data processing method provided in this application embodiment. Figure 6 .

[0081] like Figure 2 As shown, the testing phase of a billing data processing method includes:

[0082] S201. Receive a notification message sent by the business transaction database. The notification message includes the location of the third business transaction data where the data has changed.

[0083] S202. According to the prompt message, read the third business transaction data from the business transaction database;

[0084] S203. Execute the real-time deduction calculation process for the third business transaction data to obtain the third real-time data of data changes;

[0085] S204. Write the third real-time data into the temporary table;

[0086] Specifically, such as Figure 3 As shown, when a user uses call service, SMS service or mobile communication service, a business transaction is triggered. The business transaction database records the business transaction data corresponding to the business transaction and sends a notification message.

[0087] Based on the prompt message, the telecommunications company's billing system reads the third-party business transaction data from the business transaction database. This third-party business transaction data refers to the business transaction data of all accounts at all times and in all formats within a calendar month. The system then executes the real-time deduction calculation process and writes the calculation results, specifically the third-party real-time data, into a temporary table. This third-party real-time data refers to the real-time data of all accounts within a calendar month.

[0088] S205. Read the first business transaction data of all accounts within a preset time period from the business transaction database, execute the batch deduction calculation process of the first business transaction data, and obtain the first batch data of all accounts within the preset time period.

[0089] S206. Read the first real-time data of all accounts up to the end of the preset time period from the temporary table, compare the first batch data and the first real-time data of the same account, and filter out the first difference accounts that are different from the first batch data and the first real-time data.

[0090] S207. If the first discrepancy account is identified, an alert will be issued;

[0091] Specifically, identifying the first discrepancy account indicates a system defect in the real-time deduction calculation process, or other system defects in the telecommunications company's billing system. At this point, an alert is issued, notifying software administrators to analyze the cause of the first discrepancy account and identify and fix the system defects.

[0092] If the first discrepancy account is not found, it means that there are no undiscovered system defects in the real-time deduction calculation process, or that there are no other undiscovered system defects in the telecommunications company's billing system.

[0093] S208. Determine whether the proportion of the first difference account to all accounts is less than the preset proportion threshold;

[0094] S209. If so, read the second business transaction data of the first difference account within a preset time period from the business transaction database, execute the real-time deduction calculation process of the second business transaction data, and obtain the second real-time data of the first difference account within the preset time period.

[0095] S210. Delete the data for the first difference account from the temporary table;

[0096] S211. Write the second real-time data into the temporary table;

[0097] S212. If not, delete all account data from the temporary table;

[0098] S213. Write the first batch of data into the temporary table;

[0099] S214. Write data to the temporary table in the business transaction database;

[0100] Specifically, during the testing phase of this method, a natural month consists of one or more non-overlapping preset time periods. For example, a natural month consists of a first preset time period and a second preset time period. The first preset time period refers to the period from 0:00 on the first day of each natural month to 22:00 on the last day, and the second preset time period refers to the period from 22:00 to 24:00 on the last day of each natural month.

[0101] For example, such as Figure 4 As shown, after the first preset time period ends, the fifth real-time data of the first preset time period is audited. The fifth real-time data refers to the real-time data of all accounts in the first preset time period.

[0102] First, obtain the fifth business transaction data file. Read the fifth business transaction data from the business transaction database. Due to the complexity of the data, it is usually obtained in file format. The fifth business transaction data refers to the business transaction data of all accounts at all times and in all formats within the first preset time period.

[0103] Secondly, real-time deduction calculations were stopped. During the audit of the fifth set of real-time data, frequent readings and writes to temporary tables were required. To ensure data accuracy and prevent errors during the reading and writing process, real-time deduction calculations were stopped.

[0104] Accordingly, the third real-time data stops being written to the temporary table.

[0105] Secondly, sort the fifth business transaction data. Classify the fifth business transaction data according to the same account and the same data type, and then sort them by time.

[0106] Secondly, the batch deduction calculation process is executed to obtain the third batch of data. This third batch of data refers to the batch data of all accounts up to the end of the first preset time period.

[0107] Secondly, a full account audit is conducted. This involves auditing the third batch of data and comparing it with the fifth real-time data for the same account to identify accounts with third discrepancies. These third discrepancy accounts are those where the third batch of data differs from the fifth real-time data for the same account.

[0108] Secondly, determine whether the proportion is less than a proportion threshold. Thirdly, assess the accuracy of the real-time data by checking whether the proportion of the third-discretionary account to all accounts is less than a preset proportion threshold.

[0109] If so, it indicates that there are no system defects in the real-time deduction calculation process. The sixth business transaction data is sorted, categorized by the same account and data type, and then sorted by time. The sixth business transaction data refers to the business transaction data of the third difference account at various times and in various forms within the first preset time period. Next, the real-time deduction calculation process is executed to obtain the sixth real-time data. The sixth real-time data refers to the real-time data of the third difference account up to the end of the first preset time period. Next, the data of the third difference account is deleted, as the data of the third difference account stored in the temporary table failed the audit and is inaccurate. Finally, the sixth real-time data is written.

[0110] If not, this indicates a system defect in the real-time deduction calculation process. Delete all account data; the data for all accounts stored in the temporary table failed auditing and is inaccurate. Next, write the third batch of data.

[0111] Secondly, the data from the temporary table is written to the business transaction database.

[0112] Secondly, the real-time deduction calculation begins.

[0113] Finally, the third real-time data is written to the temporary table. The telecommunications company's billing system has completed the audit of the real-time data for the first preset time period, and the data in the temporary table has been written to the business transaction database. The third real-time data can continue to be written to the temporary table. Accordingly, before this, the seventh business transaction data is read from the business transaction database, the real-time deduction calculation process for the seventh transaction data is executed, the seventh real-time data is obtained, and written to the temporary table. The seventh business transaction data refers to the business transaction data of all accounts at all times and in all forms during the period when the third real-time data stops being written to the temporary table; the seventh real-time data refers to the real-time data of all accounts during the period when the third real-time data stops being written to the temporary table.

[0114] For example, such as Figure 5 As shown, after the second preset time period ends, the eighth real-time data of the second preset time period is audited. The eighth real-time data refers to the real-time data of all accounts in the second preset time period.

[0115] First, obtain the eighth business transaction data file. Read the eighth business transaction data from the business transaction database. Due to the complexity of the data, it is usually obtained in file format. The eighth business transaction data refers to the business transaction data of all accounts at all times and in all formats within the second preset time period. At this point, the natural month has ended, the real-time deduction calculation of the third real-time data has stopped, and the writing of the third real-time data to the temporary table has ceased.

[0116] Secondly, sort the transaction data for the eighth business. Classify the eighth business transaction data according to the same account and data type, and then sort them by time.

[0117] Secondly, the batch deduction calculation process is executed to obtain the fourth batch of data. This fourth batch of data refers to the batch data of all accounts up to the end of the second preset time period.

[0118] Secondly, a full account audit was conducted. The fourth batch of data was audited, and the fourth batch of data for the same account was compared with the eighth real-time data to identify the fourth discrepancy accounts. These fourth discrepancy accounts are those where the fourth batch of data and the eighth real-time data for the same account differ.

[0119] Secondly, determine whether the proportion is less than a proportion threshold. The accuracy of the eighth real-time data is judged by whether the proportion of the fourth difference account to all accounts is less than a preset proportion threshold.

[0120] If so, it indicates that there are no system defects in the real-time deduction calculation process. The ninth business transaction data is sorted, categorized by the same account and data type, and then sorted by time. The ninth business transaction data refers to the business transaction data of the fourth difference account at various times and in various formats within the second preset time period. Next, the real-time deduction calculation process is executed to obtain the ninth real-time data. The ninth real-time data refers to the real-time data of the fourth difference account up to the end of the second preset time period. Next, the data of the fourth difference account is deleted, as the data of the fourth difference account stored in the temporary table failed the audit and is inaccurate. Finally, the ninth real-time data is written.

[0121] If not, this indicates a system defect in the real-time deduction calculation process. Delete all account data; the data for all accounts stored in the temporary table failed auditing and is inaccurate. Next, write the fourth batch of data.

[0122] Finally, the data in the temporary table is written to the business transaction database. After the data writing is complete, the telecommunications company's billing system activates the account and subsequently informs the user of the account statement and balance for the previous calendar month, ensuring that the user is promptly informed of their account status.

[0123] like Figure 6 As shown, the formal stage of a billing data processing method includes:

[0124] S301. Determine whether the first difference account has been selected within a consecutive preset number of natural months;

[0125] S302. If not, starting from the next calendar month, write the third real-time data into the business transaction database;

[0126] S303. Read the fourth business transaction data of all accounts for the current natural day from the business transaction database;

[0127] S304. Execute the batch deduction calculation process for the fourth business transaction data to obtain the second batch data for all accounts on the current natural day;

[0128] S305. Read the fourth real-time data of all accounts up to the end of the current natural day from the business transaction database;

[0129] S306. Compare the second batch of data and the fourth real-time data for the same account;

[0130] S307. Determine whether the second batch of data and the fourth real-time data are different from the second difference account;

[0131] S308. If so, issue an alarm;

[0132] Specifically, if no first discrepancy account is found within a preset number of consecutive calendar months, it is considered that the system defect of the telecommunications enterprise's billing system has been found and repaired, and the system is officially launched; if the first discrepancy account is found within a preset number of consecutive calendar months, it is considered that the system defect of the telecommunications enterprise's billing system still exists and the system cannot be launched, and the next steps will continue.

[0133] Thirdly, business transaction data is written directly to the business transaction database, without needing to be written to a temporary table first. During business processing, a daily audit function is added to ensure the accuracy of daily calculation results.

[0134] Routine audit assurance refers to auditing the third real-time data within a calendar day, specifically comparing the second batch data and the fourth real-time data for the same account. The second batch data is the calculation result of the batch deduction process for the fourth business transaction data. Specifically, the second batch data refers to the batch data of all accounts up to the end of the calendar day; the fourth real-time data refers to the real-time data of all accounts within the calendar day; and the fourth business transaction data refers to the business transaction data of all accounts at various times and in various forms within the calendar day.

[0135] If no first-difference accounts or second-difference accounts are found that differ between the second batch data and the fourth real-time data, it indicates that the telecommunications company's billing system does not have any undiscovered system defects, or that a new system defect has been generated. If, however, first-difference accounts or second-difference accounts that differ between the second batch data and the fourth real-time data are found, it indicates that the telecommunications company's billing system has undiscovered system defects, or that a new system defect has been generated. In this case, an alert is issued to notify software administrators to analyze the cause of the second-difference accounts and to find and fix the system defects. Here, a second-difference account refers to an account whose second batch data and fourth real-time data differ from each other.

[0136] The method provided in this embodiment, by reading and processing first business transaction data and first real-time data to obtain first batch data and second real-time data, and writing the first batch data or the second real-time data into a temporary table, achieves the following technical effects: By acquiring real-time data in real time, it solves the problem that billing data processing can only be carried out at midnight on the first day of each calendar month, and that billing data is complex; by comparing the first batch data and the first real-time data of the same account, it solves the problem of auditing all real-time data of the previous calendar month at midnight on the first day of each calendar month; by writing the second real-time data or the first batch data into the temporary table, it solves the problem of inaccurate real-time data; by auditing real-time data over a preset time period and calendar day to determine whether discrepancies have been identified, it solves the problem of not being able to guarantee data accuracy; by issuing an alarm when discrepancies are identified, it solves the problem of not being able to notify software administrators to find and fix system defects; by determining whether the first discrepancy account has been identified within a preset number of consecutive calendar months, it solves the problem of whether to officially launch the method.

[0137] In this embodiment of the invention, electronic devices or main control devices can be divided into functional modules according to the above method examples. For example, each function can be divided into its own functional modules, or two or more functions can be integrated into one processing unit. The integrated unit can be implemented in hardware or as a software functional module. It should be noted that the module division in this embodiment of the invention is illustrative and only represents one logical functional division; other division methods may be used in actual implementation.

[0138] This application provides a telecommunications enterprise billing system, which includes:

[0139] The first data processing module is used to read the first business transaction data of all accounts within a preset time period from the business transaction database, execute the batch deduction calculation process of the first business transaction data, obtain the first batch data of all accounts within the preset time period, and write the first batch data into a temporary table.

[0140] The second data processing module is used to read the second business transaction data of the first difference account within a preset time period from the business transaction database, execute the real-time deduction calculation process of the second business transaction data, obtain the second real-time data of the first difference account within the preset time period, and write the second real-time data into a temporary table.

[0141] The third data processing module is used to read the first real-time data of all accounts up to the end of the preset time period from the temporary table, compare the first batch data and the first real-time data of the same account, filter out the first difference accounts that are different from the first batch data and the first real-time data, and determine whether the proportion of the first difference accounts to all accounts is less than the preset proportion threshold.

[0142] Furthermore, the first data processing module is specifically used for:

[0143] S205. Read the first business transaction data of all accounts within a preset time period from the business transaction database, execute the batch deduction calculation process of the first business transaction data, and obtain the first batch data of all accounts within the preset time period.

[0144] S212. If not, delete all account data from the temporary table;

[0145] S213. Write the first batch of data into the temporary table;

[0146] S303. Read the fourth business transaction data of all accounts for the current natural day from the business transaction database;

[0147] S304. Execute the batch deduction calculation process for the fourth business transaction data to obtain the second batch data for all accounts on the current natural day;

[0148] The second data processing module is specifically used for:

[0149] S201. Receive a notification message sent by the business transaction database. The notification message includes the location of the third business transaction data where the data has changed.

[0150] S202. According to the prompt message, read the third business transaction data from the business transaction database;

[0151] S203. Execute the real-time deduction calculation process for the third business transaction data to obtain the third real-time data of data changes;

[0152] S204. Write the third real-time data into the temporary table;

[0153] S209. If so, read the second business transaction data of the first difference account within a preset time period from the business transaction database, execute the real-time deduction calculation process of the second business transaction data, and obtain the second real-time data of the first difference account within the preset time period.

[0154] S210. Delete the data for the first difference account from the temporary table;

[0155] S211. Write the second real-time data into the temporary table;

[0156] S302. If not, starting from the next calendar month, write the third real-time data into the business transaction database;

[0157] The third data processing module is specifically used for:

[0158] S206. Read the first real-time data of all accounts up to the end of the preset time period from the temporary table, compare the first batch data and the first real-time data of the same account, and filter out the first difference accounts that are different from the first batch data and the first real-time data.

[0159] S207. If the first discrepancy account is identified, an alert will be issued;

[0160] S208. Determine whether the proportion of the first difference account to all accounts is less than the preset proportion threshold;

[0161] S214. Write data to the temporary table in the business transaction database;

[0162] S301. Determine whether the first difference account has been selected within a consecutive preset number of natural months;

[0163] S305. Read the fourth real-time data of all accounts up to the end of the current natural day from the business transaction database;

[0164] S306. Compare the second batch of data and the fourth real-time data for the same account;

[0165] S307. Determine whether the second batch of data and the fourth real-time data are different from the second difference account;

[0166] S308. If so, issue an alarm.

[0167] This embodiment provides a telecommunications enterprise billing system that can execute the billing data processing method of the above embodiment. Its implementation principle and technical effect are similar, and will not be described again here.

[0168] In the specific implementation of the aforementioned billing data processing method, each module can be implemented as a processor, which can execute computer execution instructions stored in the memory, thereby enabling the processor to execute the aforementioned billing data processing method.

[0169] Figure 7 Schematic diagram of the hardware structure of the electronic device provided in the embodiments of this application Figure 1 .like Figure 3 As shown, the electronic device 10 includes at least one processor 11 and a memory 12. The electronic device 10 also includes a communication component 13. The processor 11, memory 12, and communication component 13 are connected via a bus 14.

[0170] In the specific implementation process, at least one processor 11 executes computer execution instructions stored in memory 12, causing at least one processor 11 to execute the billing data processing method executed on the electronic device side as described above.

[0171] The specific implementation process of processor 11 can be found in the above method embodiments, and its implementation principle and technical effect are similar. It will not be repeated here.

[0172] In the above embodiments, it should be understood that the processor can be a Central Processing Unit (CPU), or other general-purpose processors, digital signal processors (DSPs), application-specific integrated circuits (ASICs), etc. The general-purpose processor can be a microprocessor or any conventional processor. The steps of the method disclosed in this invention can be directly implemented by a hardware processor, or implemented by a combination of hardware and software modules within the processor.

[0173] The memory may include high-speed RAM, and may also include non-volatile storage (NVM), such as at least one disk storage.

[0174] The bus can be an Industry Standard Architecture (ISA) bus, a Peripheral Component Interconnect (PCI) bus, or an Extended Industry Standard Architecture (EISA) bus, etc. Buses can be categorized as address buses, data buses, control buses, etc. For ease of illustration, the buses shown in the accompanying drawings are not limited to a single bus or a single type of bus.

[0175] The above description of the functions implemented by electronic devices and main control devices has introduced the solutions provided by the embodiments of the present invention. It is understood that, in order to implement the above functions, the electronic device or main control device includes hardware structures and / or software modules corresponding to the execution of each function. By combining the units and algorithm steps of the various examples described in the embodiments of the present invention, the embodiments of the present invention can be implemented in hardware or a combination of hardware and computer software. Whether a function is executed by hardware or by computer software driving hardware depends on the specific application and design constraints of the technical solution. Those skilled in the art can use different methods to implement the described functions for each specific application, but such implementation should not be considered beyond the scope of the technical solutions of the embodiments of the present invention.

[0176] This application also provides a computer-readable storage medium storing computer-executable instructions, which, when executed by a processor, implement the above-described billing data processing method.

[0177] The aforementioned computer-readable storage medium can be implemented by any type of volatile or non-volatile storage device or a combination thereof, such as static random access memory (SRAM), electrically erasable programmable read-only memory (EEPROM), erasable programmable read-only memory (EPROM), programmable read-only memory (PROM), read-only memory (ROM), magnetic storage, flash memory, magnetic disk, or optical disk. The readable storage medium can be any available medium accessible to a general-purpose or special-purpose computer.

[0178] An exemplary readable storage medium is coupled to a processor, enabling the processor to read information from and write information to the readable storage medium. Of course, the readable storage medium can also be a component of the processor. The processor and the readable storage medium can reside in an Application Specific Integrated Circuit (ASIC). Alternatively, the processor and the readable storage medium can exist as discrete components in an electronic device or a host device.

[0179] This application also provides a computer program product, comprising: a computer program stored in a readable storage medium, wherein at least one processor of an electronic device can read the computer program from the readable storage medium, and the at least one processor executes the computer program to cause the electronic device to perform the scheme provided in any of the above embodiments.

[0180] Those skilled in the art will understand that all or part of the steps of the above method embodiments can be implemented by hardware related to program instructions. The aforementioned program can be stored in a computer-readable storage medium. When the program is executed, it performs the steps of the above method embodiments; and the aforementioned storage medium includes various media capable of storing program code, such as ROM, RAM, magnetic disk, or optical disk.

[0181] In the embodiments of this application, the terms "first" and "second" are used to distinguish identical or similar items with essentially the same function and effect, without limiting their order. Those skilled in the art will understand that the terms "first" and "second" do not limit the quantity or execution order, and that the terms "first" and "second" do not necessarily imply that they are different.

[0182] It should be noted that, in the embodiments of this application, the terms "exemplary" or "for example" are used to indicate examples, illustrations, or descriptions. Any embodiment or design scheme described as "exemplary" or "for example" in this application should not be construed as being more preferred or advantageous than other embodiments or design schemes. Specifically, the use of terms such as "exemplary" or "for example" is intended to present the relevant concepts in a specific manner.

[0183] In the description of this application, it should be noted that, unless otherwise expressly specified and limited, the terms "installation," "connection," and "linking" should be interpreted broadly. For example, they can refer to a fixed connection, a detachable connection, or an integral connection; they can refer to a mechanical connection or an electrical connection; they can refer to a direct connection or an indirect connection through an intermediate medium; and they can refer to the internal connection between two components. Those skilled in the art can understand the specific meaning of the above terms in this application based on the specific circumstances.

[0184] Other embodiments of this application will readily occur to those skilled in the art upon consideration of the specification and practice of the invention disclosed herein. This application is intended to cover any variations, uses, or adaptations of this application that follow the general principles of this application and include common knowledge or customary techniques in the art not disclosed herein. The specification and examples are to be considered exemplary only, and the true scope and spirit of this application are indicated by the following claims.

[0185] It should be understood that this application is not limited to the precise structure described above and shown in the accompanying drawings, and various modifications and changes can be made without departing from its scope. The scope of this application is limited only by the appended claims.

Claims

1. A charging data processing method characterized by, The charging data processing method comprises: receiving a prompt message sent by the service transaction database, the prompt message comprising a third service transaction data position of data variation; reading the third service transaction data in the service transaction database according to the prompt message; performing a real-time deduction calculation process of the third service transaction data to obtain third real-time data of data variation; writing the third real-time data in a temporary table; reading first service transaction data of full accounts in a preset time period in the service transaction database, performing a batch deduction calculation process of the first service transaction data to obtain first batch data of full accounts in the preset time period; reading first real-time data of full accounts at the end of the preset time period in the temporary table, comparing the first batch data and the first real-time data of the same account, and screening out first difference accounts different from the first batch data and the first real-time data; judging whether the proportion of the first difference accounts in the full accounts is less than a preset proportion threshold; if yes, reading second service transaction data of the first difference accounts in the preset time period in the service transaction database, performing a real-time deduction calculation process of the second service transaction data to obtain second real-time data of the first difference accounts in the preset time period, and writing the second real-time data in the temporary table after deleting the data of the first difference accounts in the temporary table; if no, writing the first batch data in the temporary table after deleting the data of the full accounts in the temporary table.

2. The method of claim 1, wherein, After the judgment of whether the proportion of the first difference accounts in the full accounts is less than the preset proportion threshold, the method further comprises: writing the data of the temporary table in the service transaction database.

3. The method of claim 1, wherein, After the reading of the first real-time data of full accounts at the end of the preset time period in the temporary table, the comparison of the first batch data and the first real-time data of the same account, and the screening out of the first difference accounts different from the first batch data and the first real-time data, the method further comprises: judging whether the first difference accounts are screened out; if yes, issuing an alarm.

4. The method according to any one of claims 1 to 3, characterized in that, A natural month is composed of one or at least one non-overlapping preset time period.

5. The method of claim 3, wherein, judging whether the first difference accounts are screened out in a continuous preset number of natural months; if no, writing the third real-time data in the service transaction database from the next natural month; correspondingly, after the performance of the real-time deduction calculation process of the third service transaction data to obtain the third real-time data of data variation, the method further comprises: reading fourth service transaction data of full accounts in a current natural day in the service transaction database; performing a batch deduction calculation process of the fourth service transaction data to obtain second batch data of full accounts in the current natural day; reading fourth real-time data of full accounts at the end of the current natural day in the service transaction database; comparing the second batch data and the fourth real-time data of the same account; judging whether second difference accounts different from the second batch data and the fourth real-time data are screened out; if yes, issuing an alarm.

6. A telecommunications enterprise billing system characterized by, The method comprises: a second data processing module configured to receive a prompt message sent by the service transaction database, the prompt message comprising a third service transaction data position of data variation; According to the prompt message, reading the third business transaction data in the business transaction database; performing a real-time deduction calculation process of the third business transaction data to obtain third real-time data of data variation; and writing the third real-time data in a temporary table; The first data processing module is configured to read first business transaction data of full-amount accounts in a preset time period in the business transaction database, perform a batch deduction calculation process of the first business transaction data, and obtain first batch data of the full-amount accounts in the preset time period; The first batch data is written in the temporary table; The second data processing module is further configured to read second business transaction data of first difference accounts in the preset time period in the business transaction database, perform a real-time deduction calculation process of the second business transaction data, obtain second real-time data of the first difference accounts in the preset time period, and write the second real-time data in the temporary table; The third data processing module is configured to read the first real-time data of the full-amount accounts in the temporary table, compare the first batch data and the first real-time data of the same account, and filter out first difference accounts different from the first batch data and the first real-time data; determine whether a proportion of the first difference accounts in the full-amount accounts is less than a preset proportion threshold; if yes, read second business transaction data of the first difference accounts in the preset time period in the business transaction database, perform a real-time deduction calculation process of the second business transaction data, obtain second real-time data of the first difference accounts in the preset time period, and write the second real-time data in the temporary table after deleting data of the first difference accounts in the temporary table; and if no, write the first batch data in the temporary table after deleting data of the full-amount accounts in the temporary table.

7. An electronic device, comprising: Comprise: A processor and a memory connected with the processor in communication; The memory stores computer execution instructions; The processor executes the computer execution instructions stored in the memory to implement the method of any one of claims 1 to 5.

8. A computer-readable storage medium, characterized in that, The computer readable storage medium stores computer execution instructions, and the computer execution instructions are executed by the processor to implement the method of any one of claims 1 to 5.

Images