Heterogeneous database data synchronization method, device and system and storage medium

By deploying the intermediate database and establishing a synchronization link during the database data migration process, the incremental synchronization failure caused by the short retention time of the source database log is solved, and more efficient and flexible data synchronization is achieved.

CN119441356APending Publication Date: 2025-02-14JINZHUAN INFORMATION TECHNOLOGY CO LTD
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202411569052.0
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-11-05
Publication Date
2025-02-14

AI Technical Summary

Technical Problem

During the database data migration process, the log retention time of the source database is short, resulting in the failure of incremental synchronization and affecting engineering efficiency.

Method used

Deploy the intermediate database as the isomorphic database of the source database, establish an isomorphic synchronization link for full synchronization, and synchronize the data of the intermediate database to the target database through a heterogeneous synchronization link.

Benefits of technology

It weakens the limit on log retention time, avoids incremental synchronization failure, and improves the flexibility and scalability of data synchronization.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN119441356A_ABST
    Figure CN119441356A_ABST
Patent Text Reader

Abstract

The invention discloses a heterogeneous database data synchronization method, device and system and a storage medium, the heterogeneous database data synchronization method comprises the following steps: deploying an intermediate database, the intermediate database being an isomorphic database of a source end database; an isomorphic synchronous link is arranged between the source end database and the intermediate database; setting a heterogeneous synchronous link between the intermediate database and a target database; starting the isomorphic synchronous link, and synchronizing the data of the source end database to the intermediate database; and starting the heterogeneous synchronization link, and synchronizing the data of the intermediate database to the target database. According to the method, by deploying the intermediate library, the limitation on the log retention time can be weakened, the problem of increment failure caused by short log retention time can be effectively solved, and the problem of conflict between a long transaction and a task start site does not exist.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the field of database technology, and in particular to a method, device, system and storage medium for synchronizing data in heterogeneous databases. Background Art

[0002] A database is a collection of system data stored electronically. It can contain any type of data, including text, numbers, images, videos, and files. The data required by the business system is stored in the database in the form of database tables. Database data migration is the process of copying data from one database to another. Data migration between different types of databases will involve conversions such as data structure and type, so it is necessary to ensure the accuracy, integrity, and consistency of the data, and take appropriate measures to deal with data format and structure mismatches. Data synchronization between databases refers to the process of keeping the data in one database the same as the data in another database. This data synchronization operation is involved in the database data migration process. The prior art is to use a data migration tool to extract data from the source database and apply it to the target database to achieve full and incremental data synchronization. However, in actual applications, when the amount of data in the source database is too large, the log retention time is short, and the amount of data to be synchronized on the target end is small, it is easy to appear that the source log is cleared during the incremental synchronization acquisition process, which seriously affects the engineering efficiency. For example, during a period of time, multiple businesses on the source database wrote 2TB of logs, and the business required by the target database was ranked last. When the incremental synchronization task finished parsing the previous part of the logs and was about to parse the required business, the log retention time had expired and the source database logs were cleared. Therefore, the existing technology needs to be improved and developed. Summary of the invention

[0003] In view of the above-mentioned deficiencies in the prior art, an object of the present invention is to provide a method, device, system and storage medium for synchronizing data in heterogeneous databases.

[0004] In order to achieve the above object, the present invention adopts the following technical solutions:

[0005] The present invention provides a method for synchronizing data in heterogeneous databases, comprising the following steps:

[0006] Deploy an intermediate database, which is a database isomorphic to the source database;

[0007] Setting a homogeneous synchronization link between the source database and the intermediate database;

[0008] Setting a heterogeneous synchronization link between the intermediate database and the target database;

[0009] Starting the homogeneous synchronization link to synchronize the data of the source database to the intermediate database;

[0010] The heterogeneous synchronization link is started to synchronize the data in the intermediate database to the target database.

[0011] In a preferred embodiment, the heterogeneous database data synchronization method, the step of starting the homogeneous synchronization link to synchronize the data of the source database to the intermediate database specifically includes:

[0012] Start the synchronization task from the source database to the intermediate database, start the homogeneous synchronization link, and synchronize all the data of the source database to the intermediate database.

[0013] In a preferred embodiment, the heterogeneous database data synchronization method, the step of starting the heterogeneous synchronization link to synchronize the data of the intermediate database to the target database specifically includes:

[0014] Starting the heterogeneous synchronization link to synchronize all the data in the intermediate database to the target database;

[0015] Starting the homogeneous synchronization link to incrementally synchronize the incremental data of the source database to the intermediate database;

