Data auditing method, device and storage medium

By auditing product information and tariff order information of preset audit points for migration data, the problem of low data audit quality in the existing technology is solved, and efficient and accurate data migration and billing is achieved.

CN115099839BActive Publication Date: 2025-08-01CHINA UNITED NETWORK COMM GRP CO LTD
View PDF 2 Cites 0 Cited by

Patent Information

Application Number
CN202210360410.1
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2022-04-07
Publication Date
2025-08-01
Estimated Expiration
2042-04-07

AI Technical Summary

Technical Problem

The existing data auditing methods rely on manual auditing to risk omission and errors, and the coverage of automatic auditing is narrow, which cannot guarantee the quality and efficiency of data migration.

Method used

By obtaining the data to be migrated, the product information and tariff ordering information are audited according to the preset audit points, including product tariff correspondence, traffic outer cover, voice outer cover, traffic carryover, campus community configuration and tariff event parameters, etc., an audit result table is generated to ensure data accuracy.

Benefits of technology

It improves the accuracy of data audits, reduces manual resources, improves the efficiency and accuracy of data migration, ensures the accuracy of billing, and avoids user complaints.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN115099839B_ABST
    Figure CN115099839B_ABST
Patent Text Reader

Abstract

A data auditing method, device, and storage medium provided by this application obtain the data of the system to be migrated, then audit the product information in the data according to preset audit points to obtain the audit result of the product information, and store the audit result of the product information in the audit result table. Then, audit the user's tariff subscription information to obtain the audit result of the tariff subscription information, and store the audit result of the tariff subscription information in the audit result table. Auditing the product data ensures the accuracy of data auditing, reduces human resources, and improves the efficiency of data auditing.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] This application relates to the technical field of data auditing, and in particular, to a data auditing method, apparatus, and storage medium. Background Art

[0002] With the rapid development of the Internet, major operators have vigorously built a national business centralized system to improve the support capabilities and business development of each branch system. The user data of each branch system needs to be migrated to the national business centralized system. Data auditing is an important link in the migration of user data of branch systems, which can avoid situations such as missing subscription information of users during the data migration process, so that users cannot carry out business normally.

[0003] Currently, the existing data auditing methods mainly rely on manual auditing, and most of the automatic auditing methods can only audit the basic user information.

[0004] Manual auditing makes there is a risk of omission and error in the auditing process, unable to guarantee the quality, and the process is cumbersome and consumes a large amount of labor and costs. In the automatic auditing methods, the types of audited data are single, that is, only a part of the data can be automatically audited, such as the basic user information, which also makes the auditing quality unable to be guaranteed. Summary of the Invention

[0005] This application provides a data auditing method, apparatus, and storage medium to solve the problem that the auditing quality cannot be guaranteed by manual auditing and automatic auditing methods.

[0006] In a first aspect, this application provides a data auditing method, including:

[0007] Obtain the data to be migrated, where the data includes product information of the branch system and tariff subscription information of the user;

[0008] Audit the product information according to preset audit points to obtain a product information audit result, and store the product information audit result in an audit result table;

[0009] Audit the tariff subscription information to obtain a tariff subscription information audit result, and store the tariff subscription information audit result in the audit result table.

[0010] Optionally, the product information includes each tariff event of the product, and the auditing of the product information according to preset audit points includes:

[0011] Audit each tariff event according to the preset audit points, and the preset audit points include one or more of the following audit points: product tariff correspondence audit point, out-of-package traffic audit point, out-of-package voice audit point, traffic rollover audit point, campus community configuration audit point, and tariff event parameter audit point.

[0012] Optionally, the auditing of the tariff subscription information includes:

[0013] Checking whether the tariff event types are repeated;

[0014] Checking whether the user has out-of-package resources;

[0015] Checking whether there are repeated subscriptions;

[0016] Checking the community business parameters.

[0017] Optionally, it further includes:

[0018] Judging whether the auditing results in the auditing result table are normal;

[0019] When there are no abnormalities in the auditing results in the auditing result table, output a message indicating that the inspection results are normal. The auditing results include the auditing results of the product information and the auditing results of the tariff subscription information;

[0020] When there are abnormalities in the data in the auditing result table, output a message indicating that the inspection results are abnormal. The message indicating that the inspection results are abnormal includes the product information and the self-paid subscription information where the abnormalities occur.

[0021] Optionally, after outputting a message indicating that the inspection results are normal when there are no abnormalities in the data in the auditing result table, it further includes:

[0022] When the user data migration is completed, obtain the pre-billing monthly settlement fees of each user for whom the data migration is completed from the business centralized system. The pre-billing monthly settlement fees are calculated by the business centralized system based on the relevant data of the user at a preset time every month, and the preset time is before the monthly settlement billing time every month;

[0023] Audit the pre-billing monthly settlement fees according to preset fee auditing points to obtain a verification result. The preset fee auditing points include auditing points for users with unbilled fees, auditing points for users with abnormal ARPU, auditing points for users whose pre-billing fees exceed a preset threshold, auditing points for users with pre-billing fees of 0, and auditing points for users with negative fees;

[0024] When the verification result includes the user information corresponding to the preset fee auditing points, output fee abnormality information, which is used to instruct the system data migration personnel to perform data repair according to the verification result.

[0025] In a second aspect, the present application provides a data auditing device, including:

[0026] An acquisition module, configured to acquire the data to be migrated, where the data includes the product information of the branch system and the tariff subscription information of the user;

[0027] The first processing module is used to audit the product information according to preset audit points, obtain the audit result of the product information, and store the audit result of the product information in the audit result table;

[0028] The second processing module is used to audit the tariff subscription information, obtain the audit result of the tariff subscription information, and store the audit result of the tariff subscription information in the audit result table.

[0029] Optionally, each tariff event of the product is included in the product information, and the first processing module is specifically used for:

[0030] Auditing each tariff event according to the preset audit points, where the preset audit points include one or more of the following audit points: product tariff correspondence audit point, out-of-package traffic audit point, out-of-package voice audit point, traffic rollover audit point, campus community configuration audit point, and tariff event parameter audit point.

[0031] Optionally, the second processing module is specifically used for:

[0032] Checking whether the tariff event types are repeated;

[0033] Checking whether the user has out-of-package resources;

[0034] Checking whether there are repeated subscriptions;

[0035] Checking the community business parameters.

[0036] In a third aspect, the present application provides a data auditing device, including: a processor, and a memory communicatively connected to the processor;

[0037] The memory stores computer execution instructions;

[0038] The processor executes the computer execution instructions stored in the memory to implement the method as described in the first aspect.

[0039] In a fourth aspect, the present application provides a computer-readable storage medium, where computer execution instructions are stored in the computer-readable storage medium, and when the computer execution instructions are executed by a processor, they are used to implement the method as described in the first aspect.

[0040] In a fifth aspect, the present application provides a computer program product, including a computer program, and when the computer program is executed by a processor, it implements the method as described in the first aspect.

[0041] A data auditing method, device, and storage medium provided by this application obtain the data of the system to be migrated, then audit the product information in the data according to preset audit points to obtain the product information audit result, and store the product information audit result in the audit result table. Then, audit the user's tariff subscription information to obtain the tariff subscription information audit result, and store the tariff subscription information audit result in the audit result table. Auditing the product data ensures the accuracy of data auditing, reduces human resources, and improves the efficiency of data auditing. BRIEF DESCRIPTION OF THE DRAWINGS

[0042] The accompanying drawings herein are incorporated into and constitute a part of this specification, showing embodiments consistent with this application, and are used together with the specification to explain the principles of this application.

[0043] Figure 1 It is a schematic diagram of an application scenario applicable to this application;

[0044] Figure 2 It is a schematic flowchart of a data auditing method provided in Embodiment 1 of this application;

[0045] Figure 3 It is a schematic flowchart of the decision-making on the audit result in Embodiment 1 of this application;

