Stephen F 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.

US Patent:

20190354622, Nov 21, 2019

Filed:

May 15, 2018

Appl. No.:

15/980022

Inventors:

- Redwood Shores CA, US
Stephen P. SHELDON - San Diego CA, US

International Classification:

G06F 17/30

Abstract:

Systems, methods, and other embodiments associated with assessing and adaptively managing query loads are described. In one embodiment, a method includes determining that a query invoked by a client terminal against an application object has a duration that exceeds a completion threshold. In response to receiving a subsequent invocation of the query, statistics for the query are obtained. The obtained statistics are analyzed to determine whether the query causes the unacceptable negative impact on the application object. A data structure is modified to include a classification of the query into one of a plurality of different query classes based on a result of the analysis, and execution of the query in response to a future invocation is controlled based on the classification of the query in the modified data structure.