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

System for achieving database synchronization and method thereof

A database and data technology, applied in the database field, can solve the problems of data islands, system application difficulties, data cannot be updated and synchronized in time, etc., and achieve the effect of avoiding data islands and real-time data synchronization.

Inactive Publication Date: 2017-12-19
G CLOUD TECH
View PDF5 Cites 6 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, due to the large number of application systems, each has its own database; resulting in a data island, the data cannot be updated and synchronized in time; this has caused difficulties for the application of the system

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
  • System for achieving database synchronization and method thereof
  • System for achieving database synchronization and method thereof

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0031] See figure 1 As shown, the present invention obtains and analyzes the operation performed by the database in real time by monitoring the log of the source data, performs data encapsulation on the performed operation according to the protocol, and pushes the data to the target server; after the target server receives the data, it The data is verified. If an error occurs, the data is requested again for this time. Otherwise, the data is added to the data queue and waits for the data to be written into the database.

[0032] The system is mainly composed of a monitor, an analysis query device, a data organizer, a data checker, a data queue and a reader-writer. The monitor, analysis queryer and data organizer are at the data source; the data checker, data queue and reader are at the data synchronization target. The monitor monitors the log of the database, and when the log file is updated, it sends a message to the analysis queryer to remind; the analysis queryer finds the...

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 the technical field of databases, in particular to a system for achieving database synchronization and a method thereof. The method includes the steps of obtaining and analyzing the operations executed by a database in real time by monitoring logs in source data, according to a protocol, conducting data encapsulation on the executed operations, and pushing the data to a target server; after the target server receives the data, verifying the data; if an exception occurs, requesting for obtaining the data again, and if not, adding the data into a data queue to wait for being written into the database. The system for achieving the database synchronization and the method thereof solve the problem of data isolation in each application system, and can be applied to data synchronization among different application systems.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a system and method for realizing database synchronization. Background technique [0002] With the continuous development of Internet and computer application technology and the popularization of various application systems, the amount of data has also surged. However, due to the large number of application systems, each has its own database; resulting in data islands, the data cannot be updated and synchronized in time; this has caused difficulties for the application of the system. In order for the application system to update data in a timely manner, data synchronization has become the key. Contents of the invention [0003] One of the technical problems solved by the present invention is to provide a system for realizing database synchronization, which provides applications for systems that need this business scenario, simplifies business processes, and improves efficien...

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/21G06F16/27
Inventor 韩超季统凯
Owner G CLOUD TECH
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