Stephen H Sheldon

US Patent:

7457795, Nov 25, 2008

Filed:

Jan 19, 2004

Appl. No.:

10/761029

Inventors:

Stephen Fife Sheldon - Seattle WA, US
Arthur Vargas Lopes - San Diego CA, US

Assignee:

Teradata US, Inc. - Miamisburg OH

International Classification:

G06F 7/00
G06F 17/30

US Classification:

707 2, 707 5

Abstract:

A method, computer program, and computer network are disclosed for transforming multiple alternative equality conditions between a database column and a set of values. The method includes identifying one or more groups of consecutive values in the set. The equality conditions corresponding to values found in one or more of the identified groups are removed. One or more inequality conditions corresponding to the one or more of the identified groups are added.

US Patent:

8140521, Mar 20, 2012

Filed:

Mar 15, 2004

Appl. No.:

10/800493

Inventors:

Stephen Fife Sheldon - Seattle WA, US
Arthur Vargas Lopes - San Diego CA, US
Grace Kwan-On Au - Rancho Palos Verdes CA, US
Ahmad Said Ghazal - Redondo Beach CA, US

Assignee:

Teradata US, Inc. - Dayton OH

International Classification:

G06F 7/00

US Classification:

707716, 707797

Abstract:

A method, computer program, and database system are disclosed for processing a database query that includes one or more expressions. The method includes resolving columns in one or more of the expressions. Expression optimization is performed on one or more of the expressions. Afterward, further query optimization is performed.

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.