[0016] Incrementally synchronize the incremental data of the intermediate database to the target database.

[0017] In a preferred embodiment, the heterogeneous database data synchronization method, after the step of starting the synchronization task from the source database to the intermediate database, starting the homogeneous synchronization link, and synchronizing the entire amount of data from the source database to the intermediate database, further includes:

[0018] After the full synchronization of the data from the source database to the intermediate database is completed, the isomorphic synchronization link is terminated.

[0019] In a preferred embodiment, the heterogeneous database data synchronization method, after the step of starting the homogeneous synchronization link to incrementally synchronize the incremental data of the source database to the intermediate database, further includes:

[0020] After the data of the source database and the intermediate database are equal, the isomorphic synchronization link is terminated.

[0021] In a preferred embodiment, the heterogeneous database data synchronization method, after the step of incrementally synchronizing the incremental data of the intermediate database to the target database, further includes:

[0022] After the data of the intermediate database and the target database are equal, performing incremental data comparison;

[0023] If there is no alignment exception, the heterogeneous synchronization link is terminated.

[0024] In a preferred embodiment, the heterogeneous database data synchronization method, after the step of terminating the heterogeneous synchronization link if there is no alignment abnormality, further includes:

[0025] Perform database reconciliation on the source database and the target database.

[0026] The present invention also provides a heterogeneous database data synchronization device, the device comprising:

[0027] A database deployment module, used to deploy an intermediate database, where the intermediate database is a database isomorphic to the source database;

[0028] A homogeneous link module, used to set up a homogeneous synchronization link between the source database and the intermediate database;

[0029] A heterogeneous link module, used to set up a heterogeneous synchronization link between the intermediate database and the target database;

[0030] A homogeneous synchronization module, used to start the homogeneous synchronization link and synchronize the data of the source database to the intermediate database;

[0031] The heterogeneous synchronization module starts the heterogeneous synchronization link and synchronizes the data of the intermediate database to the target database.

[0032] The present invention also provides a heterogeneous database data synchronization system, the system comprising at least one processor; and

[0033] a memory communicatively connected to the at least one processor; wherein,

[0034] The memory stores instructions that can be executed by the at least one processor, and the instructions are executed by the at least one processor so that the at least one processor can execute the heterogeneous database data synchronization method as described above.

[0035] A non-volatile computer-readable storage medium stores computer-executable instructions. When the computer-executable instructions are executed by one or more processors, the one or more processors can execute the heterogeneous database data synchronization method as described above.

[0036] Compared with the prior art, the present invention provides a heterogeneous database data synchronization method, device, system and storage medium, wherein a heterogeneous database data synchronization method includes the following steps: deploying an intermediate database, the intermediate database is a homogeneous database of the source database; setting a homogeneous synchronization link between the source database and the intermediate database; setting a heterogeneous synchronization link between the intermediate database and the target database; starting the homogeneous synchronization link to synchronize the data of the source database to the intermediate database; starting the heterogeneous synchronization link to synchronize the data of the intermediate database to the target database. By deploying an intermediate library, the present invention can weaken the restrictions on log retention time, effectively solve the problem of incremental failure caused by short log retention time, and there is no problem of conflict between long transactions and task starting points. At the same time, it can also improve the flexibility of customized solutions for data synchronization in specific scenarios, with higher scalability. BRIEF DESCRIPTION OF THE DRAWINGS

[0037] Figure 1 The present invention provides a flow chart of a heterogeneous database data synchronization method.

[0038] Figure 2 A schematic diagram of the functional modules of the heterogeneous database data synchronization device provided by the present invention.

[0039] Figure 3 A schematic diagram of the hardware structure of the heterogeneous database data synchronization system provided by the present invention. DETAILED DESCRIPTION

[0040] In view of the shortcomings of the prior art, the object of the present invention is to provide a heterogeneous database data synchronization method, application server, system and storage medium.

[0041] In order to make the purpose, technical solution and effect of the present invention clearer and more specific, the present invention is further described in detail with reference to the accompanying drawings and examples. It should be understood that the specific embodiments described herein are only used to explain the present invention and are not used to limit the present invention.

[0042] The present invention can be applied in a computer device, and one or more applications can be installed in the computer device to process relevant data. The computer device can be a terminal or a server, wherein the terminal can be an electronic device with communication function such as a smart phone, a tablet computer, a laptop computer, a desktop computer, a personal digital assistant and a wearable device. The computer device includes a processor, a non-volatile storage medium, an internal memory and a network interface connected through a system bus. Among them, the non-volatile storage medium of the computer device can store an operating system and a computer-readable program, and when the computer-readable program is executed, the processor can execute a method for predicting the difficulty of underwriting. The processor of the computer device is used to provide computing and control capabilities to support the operation of the entire computer device. The internal memory can store a computer-readable program, and when the computer-readable program is executed by the processor, the processor can execute a method for predicting the difficulty of underwriting. The network interface of the computer device is used for network communication, such as sending assigned tasks.

[0043] like Figure 1 As shown, the present invention provides a method for synchronizing data in heterogeneous databases, comprising the following steps:

[0044] S10, deploying an intermediate database, where the intermediate database is a database isomorphic to the source database;

[0045] S20, setting a homogeneous synchronization link between the source database and the intermediate database;

[0046] S30, setting a heterogeneous synchronization link between the intermediate database and the target database;

[0047] S40, starting the homogeneous synchronization link to synchronize the data of the source database to the intermediate database;

[0048] S50: Start the heterogeneous synchronization link to synchronize the data in the intermediate database to the target database.

[0049] The source database is the production database where the actual business exists, the intermediate database is a database of the same category and version as the source database, and the target database is the database that receives data in the synchronization task. The synchronization link from the source database to the intermediate database is data synchronization between databases of the same type, and the synchronization link from the intermediate database to the target database is data synchronization between heterogeneous databases.

[0050] The present invention can weaken the restriction on log retention time by deploying the intermediate library, effectively solve the problem of incremental failure caused by short log retention time, and eliminate the problem of conflict between long transactions and task starting positions.

[0051] Preferably, in the heterogeneous database data synchronization method provided by the present invention, the step of starting the homogeneous synchronization link to synchronize the data of the source database to the intermediate database in S40 specifically includes:

[0052] S41. Start the synchronization task from the source database to the intermediate database, start the homogeneous synchronization link, and synchronize all the data of the source database to the intermediate database.

[0053] The specific implementation of the present invention can be divided into multiple stages. The first stage can be the environment preparation stage. The environment preparation mainly includes deploying the intermediate database, checking the database environment, checking the synchronization link, etc. First, the intermediate database is deployed and initialized. The type and version of the intermediate database are consistent with the source database. It is necessary to ensure that the storage space of the intermediate database, the available space of the file system of the server, the computing power, the disk performance, etc. meet the requirements. At the same time, create necessary users for the intermediate database and grant corresponding permissions, appropriately adjust the parameter configuration of the intermediate database, enable monitoring and tuning, etc., to ensure the stability and security of the intermediate database. Initializing the intermediate database is to extract the DDL of the table required by the target database from the source database and flush it into the intermediate database, and start the synchronization task from the source database to the intermediate database, and synchronize all transaction data before the specified timestamp in the source database to the intermediate database.

[0054] Then comes the database environment check, which mainly checks the environment information of the intermediate database and the target database. The intermediate database mainly checks whether there are new DDL changes, log checks, archive space and table space checks. The target database mainly checks program user permissions, parameter configuration, logs and space, backup and recovery tasks and other related checks. Finally, the synchronization link check mainly checks the synchronization link from the source end to the intermediate database and from the intermediate database to the target end. This includes checking the list that needs to be synchronized, checking the synchronization tool parameters, and checking the synchronization network connectivity.

[0055] Preferably, in the heterogeneous database data synchronization method provided by the present invention, the step of starting the heterogeneous synchronization link to synchronize the data of the intermediate database to the target database in S50 specifically includes:

[0056] S51, starting the heterogeneous synchronization link to synchronize all the data in the intermediate database to the target database;

[0057] S52: Start the homogeneous synchronization link to synchronize the incremental data of the source database to the intermediate database;

[0058] S53: Incrementally synchronize the incremental data of the intermediate database to the target database.

[0059] Preferably, the heterogeneous database data synchronization method provided by the present invention, after the step of starting the synchronization task from the source database to the intermediate database in S41, starting the homogeneous synchronization link, and synchronizing the entire amount of data from the source database to the intermediate database, further includes:

[0060] S42: After the full synchronization of the data from the source database to the intermediate database is completed, the homogeneous synchronization link is terminated.

[0061] Preferably, the heterogeneous database data synchronization method provided by the present invention, after the step of starting the homogeneous synchronization link in S52 to incrementally synchronize the incremental data of the source database to the intermediate database, further comprises:

