Terry Reynolds Allen

US Patent:

7146360, Dec 5, 2006

Filed:

Dec 18, 2002

Appl. No.:

10/323257

Inventors:

Terry Dennis Allen - San Jose CA, US
Hsiuying Cheng - Fremont CA, US
Fen-Ling Lin - San Jose CA, US
Akira Shibamiya - Los Altos CA, US
Annie S. Tsang - Saratoga CA, US

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 17/30
G06F 7/00

US Classification:

707 5, 707 3

Abstract:

Aspects for improving response time for database query execution are described. The aspects include comparing an estimate of sort pages needed for a database query against at least one threshold. A determination of whether to perform a parallel sort for the database query based on the comparison occurs, wherein response time improvement by the parallel sort is balanced against resource overhead of the parallel sort.

US Patent:

7146365, Dec 5, 2006

Filed:

Jan 27, 2003

Appl. No.:

10/353138

Inventors:

Terry Dennis Allen - San Jose CA, US
Paramesh S. Desai - San Jose CA, US
Akira Shibamiya - Los Altos CA, US
Hong Sang Tie - San Jose CA, US
Annie S. Tsang - Saratoga CA, US

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 17/30

US Classification:

707 8, 707 2

Abstract:

Disclosed is a method, system, and program for database query execution. A range of data pages is assigned to each of multiple parallel tasks. For each of the multiple parallel tasks, the range of data pages is mapped to one or more physical partitions, and a data partitioned secondary index partition associated with each of the one or more physical partitions is identified. Each of the multiple parallel tasks is executed to process the database query against the assigned range of data pages using the one or more data partitioned secondary index partitions.

US Patent:

20070198482, Aug 23, 2007

Filed:

Feb 21, 2006

Appl. No.:

11/358467

Inventors:

Terry Allen - San Jose CA, US
Toby Haynes - Richmond Hill, CA
Kelvin Ho - Richmond Hill, CA
James Pickel - Gilroy CA, US
Michael Springgay - Toronto, CA
Frankie Sun - North York, CA
Maryela Weihrauch - San Jose CA, US

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 17/30

US Classification:

707003000

Abstract:

A method, apparatus and program storage device is provided for dynamic data formatting during transmittal of generalized byte string data across a computer network. Remote server dynamically changes format of each column string data value from the result set separately, according to actual size of the string data value, and returns it to a client. Small-size data value is returned in a single network return message as varchar type, in-line with the rest of the query data. Medium-sized data value is retrieved without locators and streamed in multiple return network messages in a separate data object following the query data and in the same response. Large-size data value is retrieved using locators and returned as a progressive reference in pieces of specified size, where each piece of data value is separately transferred under client's control when needed, thus eliminating the need to buffer large amount of data.