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

Heterogeneous database synchronization method and application system

A data synchronization and database technology, applied in the database field, can solve problems such as heterogeneous database data synchronization, and achieve easy expansion and simple implementation

Active Publication Date: 2015-04-29
新方正控股发展有限责任公司 +1
View PDF5 Cites 46 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] However, in the existing distributed environment, there is still a need for data synchronization between heterogeneous databases

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 application system
  • Heterogeneous database synchronization method and application system
  • Heterogeneous database synchronization method and application system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0020] figure 1 It is a flow chart of Embodiment 1 of the method for synchronizing heterogeneous databases of the present invention, such as figure 1 As shown, the method of this embodiment may include:

[0021] Step 101, when the synchronization processor determines that data changes occur in the source data table of the source database, it stores the identification information of the changed data in the source data table in the synchronization change table, and the identification information includes at least the source The table name of the data table, the primary key value of the changed data in the source data table, the change type value, and the change time;

[0022] Step 102: When the polling period arrives, the synchronization processor obtains the identification information before the current time from the synchronization change table according to the change time in the synchronization change table, and according to the table name, master Key value and change type ...

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 provides a heterogeneous database synchronization method and an application system. A synchronous processor arranged on a side of a source data source can periodically poll change data recorded in a synchronous change table and encapsulate the change data into a data stream to send the data stream to a synchronous analyzer arranged on the side of a target database. The synchronous analyzer de-capsulates the data stream, then maps the change data in the source data table into a data structure of a target data table in the target database according to preset mapping files, and synchronizes the data of the target data table according to the change type values in the change data so as to complete the data synchronization of heterogeneous databases. The heterogeneous database synchronization method and the application system disclosed by the invention can achieve the data synchronization of heterogeneous databases just by setting different mapping files on the synchronous analyzer instead of changing the existing heterogeneous databases, the implementation is simple, and the expansion is easy.

Description

technical field [0001] The invention relates to database technology, in particular to a synchronization method and application system for heterogeneous databases. Background technique [0002] With the continuous development of computer technology and network technology, the database has also evolved from centralized to distributed. [0003] In a distributed environment, database synchronization technology, as a method to maintain data consistency between database nodes, has become a key technology to ensure system performance and improve system reliability. In the prior art, for a homogeneous database, the source database can detect whether the stored data has changed, for example, whether there is data update, whether there is data deletion, or whether there is data addition. Once a change occurs, the source database can synchronize the changed part to the target database. [0004] However, in the existing distributed environment, there is still a need for data synchroni...

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): G06F17/30
CPCG06F16/258G06F16/27G06F16/84
Inventor 廖凌浩蒋国新
Owner 新方正控股发展有限责任公司
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

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com