Patent ID: 7657576
Filing Date: 2010-02-02
Classification: G06F,Y10S

Abstract:
1. A method for change data capture, comprising the steps of: executing a database statement to copy a recovery log that contains change data for all transactions performed from a source object in a first system to a database object in a second system; storing the recovery log that contains the change data; grouping a plurality of change tables in the database object of the second system into at least two groups of change tables; obtaining at least some of the change data from the recovery log based in part on a column in the recovery log that holds data representing when a transaction has been committed; inserting the at least some change data into one of the at least two groups of change tables in a single transaction, where each change table in the one of the at least two groups of change tables includes a column corresponding to the column in the recovery log; and renaming a column heading for a source column of the source object and providing the renamed column heading for the source column as a column heading in a change column of the database object.