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.

CN107491526AInactive Publication Date: 2017-12-19G CLOUD TECH
5 Cites 6 Cited by

Patent Information

Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Publication Date
2017-12-19
Estimated Expiration
Not applicable · inactive patent

Smart Images

  • Figure 1
    Figure 1
  • Figure 2
    Figure 2
Patent Text Reader

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.
Need to check novelty before this filing date? Find Prior Art

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...

Examples

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...