International Business Machines Corporation

William Y Kyu

Peter Hoa

Yun Yu Wang

Fen-Ling Lin

Julie Ann Watts

Kalpana Shyam

Paramesh Sampatrai Desai

Christopher John Crone

Margaret Ann Bernal

Eric N Katayama

Stephen Yao Ching Chen

Georgia Carroll Fuller

Desai Paramesh Sampatrai

Jennifer Wha-Yuh Ou

Provided is a method, system, program, and data structures for making data available to an application program. A result table is generated including rows corresponding to a subset of rows in a base table having data in one or more columns that satisfy a query predicate clause. The result table includes, for each row, a location identifier of the corresponding row in the base table and a column for each column in a query select list. The result table is accessed to return requested data from the base table to the application program.

Method, system, and program for processing modifications to data in tables in a database system

Disclosed is a system, method, and program for performing a join operation on a multi-column table and at least two satellite tables having a join condition. Each satellite table is comprised of multiple rows and at least one join column. Each multi-column table is comprised of multiple rows and at least one column corresponding to the join column in each satellite table. A join operation is performed on the rows of the satellite tables to generate a first join result comprising concatenations of the rows of the satellite tables. Less than all the concatenated rows in the first join result that satisfy the join condition are then selected. The selected concatenated rows in the first join result are then joined to the multi-column table.

Method, system, and program for performing a join operation on a multi column table and satellite tables

Growing community of inventors

San Jose, CA, United States of America

William Y Kyu