International Business Machines Corporation

Kouhorng Allen Yang

Fen-Ling Lin

Vijayshankar Raman

Inderpal Singh Narang

You-Chin Gene Fuh

Wei Han

Lin Qiao

Bryan Frederick Smith

Hong Sang Tie

Tammie Dang

Randy Mitchell Nakagawa

Annie S Tsang

Ted Eric Blank

Kathryn Ruth Zeidenstein

Ying-Lin Chen

Darren Benjamin Swank

Craig Leonard Sutton

Dino Carlo Tonelli

A method, storage server, and computer readable medium for off-loading star-join operations from a host information processing system to a storage server. At least a first and second set of keys from a first and second dimension table, respectively are received from a host system. Each of the first and second set of keys is associated with at least one fact table. A set of locations associated with a set of foreign key indexes are received from the host system. A set of fact table indexes are traversed. At least a first set of Row Identifiers ('RIDs') associated with the first set of keys and at least a second set of RIDs associated with the second set of keys are identified. An operation is performed on the first and second sets of RIDs to identify an intersecting set of RIDs. The intersecting set of RIDs are then stored.

Off-loading star join operations to a storage server

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

Kouhorng Allen Yang