Data synchronization method and device, equipment and storage medium

Abstract

The invention relates to the technical field of big data, and discloses a data synchronization method and device, equipment and a storage medium, and the method comprises the steps: generating an initial data table in a target relational database according to data synchronization configuration; creating a first initial table in a target middle table database corresponding to the second database identifier according to the initial data table and a system table of the target relational database; synchronizing the initial data table into the first initial table according to the data synchronization configuration to obtain a to-be-labeled data table; a labeling ending signal corresponding to the to-be-labeled data table is obtained, the labeling ending signal is responded, a second initial table is created in the target relational database according to a label wide table in the target middle table database, and the label wide table is a wide table formed by labeling the to-be-labeled data table; and synchronizing the label wide table into the second initial table according to the data synchronization configuration to obtain a data synchronization result table. Automatic adaptation to table structure changes is achieved, and data conversion at the rear end is not needed any more.

Description

technical field [0001] The present application relates to the field of big data technology, in particular to a data synchronization method, device, equipment and storage medium. Background technique [0002] As the application of data centers becomes more and more widespread, data centers not only provide data storage functions, but also provide more diversified data services such as standardization, micro-services, and automation. As the data provider of each application, the data center needs to build data tables and synchronize data in order to meet the complexity of business requirements. The current method of fixedly building data tables and synchronizing data cannot be automated for table structure changes, and each data table needs to be developed separately, resulting in high costs; and the front-end display cannot be directly connected to the database in the data center, requiring a back-end Doing data conversion increases the cost of back-end development. Conten...

AI Technical Summary

Problems solved by technology

[0003] The main purpose of this application is to provide a data synchronization method, device, equipment, and storage medium, aiming to solve the problem that the data center adopts the method of fixedly building data tables and synchronizing data, and the table structure changes cannot be automated, and the front-end display cannot Directly connected to the database in the data center, technical issues that require back-end data conversion

Images