Jennifer R Ou

US Patent:

7899797, Mar 1, 2011

Filed:

Dec 4, 2003

Appl. No.:

10/730192

Inventors:

Curt L. Cotner - Gilroy CA, US
Tammie Dang - Morgan Hill CA, US
Brian K. Howell - San Jose CA, US
Fung Lee - Daly City CA, US
Hui-An Lee - San Jose CA, US
Charles H. Lin - San Jose CA, US
Claire W. McFeely - San Jose CA, US
Jennifer W. Ou - Cupertino CA, US
James W. Pickel - Gilroy CA, US
Jay A. Yothers - Gilroy CA, US

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 7/00
G06F 17/30

US Classification:

707702, 707758, 707769

Abstract:

A method and system for providing package resolution in a database system is disclosed. The method and system comprise providing a statement within a server which allows an application to identify a list of package collections. The method and system further includes executing the statement to obtain the appropriate package. A system and method in accordance with the present invention provides a new current package path value, which is set via a statement referred to as Set Current Package Path. The SET CURRENT PACKAGE PATH statement allows the application to supply a precedence list of qualified package collections during execution time, therefore the scheme for resolving packages can be changed at any point during execution. The SET CURRENT PACKAGE PATH statement improves application development by making the package resolution mechanism less error prone and less tedious for the application developer, while providing an optimal-performance solution in the client-server environment.

US Patent:

6598041, Jul 22, 2003

Filed:

Sep 7, 2000

Appl. No.:

09/656558

Inventors:

Margaret Ann Bernal - San Jose CA
Christopher John Crone - San Jose CA
Paramesh Desai - San Jose CA
Georgia Carroll Fuller - San Jose CA
Peter Hoa - Los Altos CA
Eric Naoto Katayama - San Jose CA
William Y. Kyu - San Jose CA
Kalpana Shyam - Los Altos CA
Julie Ann Watts - Morgan Hills CA
Jennifer Wha-Yuh Ou - Cupertino CA

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 1730

US Classification:

707 3, 707 1

Abstract:

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.