Julie A Watts

US Patent:

6604097, Aug 5, 2003

Filed:

Jul 26, 2001

Appl. No.:

09/915867

Inventors:

San Yu Phoenix - Morgan Hill CA
Kalpana Shyam - Los Altos CA
James Zu-Chia Teng - San Jose CA
Stephen Walter Turnbaugh - Hollister CA
Julie Ann Watts - Morgan Hill CA

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 1730

US Classification:

707 2, 707 4

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.

US Patent:

6643637, Nov 4, 2003

Filed:

Jul 26, 2001

Appl. No.:

09/915869

Inventors:

Yao Ching Stephen Chen - Saratoga CA
Kalpana Shyam - Los Altos CA
Julie Ann Watts - Morgan Hill CA

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 1730

US Classification:

707 2, 703 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.

US Patent:

6665678, Dec 16, 2003

Filed:

Dec 28, 2000

Appl. No.:

09/750543

Inventors:

Stephen Yao Ching Chen - Saratoga CA
Jerry Wayne Goldsmith - Morgan Hill CA
Kalpana Shyam - Los Altos CA
Julie Ann Watts - Morgan Hill CA

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 1730

US Classification:

707100, 8101, 8102, 8203

Abstract:

Provided is a method, system, and program for performing a cursor operation. 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. A command is received to perform a cursor operation with respect to a subject row in the result table. A lock is obtained on a row in the base table corresponding to the subject row in the result table. An operation specified in the received command is performed with respect to the subject row after obtaining the lock. The lock on the row in the base table is released after performing the operation.

US Patent:

6694305, Feb 17, 2004

Filed:

Jul 26, 2001

Appl. No.:

09/915866

Inventors:

Margaret Ann Bernal - San Jose CA
Christopher John Crone - San Jose CA
San Yu Phoenix - Morgan Hill CA
Kalpana Shyam - Los Altos CA
James Zu-Chia Teng - San Jose CA
Julie Ann Watts - Morgan HIll CA

Assignee:

International Business Machines Corporation - Armonk

International Classification:

G06F 1730

US Classification:

707 2, 707 4

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.

US Patent:

6754653, Jun 22, 2004

Filed:

Jul 26, 2001

Appl. No.:

09/915868

Inventors:

Charles Roy Bonner - San Jose CA
San Yu Phoenix - Morgan Hill CA
Kalpana Shyam - Los Altos CA
Julie Ann Watts - Morgan Hill CA

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 1730

US Classification:

707 4, 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.

US Patent:

6754656, Jun 22, 2004

Filed:

Oct 22, 1996

Appl. No.:

08/735168

Inventors:

Karelle Lynne Cornwell - San Jose CA
Barbara Tanya Couch - Morgan Hill CA
Robert William Lyle - San Jose CA
James Zu-Chia Teng - San Jose CA
Julie Ann Watts - Morgan Hill CA

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 1730

US Classification:

707 8, 707 9, 707100, 707101

Abstract:

A system and a method are described for selectively locking the partitions of a partitioned table in a relational database. The database system locks only those partitions of the table that are accessed by an application. Other partitions are available for concurrent access by other applications, regardless of the strength of the lock needed.

US Patent:

6816873, Nov 9, 2004

Filed:

May 15, 2001

Appl. No.:

09/858735

Inventors:

Curt L. Cotner - Gilroy CA
James W. Pickel - Gilroy CA
Julie A. Watts - Morgan Hill CA

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 1200

US Classification:

707201, 707 8, 707 10

Abstract:

System, method, and program product for managing transactions on a plurality of Database Management Systems residing on separate participant servers and a coordinator server. A single transaction proceeds by multiple steps across more then one of the plurality of Database Management Systems as participants. Savepoints are assigned to the participants across the Database Management System, with at least one savepoint within a multiple step transaction. The DBMS responds to application requests to rollback to savepoint by rolling back the transaction, across the Database Management System participants, to the savepoint Further disclosed is a program product that contains code, which, either as written on the medium, or as instantiated in RAM, or both, controls the operation of a distributed database management system.

US Patent:

6886012, Apr 26, 2005

Filed:

Nov 18, 1998

Appl. No.:

09/193966

Inventors:

San Yu Phoenix - Redlands CA, US
Kalpana Shyam - Los Altos CA, US
James Zu-Chia Teng - San Jose CA, US
Julie Ann Watts - Morgan Hill CA, US
Jay A. Yothers - Gilroy CA, US

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F017/30
G06F007/00

US Classification:

707 8, 707201, 707202

Abstract:

Traditional update semantics are provided when updates change the location of records in a database. The system detects that an update to a record will cause the record to change locations in a database from an original location to an updated location. The system selectively prevents activity in the database between the original location and update location until the updated record has changed locations in the database from the original location to the updated location.