Method for synchronizing multiple heterogeneous source databases based on log

A database and log technology, applied in electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as affecting the performance of the source database, unable to synchronize multiple source databases, and having any impact on the performance and structure of the source database, achieving enhanced Synchronized response speed, the effect of reducing execution time

Inactive Publication Date: 2012-02-08
苏州博远容天信息科技股份有限公司
View PDF3 Cites 63 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0007] 1. There is a data read operation on the source database, which affects the performance of the source database;
[0008] 2. It is necessary to establish an intermediate table in the target database, which affects the integrity of the target database;
[0009] 3. It can only synchronize between a single heterogeneous source database and target database, and cannot synchronize heterogeneous multi-source databases with a single target database
[0010] Data synchronization cannot have any impact on the performance and structure of the source database, otherwise it will cause great trouble to the management 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
  • Method for synchronizing multiple heterogeneous source databases based on log
  • Method for synchronizing multiple heterogeneous source databases based on log

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0042] The present invention will be described in detail below with reference to the accompanying drawings and in combination with embodiments.

[0043] see figure 1 As shown, a log-based heterogeneous multi-source database synchronization method is characterized in that it comprises the following steps:

[0044] Step 1) Read the source data, extract the operation of the source database according to the log file of the source database on the source database side, and reversely generate the SQL execution script of the data operation;

[0045] Step 2) SQL script delivery;

[0046] Step 3) Data conflict handling;

[0047] Step 4) Target data writing.

[0048] Further, the specific steps of the step 1 are as follows:

[0049] Step 1.1) On the source database side, use the built-in system function::fn_dblog of the source database to read the SQL log file, use the table name configured as a parameter in advance as the query condition to get all the logs of the table to be synchr...

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 discloses a method for synchronizing multiple heterogeneous source databases based on log. The method comprises the following steps of: 1) reading source data, extracting operation on a source database according to a log file of the source database at the source database end, and reversely generating an SQL (structured query language) execution script of data operation; 2) transferring the SQL script; 3) processing data conflict; and 4) writing target data. The method disclosed by the invention is used for realizing data synchronization between multiple heterogeneous source databases and a target database, can overcome the obstacle caused by heterogeneous databases, and does not bring any influence on the performance and structure of the source databases.

Description

[0001] technical field [0002] The invention belongs to the field of database synchronization, and in particular relates to a log-based heterogeneous multi-source database synchronization method. [0003] Background technique [0004] At present, in the field of database synchronization, there are relatively complete methods for data synchronization between similar databases, such as data replication and publishing of SQL Server. [0005] There are also many methods for data synchronization between heterogeneous databases, such as heterogeneous database data integration middleware, heterogeneous database SQL-based data synchronization and other related methods, but they are not perfect and there are some problems. [0006] Specific questions include: [0007] 1. There is a data read operation on the source database, which affects the performance of the source database; [0008] 2. It is necessary to establish an intermediate table in the target database, which affects th...

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 Applications(China)
IPC IPC(8): G06F17/30
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

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