Heterogeneous database platform data synchronization method

A database and data technology, applied in structured data retrieval, database distribution/replication, electronic digital data processing, etc., can solve problems such as limitations and insufficient compatibility, and achieve smooth synchronization/replication and good scalability

Active Publication Date: 2015-02-25
CHINESE NONFERROUS METAL SURVEY & DESIGN INSTITUE OF CHANGSHA
View PDF2 Cites 44 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The purpose of this application is to provide a method for synchronizing data on a heterogeneous database platform to solve the technical problems of limitations and insufficient compatibility of multi-source, distributed, and heterogeneous database platform data synchronization / replication in the prior art

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 platform data synchronization method
  • Heterogeneous database platform data synchronization method
  • Heterogeneous database platform data synchronization method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

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 platform data synchronization method. The heterogeneous database platform data synchronization method includes the following steps that a first external data exchange module and a second external data exchange module which correspond to a source database and a target database respectively are installed in a PostgreSQL database, and a first external data exchange module extender, a first external server, a second external data exchange module extender and a second server are built, wherein the source database and the target database are heterogeneous databases; a first external data table and a second external data table which are in mapping relation with the source database and the target database respectively are built, and triggers for capturing data changes are built. The PostgreSQL database and the corresponding data exchange modules serve as media innovatively to achieve data synchronization/copying between external multi-source heterogeneous databases.

Description

technical field The present application relates to the field of database data synchronization, in particular, to a method for synchronizing heterogeneous database platform data. Background technique In the prior art, most foreign database manufacturers provide the function of data replication, and generally support the replication between heterogeneous databases, such as MS SQL Server, Oracle, Sybase, etc., and have also developed products that can be used as data import and export tools. Such as DTS of SQLServer2000. Some replication middleware developed by software vendors are used in the field of data replication, such as well-known PDRE from PeerDirect, SyncKit from SynchroLogic, and DataSync from Syware. The advantages of these methods are that they are independent of the database system itself and can solve various heterogeneous problems; they can adapt to master-slave replication and synchronous replication; they can provide rich APIs and good scalability. But exi...

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/2365G06F16/27G06F16/273
Inventor 范志龙吴松林
Owner CHINESE NONFERROUS METAL SURVEY & DESIGN INSTITUE OF CHANGSHA
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