International Business Machines Corporation

Catharina K Wong

Paul Miller Bird

Michael Jeffrey Winer

Yuk Kuen Chan

Hebert Walter Pereyra

Michael Joshua Snowbell

Roger Luo Q Zheng

Kathy A McKnight

Yeung-Kuen See

Jesse Lee

A multi-node relational database management system is provided that can be embodied in software for managing a database having declared temporary tables associated with respective software application programs. The system comprises a plurality of nodes. The nodes include a catalog node for maintaining a list of identifiers for declared temporary tables associated with any application; a coordinator node for an application; at least one subordinate node for the application, the subordinate node having at least one partition of the declared temporary tables of the application; and a declared temporary table manager for causing the coordinator node to maintain for the application a list of declared temporary tables.

Method and apparatus for synchronizing not-logged application temporary tables in a multi-node relational database management system

A lock control data structure for a unit of work of an application program. The unit of work has a set of threads of access for opening a set of objects accessible to the application program. The lock control data structure has a set of object-specific lock models corresponding to the set of objects, and a lock controller for locking each object in the set of objects. Information regarding the lock requirements for each object are stored in the corresponding object-specific lock model. The lock controller locks and unlocks each object in the set of objects based on the information stored in the corresponding object-specific lock model.

Method and system for improving concurrency through early release of unnecessary locks

Growing community of inventors

Etobicoke, Canada

Catharina K Wong