Data real-time synchronization method and system

Abstract

The invention discloses a real-time data synchronization method and system, and the method comprises the steps: obtaining a data change sequence of a source database when detecting that the source database has data change, and storing the data change sequence in a data change log table; When it is detected that the data change occurs in the data change log table, obtaining change data in the datachange log table, packaging the change data into message queue information, and sending the message queue information to a message queue; Informing a target database needing to synchronize data, so that after receiving the notification message, the target database reads the message queue information from the message queue and then performs data updating operation according to the message queue information; And after judging that the message queue information in the message queue is successfully sent, sending a synchronization completion message notification to the target database. The synchronization mode is simple, program development difficulty is low, synchronization efficiency is high, data synchronization can be carried out in time, the period is short, and the method can be widely applied to the software technology industry.

Description

technical field [0001] The invention relates to the technical field of the Internet, in particular to a method and system for synchronizing data in real time. Background technique [0002] In recent years, with the vigorous development of school campus information construction, each school is actively building its own information platform. However, due to the lack of unified planning in the early stage of information construction, many school information systems have the following problems: 1. Business system No unified data requirements have been followed, and no unified data interaction specification has been formed. Second, the way of data interaction between business systems is to directly operate database tables through database direct connection, which not only increases the coupling degree of the database, but also As a result, the amount of database access is too large and the burden is too heavy; 3. If the business system needs to access multiple other business syst...

AI Technical Summary

Problems solved by technology

[0002] In recent years, with the vigorous development of school campus information construction, each school is actively building its own information platform. However, due to the lack of unified planning in the early stage of information construction, many school information systems have the following problems: 1. Business system No unified data requirements have been followed, and no unified data interaction specification has been formed. Second, the way of data interaction between business systems is to directly operate database tables through database direct connection, which not only increases the coupling degree of the database, but also As a result, the amount of database access is too large and the burden is too heavy; 3. If the business system needs to access multiple other business systems, multiple data sources must be configured, which increases the difficulty of development and maintenance; 4. The relationship between databases is intricate, The synchronization of a large amount of data can only be performed at night when it is idle, and the synchronization efficiency is low and the cycle is long

In general, in the current campus information system, data synchronization between multiple homogeneous databases and heterogeneous databases has problems such as large access volume, difficult maintenance, low efficiency, and long cycle.

Images