International Business Machines Corporation

Kou Horng Yang

James Z Teng

Bryan Frederick Smith

Paramesh Sampatrai Desai

Yun Yu Wang

Fen-Ling Lin

Donald J Haderle

Akira Shibamiya

Hong Sang Tie

Tammie Dang

William Robert Bireley

Jerome Quan Wong

Kathryn Ruth Zeidenstein

Maureen Mae McDevitt

A system and method for a computer based system having one or more consuming DBMSs and one or more producing DBMSs such that the producing DBMSs produce workfiles for the consuming DBMSs. A producing DBMS uniquely identifies the bufferpool pages comprising a workfile, uniquely identifies the workfile, and flushes only the bufferpool pages corresponding to the workfile to a storage device. The producing DBMS further notifies the consuming DBMS that the workfile is available and receives a reply from the consuming DBMS indicating that the consuming device retrieved the data from the storage device. The consuming device receives notification from the producing DBMS, retrieves the workfile, and replies to the producing DBMS that it has retrieved the workfile.

Bufferpool coherency for identifying and retrieving versions of workfile

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

Santa Clara, CA, United States of America

Kou Horng Yang