[0062] S521: After the data of the source database and the intermediate database are equal, terminate the homogeneous synchronization link.

[0063] Preferably, the heterogeneous database data synchronization method provided by the present invention further includes, after the step of incrementally synchronizing the incremental data of the intermediate database to the target database in S53:

[0064] S531, after the data of the intermediate database and the target database are equal, perform incremental data comparison;

[0065] S532: If there is no alignment exception, terminate the heterogeneous synchronization link.

[0066] Preferably, the heterogeneous database data synchronization method provided by the present invention further includes, after S532, if there is no alignment exception, terminating the heterogeneous synchronization link:

[0067] S54: performing database reconciliation between the source database and the target database.

[0068] When the present invention is implemented specifically, the second stage can be the system shutdown stage. One of the advantages of the present invention compared to previous data synchronization solutions is that it has zero intrusion on the source database, that is, the production system does not need to stop business, but the synchronization link from the target database to the intermediate database is regarded as business. After all transaction data before the specified timestamp is fully synchronized to the intermediate database, this synchronization link is suspended.

[0069] The third stage can be the data synchronization stage. First, initialize the target database. Unlike initializing the intermediate database, since the target database and the source database are heterogeneous databases, relevant tools are needed to collect the DDL of the source database objects and make appropriate modifications to successfully flush all objects in the source database into the target database. Then comes the full synchronization stage. After configuring the full synchronization whitelist, open the full synchronization link from the intermediate database to the target database. During the link operation, always pay attention to the data migration QPS, whether there are comparison anomalies, server IO and CPU usage, etc. Finally, the incremental synchronization stage. After the synchronization task is completed, start the incremental synchronization link from the intermediate database to the target database, and at the same time open the synchronization link from the source database to the intermediate database. After the synchronization link between the source database and the intermediate database is close to being equal, suspend this synchronization link again. After the incremental synchronization from the intermediate database to the target database is equal and there is no comparison anomaly, suspend this link and prepare to start reconciliation.

[0070] The fourth stage can be the reconciliation and testing stage. Reconciliation mainly includes table data reconciliation and non-table object reconciliation, and testing mainly includes basic performance testing. If the reconciliation and testing fail, you can return to the first stage and execute again.

[0071] The present invention designs a solution for partial data synchronization between heterogeneous databases using an intermediate library. The solution can reduce the log or increase the log retention time by migrating only the required number of tables, effectively solving the problem of incremental synchronization failure caused by too short log retention time and the problem of data loss caused by the conflict between the incremental task site configured on the source side and the uncommitted transaction. Moreover, the present invention has zero intrusion on the source database and does not affect the normal business process and master-slave consistency of the source database. In addition, the present invention can realize customized optimization for synchronization problems in specific scenarios, has strong flexibility and wider adaptability, meets the data synchronization requirements in different scenarios, and improves the stability and synchronization efficiency of the synchronization link between heterogeneous database data.

[0072] like Figure 2 As shown, the present invention provides a heterogeneous database data synchronization device, the device comprising:

[0073] A database deployment module 11 is used to deploy an intermediate database, which is a database isomorphic to the source database;

[0074] A homogeneous link module 12, used to set up a homogeneous synchronization link between the source database and the intermediate database;

[0075] A heterogeneous link module 13, used to set up a heterogeneous synchronization link between the intermediate database and the target database;

[0076] A homogeneous synchronization module 14 is used to start the homogeneous synchronization link and synchronize the data of the source database to the intermediate database;

[0077] The heterogeneous synchronization module 15 starts the heterogeneous synchronization link to synchronize the data in the intermediate database to the target database.

[0078] The module referred to in the present invention refers to a series of computer program instruction segments that can perform specific functions, which are more suitable for the execution process of the heterogeneous database data synchronization method than the program. For the specific implementation of each module, please refer to the corresponding method embodiment above, which will not be repeated here.

[0079] The present invention relates to a distributed database. A distributed database is a database in which data is stored in different physical locations. It may be stored in multiple computers located in the same physical location; or it may be dispersed in a network of interconnected computers. QPS (Queries Per Second) is a common measure of the search traffic received by an information retrieval system in one second. DDL (Data Definition Language) definition language is used to define relational models, delete relations, modify relational models, and create various objects in a database, such as tables, clusters, indexes, views, functions, stored procedures, and triggers. Database reconciliation is to confirm the consistency, accuracy, and completeness of data by comparing and verifying data between different databases or within a database. This process includes multiple steps such as data comparison, data difference analysis, data integration, and data repair. When performing database reconciliation, we need to first define reconciliation rules and then perform data comparison according to these rules. If data differences are found, we need to perform data difference analysis to find out the reasons for the data inconsistency. Then, we need to integrate and repair the data to ensure the data consistency and accuracy of the database. Among them, data comparison is the core step of database reconciliation, which directly affects the effect of reconciliation. Data comparison mainly involves querying and comparing data through SQL statements, including comparison of data quantity, type, content, etc.

