James I Teng, 57285 Calle Da Gama, Anaheim, CA 92807

6460048, Oct 1, 2002

May 13, 1999

09/311075

James Zu-Chia Teng - San Jose CA
Jeffrey James Todd - Aromas CA

International Business Machines Corporation - Armonk NY

G06F 1700

707103R

Disclosed is a system, method, and program for reorganizing at least one database object. The database object is comprised of at least one database file. Each database file has a name. Source database files including data for the database objects subject to the reorganization have source names. Shadow copies of the source database files are created and shadow names for the shadow copies are generated, such that the source names and corresponding shadow names are different. The data in the shadow copies is reorganized. After the reorganization, the shadow names are used to access the database files for the reorganized database objects.

6519613, Feb 11, 2003

Mar 16, 2000

09/527501

Craig Alan Friske - San Jose CA
Gary Howard Sockut - San Jose CA
James Zu-Chia Teng - San Jose CA
Stephen Walter Turnbaugh - Hollister CA

International Business Machines Corporation - Armonk NY

G06F 1700

707202, 707200, 707201

A method and apparatus for online reorganization of a database which does not prevent a process from accessing the database during the data reorganization. The invention uses a non-blocking drain to lock on a database, unloads a copy of the data contained in the database, reorganizes the copied data, loads the reorganized data into a shadow location, applies log records to the shadow location data so that the reorganized data may be adjusted for any changes to the database after the data was copied and reorganized, and then replaces the data in the database with the reorganized data. The non-blocking drain does not prevent other requests on the database from being processed while the reorganization lock is in place, except briefly when the reorganized data replaces the data in the database.

6557082, Apr 29, 2003

Mar 30, 2000

09/539664

Jeffrey William Josten - San Jose CA
James Zu-Chia Teng - San Jose CA

International Business Machines Corporation - Armonk NY

G06F 1300

711141, 711142, 711119, 707201

A method, apparatus and article of manufacture for ensuring cache coherency in a database containing a data store on a central data storage device connected to a plurality of computers. When an immediate write option is set, the data in a local buffer pool changed by a first transaction on a first computer is immediately written to a group buffer pool at the central data storage device, prior to initiating a second transaction upon a second computer that relies upon the modified data. Local buffer pools are then invalidated thereby facilitating local buffer pool updates from the group buffer pool. The immediate write (IW) option may be a subsystem parameter set at a system level or a bind option set at a plan level. The immediate write option may be set so that data is written to the group buffer pool at or before a phase one commit.

6694305, Feb 17, 2004

Jul 26, 2001

09/915866

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

International Business Machines Corporation - Armonk

G06F 1730

707 2, 707 4

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.

6754656, Jun 22, 2004

Oct 22, 1996

08/735168

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

International Business Machines Corporation - Armonk NY

G06F 1730

707 8, 707 9, 707100, 707101

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.

6775676, Aug 10, 2004

Sep 11, 2000

09/659252

Guenter Briam - Wiesloch, DE
Namik Hrle - Boeblingen, DE
James Z. Teng - San Jose CA

International Business Machines Corporation - Armonk NY
SAP Aktiengesellschaft - Walldorf

G06F 1730

707101, 707102, 707103, 707104

A defer dataset creation system creates database objects at a computer connected to a data storage device. Initially, a command to create a database object is received. A database object definition for that database object is recorded. When the database object is accessed, a dataset for the database object is created from its database object definition.

6823326, Nov 23, 2004

Mar 30, 2001

09/823062

James Zu-Chia Teng - San Jose CA
Namik Hrle - Boeblingen, DE
Akira Shibamiya - Los Altos CA
Stephen Walter Turnbaugh - Hollister CA

International Business Machines Corporation - Armonk NY

G06F 1730

707 1, 711170

A method and system for formatting space in a storage device for a database system is disclosed. The method and system include formatting a first increment for creating a database file and asynchronously formatting at least one subsequent increment for the database file in a background of the database system.

6944615, Sep 13, 2005

Jun 28, 2001

09/894090

James Zu-Chia Teng - San Jose CA, US
Namik Hrle - Boeblingen, DE

International Business Machines Corporation - Armonk NY

G06F017/30

707 8, 707201

In a database management system (DBMS) () for a database application () including a database () having a table () and a unique key index () having indexes () therefor, the DBMS () includes a data manager (), an index manager (), a transaction manager (), and a lock manager () which restricts access to the table by assigning locks to elements thereof. In order to avoid deadlock in the database application due to the pseudo-deleted entries, the lock categories include an X-lock and a Conditional S-lock, and have lock attributes including at least a Delete attribute for the X-lock. The Conditional S-lock is compatible (granted by the lock manager) with an X-lock whose Delete attribute is NOT SET, but is not compatible (granted) with an X-lock whose Delete attribute is SET. Each index entry includes a pseudo-delete flag which is SET by the index manager () to indicate deletion of the indexed row. Conditional upon locating a pseudo-deleted index key corresponding to a key to be added to the index, the index manager () requests a Conditional S-lock on the row indexed thereby, whereby the index manager () verifies the Delete transaction which set the pseudo-delete flag has committed.