CN110335022A - Automatic audit method, device, equipment and storage medium - Google Patents

Abstract

The embodiment of the present application provides a kind of automatic auditing method, device, equipment and storage medium, this method comprises: obtaining the subscriber data of user to be audited；According to the characteristic information of centralized traffic support system, configurable data of checking are determined, it is described to check data for checking to the subscriber data of the user to be audited；The subscriber data of the user to be audited is checked that data are compared with described, obtains not passing through the data checked in the subscriber data of the user to be audited.What method provided by the embodiments of the present application can overcome the prior art checks mode waste of manpower and resource, and not can guarantee the problem of checking quality.

Description

Automatic audit method, device, equipment and storage medium

technical field

The embodiments of the present application relate to the technical field of computer technology, and in particular to an automatic audit method, device, equipment, and storage medium.

Background technique

In the implementation process of the migration project of the centralized business support system, the most important part is to audit the user data of the pre-migrated to the centralized business support system in each province, so as to prevent the migrated users from being able to carry out business normally and lack of order information , resulting in user complaints.

At present, the audit actions of all existing applications are manually completed. On the one hand, the process is cumbersome and consumes a lot of labor and time costs, and there is a risk of missing audits in manual audit operations, which makes it impossible to evaluate and monitor the audit quality; on the other hand, With the expansion of the application, the complexity and workload will continue to increase, and human misoperation or missing audit will inevitably appear, which will reduce the quality of migration and delay the completion time of migration.

Therefore, manual verification cannot guarantee full coverage of audit points. For example, the auditor cannot think of auditing the problem before encountering the corresponding problem. Therefore, the audit method in the prior art wastes manpower and resources, and cannot guarantee the audit quality.

Contents of the invention

The embodiments of the present application provide an automatic auditing method, device, equipment and storage medium to overcome the problems that the auditing methods in the prior art waste manpower and resources and cannot guarantee the auditing quality.

In the first aspect, the embodiment of the present application provides an automatic audit method, including:

Obtain the user information of the user to be audited;

Determine configurable audit data according to the feature information of the centralized business support system, and the audit data is used to audit the user data of the user to be audited;

Comparing the user profile of the user to be audited with the audit data to obtain the data that failed the audit in the user profile of the user to be audited.

In a possible design, before acquiring the user information of the user to be audited, the method further includes:

receiving user profiles of multiple users to be migrated sent by business systems in each region, where the multiple users to be migrated are users to be migrated to the centralized business support system;

storing the user identifiers in the user profiles of the multiple users to be migrated into a preset user table;

Read each user ID from the preset user table, and obtain the user profile of the user to be migrated corresponding to each user ID according to each user ID;

Finding the subscription service information of each user to be migrated in the centralized service support system from the user profile of the user to be migrated corresponding to each user identifier;

According to the preset migration mapping table, determine the initial subscription service information of the user to be migrated corresponding to each user identifier in the centralized service support system, and the initial subscription service information is for each user to be migrated in Order business information in the business system of the region;

According to the subscription service information and initial subscription service information of each of the multiple users to be migrated, determine the users among the multiple users to be migrated that are eligible for migration to the centralized service support system, and transfer all the users to the centralized service support system Among the multiple users to be migrated, the users who are eligible to be migrated to the centralized business support system are used as the users to be audited;

According to the user to be audited, the preset user table is updated, and the user information of the user to be audited is stored in a database.

In a possible design, the determination of configurable audit data according to the characteristic information of the centralized business support system includes:

According to multiple service categories in the centralized service support system, configurable service information corresponding to each service category is determined, and the service information is the audit data.

In a possible design, the user profile of the user to be audited is compared with the audit data to obtain the data that failed the audit in the user profile of the user to be audited, including:

Comparing the user profile of the user to be audited with the business information, verifying the integrity of the user profile, and obtaining data in the user profile that failed the audit; and/or,

Verifying whether the ordering service information in the user profile conforms to the ordering service information in the service information, and obtaining data in the user profile that has not passed the audit.

In a possible design, after obtaining the data in the user profile that fails the audit, the method further includes:

Store the data that fails the audit in the user profile of the user to be audited in a log file, and send the log file to the terminal of the maintenance personnel, so that the maintenance personnel can determine whether to maintain User information of the user to be audited.

In the second aspect, the embodiment of the present application provides an automatic auditing device, including:

The first obtaining module is used to obtain the user information of the user to be audited;

The audit data determination module is used to determine configurable audit data according to the characteristic information of the centralized business support system, and the audit data is used to audit the user data of the user to be audited;

An audit module, configured to compare the user profile of the user to be audited with the audit data, and obtain the data in the user profile of the user to be audited that failed the audit.

In a possible design, the device further includes: a receiving module, a user identification storage module, a second acquisition module, a subscription service information search module, an initial subscription service information determination module, a user pending audit determination module, and an update module;

The receiving module is configured to receive user information of multiple users to be migrated sent by business systems in various regions before acquiring the user information of users to be audited. users in the system;

