CN115099839A - Data auditing method, device and storage medium - Google Patents
Data auditing method, device and storage medium Download PDFInfo
- Publication number
- CN115099839A CN115099839A CN202210360410.1A CN202210360410A CN115099839A CN 115099839 A CN115099839 A CN 115099839A CN 202210360410 A CN202210360410 A CN 202210360410A CN 115099839 A CN115099839 A CN 115099839A
- Authority
- CN
- China
- Prior art keywords
- auditing
- audit
- data
- result
- user
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q30/00—Commerce
- G06Q30/02—Marketing; Price estimation or determination; Fundraising
- G06Q30/0283—Price estimation or determination
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/214—Database migration support
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Business, Economics & Management (AREA)
- Databases & Information Systems (AREA)
- Development Economics (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Strategic Management (AREA)
- Entrepreneurship & Innovation (AREA)
- Game Theory and Decision Science (AREA)
- Economics (AREA)
- Marketing (AREA)
- General Business, Economics & Management (AREA)
- Software Systems (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
According to the data auditing method, the device and the storage medium, the data of the system to be migrated are obtained, then the product information in the data is audited according to the preset auditing point, the product information auditing result is obtained, and the product information auditing result is stored in the auditing result table. And then auditing the charge ordering information of the user to obtain a charge ordering information auditing result, and storing the charge ordering information auditing result into an auditing result table. The auditing of the product data ensures the accuracy of the data auditing, reduces the manual resources and improves the efficiency of the data auditing.
Description
Technical Field
The present application relates to the field of data auditing technologies, and in particular, to a data auditing method, apparatus, and storage medium.
Background
With the rapid development of the internet, all large operators are vigorously building a national service centralized system so as to improve the supporting capability and the service development of all branch systems. The user data of each branch system needs to be migrated to a national service centralized system, and data auditing is an important link of the user data migration of the branch systems, so that the situations of user ordering data loss and the like in the data migration process are avoided, and the users cannot normally develop services.
At present, the existing data auditing means mainly depend on manual auditing, and most of automatic auditing methods only can audit basic information of users.
In the automatic auditing method, the type of the audited data is single, namely only a part of data, such as user basic information, can be automatically audited, and the auditing quality cannot be guaranteed.
Disclosure of Invention
The application provides a data auditing method, a data auditing device and a storage medium, which are used for solving the problem that the auditing quality cannot be guaranteed by an artificial auditing method and an automatic auditing method.
In a first aspect, the present application provides a data auditing method, including:
acquiring data to be migrated, wherein the data comprises product information of a branch system and tariff ordering information of a user;
auditing the product information according to preset auditing points to obtain a product information auditing result, and storing the product information auditing result into an auditing result table;
auditing the charge ordering information to obtain a charge ordering information auditing result, and storing the charge ordering information auditing result into the auditing result table.
Optionally, the auditing the product information according to a preset auditing point includes:
auditing each tariff event according to the preset auditing points, wherein the preset auditing points comprise one or more of the following auditing points: the system comprises a product charge corresponding relation audit point, a flow external audit point, a voice external audit point, a flow transfer audit point, a campus cell configuration audit point and a charge event parameter audit point.
Optionally, the auditing the tariff subscription information includes:
checking whether the tariff event type is repeated;
checking whether the user has an out-of-sleeve resource;
checking whether the order is repeated;
cell business parameters are checked.
Optionally, the method further includes:
judging whether the audit result in the audit result table is normal or not;
when the audit results in the audit result table are not abnormal, outputting normal inspection result information, wherein the audit results comprise the product information audit results and the tariff ordering information audit results;
and when the data in the audit result table is abnormal, outputting an inspection result abnormal message, wherein the inspection result abnormal message comprises abnormal product information and self-fee ordering information.
Optionally, after the data in the audit result table is all abnormal and the check result normal message is output, the method further includes:
when the user data migration is completed, acquiring pre-expenditure monthly fees of each user after the data migration is completed from the business centralized system, wherein the pre-expenditure monthly fees are calculated by the business centralized system at a preset time of each month according to the relevant data of the user, and the preset time is before the time of paying out each month;
auditing the pre-payment monthly expense according to a preset expense auditing point to obtain a checking result, wherein the preset expense auditing point comprises a user auditing point of non-payment, a user auditing point of ARPU abnormality, a user auditing point of pre-payment expense exceeding a preset threshold, a user auditing point of pre-payment 0 expense and a user auditing point of negative expense;
and outputting expense abnormal information when the verification result comprises user information corresponding to the preset expense audit point, wherein the expense abnormal information is used for indicating system data migration personnel to carry out data restoration according to the verification result.
In a second aspect, the present application provides a data auditing apparatus, including:
the system comprises an acquisition module, a migration module and a migration module, wherein the acquisition module is used for acquiring data to be migrated, and the data comprises product information of a branch system and cost ordering information of a user;
the first processing module is used for auditing the product information according to preset auditing points to obtain a product information auditing result, and storing the product information auditing result into an auditing result table;
and the second processing module is used for auditing the charge ordering information to obtain a charge ordering information auditing result and storing the charge ordering information auditing result into the auditing result table.
Optionally, the product information includes each tariff event of the product, and the first processing module is specifically configured to:
auditing each tariff event according to the preset auditing points, wherein the preset auditing points comprise one or more of the following auditing points: the system comprises a product charge corresponding relation audit point, a flow external audit point, a voice external audit point, a flow transfer audit point, a campus cell configuration audit point and a charge event parameter audit point.
Optionally, the second processing module is specifically configured to:
checking whether the tariff event type is repeated;
checking whether the user has an out-of-sleeve resource;
checking whether the order is repeated;
cell operating parameters are checked.
In a third aspect, the present application provides a data auditing apparatus, including: a processor, and a memory communicatively coupled to the processor;
the memory stores computer execution instructions;
the processor executes computer-executable instructions stored by the memory to implement the method of the first aspect.
In a fourth aspect, the present application provides a computer-readable storage medium having stored thereon computer-executable instructions for implementing the method according to the first aspect when executed by a processor.
In a fifth aspect, the present application provides a computer program product comprising a computer program which, when executed by a processor, implements the method of the first aspect.
According to the data auditing method, the data auditing device and the storage medium, the data of the system to be migrated are acquired, then the product information in the data is audited according to the preset auditing points, the product information auditing result is acquired, and the product information auditing result is stored in the auditing result table. Then, the price ordering information of the user is audited to obtain a price ordering information auditing result, and the price ordering information auditing result is stored in an auditing result table. The auditing of the product data ensures the accuracy of the data auditing, reduces the manual resources and improves the efficiency of the data auditing.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the present application and together with the description, serve to explain the principles of the application.
Fig. 1 is a schematic diagram of an application scenario in which the present application is applicable;
FIG. 2 is a flowchart illustrating a data auditing method according to an embodiment of the present disclosure;
FIG. 3 is a flowchart illustrating a decision-making process for audit results according to an embodiment of the present disclosure;
fig. 4 is a signaling flowchart of a data auditing method according to a second embodiment of the present application;
FIG. 5 is a schematic structural diagram of a data auditing apparatus according to a third embodiment of the present application;
fig. 6 is a schematic structural diagram of a data auditing apparatus according to a fourth embodiment of the present application.
Specific embodiments of the present application have been shown by way of example in the drawings and will be described in more detail below. These drawings and written description are not intended to limit the scope of the inventive concepts in any manner, but rather to illustrate the inventive concepts to those skilled in the art by reference to specific embodiments.
Detailed Description
Reference will now be made in detail to the exemplary embodiments, examples of which are illustrated in the accompanying drawings. When the following description refers to the accompanying drawings, like numbers in different drawings represent the same or similar elements unless otherwise indicated. The implementations described in the following exemplary embodiments do not represent all implementations consistent with the present application. Rather, they are merely examples of apparatus and methods consistent with certain aspects of the present application, as detailed in the appended claims.
At present, the existing data auditing means mainly depend on manual auditing, most automatic auditing methods are used for auditing basic information of a user, whether the service of the user is met or not is not considered, the quality cannot be guaranteed due to missing error risks in the auditing process because of manual reasons, and the quality cannot be guaranteed because of large data quantity, more service centralized systems relate to service sub-modules, the workload of manual auditing is continuously increased, all data cannot be audited, and the condition of manual misoperation or audit omission cannot be avoided. At present, besides the existing manual auditing methods, some automatic auditing methods exist, but the auditing means is single, the product information of a branch system and the charge ordering information of a user are not considered, the auditing coverage is narrow, and the auditing quality can not be guaranteed.
Therefore, the application provides a data auditing method, a device and a storage medium, service auditing is carried out on user data to be migrated, namely user product information in the user data is audited according to a preset auditing point, then product charge information in the user data is audited, and the product data is audited, so that the accuracy of data auditing is ensured, manual resources are reduced, the efficiency of data auditing is improved, whether data migration is carried out or not can be judged according to an auditing result, and the accuracy of data migration is also improved.
Fig. 1 is a schematic diagram of an application scenario to which the present application is applied. As shown in fig. 1, the branch system 101 is a system where data to be migrated is located, the service centralized system 102 is a system where data to be migrated is migrated, the data audit server 103 obtains the data to be migrated from the branch system through the internet, stores the data in the audit database, and then performs data audit on the data to be migrated in the database, that is, user product information in the user data is audited according to a preset audit point, abnormal point audit is performed on product charge information in the user data to obtain an audit result, the data audit server 103 may determine whether to perform data migration based on the audit result, and when the audit result has no problem, the data migrator migrates the data to be migrated from the branch system 101 to the service centralized system 102 through the data migration tool. It is understood that the number of the branch systems 101, the traffic concentration system 102 and the data audit server 103 may be multiple, which is not shown in the figure.
The following describes the technical solutions of the present application and how to solve the above technical problems with specific embodiments. The following embodiments may exist independently or in combination, and the same or similar concepts or processes may not be described in detail in some embodiments. Embodiments of the present application will be described below with reference to the accompanying drawings.
Referring to fig. 2, fig. 2 is a flowchart illustrating a data auditing method according to an embodiment of the present application, which can be executed by a data auditing device, that is, the data auditing server 103 in fig. 1, and the method includes the following steps.
S201, user data to be migrated is obtained, and the user data comprises user product information and product charge information of a user.
User data of a branch system (such as a province company) is migrated to a service centralized system (such as a national service centralized system), that is, the user data is cut over, and before data migration, data to be migrated needs to be audited, that is, audited and audited, so as to ensure that errors do not occur in the migrated data, and charging of user services and the like are not affected.
The server may obtain the user data to be migrated from the branch system, and specifically, the server may obtain the user data from the branch system through the spark engine.
After the server obtains the data to be migrated, the data may be stored in a Distributed File System HDFS (HDFS for short), and then the data is synchronized to an audit database for storage to perform data audit. Alternatively, the data may be stored directly into the audit database. It is understood that the data to be migrated is in bulk, i.e., a batch cut of data for the branch system.
S202, auditing the product information according to the preset auditing points to obtain a product information auditing result, and storing the product information auditing result into an auditing result table.
After the data to be migrated is obtained, the server audits the product information of the branch system in the data according to a preset audit point, wherein the product information comprises each tariff event corresponding to a product, for example, each tariff event can be voice, flow, short message, multimedia message and the like, each tariff event can be packaged into a tariff, and the tariff can be packaged into one product or a plurality of products, that is, one product can be understood to comprise a plurality of tariff events.
It should be noted that, auditing is performed according to the preset auditing point, which can be understood as that before data migration, when the server creates corresponding data according to the data of the branch system and the requirement (for example, data type) of the service centralized system, corresponding auditing is performed on the data of the branch system and the created corresponding data, so as to avoid missing or error of the data migrated to the service centralized system.
The preset audit points comprise one or more of the following audit points: a product charge corresponding relation audit point, a flow rate external audit point, a voice external audit point, a flow rate transfer audit point, a campus cell configuration audit point, a charge event parameter audit point and a charge integrity audit point.
Wherein, the product charge corresponding relation check point is as follows: checking the corresponding relation between the product and each tariff event corresponding to the product, and whether a corresponding error condition exists, namely checking whether the tariff event in the product is missing or redundant, so as to avoid that the composition of the tariff event influences the charging and causes the complaint of a client in the process of using the product by a user after data migration.
Flow rate transition check point: checking whether the flow in the product is configured to carry out conversion, and converting the flow into the flow which is not used in the month can carry out conversion to the next month.
Configuring an audit point in a campus cell: and checking whether the tariff event in the product is related to a base station of a certain campus cell, namely checking whether the tariff event in the product needs to use a tariff advantage in a certain campus cell.
And (3) auditing parameters of the charge events: because some tariff events are realized through a business parameter transmission mode, namely the package value of the tariff is transmitted through a plurality of tables through a business system, whether the tariff events in the product are configured with the tables related to the business parameter transmission is checked.
Flow rate external audit point: it is checked whether a flow out-of-sleeve event is included in the user's product.
Voice-over external audit point: it is checked whether a voice out-of-cover event is included in the user's product.
After the server audits the user product information according to the preset audit points, the audit results corresponding to the audit points can be stored in the audit result table, and the audit points are audited, so that the accuracy of data audit can be improved. Specifically, the audit result of the audit point without the exception may be recorded as 1, and the audit result with the exception may be recorded as 0, or vice versa, or may be recorded as other symbols or characters that can distinguish whether the exception exists, which is not limited in this application.
S203, auditing the charge ordering information to obtain a charge ordering information auditing result, and storing the charge ordering information auditing result into an auditing result table.
After auditing the product information, the server audits the charge ordering information of the user, wherein the charge ordering information comprises each charge event in the product ordered by the user, and the charge ordering information specifically comprises the following steps:
(1) checking whether the types of the charging events are repeated, wherein the auditing step only aims at the products ordered by the user and having monthly charging events, and is to check whether the field types of the monthly charging events in all the products ordered by the user are consistent, if so, the field types of the monthly charging events are abnormal. The purpose is to avoid influencing the charging when the field types of the monthly rental charging events are consistent, for example, when the product A and the product B ordered by the user are the product A with 10 yuan for the monthly rental charging event and the product B with 20 yuan for the monthly rental charging event, if the field types of the two charging events are consistent, the service centralized system charges only one of the charging events, but actually charges the two monthly rental charging events at the same time.
(2) Whether the user has the out-of-cover resource is checked, that is, whether the out-of-cover event is included in all the products corresponding to the user is checked, for example, whether the flow out-of-cover event or the voice out-of-cover event is included in all the products of the user is checked, and if not, the exception is determined.
(3) Checking whether the ordering is repeated, one product can only be ordered, and a plurality of products cannot be ordered simultaneously, for example, for the product of the A king card, only one product can be ordered, and two A king cards cannot be ordered repeatedly.
(4) And checking the business parameters of the cell, if the tariff event in the product ordered by the user needs business transfer, checking whether the business parameters are transferred according to the user, and if the business transfer cannot be performed normally, determining that the tariff event is abnormal.
It can be understood that the above auditing steps for the fee ordering information are not in sequence. The server audits each charge event in the charge ordering information based on the four points, so that the data audit is more accurate.
After the server audits the charge ordering relationship of the user, the result of each auditing step is stored in an auditing result table, and similarly, each auditing result can be recorded as 1, and the abnormal result can be recorded as 0, or conversely, or can be recorded as other symbols or characters which can distinguish whether abnormal results exist. The audit result table can be used for judging whether to perform data migration or not and can also be used for other operations after data audit.
After the server stores the audit result into the audit result table, the server can judge whether the audit result in the audit result table is normal, and when the data in the audit result table are not abnormal, the server outputs a check result normal message, wherein the audit result comprises a product information audit result and a charge ordering information audit result. The check result normal message may be used to instruct system data migration personnel to perform system migration.
And when the audit result in the audit result table is abnormal, outputting an abnormal inspection result message, wherein the abnormal inspection result message comprises abnormal product information and self-fee ordering information. The abnormal information of the inspection result can be used for indicating system data migration personnel to carry out data restoration according to the abnormal information, and the working efficiency of the system data migration personnel is improved. And after the repair is finished, auditing is carried out based on the repaired data.
And after the server outputs a normal inspection result message and data migration is completed, before monthly account balance of each month, the server acquires pre-account balance charges of each user after the data migration is completed from the service centralized system, wherein the pre-account balance charges are calculated by a charging module of the service centralized system according to the relevant data of the user at preset time of each month, and the preset time is before monthly account balance time of each month. The server checks the pre-paid monthly payment according to a preset payment check point to obtain a check result, wherein the preset payment check point comprises a User check point with no payment, a User check point with abnormal Average income ARPU (Average income Per User, ARPU for short), a User check point with pre-paid payment exceeding a preset payment threshold, a User check point with pre-paid payment 0 payment and a User check point with negative payment, and the preset payment threshold can be 600 yuan.
The above description of the decision flow of the audit result can refer to fig. 3.
When the verification result comprises user information corresponding to the preset expense audit point, the server outputs expense abnormal information which is used for indicating system data migration personnel to carry out data restoration according to the verification result, so that even if the charging is abnormal after the user data migration, the data restoration can be carried out before the user receives a charging bill, the user does not feel, and the complaint of the user is avoided.
In the embodiment, the data of the system to be migrated is acquired, then the product information in the data is audited according to the preset audit point, so that a product information audit result is obtained, and the product information audit result is stored in the audit result table. And then auditing the charge ordering information of the user to obtain a charge ordering information auditing result, and storing the charge ordering information auditing result into an auditing result table. The auditing of the product data ensures the accuracy of the data auditing, reduces the manual resources and improves the efficiency of the data auditing.
The following describes an interaction process between devices through embodiment two.
Referring to fig. 4, fig. 4 is a signaling flowchart of a data auditing method provided in a second embodiment of the present application, and in this embodiment, an interaction process between devices is described in detail on the basis of the first embodiment, as shown in fig. 4, the method provided in this embodiment includes the following steps.
S401, the branch system sends data to be migrated to the data auditing server.
The data includes product information of the branch system and tariff ordering information of the user.
S402, the data auditing server audits the data to be migrated to obtain an auditing result.
The server audits the product information according to preset audit points to obtain a product information audit result, and performs abnormal point audit on the charge ordering information to obtain a charge ordering information audit result, wherein the preset audit points comprise one or more of the following audit points: the specific implementation of the method can refer to the first embodiment, where the method includes a product charge correspondence audit point, a traffic external audit point, a voice external audit point, a traffic transit audit point, a campus cell configuration audit point, and a charge event parameter audit point.
S403, the data auditing server stores the auditing result into an auditing result table.
The audit result table can be used for judging whether to perform data migration.
S404, the data auditing server judges whether the auditing result in the auditing result table is normal or not.
The audit result comprises a product information audit result and a charge ordering information audit result. If the audit result is normal, go to step S405, and if the audit result is abnormal, go to step S406.
S405, the data auditing server outputs a normal checking result message.
And the normal message of the inspection result is used for indicating a system data migration person to implement data migration.
S406, the data auditing server outputs an abnormal message of the checking result.
The abnormal information of the inspection result comprises abnormal product information and self-fee ordering information, and the abnormal information can be used for system data migration personnel to carry out data restoration according to the abnormal information.
S407, the service centralized system sends pre-billed monthly fees to the data auditing server.
S408, the server audits the pre-paid monthly fee according to the pre-set fee audit point to obtain a check result.
The preset expense audit points comprise user audit points with outstanding expenses, abnormal ARPU user audit points, user audit points with outstanding expenses exceeding a preset threshold value, user audit points with outstanding expenses of 0 and user audit points with negative expenses.
S409, when the verification result comprises user information corresponding to the preset expense audit point, the data audit server outputs expense abnormal information.
The abnormal expense information can be used for indicating a system data migration person to carry out data restoration according to the verification result.
In the embodiment, the data of the system to be migrated is acquired, the product information and the charge ordering information in the data are audited to obtain the product information auditing result and the charge ordering information auditing result, and the auditing result is stored in the auditing result table, so that the accuracy of data auditing is ensured, the manual resources are reduced, and the efficiency of data auditing is improved. And then judging whether the audit result in the audit result table is normal or not, and outputting related information to instruct system data migration personnel to implement data migration or data repair according to the information, so that the accuracy of data migration is improved. And moreover, the acquired monthly charges of the pre-paid accounts are audited according to a preset charge audit point, so that even if abnormal charging occurs after the user data is migrated, data can be restored before the user receives a charging bill, the user can not feel the user, and complaints of the user are avoided.
Referring to fig. 5, fig. 5 is a schematic structural diagram of a data auditing apparatus according to a third embodiment of the present application. As shown in fig. 5, the apparatus 50 includes: an acquisition module 501, a first processing module 502 and a second processing module 503.
An obtaining module 501, configured to obtain data to be migrated, where the data includes product information of a branch system and cost ordering information of a user.
The first processing module 502 is configured to audit the product information according to a preset audit point, obtain a product information audit result, and store the product information audit result in an audit result table.
The second processing module 503 is configured to audit the charge subscription information, obtain a charge subscription information audit result, and store the charge subscription information audit result in the audit result table.
Optionally, the product information includes each tariff event of the product, and the first processing module 502 is specifically configured to:
auditing each tariff event according to a preset audit point, wherein the preset audit point comprises one or more of the following audit points: the system comprises a product charge corresponding relation audit point, a flow external audit point, a voice external audit point, a flow transfer audit point, a campus cell configuration audit point and a charge event parameter audit point.
Optionally, the second processing module 503 is specifically configured to:
it is checked whether the tariff event type is repeated.
Checking whether the user has the out-of-sleeve resource.
It is checked whether the subscription is repeated.
Cell business parameters are checked.
Optionally, the method further includes:
and judging whether the audit result in the audit result table is normal or not.
And when the audit results in the audit result table are abnormal, outputting normal information of the inspection results, wherein the audit results comprise product information audit results and charge ordering information audit results.
And when the data in the audit result table is abnormal, outputting an inspection result abnormal message, wherein the inspection result abnormal message comprises abnormal product information and self-fee ordering information.
Optionally, when none of the data in the audit result table is abnormal, after outputting the message that the inspection result is normal, the method further includes:
when the user data migration is completed, acquiring pre-expenditure monthly fees of each user after the data migration is completed from the business centralized system, wherein the pre-expenditure monthly fees are calculated by the business centralized system at preset time of each month according to the relevant data of the user, and the preset time is before the time of the monthly expenditure.
And auditing the pre-paid monthly charges according to a preset charge auditing point to obtain a checking result, wherein the preset charge auditing point comprises a user auditing point of non-paid charges, a user auditing point of ARPU abnormity, a user auditing point of pre-paid charges exceeding a preset threshold value, a user auditing point of pre-paid charges 0 and a user auditing point of negative charges.
And outputting cost abnormal information when the verification result comprises user information corresponding to the preset cost audit point, wherein the cost abnormal information is used for indicating a system data migration worker to carry out data restoration according to the verification result.
The device of this embodiment may be used to execute the data auditing method of the first embodiment or the second embodiment, and the specific implementation manner and the technical effect are similar, which are not described herein again.
Referring to fig. 6, fig. 6 is a schematic structural diagram of a data auditing apparatus according to a fourth embodiment of the present application. As shown in fig. 6, the apparatus 60 includes: the processor 601, the memory 602, and the transceiver 603, where the processor 601 executes the computer execution instruction stored in the memory 602, and controls the receiving action and the sending action of the transceiver 603, so that at least one processor executes the method steps for data auditing in the first embodiment or the second embodiment, and the specific implementation and technical effects are similar, and are not described herein again.
A fifth embodiment of the present application provides a computer-readable storage medium, where a computer-executable instruction is stored in the computer-readable storage medium, and when the computer-executable instruction is executed by a processor, the computer-executable instruction is used to implement the steps of the data auditing method according to any one of the first embodiment or the second embodiment, and the specific implementation manner and the technical effect are similar, and are not described herein again.
A sixth embodiment of the present invention provides a computer program product, including a computer program, where when the computer program is executed by a processor, the method for auditing data according to any one of the first embodiment or the second embodiment is implemented, and the specific implementation manner and technical effects are similar, which are not described herein again.
Other embodiments of the present application will be apparent to those skilled in the art from consideration of the specification and practice of the invention disclosed herein. This application is intended to cover any variations, uses, or adaptations of the invention following, in general, the principles of the application and including such departures from the present disclosure as come within known or customary practice within the art to which the invention pertains. It is intended that the specification and examples be considered as exemplary only, with a true scope and spirit of the application being indicated by the following claims.
It will be understood that the present application is not limited to the precise arrangements that have been described above and shown in the drawings, and that various modifications and changes may be made without departing from the scope thereof. The scope of the application is limited only by the appended claims.
Claims (10)
1. A data auditing method, comprising:
acquiring data to be migrated, wherein the data comprises product information of a branch system and tariff ordering information of a user;
auditing the product information according to preset auditing points to obtain a product information auditing result, and storing the product information auditing result into an auditing result table;
auditing the charge ordering information to obtain a charge ordering information auditing result, and storing the charge ordering information auditing result into the auditing result table.
2. The method of claim 1, wherein the product information includes cost events of products, and the auditing the product information according to a predetermined audit point includes:
auditing each tariff event according to the preset auditing points, wherein the preset auditing points comprise one or more of the following auditing points: the system comprises a product charge corresponding relation audit point, a flow external audit point, a voice external audit point, a flow transfer audit point, a campus cell configuration audit point and a charge event parameter audit point.
3. The method of claim 1, wherein auditing the tariff subscription information comprises:
checking whether the tariff event type is repeated;
checking whether the user has an out-of-sleeve resource;
checking whether the order is repeated;
cell business parameters are checked.
4. The method of any one of claims 1-3, further comprising:
judging whether the audit result in the audit result table is normal or not;
when the audit results in the audit result table are not abnormal, outputting normal inspection result information, wherein the audit results comprise the product information audit results and the tariff ordering information audit results;
and when the data in the audit result table is abnormal, outputting an inspection result abnormal message, wherein the inspection result abnormal message comprises abnormal product information and self-fee ordering information.
5. The method as claimed in claim 4, wherein when none of the data in the audit result table is abnormal, after outputting the check result normal message, the method further comprises:
when the user data migration is completed, acquiring pre-charge monthly fees of each user for which the data migration is completed from the service centralized system, wherein the pre-charge monthly fees are calculated by the service centralized system according to the relevant data of the user at the preset time of each month, and the preset time is before the time of the monthly charge;
auditing the pre-expenditure monthly expense according to a preset expense auditing point to obtain a checking result, wherein the preset expense auditing point comprises a user auditing point of non-expenditure, a user auditing point of abnormal average income ARPU of each user, a user auditing point of which the pre-expenditure expense exceeds a preset threshold value, a user auditing point of pre-expenditure 0 expense and a user auditing point of negative expense;
and outputting cost abnormal information when the verification result comprises user information corresponding to the preset cost audit point, wherein the cost abnormal information is used for indicating a system data migration worker to carry out data restoration according to the verification result.
6. A data auditing apparatus, comprising:
the system comprises an acquisition module, a migration module and a migration module, wherein the acquisition module is used for acquiring data to be migrated, and the data comprises product information of a branch system and cost ordering information of a user;
the first processing module is used for auditing the product information according to preset auditing points to obtain a product information auditing result, and storing the product information auditing result into an auditing result table;
and the second processing module is used for auditing the charge ordering information to obtain a charge ordering information auditing result and storing the charge ordering information auditing result into the auditing result table.
7. The apparatus according to claim 6, wherein the product information includes respective tariff events for the product, and the first processing module is specifically configured to:
auditing each tariff event according to the preset auditing points, wherein the preset auditing points comprise one or more of the following auditing points: the system comprises a product charge corresponding relation audit point, a flow external audit point, a voice external audit point, a flow transfer audit point, a campus cell configuration audit point and a charge event parameter audit point.
8. The apparatus of claim 6, wherein the second processing module is specifically configured to:
checking whether the tariff event type is repeated;
checking whether the user has an out-of-sleeve resource;
checking whether the order is repeated;
cell business parameters are checked.
9. A data auditing apparatus, comprising: a processor, and a memory communicatively coupled to the processor;
the memory stores computer-executable instructions;
the processor executes computer-executable instructions stored by the memory to implement the method of any of claims 1 to 5.
10. A computer-readable storage medium having computer-executable instructions stored therein, which when executed by a processor, are configured to implement the method of any one of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210360410.1A CN115099839A (en) | 2022-04-07 | 2022-04-07 | Data auditing method, device and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210360410.1A CN115099839A (en) | 2022-04-07 | 2022-04-07 | Data auditing method, device and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN115099839A true CN115099839A (en) | 2022-09-23 |
Family
ID=83287101
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210360410.1A Pending CN115099839A (en) | 2022-04-07 | 2022-04-07 | Data auditing method, device and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115099839A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115967654A (en) * | 2022-11-24 | 2023-04-14 | 浪潮通信信息系统有限公司 | Service data auditing method and device, electronic equipment and storage medium |
| CN116645230A (en) * | 2023-06-06 | 2023-08-25 | 中国铁塔股份有限公司成都市分公司 | Management method and terminal equipment for full flow of tent of communication base station |
-
2022
- 2022-04-07 CN CN202210360410.1A patent/CN115099839A/en active Pending
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115967654A (en) * | 2022-11-24 | 2023-04-14 | 浪潮通信信息系统有限公司 | Service data auditing method and device, electronic equipment and storage medium |
| CN116645230A (en) * | 2023-06-06 | 2023-08-25 | 中国铁塔股份有限公司成都市分公司 | Management method and terminal equipment for full flow of tent of communication base station |
| CN116645230B (en) * | 2023-06-06 | 2024-04-16 | 中国铁塔股份有限公司成都市分公司 | Management method and terminal equipment for full flow of tent of communication base station |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US6636585B2 (en) | Metrics-related testing of an operational support system (OSS) of an incumbent provider for compliance with a regulatory scheme | |
| CN115099839A (en) | Data auditing method, device and storage medium | |
| CN111240983A (en) | Method and device for realizing automatic test of telecommunication charging service | |
| CN109760985B (en) | Method and device for material circulation checking, electronic equipment and readable storage medium | |
| CN108632047B (en) | Method and device for determining tariff data | |
| CN105553677A (en) | Charging verification audit system | |
| CN107194627A (en) | Expense report checking method and device | |
| CN110827168A (en) | Electric quantity data processing method based on block chain and electronic equipment | |
| CN108123810A (en) | A kind of error bills processing method and processing device | |
| CN108075911B (en) | Service testing method and device | |
| US8660917B2 (en) | Multipoint billing quality control and certification | |
| CN110827007A (en) | Block chain-based electric charge settlement method, electronic equipment and storage device | |
| CN112036836B (en) | Service opening method, system and equipment | |
| CN115150764B (en) | Tariff configuration method, tariff configuration device, tariff configuration equipment and tariff configuration medium | |
| CN111651345A (en) | System testing method and device and electronic equipment | |
| CN117522612A (en) | Communication expense reimbursement method, equipment and medium based on RPA | |
| CN111163428A (en) | Method and server for generating short message bill | |
| CN1322706C (en) | Method of realizing real time segmental charging | |
| TWM580754U (en) | Payment entry checking system | |
| CN113743894B (en) | Method and system for establishing rechecking rule model for rechecking electric bill | |
| CN104219064B (en) | charging method and device | |
| CN116645230B (en) | Management method and terminal equipment for full flow of tent of communication base station | |
| CN105722048A (en) | Charging method and equipment for online charging system | |
| CN112132645A (en) | Method and system for verifying similar elements of tariff configuration template | |
| CN113824847B (en) | Method and device for determining charging abnormality, computing equipment and computer storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |