Changed data extracting method realized by being based on Oracle CDC technique

Abstract

The invention relates to a changed data extracting device which is realized by being based on an Oracle CDC technique and comprises an analysis unit, a changed table establishment unit, a subscriptionuser establishment unit, a subscription view establishment unit, a data acquisition unit, a transmission and judgment unit and a subscription deleting unit. The invention can communicate with high performance without programming, thereby ensuring the information to be directly communicated in a path which is most effective and fast and is positioned between a source and an object.

Description

technical field

[0001] The invention relates to a method for extracting changed data realized based on Oracle CDC technology. Background technique

[0002] In the ETL process of building a data warehouse, the extraction of changed data is a very critical link. The solution to extracting changed data generally needs to meet the following two requirements:

[0003] 1. Accuracy, the change data of the business table can be accurately retrieved into the data warehouse at a certain frequency.

[0004] 2. Performance, not to cause too much pressure on the business database and business table, and not to affect the performance of the existing business system.

[0005] Currently, the three most commonly used ways to achieve data synchronization are:

[0006] 1. Timestamp synchronization

[0007] Use a certain field in the business table as the basis for judging new and old data. This field can be of time type or int type. There are following problems in using this method: [00...

Images