[0046] Figure 4 It is a signaling flowchart of a data auditing method provided in Embodiment 2 of this application;

[0047] Figure 5 It is a schematic structural diagram of a data auditing device provided in Embodiment 3 of this application;

[0048] Figure 6 It is a schematic structural diagram of a data auditing device provided in Embodiment 4 of this application.

[0049] Through the above-mentioned accompanying drawings, the clear embodiments of this application have been shown, and there will be more detailed descriptions hereinafter. These drawings and text descriptions are not intended to limit the scope of the concept of this application in any way, but to illustrate the concept of this application to those skilled in the art by referring to specific embodiments. DETAILED DESCRIPTION OF THE EMBODIMENTS

[0050] Here, the exemplary embodiments will be described in detail, and the examples are shown in the accompanying drawings. When the following description refers to the accompanying drawings, unless otherwise indicated, the same numbers 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. On the contrary, they are only examples of devices and methods consistent with some aspects of this application as detailed in the appended claims.

[0051] Currently, the existing data auditing methods mainly rely on manual auditing. Most of the automatic auditing methods audit the user's basic information, etc., without considering whether the user's business is satisfied. Moreover, due to human reasons, there are risks of omission and error during the auditing process, and the quality cannot be guaranteed. Also, due to the large amount of data and the large number of business sub-modules involved in the business centralized system, the workload of manual auditing has been continuously increased, and it is impossible to ensure that all data is audited. The situation of human misoperation or missed auditing is inevitable. Currently, in addition to the existing manual auditing methods, there are also some automatic auditing methods, but the auditing means are single, and the product information of the branch system and the user's tariff subscription information, etc., are not considered, and the auditing coverage is narrow, which also makes the auditing quality unable to be guaranteed.

[0052] Therefore, the present application provides a data auditing method, device, and storage medium to perform business auditing on the user data to be migrated, that is, to audit the user product information in the user data according to the preset audit points, and then audit the product tariff information in the user data. The auditing of the product data ensures the accuracy of data auditing, reduces human resources, improves the efficiency of data auditing, and can also judge whether to perform data migration based on the auditing results, thereby improving the accuracy of data migration.

[0053] Figure 1 It is a schematic diagram of an application scenario applicable to the present application. As Figure 1 shown, the branch system 101 is the system where the data to be migrated is located, and the business centralized system 102 is the system where the data to be migrated is to be migrated. The data auditing server 103 obtains the data to be migrated from the branch system through the Internet and stores the data in the auditing database, and then performs data auditing on the data to be migrated in the database, that is, audits the user product information in the user data according to the preset audit points, and performs anomaly point auditing on the product tariff information in the user data to obtain the auditing result. The data auditing server 103 can judge whether to perform data migration based on the auditing result. When the auditing result is okay, the data migration personnel can migrate the data to be migrated from the branch system 101 to the business centralized system 102 through the data migration tool. It can be understood that the number of the branch system 101, the business centralized system 102, and the data auditing server 103 can all be multiple, which are not shown in the figure.

[0054] The following uses specific embodiments to elaborate in detail on the technical solution of the present application and how the technical solution of the present application solves the above technical problems. These several specific embodiments can exist independently or be combined with each other. For the same or similar concepts or processes, they may not be repeated in some embodiments. The following will describe the embodiments of the present application in conjunction with the drawings.

[0055] Refer to Figure 2 ,Figure 2 The flowchart of a data auditing method provided in the first embodiment of this application. This method can be executed by a data auditing device, which is the data auditing server 103 in Figure 1 and the method includes the following steps.

[0056] S201. Obtain user data to be migrated, where the user data includes user product information and the product tariff information of the user.

[0057] Migrate the user data of the branch system (such as the provincial company) to the business centralized system (such as the national business centralized system), that is, perform cutover on the user data. Before data migration, it is necessary to audit the data to be migrated, that is, inspect and verify, to ensure that the migrated data does not have errors and affect the billing of user services, etc.

