International Business Machines Corporation

Hsiuying Yen Cheng

Thomas Abel Beavin

Fen-Ling Lin

Yao-Ching Stephen Chen

Mengchu Cai

Jerry Mukai

Li Jun Xia

Yoichi Tsuji

Irene Ching-Hua Liu

Ying Zeng

Demai Ni

Akira Shibamiya

Shuanglin Guo

Patrick Michael Malone

Annie S Tsang

Xun Li

Brian Tran

Jung-hsin Eva Hu

Terry Dennis Allen

Kyung B Lee

Xiazhen Wang

Techniques are provided that determine that a query includes at least one subquery that may be correlated or decorrelated. An internal representation of the query that represents the subquery in both correlated and decorrelated form is generated, wherein the internal representation includes at least one virtual table.

Cost-based subquery correlation and decorrelation

A method, apparatus, and article of manufacture for improving the performance of evaluating predicates with non-matching operands by aggressively casting the input value to the data type of the target column before the data of the target column is accessed.

High performance predicate push-down for non-matching predicate operands

Aspects for improving response time for database query execution are described. The aspects include comparing an estimate of sort pages needed for a database query against at least one threshold. A determination of whether to perform a parallel sort for the database query based on the comparison occurs, wherein response time improvement by the parallel sort is balanced against resource overhead of the parallel sort.

Method and system for improving response time for database query execution

The present invention is directed to a storage management system. More particularly if relates to a client/server library system for storing objects in the library system in batches by avoiding storing those objects in an intermediary storage, such as in a client storage space or in a cache, before storing them in the library system. The invention includes a library server, object server and library client, in which an application program interacts with the library client for storing objects, or binary large objects (blobs), in the object server under control of the library server. The present invention provides for an application program to read in objects into a memory space allocated and managed by the application program, or into an application program memory space allocated and managed by the library client. When the library client stores the objects residing in the allocated memory space, copies of the objects are transferred directly from the allocated memory space to the object server without having another copy of the object first being made in the library client, such as in the library client storage space or in a client cache. Accordingly, batch storage of objects is accomplished more efficiently than in conventional library system.

Method and apparatus for batch storage of objects in a client-server storage management system

Growing community of inventors

Fremont, CA, United States of America

Hsiuying Yen Cheng