Change Data Capture: the beginning

I. in many application systems, there are many operations that need to be processed by changing data tables. There are various processing logics for different situations such as addition, deletion, modification, and query. example: 1. mobile obtains the latest business data from the server for display and processing. In the case of big data, different updates are required each time. (PS: 1

I. in many application systems, there are many operations that need to be processed by changing data tables. There are various processing logics for different situations such as addition, deletion, modification, and query. example: 1. mobile obtains the latest business data from the server for display and processing. In the case of big data, different updates are required each time. (PS: 1

I. Application scenarios

In many application systems, there are many operations that need to be processed by changing data tables. Various processing logics are supported in various situations such as addition, deletion, modification, and query. For example:

1. mobile obtains the latest business data from the server for display and processing. In the case of big data, different updates are required each time. (PS: basic data (basically unchanged) and business data (frequently changed) are usually selected ))

2. perform post-processing based on the basic data of an announcement in system A and system B. Therefore, each time B obtains the differential data in system.

2. Comparison of various solutions

1. TimeStamp)

2. Trigger)

3. Complex Data Query

4. SQL Server CDC

5. Oracle CDC

3. whimsy

The above solutions are learned and used after they are encountered in the project. During this period, many trade-offs also encountered many problems. Now we have time to record and summarize them.

When I first wrote a blog, I would like to make some mistakes. If you have any better solutions, please kindly advise.

To be continued

,