[0058] The server can obtain the user data to be migrated from the branch system. Specifically, the server can obtain the user data from the branch system through the spark engine.

[0059] After the server obtains the data to be migrated, it can store the data in the distributed file system HDFS (Hadoop Distributed File System, abbreviated as HDFS), and then synchronize the data to the auditing database for storage to perform data auditing. Or, the data can be directly stored in the auditing database. It can be understood that the data to be migrated is in batches, that is, the data of the branch system is cut over in batches.

[0060] S202. Audit the product information according to preset audit points to obtain the product information audit result, and store the product information audit result in the audit result table.

[0061] After obtaining the data to be migrated, the server audits the product information of the branch system in the data according to preset audit points. The product information includes various tariff events corresponding to the product. For example, each tariff event can be voice, traffic, SMS, MMS, etc., and each tariff event can be packaged into a tariff, and the tariff can be packaged into one product or multiple products, that is, it can be understood that one product includes multiple tariff events.

[0062] It should be noted that auditing according to preset audit points can be understood as before data migration, when the server makes corresponding data according to the data of the branch system and the requirements of the business centralized system (such as data type, etc.), auditing the data of the branch system and the corresponding data made to avoid omission or error of the data migrated to the business centralized system.

[0063] The preset audit points include one or more of the following audit points: product tariff correspondence audit point, out-of-bundle traffic audit point, out-of-bundle voice audit point, traffic rollover audit point, campus community configuration audit point, tariff event parameter audit point, tariff integrity audit point.

[0064] Among them, the product tariff correspondence audit point: checks the correspondence between the product and each tariff event corresponding to the product, whether there is a corresponding error, that is, checks whether there are missing or redundant tariff events in the product, so as to avoid that the composition of the tariff events affects the billing during the user's use of the product after data migration, causing customer complaints.

[0065] The traffic rollover audit point: checks whether the traffic in the product is configured for rollover, and the traffic that is not used this month can be rolled over to the next month.

[0066] The campus community configuration audit point: checks whether the tariff events in the product are associated with the base stations of a certain campus community, that is, checks whether the tariff events in the product need to use tariff discounts within a certain campus community.

[0067] The tariff event parameter audit point: Since some tariff events are implemented through the business parameter passing method, that is, the package value of this tariff is passed through multiple tables by the business system, so check whether the tariff events in the product are configured with the tables related to business parameter passing.

[0068] The out-of-bundle traffic audit point: checks whether the user's product includes out-of-bundle traffic events.

[0069] The out-of-bundle voice audit point: checks whether the user's product includes out-of-bundle voice events.

[0070] After the server audits the user product information according to the above preset audit points, it can store the audit results corresponding to each audit point in the audit result table. Auditing multiple audit points can improve the accuracy of data auditing. Specifically, the audit result of an audit point without anomalies can be recorded as 1, and that with anomalies can be recorded as 0, or vice versa, or it can also be recorded as other symbols or words that can distinguish between anomalies and non-anomalies. This application does not limit this.

[0071] S203. Audit the tariff subscription information to obtain the audit result of the tariff subscription information, and store the audit result of the tariff subscription information in the audit result table.

[0072] After the server audits the product information, it audits the user's tariff subscription information. The tariff subscription information includes each tariff event in the product subscribed by the user, specifically including the following:

[0073] (1) Check whether the tariff event types are repeated. This auditing step is only applicable to products with monthly rent tariff events subscribed by users. It checks whether the field types of the monthly rent tariff events in all products subscribed by the user are consistent. If the field types of all monthly rent tariff events are consistent, it is considered abnormal. The purpose is to avoid affecting billing when the field types of monthly rent tariff events are consistent. For example, when a user subscribes to Product A and Product B, the monthly rent tariff event in Product A is 10 yuan, and the monthly rent tariff event in Product B is 20 yuan. If the field types of these two tariff events are consistent, the business concentration system will only bill one of them during billing, but in fact, both monthly rent tariff events should be billed simultaneously.

