International Business Machines Corporation

Maureen Mae McDevitt

Jerome Quan Wong

Yun Yu Wang

James Z Teng

Fen-Ling Lin

Donald J Haderle

Bryan Frederick Smith

Akira Shibamiya

Hong Sang Tie

Tammie Dang

Paramesh Sampatrai Desai

William Robert Bireley

Regina J Liu

Kathryn Ruth Zeidenstein

Roy Lorenzo Smith

Kou Horng Yang

A catalog management system for executing a statement that accesses a catalog to manipulate referenced system or user-defined objects and related data. Initially, a statement for a transaction to operate on an object is received. A private copy of the structure of a catalog is created to record information about the object used by the transaction. Then, the private copy of the structure of the catalog is used for the during the transaction to access the object.

Method, apparatus, and article of manufacture for executing a statement to manipulate data

A system and method for a computer system having a plurality of DBMS providing a coordinating and assisting function. If a DBMS performs a coordinating function, it is referred to as a coordinating DBMS. If a DBMS performs an assisting function, it is referred to as an assisting DBMS. Each coordinating DBMS receives a query from a user application, decomposes the query into multiple parallel tasks, and allocates the parallel tasks to all of the DBMSs in the system. Each assisting DBMS receives one or more parallel tasks from a coordinating DBMS, executes the parallel tasks and returns the results to the coordinating DBMS. The coordinating DBMSs and assisting DBMSs access one or more storage devices. Furthermore, the present invention comprises a system and method for dynamically disabling a parallel mode on the coordinating DBMSs and the assisting DBMSs.

Query parallelism in a shared data DBMS system

Growing community of inventors

San Jose, CA, United States of America

Maureen Mae McDevitt