The user identification storage module is configured to store the user identifications in the user profiles of the plurality of users to be migrated into a preset user table;

The second acquisition module is configured to read each user ID from the preset user table, and acquire the user profile of the user to be migrated corresponding to each user ID according to each user ID;

The ordering service information search module is configured to search for the ordering service information of each user to be migrated in the centralized service support system from the user profile of the user to be migrated corresponding to each user ID;

The initial order service information determination module is configured to determine the initial order service information of the user to be migrated corresponding to each user ID in the centralized service support system according to a preset migration mapping table, the initial order The business information is the subscription business information of each user to be migrated in the business system of the region;

The user-to-be-audited determination module is configured to determine, according to the subscription service information and initial subscription service information of each of the multiple users to be migrated, among the multiple users to be migrated that they are eligible to be migrated to the For the users in the centralized business support system, users among the multiple users to be migrated who are eligible to be migrated to the centralized business support system are taken as the users to be audited;

An update module, configured to update the preset user table according to the user to be audited, and store the user information of the user to be audited in a database.

In a possible design, the audit data determination module is specifically configured to: determine the configurable business information corresponding to each business category according to multiple business categories in the centralized business support system, and the business information is The audit data.

In a third aspect, an embodiment of the present application provides an automatic auditing device, including: at least one processor and a memory;

the memory stores computer-executable instructions;

The at least one processor executes the computer-executed instructions stored in the memory, so that the at least one processor executes the automatic auditing method described in the first aspect and various possible designs of the first aspect.

In the fourth aspect, the embodiment of the present application provides a computer-readable storage medium, the computer-readable storage medium stores computer-executable instructions, and when the processor executes the computer-executable instructions, the above first aspect and the first Aspects of various possible designs for the automated auditing method described.

The automatic audit method, device, equipment and storage medium provided by this embodiment first obtains the user information of the user to be audited, and starts to automatically audit the user information of the user to be audited, and judges whether the user to be audited meets the centralized business support system, and then according to the characteristic information of the centralized business support system, determine that the configurable audit data is the audit point, which is used to audit the user data of the user to be audited, and then compare the user data of the user to be audited with the The audit data is compared to obtain the data that failed the audit in the user profile of the user to be audited, which can realize the process of automatic audit. In this solution, in the automatic audit method, the user information of the user to be audited is obtained, and then according to the configurable audit data, the user information of the user to be audited is compared with the audit data, and the user information of the user to be audited is obtained. For the data that has not passed the audit, the audit data can be configured and modified during the automatic audit process, which is flexible and easy to operate, and the automatic audit can save manpower and resources, and at the same time ensure the audit quality.

Description of drawings

In order to more clearly illustrate the technical solutions in the embodiments of the present application or the prior art, the following will briefly introduce the drawings that need to be used in the description of the embodiments or the prior art. Obviously, the accompanying drawings in the following description These are some embodiments of the present application. Those skilled in the art can also obtain other drawings based on these drawings without any creative effort.

Fig. 1 is a schematic flow chart of the automatic audit method provided by the embodiment of the present application;

FIG. 2 is a schematic flow chart of an automatic audit method provided in another embodiment of the present application;

Fig. 3 is a schematic structural diagram of the automatic auditing device provided by the embodiment of the present application;

FIG. 4 is a schematic structural diagram of an automatic auditing device provided by an embodiment of the present application.

Detailed ways

In order to make the purposes, technical solutions and advantages of the embodiments of the present application clearer, the technical solutions in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described embodiments It is a part of the embodiments of this application, not all of them. Based on the embodiments in this application, all other embodiments obtained by persons of ordinary skill in the art without creative efforts fall within the protection scope of this application.

The terms "first", "second", "third", "fourth", etc. (if any) in the description and claims of this application and the above drawings are used to distinguish similar objects and not necessarily Describe a particular order or sequence. It is to be understood that the data so used are interchangeable under appropriate circumstances such that the embodiments of the application described herein, for example, can be practiced in sequences other than those illustrated or described herein. Furthermore, the terms "comprising" and "having", as well as any variations thereof, are intended to cover a non-exclusive inclusion, for example, a process, method, system, product or device comprising a sequence of steps or elements is not necessarily limited to the expressly listed instead, may include other steps or elements not explicitly listed or inherent to the process, method, product or apparatus.

Fig. 1 is a schematic flow chart of the automatic audit method provided by the embodiment of this application. The execution subject of this embodiment is a server, which may also be an automatic audit device, or a plug-in or tool in the database. This embodiment does not limit the execution subject, the user information of the user to be audited can be obtained from the database through the server, or the automatic audit device can obtain the user information of the user to be audited from the database through the communication interface, or through a plug-in or The tool obtains user information and so on from the path where the user to be audited is stored in the database.

In practical application, in the implementation process of Centralized Business Support System (CBSS) migration project, the most important part is to check whether the user data in each region (each province) pre-migrated to CBSS conforms to the logic of CBSS, so as to avoid migration The transferred (migrated) users cannot carry out business normally, and the order information (order business information) is missing, causing user complaints and other problems. Through the following automatic audit method, the audit of user information can be automatically realized.