[0074] (2) Check whether the user has out-of-package resources, that is, check whether all products corresponding to the user include out-of-package events. For example, check whether all products of the user include out-of-package data events or out-of-package voice events. If not, it is considered abnormal.

[0075] (3) Check whether there is duplicate subscription. A product can only be subscribed once and cannot be subscribed multiple times simultaneously. For example, for products like the A King Card, only one can be subscribed, and it is not allowed to subscribe two A King Cards repeatedly.

[0076] (4) Check the community business parameters. If the tariff event in the product subscribed by the user requires business parameter transmission, then it is necessary to check whether the business parameters are transmitted according to the user. If the business parameter transmission cannot be carried out normally, the tariff event is considered abnormal.

[0077] It can be understood that the above auditing steps for tariff subscription information are not in a specific order. The server audits each tariff event in the tariff subscription information based on the above four points, which can make the data auditing more accurate.

[0078] After the server audits the user's tariff subscription relationship, it stores the results of each auditing step in the audit result table. Similarly, each audit result can be recorded as 1 for abnormal, 0 for no abnormality, or vice versa. It can also be recorded as other symbols or words that can distinguish between abnormality and non-abnormality. This audit result table can be used to determine whether to perform data migration and can also be used for other operations after data auditing.

[0079] After the server stores the audit results in the audit result table, the server can judge whether the audit results in the audit result table are normal. When all the data in the audit result table are normal, it outputs a message indicating that the inspection result is normal. The audit results include the audit results of product information and tariff subscription information. The message indicating that the inspection result is normal can be used to instruct the system data migration personnel to implement system migration.

[0080] When there are abnormalities in the audit results in the audit result table, an abnormal inspection result message is output, which includes the product information and self-paid subscription information where the abnormalities occur. This abnormal inspection result message can be used to instruct system data migration personnel to repair the data according to the abnormal information, improving the work efficiency of system data migration personnel. After the repair is completed, the audit is performed based on the repaired data.

[0081] When there are no abnormalities in the data in the audit result table and the server outputs a normal inspection result message, after the data migration is completed and before the monthly settlement and billing at the end of each month, the server obtains the pre-settlement monthly fees of each user for whom the data migration is completed from the business centralized system. The pre-settlement monthly fee is calculated by the billing module of the business centralized system at a preset time each month based on the relevant data of the user, and this preset time is before the monthly settlement and billing time at the end of each month. The server audits the pre-settlement monthly fees according to the preset fee audit points to obtain the verification results. The preset fee audit points include the audit point for users with unpaid fees, the audit point for users with abnormal Average Revenue Per User (ARPU), the audit point for users whose pre-settlement fees exceed the preset fee threshold, the audit point for users with pre-settlement fees of 0, and the audit point for users with negative fees. The preset fee threshold can be 600 yuan.

[0082] The description of the decision-making process for the audit results above can be referred to Figure 3 。

[0083] When the verification results include the user information corresponding to the preset fee audit points, the server outputs a fee abnormal information, which is used to instruct system data migration personnel to repair the data according to the verification results, so that even if there are abnormalities in the billing after the user data is migrated, the data can be repaired before the user receives the billing statement, achieving user imperceptibility and avoiding user complaints.

[0084] In this embodiment, by obtaining the data of the system to be migrated, then auditing the product information in the data according to the preset audit points to obtain the product information audit results, and storing the product information audit results in the audit result table. Then, the tariff subscription information of the user is audited to obtain the tariff subscription information audit results, and the tariff subscription information audit results are stored in the audit result table. The audit of the product data ensures the accuracy of the data audit, reduces human resources, and improves the efficiency of the data audit.

[0085] The following describes the interaction process between devices through Embodiment 2.

[0086] Reference Figure 4 , Figure 4This is a signaling flowchart of a data auditing method provided in the second embodiment of this application. Based on the first embodiment, this embodiment details the interaction process between devices, such as Figure 4 As shown, the method provided in this embodiment includes the following steps.

