International Business Machines Corporation

Xun Li

Thomas Abel Beavin

Curt Lee Cotner

Gerald George Kiernan

Yao-Ching Stephen Chen

Walid Rjaibi

Timothy Jon Vincent

Shuanglin Guo

Dengfeng Gao

Hsiuying Yen Cheng

Gregory R Stager

Patrick Michael Malone

Irene C Liu

Liyan Zhou

Brian Tran

Eric L Alton

Joyce A Taylor

Harley W Boughton

Yuping Ding

Xiazhen Wang

According to one embodiment of the present invention, a system processes a database query, and comprises a computer system including at least one processor. The system identifies one or more expressions within the database query utilizing a database object with value masking. Masking requirements are determined for each identified expression and the database object utilized by that identified expression is replicated to provide masked and actual versions of that database object in response to the masking requirements for that expression including masked values and actual values of that database object. The value masking of the database object is applied to the identified expressions within the database query based on the determined masking requirements to produce search results with masked values for the database query. Embodiments of the present invention further include a method and computer program product for processing a database query in substantially the same manner described above.

Query transformation for masking data within database objects

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

Growing community of inventors

San Jose, CA, United States of America

Xun Li