Data synchronization method and system

Abstract

The invention discloses a data synchronization method and system. The data synchronization method comprises the steps that a transmitting system is additionally arranged and used for monitoring an incremental data operation log of a source database; the source database sends the incremental data operation log to the transmitting system, and the transmitting system converts the incremental data operation log into corresponding data objects and transmits the data objects to a target system. According to the data synchronization method and system, the processing pressure of the database can be reduced, and the timeliness of data can be improved.

Description

technical field [0001] The present application relates to the field of computer data processing, in particular to a data synchronization method and system. Background technique [0002] At present, Internet system data is generally stored in relational databases, such as Mysql, Oracle, and Sqlserver. However, there are many forms of data application. For example, in the report system, multiple tables need to be correlated and queried. This kind of query puts a lot of pressure on the database, and sometimes causes the performance of the database server to drop sharply, affecting normal operation. Business system functions, so the data of each associated table is generally queried and put into the retrieval service system, and the report query is a query retrieval service system. There are also some real-time data analysis systems that require real-time data, perform data calculations, and output calculation results for business personnel to use. Therefore, how to query data...

AI Technical Summary

Problems solved by technology

[0005] First of all, regularly query the tables of the business database, and the general query of structured query language (SQL) is relatively complicated, which will cause the service pressure of the database server and affect the normal production of the business system; There is a delay, and this method is difficult to meet some businesses that require high real-time data;

Images