[0087] S401. The branch system sends the data to be migrated to the data auditing server.

[0088] This data includes the product information of the branch system and the tariff subscription information of the user.

[0089] S402. The data auditing server audits the data to be migrated to obtain an auditing result.

[0090] The server audits the product information according to the preset auditing points to obtain the product information auditing result, and audits the tariff subscription information for abnormal points to obtain the tariff subscription information auditing result. The preset auditing points include one or more of the following auditing points: product-tariff correspondence auditing point, out-of-package traffic auditing point, out-of-package voice auditing point, traffic rollover auditing point, campus community configuration auditing point, and tariff event parameter auditing point. For specific implementation, reference can be made to the first embodiment.

[0091] S403. The data auditing server stores the auditing result in the auditing result table.

[0092] The auditing result table can be used to determine whether to perform data migration.

[0093] S404. The data auditing server determines whether the auditing result in the auditing result table is normal.

[0094] The auditing result includes the product information auditing result and the tariff subscription information auditing result. When the auditing result is normal, step S405 is executed; when the auditing result is abnormal, step S406 is executed.

[0095] S405. The data auditing server outputs a message indicating that the inspection result is normal.

[0096] The message indicating that the inspection result is normal is used to instruct the system data migration personnel to perform data migration.

[0097] S406. The data auditing server outputs a message indicating that the inspection result is abnormal.

[0098] The message indicating that the inspection result is abnormal includes the abnormal product information and the self-paid subscription information in the abnormal message. The abnormal message can be used for the system data migration personnel to repair the data according to the abnormal information.

[0099] S407. The business concentration system sends the pre-billing monthly settlement fee to the data auditing server.

[0100] S408. The server audits the pre-billing monthly settlement fees according to the preset fee audit points to obtain the verification result.

[0101] The preset fee audit points include the user audit points for uncharged fees, the user audit points for abnormal ARPU, the user audit points for pre-billing fees exceeding the preset threshold, the user audit points for pre-billing zero fees, and the user audit points for negative fees.

[0102] S409. When the verification result includes the user information corresponding to the preset fee audit points, the data audit server outputs a fee anomaly message.

[0103] The fee anomaly information can be used to instruct the system data migration personnel to perform data repair according to the verification result.

[0104] In this embodiment, by obtaining the data of the system to be migrated, then auditing the product information and the tariff subscription information in the data to obtain the product information audit result and the tariff subscription information audit result, and storing the audit results in the audit result table, the accuracy of data audit is ensured, the human resources are reduced, and the efficiency of data audit is improved. Then, it is judged whether the audit results in the audit result table are normal, and relevant messages are output to instruct the system data migration personnel to perform data migration or data repair according to the messages, improving the accuracy of data migration. And the pre-billing monthly settlement fees obtained are audited according to the preset fee audit points, so that even if the billing is abnormal after the user data is migrated, data repair can be performed before the user receives the billing statement, realizing user imperceptibility and avoiding user complaints.

[0105] Reference Figure 5 , Figure 5 FIG. Figure 5 As shown in FIG., the apparatus 50 includes: an acquisition module 501, a first processing module 502, and a second processing module 503.

[0106] The acquisition module 501 is configured to acquire the data to be migrated, where the data includes the product information of the branch system and the tariff subscription information of the user.

[0107] The first processing module 502 is configured to audit the product information according to the preset audit points to obtain the product information audit result, and store the product information audit result in the audit result table.

[0108] The second processing module 503 is configured to audit the tariff subscription information to obtain the tariff subscription information audit result, and store the tariff subscription information audit result in the audit result table.

[0109] Optionally, the product information includes each tariff event of the product, and the first processing module 502 is specifically configured to:

[0110] Audit each tariff event according to the preset audit points, and the preset audit points include one or more of the following audit points: product tariff correspondence audit point, out-of-package traffic audit point, out-of-package voice audit point, traffic rollover audit point, campus community configuration audit point, and tariff event parameter audit point.

