Device and method for data timing synchronization of heterogeneous system

Abstract

The invention provides a device for the data timing synchronization of a heterogeneous system. The device comprises a creation unit, an acquisition unit and an importing unit, wherein the creation unit creates a middle table in a target database, and the middle table has a table structure the same as that of a source data table in a source database; the acquisition unit acquires target data from the source data table; and the importing unit imports the target data acquired by the acquisition unit into the middle table. Correspondingly, the invention also provides a method for realizing the data timing synchronization of the heterogeneous system. By the technical scheme, data can be more effectively and safely synchronized, concurrency conflicts can be effectively prevented, and the running efficiency and reliability of the system are improved.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to a device and a method for realizing timing synchronization of heterogeneous system data. Background technique [0002] With the development of the enterprise, in order to improve the management level, the enterprise uses a lot of information systems, such as CRM (Customer Relationship Management, customer relationship management) system, enterprise management system, data warehouse system and distribution system, etc., and each system All run independently. There are multiple information systems within the enterprise that cannot share data. In the wholesale and retail process of the distribution industry, the enterprise hopes that the naming rules of its products in each system will be unified, and the user's order information can be synchronized in different systems, and realize the product and Order data is automatically synchronized from one system to another. In the...

AI Technical Summary

Problems solved by technology

[0015] However, there are several key technical problems in the analysis of this data through the method and device: there are hidden dangers in the security of data import, and any database user can synchronize the data; there is no way to track and control the change of data; The production environment has a great impact. Every time data is synchronized, the data source of the target database must be checked, resulting in data access conflicts in the production environment; data concurrency conflicts. When data is imported, users need to access the imported data, which is easy Cause concurrency conflicts; the efficiency of data processing is poor

[0016] Because there are many problems in related inventions, they cannot meet our needs. Therefore, a new data synchronization technology is needed to achieve more efficient and safer data synchronization, and can effectively prevent concurrency conflicts, improve the efficiency of system operation and reliability

Images