Referring to Fig. 1, the automatic audit method includes:

S101. Obtain user information of a user to be audited.

In this embodiment, the user information of the user to be audited is stored in the database. The user to be audited can be multiple and come from each province. Each user to be audited corresponds to a set of user information, and the user information can include user Identification, subscription service information, and information associated with the subscription service (that is, other service information bound to the subscription service), for example, if a certain service package is a broadband package, it needs to be bound to a mobile phone service package under the relevant tariff conditions. Since the execution subject is not limited, there are many ways to obtain the user information of the user to be audited: the user information of the user to be audited can be obtained from the database through the server, or the automatic audit device can be obtained from the database through the communication interface The user information of the user to be audited can also be obtained from the path of the user to be audited in the database through a plug-in or tool.

S102. Determine configurable audit data according to the feature information of the centralized service support system, where the audit data is used to audit the user profile of the user to be audited.

In this embodiment, since each user to be audited is an individual, the services ordered may also be different, so the audit data that needs to be audited on the user data of the user to be audited is also different. At the same time, for different time periods, the centralized The business support system is also constantly updated, therefore, audit data needs to be configurable, that is, the audit data can be continuously updated and changed, and the audit data is determined according to the characteristic information of the centralized business support system, and the user to be audited The audit data can also be determined according to the obtained user information of the user to be audited combined with the characteristic information of the centralized business support system, so as to realize the flexibility and real-time performance of the audit, so as to make the audit result more accurate.

Among them, the audit data is stored in the configuration file, and the auditor can implement the audit of user data by importing the user ID into the audit interface during the actual audit process. The audit data may include order service information corresponding to each service category in the centralized service support system and information associated with order service information.

S103. Compare the user information of the user to be audited with the audit data, and obtain the data that failed the audit in the user information of the user to be audited.

In this embodiment, in the actual audit process, it is necessary to compare the user information of the user to be audited with the audit data one by one to determine whether the user to be audited lost data during the migration process or the user to be audited The user profile for is missing. And record the data that has not passed the audit in the user information of the user to be audited, so that the auditors can perform follow-up operations, such as summarizing the places that are prone to problems during the migration process or which provinces are likely to have incomplete or lost data.

The automatic audit method provided by this embodiment first obtains the user information of the user to be audited, starts to automatically audit the user information of the user to be audited, judges whether the user to be audited conforms to the centralized business support system, and then according to the centralized business support The characteristic information of the system, the configurable audit data is determined to be the audit point, which is used to audit the user data of the user to be audited, and then compare the user data of the user to be audited with the audit data to obtain The data that fails to pass the audit in the user profile of the user to be audited can realize the automatic audit process. In this solution, in the automatic audit method, the user information of the user to be audited is obtained, and then according to the configurable audit data, the user information of the user to be audited is compared with the audit data, and the user information of the user to be audited is obtained. For the data that has not passed the audit, the audit data can be configured and modified during the automatic audit process, which is flexible and easy to operate, and the automatic audit can save manpower and resources, and at the same time ensure the audit quality.

FIG. 2 is a schematic flowchart of an automatic audit method provided by another embodiment of the present application. This embodiment is based on the embodiment described in FIG. 1 , and this embodiment describes the automatic audit method in detail before step S101. As shown in Figure 2, before the acquisition of the user profile of the user to be audited, the method also includes:

S201. Receive user information of multiple users to be migrated sent by service systems in various regions, where the multiple users to be migrated are users to be migrated to a centralized service support system.

In this embodiment, before obtaining the users to be audited, it is necessary to determine the users who are suitable for migration to the centralized business support system from the users to be migrated. First, it is necessary to obtain user information of multiple users to be migrated from each province or receive The user data of multiple users to be migrated sent by the business system of the business system, where each province can migrate the user data of multiple users to be migrated to the centralized business support system, and each user to be migrated is to be migrated to the centralized business support system , and cache the user profiles of the multiple users to be migrated in the database.

S202. Store the user identifiers in the user profiles of the multiple users to be migrated into a preset user table.

In this embodiment, in order to conveniently query the user profile of each user to be migrated among the multiple users to be migrated, the user identification in the user profile uploaded by each province may be stored in a preset user table in the database, The user identifier can be a user number. Due to the uniqueness of the user number, the corresponding user information can be obtained through the user number, avoiding searching for a user information of a user to be migrated from a large number of user information.

S203. Read each user ID from the preset user table, and acquire the user profile of the user to be migrated corresponding to each user ID according to each user ID.

In this embodiment, if you want to obtain the user information of the user to be migrated corresponding to each user ID, you need to read each user ID from the preset user table, that is, you need to get all the users uploaded from a certain province When obtaining information, it is necessary to obtain all user information corresponding to the province from the database cache according to the user number of the province recorded in the user list. For example, each user number corresponds to a user information acquisition path. According to the acquisition path, you can obtain Required user profile.