[0111] Optionally, the second processing module 503 is specifically configured to:

[0112] Check whether the tariff event types are repeated.

[0113] Check whether the user has out-of-package resources.

[0114] Check whether there are duplicate subscriptions.

[0115] Check the community business parameters.

[0116] Optionally, it further includes:

[0117] Judge whether the audit results in the audit result table are normal.

[0118] When there are no abnormalities in the audit results in the audit result table, output a message indicating that the inspection result is normal. The audit results include the audit results of product information and the audit results of tariff subscription information.

[0119] When there are abnormalities in the data in the audit result table, output a message indicating that the inspection result is abnormal. The message indicating that the inspection result is abnormal includes the product information and the self-paid subscription information where the abnormalities occur.

[0120] Optionally, after outputting a message indicating that the inspection result is normal when there are no abnormalities in the data in the audit result table, it further includes:

[0121] When the user data migration is completed, obtain the pre-billing monthly settlement fees of each user for whom the data migration is completed from the business centralized system. The pre-billing monthly settlement fees are calculated by the business centralized system based on the relevant data of the user at a preset time every month, and the preset time is before the monthly settlement billing time.

[0122] Audit the pre-billing monthly settlement fees according to the preset fee audit points to obtain a verification result. The preset fee audit points include the audit point for users with unbilled fees, the audit point for users with abnormal ARPU, the audit point for users whose pre-billing fees exceed the preset threshold, the audit point for users with pre-billing fees of 0, and the audit point for users with negative fees.

[0123] When the verification result includes the user information corresponding to the preset fee audit points, output fee exception information, which is used to instruct the system data migration personnel to perform data repair according to the verification result.

[0124] The device of this embodiment can be used to execute a data auditing method in Embodiment 1 or Embodiment 2. The specific implementation manners and technical effects are similar and will not be elaborated here.

[0125] Reference Figure 6 , Figure 6 is a schematic structural diagram of a data auditing device provided in Embodiment 4 of this application. As Figure 6 shown, the device 60 includes: a processor 601, a memory 602, and a transceiver 603. The processor 601 executes the computer-executable instructions stored in the memory 602 and controls the receiving and sending actions of the transceiver 603, so that at least one processor executes the method steps of a data auditing method in Embodiment 1 or Embodiment 2. The specific implementation manners and technical effects are similar and will not be elaborated here.

[0126] Embodiment 5 of this application provides a computer-readable storage medium. Computer-executable instructions are stored in the computer-readable storage medium. When the computer-executable instructions are executed by a processor, they are used to implement the method steps of a data auditing method in any one of the above Embodiment 1 or Embodiment 2. The specific implementation manners and technical effects are similar and will not be elaborated here.

[0127] Embodiment 6 of the present invention provides a computer program product, including a computer program. When the computer program is executed by a processor, it implements the method steps of a data auditing method in any one of the above Embodiment 1 or Embodiment 2. The specific implementation manners and technical effects are similar and will not be elaborated here.

[0128] After considering the specification and practicing the invention disclosed here, those skilled in the art will readily think of other implementation schemes of this application. This application is intended to cover any variations, uses, or adaptive changes of this application. These variations, uses, or adaptive changes follow the general principles of this application and include the common general knowledge or conventional technical means in the technical field not disclosed in this application. The specification and embodiments are only regarded as exemplary, and the true scope and spirit of this application are pointed out by the following claims.

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

Claims

1. A data auditing method, characterized in that, including: Obtain the data to be migrated, where the data includes product information of the branch system and tariff subscription information of users; Audit the product information according to preset audit points to obtain a product information audit result, and store the product information audit result in an audit result table; Audit the tariff subscription information to obtain a tariff subscription information audit result, and store the tariff subscription information audit result in the audit result table; After outputting a normal inspection result message when there is no abnormality in the data in the audit result table, it further includes: When the user data migration is completed, obtain the pre-billing monthly settlement fees of each user for whom the data migration is completed from the business centralized system. The pre-billing monthly settlement fees are calculated by the business centralized system based on the relevant data of the user at a preset time every month, and the preset time is before the monthly settlement and billing time; Audit the pre-billing monthly settlement fees according to preset fee audit points to obtain a verification result. The preset fee audit points include audit points for users with unbilled fees, audit points for users with abnormal average revenue per user (ARPU), audit points for users with pre-billing fees exceeding a preset threshold, audit points for users with pre-billing fees of 0, and audit points for users with negative fees; When the verification result includes user information corresponding to the preset fee audit points, output a fee abnormality message, which is used to instruct system data migration personnel to perform data repair according to the verification result.

