International Business Machines Corporation

Annie S Tsang

Fen-Ling Lin

Akira Shibamiya

Hong Sang Tie

Terry Dennis Allen

Bryan Frederick Smith

Tammie Dang

Paramesh Sampatrai Desai

Randy Mitchell Nakagawa

Hsiuying Yen Cheng

Ted Eric Blank

Kathryn Ruth Zeidenstein

Kouhorng Allen Yang

Darren Benjamin Swank

Craig Leonard Sutton

Dino Carlo Tonelli

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.

Method and system for improving response time for database query execution

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.

Method, system, and program for optimizing database query execution

A method, apparatus, and article of manufacture for a computer-implemented apportioning system. Work is distributed to processors in a multi-processor system. Initially, during bind-time, a scaling factor is determined for each processor. The scaling factor represents relative processing power in relation to each other processor. Then, portions of a total amount of work are distributed to each processor based on the determined scaling factor of that processor and a determined amount of work for an average processor.

Apportioning a work unit to execute in parallel in a heterogeneous environment

Growing community of inventors

Saratoga, CA, United States of America

Annie S Tsang