Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Data synchronization method and system among heterogeneous databases

A data synchronization and database technology, applied in the database field, can solve the problems of inability to obtain incremental change data, difficult to widely implement, etc., and achieve real-time synchronization efficiency, easy configuration, and low resource consumption.

Inactive Publication Date: 2015-10-28
HANGZHOU HEZHONG DATA TECH CO LTD
View PDF5 Cites 54 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The disadvantage of these technologies is that they all need tools and API functions. If the database does not install these tools or shields the API functions from the outside, it is impossible to obtain incremental change data.
Moreover, the use of these tools requires professional knowledge of the database and familiarity with the instructions of the operating system, which is difficult to be widely implemented

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
  • Data synchronization method and system among heterogeneous databases
  • Data synchronization method and system among heterogeneous databases
  • Data synchronization method and system among heterogeneous databases

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0042] Example: such as figure 1 As shown, a data synchronization system between heterogeneous databases is composed of a configurator, an engine, a historical data synchronization module, a log collection module, a log analysis module, and a data loading module.

[0043] The configurator is divided into two configurations: data resource configuration and service configuration. Data resource configuration can configure the information of the source database and the target database; service configuration is to configure a service to synchronize the data in the specified table in the source database to the specified table in the target database. The information of data resource configuration is used in service configuration. The configuration file after the service configuration is completed will be used by other modules of the system.

[0044] The engine is responsible for starting and stopping historical data synchronization, log collection, log parsing, and data loading.

[...

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 a data synchronization method and system among heterogeneous databases, by which the two purposes of historical data synchronization and incremental data synchronization are achieved. According to the method, heterogeneous synchronization among various types of main databases is supported, other tools and scripts are not needed, the historical data synchronization and the incremental data synchronization can be easily configured and are automatically linked, and the complexity is reduced. The system is simple and easy to understand, backstage scrip writing and database command input are not needed, and a whole data synchronization service can be configured even by a person who has no experience in database application. The method and the system are applicable for a synchronization scenario of various types of data.

Description

technical field [0001] The invention relates to the field of databases, in particular to a data synchronization method and system between heterogeneous databases. Background technique [0002] At present, there are many synchronization technologies between databases on the market. These technologies must solve two problems, one is the synchronization of historical data, and the other is the synchronization of incremental change data. [0003] Synchronization of historical data is common with the synchronization technology that comes with the database, such as Oracle's data pump import and export technology, but these tools often do not support the synchronization of historical data between heterogeneous databases, and after using these tools to achieve historical data synchronization, It is also necessary to start incremental data synchronization manually. If the starting point of incremental synchronization is not well selected, it is easy to lose data and the operation is ...

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
CPCG06F16/27
Inventor 王士一黄斌陈盈周弘毅
Owner HANGZHOU HEZHONG DATA TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products