Loading patent…
AssigneeTeradata US, Inc.
InventorsMay Pederson, James Chapman, Cuong Nhan, Jeremy Davis, Donald Pederson, James Pierce, Sunanda Reddy, Stephen Sheldon
Estimating the term…
A method of archiving a set of source tables in a database system. Each source table has a plurality of rows. Initially, a consistency point for the set of source tables is established. The database system creates a log record for each change (insert, modify, or delete) effected to a row of the source tables subsequent to the consistency point. Substantially all source table rows are copied to an archive (a data storage object that is external to the database system). Then the accumulated log records for the affected source tables are distilled and appended to the archive.
A method of archiving a source table in a database system, the source table having a plurality of table rows, the database creating a log record for each change effected to a row of the source table, the method comprising the steps of:
The method of claim 2 further comprising the step, if there are more than one log record for a base row, of selecting for copying only the earliest log record.
A method of restoring a target table in a database system from an archive table, the archive table having a plurality of base rows and no more than one log record for each base row, the method comprising the steps of:
Dependencies are inferred from the claim text.