[0080] Another embodiment of the present invention further provides a heterogeneous database data synchronization system, such as Figure 3 As shown, the system 10 includes:

[0081] One or more processors 110 and memory 120, Figure 3 A processor 110 is used as an example for description. The processor 110 and the memory 120 may be connected via a bus or other means. Figure 3 The example of connecting through bus is taken in the following.

[0082] The processor 110 is used to complete various control logics of the system 10, and it can be a general-purpose processor, a digital signal processor (DSP), an application-specific integrated circuit (ASIC), a field programmable gate array (FPGA), a single-chip microcomputer, an ARM (Acorn RISC Machine) or other programmable logic device, a discrete gate or transistor logic, a discrete hardware component, or any combination of these components. In addition, the processor 110 can also be any traditional processor, microprocessor or state machine. The processor 110 can also be implemented as a combination of computing devices, for example, a combination of a DSP and a microprocessor, a plurality of microprocessors, one or more microprocessors combined with a DSP and / or any other such configuration.

[0083] The memory 120, as a non-volatile computer-readable storage medium, can be used to store non-volatile software programs, non-volatile computer executable programs and modules, such as program instructions corresponding to the heterogeneous database data synchronization method in the embodiment of the present invention. The processor 110 executes various functional applications and data processing of the system 10 by running the non-volatile software programs, instructions and units stored in the memory 120, that is, implements the heterogeneous database data synchronization method in the above method embodiment.

[0084] The memory 120 may include a program storage area and a data storage area, wherein the program storage area may store an operating system and an application required by at least one function; the data storage area may store data created according to the use of the system 10, etc. In addition, the memory 120 may include a high-speed random access memory, and may also include a non-volatile memory, such as at least one disk storage device, a flash memory device, or other non-volatile solid-state storage device. In some embodiments, the memory 120 may optionally include a memory remotely arranged relative to the processor 110, and these remote memories may be connected to the system 10 via a network. Examples of the above-mentioned network include, but are not limited to, the Internet, an intranet, a local area network, a mobile communication network, and combinations thereof.

[0085] One or more units are stored in the memory 120, and when executed by one or more processors 110, the water supply proportional valve fault detection method in any of the above method embodiments is executed, for example, the above described Figure 1 The method comprises steps S101 to S103.

[0086] An embodiment of the present invention provides a non-volatile computer-readable storage medium, wherein the computer-readable storage medium stores computer-executable instructions, and the computer-executable instructions are executed by one or more processors, for example, to execute the above-described Figure 1 The method comprises steps S101 to S103.

[0087] As an example, non-volatile storage media can include read-only memory (ROM), programmable ROM (PROM), electrically programmable ROM (EPROM), electrically erasable ROM (EEPROM) or flash memory. Volatile memory can include random access memory (RAM) as external cache memory. By way of illustration and not limitation, RAM can be obtained in many forms such as synchronous RAM (SRAM), dynamic RAM, (DRAM), synchronous DRAM (SDRAM), double data rate SDRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), Synchlink DRAM (SLDRAM) and direct Rambus RAM (DRRAM). The disclosed memory components or memories of the operating environment described herein are intended to include one or more of these and / or any other suitable types of memory.

[0088] In summary, the present invention designs a solution for partial data synchronization between heterogeneous databases using an intermediate library. The solution can reduce the log or increase the log retention time by migrating only the required number of tables, effectively solving the problem of incremental synchronization failure caused by too short log retention time and the problem of data loss caused by conflicts between incremental task sites configured on the source side and uncommitted transactions. Moreover, the present invention has zero intrusion on the source database and does not affect the normal business processes and master-slave consistency of the source database. In addition, the present invention can achieve customized optimization for synchronization problems in specific scenarios, with strong flexibility and wider adaptability, meeting the data synchronization requirements in different scenarios, and improving the stability and synchronization efficiency of the synchronization link between heterogeneous database data.

[0089] It should be noted that there is not necessarily a certain order between the above-mentioned steps. A person skilled in the art can understand, based on the description of the embodiments of the present invention, that in different embodiments, the above-mentioned steps may have different execution orders, that is, they may be executed in parallel, may be executed interchangeably, and so on.

