A method and device for data synchronization between heterogeneous relational databases

A data synchronization and database technology, applied in relational databases, database models, structured data retrieval, etc., can solve the problems of occupying source-end database computing resources and disk IO resources, lack of real-time performance, etc., and achieve the goal of improving robustness Effect

Active Publication Date: 2021-08-17
北京达梦数据库技术有限公司
View PDF16 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The technical problem to be solved by the present invention is the lack of an effective data synchronization method in the heterogeneous database scene in the prior art; to solve the two synchronization methods in the prior art, either lack real-time performance, or need to temporarily parse the database log, resulting in Occupying computing resources and disk IO resources of the source database

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
  • A method and device for data synchronization between heterogeneous relational databases
  • A method and device for data synchronization between heterogeneous relational databases
  • A method and device for data synchronization between heterogeneous relational databases

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0046] Embodiment 1 of the present invention provides a method for synchronizing data between heterogeneous relational databases, and its relational architecture diagram is as follows figure 1 As shown, there may be multiple subscribers in the actual operation process, and for the intuitiveness of the performance, only a single source-end database (the device carrying the source-end database in the embodiment of the present invention is also referred to as the source for short) For example, in figure 1 When the log capture module shown in is actually implemented, it can be the corresponding network interface, which is used to obtain the log content actively reported by the source database side. In addition, it can also add a listening thread in a source database , and the log capture module realizes network communication with the corresponding listening thread, and obtains the log content reported by the corresponding listening thread. while in figure 1 The log receiving mod...

Embodiment 2

[0072] The embodiment of the present invention takes Figure 5 As an example, a cross-subscription relationship is cited. Compared with Embodiment 1, the applicable scenarios are directly presented in the form of examples, and the specific subscription relationship establishment, subscription synchronization and storage content management can be Referring to the content described in Embodiment 1, the description will not be repeated in this embodiment.

[0073] In the embodiment of the present invention, there are two tables table1 and table2 (which may belong to one source or belong to different sources), and each table has one partition. The destination has 2 subscriber groups (which can be understood as consisting of multiple subscribers), among which subscriber group 1 consists of 2 oracle subscribers, and subscriber group 2 consists of 2 mysql subscribers. The messages in the partition on table1 are respectively subscribed by oracle subscriber 1 and mysql subscriber 2, a...

Embodiment 3

[0075] Such as Image 6 As shown in FIG. 1 , it is a schematic diagram of the structure of the content recommendation device based on the human body state according to the embodiment of the present invention. The device for recommending content based on human body state in this embodiment includes one or more processors 21 and memory 22 . in, Image 6 A processor 21 is taken as an example.

[0076] Processor 21 and memory 22 can be connected by bus or other means, Image 6 Take connection via bus as an example.

[0077] Memory 22, as a non-volatile computer-readable storage medium, can be used to store non-volatile software programs and non-volatile computer-executable programs, such as data synchronization between heterogeneous relational databases in Embodiment 1 method. The processor 21 executes the method for synchronizing data between heterogeneous relational databases by running the non-volatile software programs and instructions stored in the memory 22 .

[0078] ...

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

The invention relates to the technical field of data synchronization, and provides a data synchronization method and device between heterogeneous relational databases. The method comprises that the synchronization server obtains the database log of the source end; the synchronization server converts the database log into the database language content supported by the destination end according to the subscription information corresponding to the source end database, and stores it in the corresponding sector; the synchronization server Send a notification message of log content update to the subscriber, so that the destination end can obtain the log content. The present invention provides a destination subscription mechanism through the set synchronization server, so that the corresponding heterogeneous database synchronization process can complete the conversion of subscribed data for different database types in advance on the synchronization server, so that the storage space can be appropriately sacrificed. Under certain conditions, real-time performance is guaranteed and the occupation of processing resources is reduced.

Description

【Technical field】 [0001] The invention relates to the technical field of data synchronization, in particular to a method and device for data synchronization between heterogeneous relational databases. 【Background technique】 [0002] In the current Internet era, the data access demand of many enterprises is growing rapidly, and a single core database is often unable to support more and more concurrent operations. Therefore, many enterprises establish multiple cross-regional target databases, and transfer a large amount of business data from the core database transferred to the corresponding target database. In order to ensure the normal operation of enterprise business, data synchronization between the core database and target databases in each region is required to ensure data integrity and consistency. On the other hand, with business development, some enterprises will upgrade their core business systems. The upgrade process will involve database replacement. During the pe...

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
Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/27G06F16/28
CPCG06F16/27G06F16/284
Inventor 冯源余院兰宋天扬
Owner 北京达梦数据库技术有限公司
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