Heterogeneous database synchronization method and system

A synchronization system and data synchronization technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve the problems that heterogeneous databases cannot achieve real-time synchronization, overcome data interaction and improve real-time performance Consistency, the effect of achieving real-time synchronization

Inactive Publication Date: 2009-12-30
深圳市珍爱网信息技术有限公司
View PDF0 Cites 39 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] The technical problem to be solved by the present invention is to provide a heterogeneous database synchronization method and system for the above-mentioned problem that real-time synchronization cannot be realized 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 system
  • Heterogeneous database synchronization method and system
  • Heterogeneous database synchronization method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0031] The present invention generates the execution statement of the target database through the trigger when the source database data changes, and realizes the transmission of the execution statement through mysql ODBC, the xp_cmdShell command of sql server and the pipeline command of DOS, and finally executes the above execution statement on the target database end, thereby Realizes the real-time synchronization of heterogeneous databases, overcomes the shortcomings that the data interaction between existing traditional heterogeneous databases cannot be synchronized in real time, and greatly improves the real-time performance and consistency of data synchronization.

[0032] Such as figure 1 Shown is a schematic diagram of the first embodiment of the heterogeneous database synchronization system of the present invention. The system consists of a source database server 11 that runs a source database and a destination database server 14 that runs a target database. The source da...

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 heterogeneous database synchronization method used for realizing data synchronization between a heterogeneous source database and a target database. The method comprises the following steps: (a) executable statements of the target database are created at a source database terminal according to data maintenance and operation of the source database; (b) a target database terminal obtains the executable statements from the source database terminal; (c) the target database terminal executes the executable statements to update the data in the target database. The invention also provides a corresponding system. The invention realizes real-time synchronization between the heterogeneous source database and the target database by creating the executable statements of the target database at the source database terminal and sending the executable statements to the target database to be executed.

Description

Technical field [0001] The invention relates to the technical field of database data synchronization, in particular to a method and system for synchronizing heterogeneous databases. Background technique [0002] At present, informatization construction is developing at an unprecedented speed, and all kinds of data are expanding rapidly. The existing computer system mainly realizes the storage and maintenance of data through the database, and each application system obtains the required data or performs related data maintenance by accessing the database. Many companies have launched their own database software, such as SQL Server from Microsoft Corporation of the United States and Oracle from Oracle Corporation of the United States. [0003] In order to ensure the consistency of data between application systems, it is often necessary to synchronize the data of the database (for example, a local database and a remote database). For the same structure of the database, you can direct...

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