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:

7080074, Jul 18, 2006

Filed:

Nov 5, 2001

Appl. No.:

10/010371

Inventors:

Namik Hrle - Boeblingen, DE
Andreas R. Maier - Stuttgart, DE
James Zu-Chia Teng - San Jose CA, US
Julie A. Watts - Morgan Hill CA, US

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 17/30

US Classification:

707 8, 707 10, 707100, 707200

Abstract:

According to the method, apparatus, and computer readable medium of the present invention, a scan is performed by accessing all rows of a table in a relational database, evaluating each row to determine whether the row satifies a set of predicates of a database query, and returning the row if it satisfies the set of predicates. According to a preferred embodiment of the present invention, all rows are evaluated regardless of current locks. The scan is continued if the row does not satisfy the set of predicates regardless of the current lock on the row. The locking semantics according to the invention has the advantage that it completely removes the problem of lock contention on the rows that do not satisfy statement predicates.