Sunanda K Reddy

US Patent:

8452730, May 28, 2013

Filed:

Dec 8, 2008

Appl. No.:

12/329681

Inventors:

May Pederson - San Diego CA, US
James Chapman - Glendale CA, US
Cuong Nhan - Oceanside CA, US
Jeremy Davis - San Diego CA, US
Donald Pederson - San Diego CA, US
James Pierce - Torrance CA, US
Sunanda Reddy - Dublin CA, US
Stephen Sheldon - Seattle WA, US

Assignee:

Teradata US, Inc. - Dayton OH

International Classification:

G06F 7/00
G06F 17/00

US Classification:

707648, 707640, 707647, 707650, 707653

Abstract:

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.

US Patent:

7089258, Aug 8, 2006

Filed:

Jan 25, 2002

Appl. No.:

10/056549

Inventors:

Douglas P. Brown - Rancho Santa Fe CA, US
Sunanda K. Reddy - Escondido CA, US
Jeetendra Chaware - Secunderabad, IN

Assignee:

NCR Corporation - Dayton OH

International Classification:

G06F 17/30

US Classification:

707102, 707103 R, 707103 Z, 7071041

Abstract:

A method and computer system for structure subset generation for multiple databases is disclosed. The method retrieves a database view object structure. The method includes inputting definition language specifying a database view identifier and with at least one directly or indirectly referenced database object unqualified with a containing database identifier. The method further includes inputting a show statement that identifies the database view identifier and outputting the definition language with each directly or indirectly referenced database object qualified with its containing database identifier.