Comparing system and method for data having different file formats

Abstract

The invention provides a comparing system and method for data having different file formats. The comparing system includes: a data acquisition module for acquiring service data templates of an A platform and a B platform; a data extraction module for extracting service data to be compared from a corresponding storage space; a data comparing module for putting the extracted service data in a cache or a database to be compared; and a data generation module for allowing different data to generate a comparing file according to a preset format. The data comparing system does not have to concern service data, data comparing and a service body cannot be separated, various service responsible person needs performing configuration according to the corresponding format of a file, and then data processing can be performed; the different data is stored in the database or generates the file according to the preset format after data processing, and later analysis and processing is facilitated; and the step of data processing is simplified to the greatest extent, the operation and maintenance cost is reduced, and the working efficiency is improved.

Description

Technical field [0001] The present invention mainly relates to the technical field of data processing, in particular to a data comparison system and method of different file formats. Background technique [0002] At present, in the mobile NGBOSS system in various regions, the point data used by users has a set of data centers in the region, and the point platform also has a point data center for users. Due to the independence of the points platform and the systems in each region, coupled with asynchronous processing during business acceptance, system or database failures, etc., some users' points data are abnormal during synchronization between the two platforms. Therefore, the data of the two platforms need to be compared regularly (by day, week or month, etc.), and the difference data should be analyzed and processed. [0003] However, there are many businesses in the two data centers of two systems like this, which often involve the comparison of data consistency. Due to the d...

AI Technical Summary

Problems solved by technology

Due to the differences in the business logic of these businesses, the data file formats issued by each type of business group platform or regional platform are different, and the SQL scripts for database values ​​are also different. Therefore, the consistency of adding a new business data each time For comparative needs, each region must add a new set of procedures for processing, and the cost is relatively high

Images