The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Jan. 06, 2015
Filed:
Oct. 03, 2011
Eric L. Alton, Markham, CA;
Thomas A. Beavin, Milpitas, CA (US);
Harley W. Boughton, Mississauga, CA;
Yao-ching S. Chen, Saratoga, CA (US);
Curt L. Cotner, Gilroy, CA (US);
Yuping Ding, Markham, CA;
Dengfeng Gao, San Jose, CA (US);
Gerald G. Kiernan, San Jose, CA (US);
Xun LI, San Jose, CA (US);
Irene C. Liu, San Jose, CA (US);
Walid Rjaibi, Markham, CA;
Gregory R. Stager, Markham, CA;
Joyce A. Taylor, San Jose, CA (US);
Timothy J. Vincent, Toronto, CA;
Liyan Zhou, San Jose, CA (US);
Eric L. Alton, Markham, CA;
Thomas A. Beavin, Milpitas, CA (US);
Harley W. Boughton, Mississauga, CA;
Yao-Ching S. Chen, Saratoga, CA (US);
Curt L. Cotner, Gilroy, CA (US);
Yuping Ding, Markham, CA;
Dengfeng Gao, San Jose, CA (US);
Gerald G. Kiernan, San Jose, CA (US);
Xun Li, San Jose, CA (US);
Irene C. Liu, San Jose, CA (US);
Walid Rjaibi, Markham, CA;
Gregory R. Stager, Markham, CA;
Joyce A. Taylor, San Jose, CA (US);
Timothy J. Vincent, Toronto, CA;
Liyan Zhou, San Jose, CA (US);
International Business Machines Corporation, Armonk, NY (US);
Abstract
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.