2. The method according to claim 1, characterized in that The product information includes various tariff events of the product. Auditing the product information according to preset audit points includes: Audit each tariff event according to the preset audit points. The preset audit points include one or more of the following audit points: product tariff correspondence audit point, out-of-package traffic audit point, out-of-package voice audit point, traffic rollover audit point, campus community configuration audit point, and tariff event parameter audit point.

3. The method according to claim 1, characterized in that, Auditing the tariff subscription information includes: Check whether the tariff event types are repeated; Check whether the user has out-of-package resources; Check whether the subscriptions are repeated; Check the community business parameters.

4. The method according to any one of claims 1 to 3, characterized in that, It further includes: Judge whether the audit results in the audit result table are normal; When there is no abnormality in the audit results in the audit result table, output a normal inspection result message. The audit results include the product information audit result and the tariff subscription information audit result; When there is an abnormality in the data in the audit result table, output an abnormal inspection result message, and the abnormal inspection result message includes the abnormal product information and self-paid subscription information.

5. A data auditing device, characterized in that, including: An acquisition module for acquiring the data to be migrated, where the data includes product information of the branch system and tariff subscription information of users; A first processing module for auditing the product information according to preset audit points to obtain a product information audit result, and storing the product information audit result in an audit result table; A second processing module for auditing the tariff subscription information to obtain a tariff subscription information audit result, and storing the tariff subscription information audit result in the audit result table; After the data in the audit result tables of the first processing module and the second processing module are all normal and a normal inspection result message is output, it is further used for: When the user data migration is completed, obtain the pre-billing monthly settlement fees of each user for whom the data migration is completed from the business centralized system. The pre-billing monthly settlement fees are calculated by the business centralized system based on the relevant data of the user at a preset time every month, and the preset time is before the monthly settlement and billing time of each month; Audit the pre-billing monthly settlement fees according to preset fee audit points to obtain a verification result. The preset fee audit points include user audit points for users with unbilled fees, user audit points for abnormal average revenue per user (ARPU), user audit points for pre-billing fees exceeding a preset threshold, user audit points for users with pre-billing fees of 0, and user audit points for negative fees; When the verification result includes the user information corresponding to the preset fee audit points, output a fee anomaly information, which is used to instruct the system data migration personnel to perform data repair according to the verification result.

6. The device according to claim 5, characterized in that, The product information includes various tariff events of the product. The first processing module is specifically used for: Audit each tariff event according to the preset audit points, and the preset audit points include one or more of the following audit points: product tariff correspondence audit point, out-of-package traffic audit point, out-of-package voice audit point, traffic rollover audit point, campus community configuration audit point, and tariff event parameter audit point.

7. The device according to claim 5, characterized in that The second processing module is specifically used for: Check whether the tariff event types are repeated; Check whether the user has out-of-package resources; Check whether the subscriptions are repeated; Check the community business parameters.

8. A data auditing device, characterized in that, It includes: A processor and a memory communicatively connected to the processor; The memory stores computer execution instructions; The processor executes the computer execution instructions stored in the memory to implement the method according to any one of claims 1 to 4.

9. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores computer execution instructions, and when the computer execution instructions are executed by a processor, they are used to implement the method according to any one of claims 1 to 4.

Citation Information

Patent Citations

  • Automatic auditing method and device, equipment and storage medium

    CN110335022A

  • Charging system and method

    CN110706088A