S204. Search the subscription service information of each user to be migrated in the centralized service support system from the user profile of the user to be migrated corresponding to each user identifier.

In this embodiment, before the user to be audited is audited, the user to be migrated needs to be audited for ordering business, and it is determined whether the user to be migrated to the centralized business support system meets the business requirements of the centralized business support system, such as , the subscription service information of the user to be migrated in the centralized service support system is the subscription relationship, for example, the subscription package service.

S205. According to the preset migration mapping table, determine the initial subscription service information of the user to be migrated corresponding to each user ID in the centralized service support system, and the initial subscription service information is for each of the to-be-migrated users The user's subscription business information in the business system of the region.

In this embodiment, since the user profiles of multiple users to be migrated from each province are received, the user profiles have already been transferred in the file format, and the default migration mapping table stores the ordering services of the corresponding provinces of the users to be migrated The mapping relationship between the information and the subscription service information of the user to be migrated to the side of the centralized service support system. For example, according to the preset migration mapping table, if a user to be migrated ordered a package A in the province, it is the initial order service information of the user to be migrated in the business system of the region, and the actual needs to be migrated to the centralized The package B in the business support system is the subscription service information of the user to be migrated in the centralized business support system.

S206. According to the subscription service information and initial subscription service information of each of the multiple users to be migrated, determine users among the multiple users to be migrated that are eligible for migration to the centralized service support system, Among the multiple users to be migrated, the users who are eligible to be migrated to the centralized service support system are taken as the users to be audited.

In this embodiment, it is judged whether the subscription service information of each of the multiple users to be migrated is consistent with the initial subscription service information, if each of one or some of the users to be migrated If the subscription service information is consistent with the initial subscription service information, it means that one or some users to be migrated are eligible to be migrated to the centralized service support system. For example, according to the preset migration mapping table, if a user to be migrated ordered a package A in the province, it is the initial order service information of the user to be migrated in the business system of the region, and the actual needs to be migrated to the centralized The B package in the business support system is the subscription service information of the user to be migrated in the centralized business support system. At this time, according to the preset migration mapping table, the B package is actually corresponding to the preset migration mapping table The ordering service information on the province side is A, so the user to be migrated conforms to the ordering service information in the centralized business support system.

In practical applications, according to the preset migration mapping table corresponding to each province, the user number is read from the preset user table, and the order relationship on the province side in the corresponding user profile is obtained according to the user number, and the user is on the CBSS side (the The expected ordering service information in the user profile of the user to be migrated on the centralized business support system side) is compared with the ordering service information in the corresponding user profile that is actually implemented (in the database), and the difference is obtained and corrected. Or, specifically, obtain the order relationship (order business information) of the user to be migrated on the BSS side from the province side, and then associate the product mapping relationship between the BSS side and the CBSS side (preset migration mapping table) to obtain the migration The user's expected ordering relationship on the CBSS side (initial ordering business information), and then obtain the real ordering relationship on the CBSS side of the user to be migrated (ordering business information stored in the database), and compare the expected ordering relationship with the real ordering relationship , find the difference.

S207. Update the preset user table according to the user to be audited, and store the user information of the user to be audited in a database.

In this embodiment, the auditing of the user data of the users to be audited facilitates the screening of users who do not comply with the CBSS system and determines the users to be audited, avoiding detailed auditing of users who do not comply with the migration to the CBSS system and wasting audit time. According to the user to be audited, update the preset user table, delete the user who does not meet the migration to the centralized business support system from the preset user list, no longer perform user data audit on the deleted user, and delete all users The user information of the user to be audited is stored in the database, which is convenient for accurately obtaining the user information of the user to be audited and performing the audit operation.

In a possible design, on the basis of the foregoing embodiments, for example, on the basis of the embodiment shown in FIG. 1 , step S102 is described in detail in this embodiment. The determining the configurable audit data according to the feature information of the centralized business support system includes: determining the configurable business information corresponding to each business category according to multiple business categories in the centralized business support system, the business information For the audit data.

In this embodiment, since each user to be audited is an individual, the services ordered may also be different, so the audit data that needs to be audited on the user data of the user to be audited is also different. At the same time, for different time periods, the centralized The business support system is also constantly updated, therefore, audit data needs to be configurable, that is, the audit data can be continuously updated and changed, and the audit data is determined according to the characteristic information of the centralized business support system, and the user to be audited The audit data can also be determined according to the obtained user information of the user to be audited combined with the characteristic information of the centralized business support system, so as to realize the flexibility and real-time performance of the audit, so as to make the audit result more accurate.

