Back to results
US 2003/0225798 A1Published application
High-performance change capture for data warehousing
AssigneeOracle International Corporation
InventorWilliam D. Norcott
Life of this patent
Estimating the term…
Abstract
A method and software for change data capture is described, in which change data is extracted from a recovery log in a single pass and stored into multiple database objects, such as change tables. The change data indicates modifications that has been performed to multiple source objects that correspond to the multiple database objects. In a preferred embodiment, this can be accomplished with a single multi-table insert SQL statement.
Claims8
A method for change data capture, comprising the steps of:
- extracting change data from a recovery log in a single pass;
- and
- storing the change data extracted from the recovery log in a single pass into a plurality of database objects, said change data indicating modifications that has been performed to a plurality of source objects that correspond to the database objects.
A method of change data capture, comprising the steps of:
- generating a SQL single multi-table insert statement to extract the change data in a single pass from the recovery log;
- and
- executing the SQL statement, thereby extracting the change data from the recovery log in a single pass and storing the change data from the recovery log in a plurality of change tables, said change tables indicating at least one modification that has been performed to a plurality of corresponding source objects.
Dependencies are inferred from the claim text.