[0090] What has been described in this specification and the accompanying drawings includes examples that can provide water proportional valve fault detection methods, devices, systems and media. Of course, it is not possible to describe every conceivable combination of elements and / or methods for the purpose of describing the various features of the present disclosure, but it can be recognized that many other combinations and permutations of the disclosed features are possible. Therefore, it is obvious that various modifications can be made to the present disclosure without departing from the scope or spirit of the present disclosure. In addition, or in an alternative, other embodiments of the present disclosure may be obvious from consideration of this specification and the accompanying drawings and from the practice of the present disclosure as presented herein. It is intended that the examples proposed in this specification and the accompanying drawings are considered to be illustrative and not restrictive in all respects. Although specific terms are used in this article, they are used in a general and descriptive sense and are not used for the purpose of limitation.

Claims

1. A method for synchronizing data in heterogeneous databases, characterized in that: The steps include: Deploy an intermediate database, which is a database isomorphic to the source database; Setting a homogeneous synchronization link between the source database and the intermediate database; Setting a heterogeneous synchronization link between the intermediate database and the target database; Starting the homogeneous synchronization link to synchronize the data of the source database to the intermediate database; The heterogeneous synchronization link is started to synchronize the data in the intermediate database to the target database.

2. The heterogeneous database data synchronization method according to claim 1, characterized in that: The step of starting the homogeneous synchronization link to synchronize the data of the source database to the intermediate database specifically includes: Start the synchronization task from the source database to the intermediate database, start the homogeneous synchronization link, and synchronize all the data of the source database to the intermediate database.

3. The method for synchronizing data in heterogeneous databases according to claim 2, characterized in that: The step of starting the heterogeneous synchronization link and synchronizing the data of the intermediate database to the target database specifically includes: Starting the heterogeneous synchronization link to synchronize all the data in the intermediate database to the target database; Starting the homogeneous synchronization link to incrementally synchronize the incremental data of the source database to the intermediate database; Incrementally synchronize the incremental data of the intermediate database to the target database.

4. The method for synchronizing data in heterogeneous databases according to claim 2, characterized in that: After the step of starting the synchronization task from the source database to the intermediate database, starting the isomorphic synchronization link, and synchronizing all the data of the source database to the intermediate database, the method further includes: After the full synchronization of the data from the source database to the intermediate database is completed, the isomorphic synchronization link is terminated.

5. The method for synchronizing data in heterogeneous databases according to claim 3, characterized in that: After the step of starting the homogeneous synchronization link and synchronizing the incremental data of the source database to the intermediate database, the method further includes: After the data of the source database and the intermediate database are equal, the isomorphic synchronization link is terminated.

6. The method for synchronizing data in heterogeneous databases according to claim 5, characterized in that: After the step of incrementally synchronizing the incremental data of the intermediate database to the target database, the method further includes: After the data of the intermediate database and the target database are equal, performing incremental data comparison; If there is no alignment exception, the heterogeneous synchronization link is terminated.

7. The method for synchronizing data in heterogeneous databases according to claim 6, characterized in that: After the step of terminating the heterogeneous synchronization link if there is no alignment abnormality, the method further includes: Perform database reconciliation on the source database and the target database.

8. A heterogeneous database data synchronization device, characterized in that: The device comprises: A database deployment module, used to deploy an intermediate database, where the intermediate database is a database isomorphic to the source database; A homogeneous link module, used to set up a homogeneous synchronization link between the source database and the intermediate database; A heterogeneous link module, used to set up a heterogeneous synchronization link between the intermediate database and the target database; A homogeneous synchronization module, used to start the homogeneous synchronization link and synchronize the data of the source database to the intermediate database; The heterogeneous synchronization module starts the heterogeneous synchronization link and synchronizes the data of the intermediate database to the target database.

9. A heterogeneous database data synchronization system, characterized in that: The system includes at least one processor; and, a memory communicatively connected to the at least one processor; wherein, The memory stores instructions that can be executed by the at least one processor, and the instructions are executed by the at least one processor so that the at least one processor can execute the heterogeneous database data synchronization method described in any one of claims 1-7.

10. A non-volatile computer-readable storage medium, characterized in that: The non-volatile computer-readable storage medium stores computer-executable instructions, which, when executed by one or more processors, enable the one or more processors to execute the heterogeneous database data synchronization method according to any one of claims 1 to 7.