Heterogeneous database synchronization method and device, computer equipment and storage medium

A database, heterogeneous technology, applied in database design/maintenance, database update, structured data retrieval, etc., can solve the problem of long data transmission time

Active Publication Date: 2020-07-07
GUANGZHOU BAIGUOYUAN INFORMATION TECH CO LTD
View PDF3 Cites 6 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] However, for the one-master-multiple-slave mode, all write operations are completed at the master point, which will greatly depend on the network conditions between the business point and the master point. For example, in the process of global business deplo

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Heterogeneous database synchronization method and device, computer equipment and storage medium
  • Heterogeneous database synchronization method and device, computer equipment and storage medium
  • Heterogeneous database synchronization method and device, computer equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0050] For details, please refer to figure 1 , figure 1 It is a schematic flow chart of a method for synchronizing heterogeneous databases in this embodiment.

[0051] Such as figure 1As shown, a heterogeneous database synchronization method includes the following steps:

[0052] S1100. Acquire database incremental data;

[0053] Incremental data in the database refers to information data that changes the stored data in the database, including but not limited to adding new data, deleting data, and modifying data. When performing data operations in the database, corresponding log records will be generated to record the data in the database Taking the application of the heterogeneous database synchronization method of the present invention to the database in the heterogeneous database system as an example, when the data in the database changes, the database incremental data of the data change can be obtained.

[0054] S1200. Encapsulate the database incremental data into tar...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

Embodiments of the invention disclose a heterogeneous database synchronization method and apparatus, computer equipment and a storage medium. The method comprises the following steps: obtaining database incremental data; packaging the incremental data of the database into target transmission data according to a preset custom packaging protocol; and transmitting the target transmission data to a heterogeneous database system, so that the target transmission data is synchronously transmitted in a plurality of databases in the heterogeneous database system. According to the embodiment of the invention, database incremental data is acquired, the database incremental data is packaged into target transmission data according to a preset custom packaging protocol, and the target transmission datais transmitted to a heterogeneous database system, so the target transmission data is synchronously transmitted by multiple databases in the heterogeneous database system, data conflicts possibly occurring in the data transmission process can be effectively avoided, final consistency of the data is achieved, version iterability of the bottom-layer database is improved, and replacement and migration of the database are facilitated.

Description

technical field [0001] Embodiments of the present invention relate to the technical field of data synchronization, in particular to a heterogeneous database synchronization method, device, computer equipment, and storage medium. Background technique [0002] With the development of network technology, the database tends to develop more and more in the direction of high availability. In some existing solutions, the data conflict resolution algorithm can be uniformly controlled by setting the proxy layer to hijack business access, that is, by invading the original database to quickly access the database. Local writing, but this solution is not universal and does not support heterogeneous databases. In other solutions, heterogeneous databases can be used, which can realize data sharing and transparent access. Several database systems already existed before joining the heterogeneous database system, with their own data array management system, external Each component of the dat...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): G06F16/27G06F16/23G06F16/21
CPCY02D10/00
Inventor 邱旭威蓝昭宝张东明田依腾蒋德为
Owner GUANGZHOU BAIGUOYUAN INFORMATION TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap