International Business Machines Corporation

Kathryn Ruth Zeidenstein

Fen-Ling Lin

Bryan Frederick Smith

Hong Sang Tie

Tammie Dang

Paramesh Sampatrai Desai

Yun Yu Wang

James Z Teng

James Alan Ruddy

Julie Ann Watts

Donald J Haderle

John Marland Garth

Akira Shibamiya

Craig Alan Friske

William Robert Bireley

Laura Michiko Kunioka-Weis

Randy Mitchell Nakagawa

Jerome Quan Wong

Annie S Tsang

Ted Eric Blank

Kouhorng Allen Yang

Daniel Keith Courter

Maureen Mae McDevitt

Kou Horng Yang

Darren Benjamin Swank

David Elmer Raiman

Craig Leonard Sutton

Kevin Daniel Gougherty

Dino Carlo Tonelli

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

A method, apparatus, and article of manufacture for a computer-implemented repartitioning system. Data is repartitioned in a database stored on a data storage device connected to a computer. First, it is detected that a partitioning scheme for the data has been altered. Next, partitions that would be affected by the altered partitioning scheme are identified. Then, the identified partitions are reorganized based on the altered partitioning scheme.

Repartitioning data

A system and method for a computer system having a plurality of DBMS providing a coordinating and assisting function. If a DBMS performs a coordinating function, it is referred to as a coordinating DBMS. If a DBMS performs an assisting function, it is referred to as an assisting DBMS. Each coordinating DBMS receives a query from a user application, decomposes the query into multiple parallel tasks, and allocates the parallel tasks to all of the DBMSs in the system. Each assisting DBMS receives one or more parallel tasks from a coordinating DBMS, executes the parallel tasks and returns the results to the coordinating DBMS. The coordinating DBMSs and assisting DBMSs access one or more storage devices. Furthermore, the present invention comprises a system and method for dynamically disabling a parallel mode on the coordinating DBMSs and the assisting DBMSs.

Query parallelism in a shared data DBMS system

Growing community of inventors

San Jose, CA, United States of America

Kathryn Ruth Zeidenstein