International Business Machines Corporation

Jerome Quan Wong

Fen-Ling Lin

William Robert Bireley

Roy Lorenzo Smith

Maureen Mae McDevitt

Yun Yu Wang

Curt Lee Cotner

James Z Teng

Donald J Haderle

Bryan Frederick Smith

Akira Shibamiya

Hong Sang Tie

Tammie Dang

Nelson Mendonca Mattos

Paramesh Sampatrai Desai

Regina J Liu

Randy Mitchell Nakagawa

Adrian B Lobo

Kathryn Ruth Zeidenstein

Kou Horng Yang

Kimberly Anne Braia

Lisa R Curran

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 method, apparatus, and article of manufacture for a computer implemented authorization system. A statement is to be executed by a computer to manipulate data in a database stored on a data storage device connected to the computer. Initially, an environment of the database from which the statement was invoked is identified. Additionally, a security option is identified. Then, authorization privileges for the statement are determined based on the identified environment and security option.

Context-sensitive authorization in an RDBMS

A method, apparatus, and article of manufacture for a computer implemented two-level caching system. A statement is executed in a computer. The statement is executed by the computer to manipulate data in a database stored on a data storage device connected to the computer. Initially, a first statement is prepared to create an executable structure for executing the first statement from an application. Then, the executable structure is stored in an application-level cache associated with the application. A second statement is received for execution from the application. It is determined that the second statement can be executed using the stored executable structure for the first statement. Next, the second statement is executed using the stored executable structure.

Two-level caching system for prepared SQL statements in a relational

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

Mountain View, CA, United States of America

Jerome Quan Wong