Real-time data redaction in a database management system

• US 9,715,528 B2
• Filed: 06/23/2014
• Issued: 07/25/2017
• Est. Priority Date: 12/01/2011
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Lim, Dah-Yoh, Youn, Paul, Ho, Min-Hank, Samuel, Javed, Knaggs, Peter
• Primary Examiner(s): DANG, THANH HA T
• Application Number:
  US14/312,578
• Publication Number:
  US 20140304298A1
• Time in Patent Office: 1,128 Days
• Field of Search: 707769
• CPC Class Codes: G06F 16/2456 Join operations
• CPC Class Codes: G06F 16/248 Presentation of query results

Abstract

A database server receives a data request from a client. In response to the data request, the database server selects, from a database, actual data that satisfies criteria specified by the data request. The database server retrieves the selected actual data from the database. Also in response to the data request, the database server redacts the retrieved data in real time without modifying the actual data contained within the database. This may be accomplished by the prior insertion of masking operators into a top SELECT clause of a query representation generated during semantic analysis. The database server returns the redacted data to the client as a reply to the data request.

Claims

1. A computer-implemented method comprising steps of:

generating an internal representation of a query that references a plurality of columns that includes a particular column;

determining that said particular column is affected by a redaction policy, wherein said redaction policy specifies a regular expression that applies to said particular column, wherein said regular expression;

specifies one or more matching criteria for a matching string;

indicates one or more values to replace with a random value;

executing the query, wherein executing the query includes;

for a particular column value in said particular column, determining that a particular string in said particular column value matches said one or more matching criteria;

in response to determining that a particular string matches said matching criteria, generating a replacement string, wherein generating a replacement string includes, replacing, according to said regular expression, one or more characters in said particular string with a random value;

returning said replacement string in place of said particular string.

2. The method of claim 1,

wherein said query includes multiple column instances that each reference said particular column;

for a first column instance of said multiple column instances, determining to place within the internal representation a masking operator corresponding to said first column instance;

for a second column instance of said multiple column instances, determining to not place within the internal representation a masking operator corresponding to said second column instance;

executing the query based on the internal representation, wherein executing the query comprises executing the masking operator to redact data.

3. The method of claim 2, wherein determining to not place within the internal representation a masking operator corresponding to said second column instance includes determining that a join operation involves said second column instance.

4. The method of claim 2, wherein determining to place within the internal representation a masking operator corresponding to said first column instance includes determining that said first column instance is included in a top SELECT clause of said query.

5. The method of claim 1, wherein said particular column stores data of a large object type;

wherein said redaction policy specifies a portion of a large object of said large object type,

wherein said portion includes multiple instances of data items;

wherein executing the query includes;

determining that an at least one instance of said multiple instances of data items match said matching criteria;

replacing the at least one instance of said data items that match said matching criteria with different data.

6. One or more non-transitory storage media storing instructions, which when executed by one or more computing devices, cause:

generating an internal representation of a query that references a plurality of columns that includes a particular column;

determining that said particular column is affected by a redaction policy, wherein said redaction policy specifies a regular expression that applies to said particular column, wherein said regular expression;

specifies one or more matching criteria for a matching string;

indicates one or more values to replace with a random value;

executing the query, wherein executing the query includes;

for a particular column value in said particular column, determining that a particular string in said particular column value matches said one or more matching criteria;

in response to determining that a particular string matches said matching criteria, generating a replacement string, wherein generating a replacement string includes, replacing, according to said regular expression, one or more characters in said particular string with a random value;

returning said replacement string in place of said particular string.

7. The one or more non-transitory storage media of claim 6,

wherein said query includes multiple column instances that each reference said particular column;

wherein the instructions further including instructions that, when executed by one or more computing devices, cause;

for a first column instance of said multiple column instances, determining to place within the internal representation a masking operator corresponding to said first column instance;

for a second column instance of said multiple column instances, determining to not place within the internal representation a masking operator corresponding to said second column instance;

executing the query based on the internal representation, wherein executing the query comprises executing the masking operator to redact data.

8. The one or more non-transitory storage media of claim 7, wherein determining to not place within the internal representation a masking operator corresponding to said second column instance includes determining that a join operation involves said second column instance.

9. The one or more non-transitory storage media of claim 7, wherein determining to place within the internal representation a masking operator corresponding to said first column instance includes determining that said first column instance is included in a top SELECT clause of said query.

10. The one or more non-transitory storage media of claim 6, wherein said particular column stores data of a large object type;

wherein said redaction policy specifies a portion of a large object of said large object type,

wherein said portion includes multiple instances of data items;

wherein executing the query includes;

determining that an at least one instance of said multiple instances of data items match said matching criteria;

replacing the at least one instance of said data items that match said matching criteria with different data.