Among them, the type that can support automatic audit is the audit data, which can be at least one of the following: the record of user profile TF_BH_TRADE 4444, the data related to TF_F_USER, the record of whether REMOVE_TAG is equal to X, the record of whether ACCT_TAG is equal to 2, the TF_F_USER table, TF_F_USER_PRODUCT表、TF_F_USER_INFOCHANGE表PRODUCT_ID不一致，TF_F_USE表USER_STATE_CODESET与TF_F_USER_SVCSTATE STATE_CODE是否一致，TF_F_USER表TF_F_USER_INFOCHANGE表BRAND_CODE是否一致，TF_F_USER表CITY_CODE是否在TD_M_AREA表中，TF_F_USER表IS_TRANSMIT属性生效日期不是次月1号，用户IPTV服务是否Has the service attribute iptvnbr, whether the broadband INSTALL_ADDRESS attribute is empty, whether the broadband rate attribute value matches the current product, whether the effective date of the main product is the first of the next month, whether there is a tariff corresponding to the product in TF_F_USER_PRODUCT table 00, and whether there is an annual subscription adStart attribute value, whether there is a lowCost attribute in the premium account, whether the traffic reminder service 50300 has a remindMethod attribute, whether the effective date of the message billing service 50312 is on the first day of the next month, whether there is data in TF_A_PAYRELATION, whether there is data in TF_F_TRADE_PRODUCT, whether the data in the TF_F_USER_LIST_CRM table is normal , Whether TF_R_SIMCARD_USE has sim_card_code=4 data, whether the user information conforms to the product tree structure, check whether the product ordered by the user depends on the product not ordered, check whether the package ordered by the user depends on the package not ordered, check Check whether the elements ordered by the user are dependent on the elements not ordered, check whether there is a mutually exclusive relationship between the products, packages, and elements ordered by the user, whether the package under the product must be ordered, and whether the maximum and minimum values of the package under the product are Conformity, whether the maximum and minimum values of the elements under the package are consistent, check whether there is ti_bh_bss_cb state='1' but there is remove_tag='X' data in the tf_f_user table, for all users, the user_state_codeset of the user table and the state_code of the tf_f_user_svcstate table are inconsistent Check whether the account management and the total number of business transfers are consistent, whether the transfer number has a reservation effective route, whether the subscription business information of BSS and CBSS is consistent, and whether the number belongs to the customer in the province and the CBSS belongs to the customer It is the same certificate type and the same name—provided by each province (the format is the number, certificate type, certificate number, customer type, customer name, province code, real name system identification).

In a possible design, on the basis of the foregoing embodiments, this embodiment describes step S103 in detail. Comparing the user profile of the user to be audited with the audit data to obtain the data that failed the audit in the user profile of the user to be audited, including: comparing the user profile of the user to be audited with the business information Perform a comparison, verify the integrity of the user profile, and obtain the data in the user profile that has not passed the audit; and/or, check whether the order service information in the user profile conforms to the order service information in the service information information to obtain the data that failed the audit in the user profile.

In this embodiment, comparing the user profile of the user to be audited with the audit data includes: comparing the user profile of the user to be audited with the business information, and/or verifying the Whether the subscription service information in the user profile conforms to the subscription service information in the business information.

Among them, comparing the user information of the user to be audited with the business information is to check the integrity of the user information of each user to be audited: check whether the user information meets the system requirements of CBSS, such as TF_F_USER table, TF_F_USER_PRODUCT table 、 The PRODUCT_ID in the TF_F_USER_INFOCHANGE table is inconsistent, whether the USER_STATE_CODESET in the TF_F_USE table is consistent with the TF_F_USER_SVCSTATE STATE_CODE, whether the BRAND_CODE in the TF_F_USER table TF_F_USER_INFOCHANGE table is consistent, whether the CITY_CODE in the TF_F_USER table is in the service date number in the TD_M_AREA table, whether the TF_F_USER table has the IS_TRANSMIT service month attribute Attribute iptvnbr, whether the broadband INSTALL_ADDRESS attribute is empty, whether the broadband rate attribute value matches the current product, whether the effective date of the main product is the 1st of the next month, whether there is a tariff corresponding to the product in TF_F_USER_PRODUCT table 00, whether the annual subscription has the adStart attribute Value, whether there is a lowCost attribute in the premium account, whether the traffic reminder service 50300 has the reminderMethod attribute, whether the effective date of the message billing service 50312 is on the 1st of the next month, whether there is data in TF_A_PAYRELATION, whether there is data in TF_F_TRADE_PRODUCT, whether the data in the TF_F_USER_LIST_CRM table is normal, and TF_R_SIMCARD_USE Whether there are requirements such as sim_card_code=4 data, etc., and obtain the data that failed the audit in the user profile.

In addition, verifying whether the ordering business information in the user profile conforms to the ordering business information in the business information is to check the logic of the user's product: get the provincial side product according to the ordering business information in the user profile of the user to be audited Information (business information), check whether the parameter information of the product is consistent with the user information, specifically whether the user information conforms to the product tree structure, verify whether the product ordered by the user has no dependent product ordered, and verify the package ordered by the user Whether the dependent packages are not ordered, check whether the elements ordered by the user are not ordered, check whether there is a mutually exclusive relationship among the products, packages, and elements ordered by the user, whether the packages under the product are mandatory To order, whether the maximum and minimum values of the package of the product meet, whether the maximum and minimum values of the package elements meet, and obtain the data that failed the audit in the user profile.

