Method and system for data audit during data migration

Abstract

The invention relates to a method and system for auditing data in a data transplantation process. The method comprises the steps: obtaining product data of a to-be-upgraded system, and pre-auditing the product data based on a Shell technology; transplanting the product data which finishing the pre-auditing operation, and sorting and storing the product data according to a transplantation rule in the transplantation process; after the transplantation of the product data is finished, based on the Shell technology, designing relative auditing scripts for data generated after the transplantation and data before the transplantation, and generating an auditing result; extracting abnormal data in the auditing result, exporting an abnormal data file through the excel tool, and invoking a preset automatic processing script to process the abnormal data. According to the method and system for auditing the data in the data transplantation process, the defaults of transplantation program are found out by data auditing, thereby providing reference data for the accuracy of data transplantation and the accuracy of checking.

Description

technical field [0001] The invention relates to the field of electronic information processing, in particular to a method and system for data auditing during data transplantation. Background technique [0002] In the process of upgrading the mobile communication system, it is necessary to convert the product data of the old model data structure into the product data of the new model data structure. Due to the following problems in product data migration: huge data volume, many and complex businesses, certain data differences between the stock product order data of the old CRM system and the corresponding business tables, and certain data differences between the old CRM system and the billing interface table, The new and old data models of the product domain are quite different. Therefore, the migration of product data will have to consider the implementation method of data migration audit, otherwise the accuracy of data migration cannot be guaranteed, and the billing reconci...

AI Technical Summary

Problems solved by technology

Due to the following problems in product data migration: huge data volume, many and complex businesses, certain data differences between the stock product order data of the old CRM system and the corresponding business tables, and certain data differences between the old CRM system and the billing interface table, The new and old data models of the product domain are quite different. Therefore, the migration of product data will have to consider the implementation method of data migration audit, otherwise the accuracy of data migration cannot be guaranteed, and the billing reconciliation results can meet the requirements of the bureau.

Images