International Business Machines Corporation

Liyan Zhou

Curt Lee Cotner

Yao-Ching Stephen Chen

Thomas Abel Beavin

Gerald George Kiernan

James Willis Pickel

Walid Rjaibi

Jay A Yothers

Timothy Jon Vincent

Tammie Dang

Claire Willey McFeely

Margaret Ann Bernal

Yumi Kimura Tsuji

Margaret Zagelow

Dengfeng Gao

Chunfeng Pei

Gregory R Stager

Georgia Carroll Fuller

Ding-Wei Chieh

Baoqiu Cui

Xun Li

Joe Cheng-yu Huang

Irene C Liu

Hui-An Lee

Yuping Ding

Marion B Farber

Eric L Alton

Joyce A Taylor

Harley W Boughton

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

An SQL procedure deployment system deploys a query procedure comprising a procedural logic component and a database request component from a source system to a target system. At generation of the query procedure, the system generates a query procedure source code, a symbol table, and an encapsulated optimization results to regenerate run-time instructions for query statements of the database request component and make the query statements function with a deployed procedural logic component. The system maintains an association between the procedural logic component and the database request component during deployment. The system copies an internal representation of the procedural logic component to the target system without regeneration. The system regenerates the database request component to recreate the query procedure on the target system and to maintain a consistent interface between the procedural logic component and database request component.

System and method for deploying an SQL procedure

Growing community of inventors

San Jose, CA, United States of America

Liyan Zhou