Data synchronization method

Abstract

The invention discloses a data synchronization method, which comprises the steps of: establishing a synchronization temporary table and a data synchronized mapping relation table in a database of an integrated management system; setting a corresponding trigger in a first service subsystem according to the mapping relation table; triggering the trigger when basic data in a data table provided withthe trigger in the first service subsystem is changed, and uploading the changed basic data to the synchronization temporary table in real time; reading the synchronization temporary table at regulartime by a second service subsystem, acquiring correspondingly changed basic data, converting the correspondingly changed basic data into data of required data type and data structure, and synchronizing the converted data to a local database of the second service subsystem; and synchronizing the changed basic data to the second service subsystem by means of the first service subsystem through usinga data synchronization calling interface. The data synchronization method adopts two modes for synchronization at the same time, avoids synchronous planting caused by disconnection between two systems, and reduces the probability of data omission to a great extent.

Description

technical field [0001] The invention belongs to the field of data synchronization transmission, and more specifically relates to a data synchronization method. Background technique [0002] In real business, different systems may need to share some basic data. These basic data have different data types and data structures in these different systems, and the synchronization conditions in different systems are also different. Some synchronization The tool needs to input the conditions for each synchronization. The detailed conditions are not recorded, which is not convenient for the user to use next time. At the same time, the input conditions do not support the organizational isolation of the group-level system. In addition, the current synchronization tools have a fixed data source, a fixed data type, and a fixed data structure, which is relatively single and lacks data diversity. There is also the current synchronization tool. Although it provides log information of data o...

AI Technical Summary

Problems solved by technology

[0002] In real business, different systems may need to share some basic data. These basic data have different data types and data structures in these different systems, and the synchronization conditions in different systems are also different. Some synchronization The tool needs to input the conditions for each synchronization. The detailed conditions are not recorded, which is not convenient for users to use next time. At the same time, the input conditions do not support the organizational isolation of the group-level system

In addition, the current synchronization tools have a fixed data source, a fixed data type, and a fixed data structure, which is relatively single and lacks data diversity.

There is also the current synchronization tool. Although it provides log information for data operation errors to help customers locate operation error information, it lacks detailed records of synchronization log errors, so that customers can quickly and conveniently locate the error location

Images