Teradata Us, Inc.

Ncr Corporation

May Pederson

Donald Raymond Pederson

Grace Kwan-On Au

James P Chapman

Stephen Sheldon

Jeremy Davis

Bill Huffman

Cuong Nhan

Richard Pogue

James Pierce

Sang-Luen Helen Fan

Sunanda Reddy

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.

Archiving method and system

Various embodiments may include taking an initial dump of a database table and tracking changes to the database table, with regard to but outside of transactions, since a most recent full or partial dump has been taken. A partial dump, in such embodiments, may be taken since the most recent full or partial dump and used to create a data structure which may be used to update only those database table rows modified since a last full or partial dump. As a result, the dumps of a database table will include a single full dump and may include one or more partial dumps. These full and partial dumps may then be instantiated to create or update an instance of the database table. In some embodiments, dumps may be taken directly to a mirrored instance of a database table.

Online incremental database dump

A method and computer program are disclosed for measuring the parallelism of an execution step. The method includes determining whether the step operates on rows whose primary index is specified. If the primary index is specified, the parallelism is measured as single. If the primary index is not specified, the method determines whether the step uses an output from a previous step. If an output is used, the number of rows in the output is compared to a specified number. If the number of rows is greater than the specified number, the parallelism is measured as total. In one implementation, the geography of the output is determined and the previous step is compared to specified types such that if the primary index is not specified, the number is rows is not greater than a specified number, the geography does not write output rows to all parallel units, and the previous step is of a specified type, then the parallelism is measured as partial.

Method and system for measuring parallelism of a database system execution step

Growing community of inventors

San Diego, CA, United States of America

May Pederson