International Business Machines Corporation

Binghua Zhen

You-Chin Gene Fuh

Yun Yu Wang

Ping Wang

Fen-Ling Lin

Yao-Ching Stephen Chen

Li Jun Xia

Lee-Chin Hsu Liu

Li-Mey P Lee

Allan Benjamin Lebovitz

A system and computer readable medium for executing a query to access data stored in a database, wherein the query includes a plurality of DISTINCT keys, is disclosed. The system and computer readable medium includes a capture module for identifying each of the plurality of DISTINCT keys in the query and a sort module coupled to the capture module for determining if more than one sort is needed to execute the query, performing a first DISTINCT operation on a first DISTINCT key of the plurality of DISTINCT keys, storing data fetched from the first DISTINCT operation in a master workfile only if more than one sort process is needed to execute the query, and utilizing the master workfile to perform subsequent DISTINCT operations on the other of the plurality of DISTINCT keys.

System for executing a query having multiple distinct key columns

Techniques are provided for processing a query using an index. It is determined whether a number of consecutive keys that evaluate to a false-positive when applying a screening predicate in the query exceeds a false-positive predefined value. One or more keys in the index are skipped in response to determining that the number of consecutive keys exceeds the false-positive predefined value.

System and article of manufacture for efficient evaluation of index screening predicates

A method for executing a query to access data stored in a database, wherein the query includes a plurality of DISTINCT keys, is disclosed. The method of the present invention includes providing a first DISTINCT operation on a first DISTINCT key, storing data fetched from the first DISTINCT operation in a master workfile if more than one sort process is needed to execute the query, and utilizing the master workfile to perform subsequent DISTINCT operations for the other DISTINCT keys.

Method for executing a query having multiple distinct key columns

Method for efficient evaluation of index screening predicates

Growing community of inventors

San Jose, CA, United States of America

Binghua Zhen