Method and system for synchronization of relational databases

A data synchronization and database technology, applied in the computer field, can solve the problems of difficulty in adapting to heterogeneous database data synchronization and high operational complexity, and achieve good timeliness, sacrifice storage space, and facilitate export and import effects

Active Publication Date: 2012-07-04
NO 15 INST OF CHINA ELECTRONICS TECH GRP
View PDF5 Cites 76 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The key of this professional data synchronization tool lies in the analysis of the log, which is too closely coupled with the database product, the operation complexity is high, and it is difficult to adapt to the data synchronization between any 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
  • Method and system for synchronization of relational databases
  • Method and system for synchronization of relational databases
  • Method and system for synchronization of relational databases

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0061] In order to make the object, technical solution and advantages of the present invention clearer, the present invention will be described in further detail below with reference to the accompanying drawings and preferred embodiments. However, it should be noted that many of the details listed in the specification are only for readers to have a thorough understanding of one or more aspects of the present invention, and these aspects of the present invention can be implemented even without these specific details.

[0062] The main ideas of the present invention include: establishing synchronization rules between databases as tasks for execution; using database agents to shield the heterogeneity between databases; realizing changing data capture through triggers and capture tables, and avoiding loopback writing; The scheduler implements timing and / or multi-thread execution of data synchronization tasks.

[0063] First, the synchronization method between relational databases ...

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 method and system for synchronization of relational databases. The method for synchronization of the relational databases comprises the following steps of: creating a data synchronization task aiming at varied data among a plurality of databases; analyzing the data synchronization task; capturing varied data in an original database; and carrying out the data synchronization task according to schedules. In the technical scheme provided by the invention, a synchronization rule among the databases is created into a task to be carried out, a database agency is used for shielding heterogeneity among the databases, the varied data is captured through a trigger and a capture table, loopback write-in is avoided, and timing and/or multi-threading implementation of the data synchronization task is realized through a scheduler. The method and the system have the advantages of simplicity and easiness in use, flexibility and high efficiency.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a synchronization method and system between relational databases. Background technique [0002] Simply put, a database is a warehouse that organizes, stores and manages data according to its data structure. There are many types of databases, ranging from the simplest tables storing various data to large-scale database systems capable of storing massive data, which have been widely used in financial management, warehouse management, production management and other aspects. [0003] For the convenience of data storage and management, data security and other considerations, there are often multiple databases between departments at all levels and within departments at all levels within a system. At the same time, business contacts, mutual cooperation, and information systems put forward higher requirements for information sharing. How to realize data sharing and data synchronizat...

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 NO 15 INST OF CHINA ELECTRONICS TECH GRP
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