In a possible design, on the basis of the foregoing embodiments, this embodiment describes in detail the automatic audit method after step S103. After obtaining the failed audit data in the user profile, the method further includes: storing the failed audit data in the user profile of the user to be audited in a log file, and sending the log file to to the terminal of the maintenance personnel, so that the maintenance personnel can determine whether to maintain the user profile of the user to be audited according to the data that fails the audit.

In this embodiment, in order to make it easier for maintenance personnel or auditors to inquire about and solve problems, all users to be audited who have failed the audit can be counted, and for each user to be audited among all users to be audited who have not passed the audit, the The data that fails to pass the audit in the user profile of each user to be audited is stored in the log file in the database, and the log file is sent to the terminal of the maintenance personnel, so that the maintenance personnel can Determining whether to maintain the user data of the user to be audited is to determine whether to return the user who failed the audit to the province or modify and store the user data of the user who failed the audit, which can ensure that the evaluation and monitoring of the audit quality can be carried out smoothly. accomplish.

Specifically, this solution can use the processing tools of the ORACLE database to make logical judgments and completeness checks on the read-in pre-migration user data. At the same time, new audit points can be added to easily realize the automatic audit of existing migration projects. , and is not limited to source systems (business systems in various provinces or regions), it can support the audit verification of any system user's migration to the CBSS system to improve the quality of migration, and can ensure the evaluation and monitoring of audit quality can be realized.

In practical applications, this application develops a fully automated audit tool, which is lightweight and scalable, and can improve the success rate and efficiency of user data cutover (transfer or migration) from other systems (various business systems) to the CBSS system . Through the application tool for ORACLE database, according to the user number, obtain the user's pre-cutover data in the CBSS system, including its order relationship and product structure, and then automatically check the data integrity and logical relationship of the cutover product according to the CBSS product data model At the same time, log files are generated, so that the automatic audit not only saves a lot of manpower, but also avoids the missed checks and mischecks of manual audits, ensuring the effectiveness and efficiency of audits. Through the operation information of log files, the quality of cutover audits is realized. evaluation and monitoring. The audit method is flexible and configurable, and can be adjusted at any time according to the model change of the CBSS system, which is convenient, instant and reliable.

FIG. 3 is a schematic structural diagram of an automatic auditing device provided by an embodiment of the present application. As shown in Figure 3, this automatic auditing device 30 comprises: the first acquisition module 301, audit data determination module 302, audit module 303; The first acquisition module 301 is used to obtain the user data of the user to be audited; , for determining configurable audit data according to the characteristic information of the centralized business support system, the audit data is used for auditing the user data of the user to be audited; the audit module 303 is used for The user profile is compared with the audit data to obtain the data that failed the audit in the user profile of the user to be audited.

The device provided in this embodiment can be used to implement the technical solution of the automatic audit method embodiment shown in FIG. 1 or 2 above. Its implementation principle and technical effect are similar, and will not be repeated in this embodiment.

In a possible design, the device further includes: a receiving module, a user identification storage module, a second acquisition module, an order service information search module, an initial order service information determination module, a user to be audited determination module, and an update module; The receiving module is used to receive the user data of multiple users to be migrated sent by the business systems in each region before the user data of the user to be audited is obtained, and the multiple users to be migrated are to be migrated to the centralized business support system the user in the user; the user ID storage module is used to store the user IDs in the user profiles of the multiple users to be migrated to the preset user table; the second acquisition module is used to obtain from the preset Each user ID is read in the user table, and according to each of the user IDs, the user profile of the user to be migrated corresponding to each of the user IDs is obtained; Find the subscription service information of each of the users to be migrated in the centralized service support system from the user profile of the corresponding user to be migrated; the initial subscription service information determination module is used to determine according to the preset migration mapping table The initial order service information of the user to be migrated in the centralized service support system corresponding to each user identifier, the initial order service information is the order of each user to be migrated in the business system in the region Business information; the user to be audited determination module is used to determine that among the multiple users to be migrated, the migration is eligible For the users in the centralized business support system, use the users among the multiple users to be migrated who are eligible to be migrated to the centralized business support system as the users to be audited; the update module is used to , updating the preset user table, and storing the user information of the user to be audited in the database.

In a possible design, the audit data determination module 302 is specifically configured to: determine the configurable business information corresponding to each business category according to multiple business categories in the centralized business support system, and the business information is The audit data.

In a possible design, the audit module 303 is specifically configured to: compare the user information of the user to be audited with the business information, verify the integrity of the user information, and obtain the user information and/or verify whether the ordering service information in the user profile matches the ordering service information in the business information, and obtain the data that has failed the audit in the user profile.

In a possible design, the automatic auditing device further includes: a storage module; the storage module is used to store the data of the user to be audited after obtaining the data that failed the audit in the user profile The data that fails the audit in the user profile is stored in the log file, and the log file is sent to the terminal of the maintenance personnel, so that the maintenance personnel can determine whether to maintain the user of the user to be audited based on the data that has failed the audit. material.

In practical applications, the automatic auditing device is used to obtain the user information of the user to be audited, start to automatically audit the user information of the user to be audited, judge whether the user to be audited is in line with the centralized business support system, and then according to the centralized business support The characteristic information of the system, the configurable audit data is determined to be the audit point, which is used to audit the user data of the user to be audited, and then compare the user data of the user to be audited with the audit data to obtain The data that fails to pass the audit in the user profile of the user to be audited can realize the automatic audit process. This solution obtains the user information of the user to be audited through the automatic audit device, and then compares the user information of the user to be audited with the audit data according to the configurable audit data, and obtains the user information of the user to be audited For the data that has not passed the audit, the audit data can be configured and modified during the automatic audit process, which is flexible and easy to operate, and the automatic audit can save manpower and resources, and at the same time ensure the audit quality.

FIG. 4 is a schematic structural diagram of an automatic auditing device provided by an embodiment of the present application. As shown in FIG. 4 , the automatic audit processing device 40 of this embodiment includes: a processor 401 and a memory 402; wherein, the memory 402 is used to store computer-executed instructions; the processor 401 is used to execute the computer-executed instructions stored in the memory, In order to realize various steps performed by the receiving device in the foregoing embodiments. For details, refer to the related descriptions in the foregoing method embodiments.

The embodiment of the present application also provides a computer-readable storage medium, where computer-executable instructions are stored in the computer-readable storage medium, and when the processor executes the computer-executable instructions, the implementation of any of the above-mentioned embodiments corresponds to Automated audit method.

In the several embodiments provided in this application, it should be understood that the disclosed devices and methods may be implemented in other ways. For example, the device embodiments described above are only illustrative. For example, the division of the modules is only a logical function division. In actual implementation, there may be other division methods, for example, multiple modules can be combined or integrated. to another system, or some features may be ignored, or not implemented. In another point, the mutual coupling or direct coupling or communication connection shown or discussed may be through some interfaces, and the indirect coupling or communication connection of devices or modules may be in electrical, mechanical or other forms. In addition, each functional module in each embodiment of the present application may be integrated into one processing unit, each module may exist separately physically, or two or more modules may be integrated into one unit. The units formed by the above modules can be implemented in the form of hardware, or in the form of hardware plus software functional units.

The above-mentioned integrated modules implemented in the form of software function modules can be stored in a computer-readable storage medium. The above-mentioned software functional modules are stored in a storage medium, and include several instructions to enable a computer device (which may be a personal computer, server, or network device, etc.) or a processor (English: processor) to execute the functions described in various embodiments of the present application. part of the method. It should be understood that the above-mentioned processor can be a central processing unit (English: Central Processing Unit, referred to as: CPU), and can also be other general-purpose processors, digital signal processors (English: Digital Signal Processor, referred to as: DSP), application-specific integrated circuits (English: Application Specific Integrated Circuit, referred to as: ASIC) and so on. A general-purpose processor may be a microprocessor, or the processor may be any conventional processor, and the like. The steps of the method disclosed in conjunction with the invention can be directly implemented by a hardware processor, or implemented by a combination of hardware and software modules in the processor.

The storage may include a high-speed RAM memory, and may also include a non-volatile storage NVM, such as at least one disk storage, and may also be a U disk, a mobile hard disk, a read-only memory, a magnetic disk, or an optical disk. The bus may be an Industry Standard Architecture (Industry Standard Architecture, ISA) bus, a Peripheral Component Interconnect (Peripheral Component, PCI) bus, or an Extended Industry Standard Architecture (Extended Industry Standard Architecture, EISA) bus, etc. The bus can be divided into address bus, data bus, control bus and so on. For ease of representation, the buses in the drawings of the present application are not limited to only one bus or one type of bus. The above-mentioned storage medium can be realized by any type of volatile or non-volatile storage device or their combination, such as static random access memory (SRAM), electrically erasable programmable read-only memory (EEPROM), erasable In addition to programmable read-only memory (EPROM), programmable read-only memory (PROM), read-only memory (ROM), magnetic memory, flash memory, magnetic disk or optical disk. A storage media may be any available media that can be accessed by a general purpose or special purpose computer.

An exemplary storage medium is coupled to the processor such the processor can read information from, and write information to, the storage medium. Of course, the storage medium may also be a component of the processor. The processor and the storage medium may be located in application specific integrated circuits (Application Specific Integrated Circuits, ASIC for short). Of course, the processor and the storage medium can also exist in the electronic device or the main control device as discrete components.

Those of ordinary skill in the art can understand that all or part of the steps for implementing the above method embodiments can be completed by program instructions and related hardware. The aforementioned program can be stored in a computer-readable storage medium. When the program is executed, it executes the steps including the above-mentioned method embodiments; and the aforementioned storage medium includes: ROM, RAM, magnetic disk or optical disk and other various media that can store program codes.

Finally, it should be noted that: the above embodiments are only used to illustrate the technical solutions of the present application, and are not intended to limit it; although the application has been described in detail with reference to the foregoing embodiments, those of ordinary skill in the art should understand that: It is still possible to modify the technical solutions described in the foregoing embodiments, or perform equivalent replacements for some or all of the technical features; and these modifications or replacements do not make the essence of the corresponding technical solutions deviate from the technical solutions of the various embodiments of the application. scope.

Claims (10)

1. An automatic audit method, characterized in that, comprising: Obtain the user information of the user to be audited; Determine configurable audit data according to the feature information of the centralized business support system, and the audit data is used to audit the user data of the user to be audited; Comparing the user profile of the user to be audited with the audit data to obtain the data that failed the audit in the user profile of the user to be audited. 2. The method according to claim 1, characterized in that, before the acquisition of the user profile of the user to be audited, the method further comprises: receiving user profiles of multiple users to be migrated sent by business systems in each region, where the multiple users to be migrated are users to be migrated to the centralized business support system; storing the user identifiers in the user profiles of the multiple users to be migrated into a preset user table; Read each user ID from the preset user table, and obtain the user profile of the user to be migrated corresponding to each user ID according to each user ID; Finding the subscription service information of each user to be migrated in the centralized service support system from the user profile of the user to be migrated corresponding to each user identifier; According to the preset migration mapping table, determine the initial subscription service information of the user to be migrated corresponding to each user identifier in the centralized service support system, and the initial subscription service information is for each user to be migrated in Order business information in the business system of the region; According to the subscription service information and initial subscription service information of each of the multiple users to be migrated, determine the users among the multiple users to be migrated that are eligible for migration to the centralized service support system, and transfer all the users to the centralized service support system Among the multiple users to be migrated, the users who are eligible to be migrated to the centralized business support system are used as the users to be audited; According to the user to be audited, the preset user table is updated, and the user information of the user to be audited is stored in a database. 3. The method according to claim 1, wherein said determining the configurable audit data according to the characteristic information of the centralized business support system comprises: According to multiple service categories in the centralized service support system, configurable service information corresponding to each service category is determined, and the service information is the audit data. 4. The method according to claim 3, characterized in that, comparing the user profile of the user to be audited with the audit data to obtain the data that failed the audit in the user profile of the user to be audited, including : Comparing the user profile of the user to be audited with the business information, verifying the integrity of the user profile, and obtaining data in the user profile that failed the audit; and/or, Verifying whether the ordering service information in the user profile conforms to the ordering service information in the service information, and obtaining data in the user profile that has not passed the audit. 5. The method according to any one of claims 1-4, characterized in that, after obtaining the data in the user profile that failed the audit, the method further comprises: Store the data that fails the audit in the user profile of the user to be audited in a log file, and send the log file to the terminal of the maintenance personnel, so that the maintenance personnel can determine whether to maintain User information of the user to be audited. 6. An automatic auditing device, characterized in that it comprises: The first obtaining module is used to obtain the user information of the user to be audited; The audit data determination module is used to determine configurable audit data according to the characteristic information of the centralized business support system, and the audit data is used to audit the user data of the user to be audited; An audit module, configured to compare the user profile of the user to be audited with the audit data, and obtain the data in the user profile of the user to be audited that failed the audit. 7. The device according to claim 6, further comprising: a receiving module, a user identification storage module, a second acquisition module, an order service information search module, an initial order service information determination module, a user to be audited Determine the module and update the module; The receiving module is configured to receive user information of multiple users to be migrated sent by business systems in various regions before acquiring the user information of users to be audited. users in the system; The user identification storage module is configured to store the user identifications in the user profiles of the multiple users to be migrated into a preset user table; The second acquisition module is configured to read each user ID from the preset user table, and acquire the user profile of the user to be migrated corresponding to each user ID according to each user ID; The ordering service information search module is configured to search for the ordering service information of each user to be migrated in the centralized service support system from the user profile of the user to be migrated corresponding to each user ID; The initial order service information determination module is configured to determine the initial order service information of the user to be migrated corresponding to each user ID in the centralized service support system according to a preset migration mapping table, the initial order The business information is the subscription business information of each user to be migrated in the business system of the region; The user-to-be-audited determination module is configured to determine, according to the subscription service information and initial subscription service information of each of the multiple users to be migrated, among the multiple users to be migrated that they are eligible to be migrated to the For the users in the centralized business support system, users among the multiple users to be migrated who are eligible to be migrated to the centralized business support system are taken as the users to be audited; An update module, configured to update the preset user table according to the user to be audited, and store the user information of the user to be audited in a database. 8. The device according to claim 6, wherein the audit data determination module is specifically configured to: determine the configurable business corresponding to each business category according to multiple business categories in the centralized business support system Information, the business information is the audit data. 9. An automatic auditing device, comprising: at least one processor and a memory; the memory stores computer-executable instructions; The at least one processor executes the computer-executed instructions stored in the memory, so that the at least one processor executes the automatic auditing method according to any one of claims 1-5. 10. A computer-readable storage medium, wherein computer-readable instructions are stored in the computer-readable storage medium, and when the processor executes the computer-executable instructions, any one of claims 1-5 is implemented. The automatic audit method described above.