Invention Grant
- Patent Title: Processing database statements for a relational database
-
Application No.: US14948847Application Date: 2015-11-23
-
Publication No.: US10592471B2Publication Date: 2020-03-17
- Inventor: Pedro M. Barbas , Joseph Duffy , Lei Pan , David M. Tilson
- Applicant: International Business Machines Corporation
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Mollborn Patents, Inc.
- Agent Fredrik Mollborn
- Main IPC: G06F16/2455
- IPC: G06F16/2455 ; G06F16/16

Abstract:
A computer-implemented method of a database statement for a relational database. The database comprises one or more tables comprising one or more data rows. A database statement is received. A set of predicates from the database statement and a set of data rows from the tables to use to generate the result of the database statement are determined. A set of interdiction statements applicable to one or more data rows is obtained. For each predicate, a set of masks applicable to one or more data rows is obtained, where for each mask, the data masked by the mask is used by the predicate. It is determined if a data row has an applicable interdiction statement, and contains data masked by a mask. If so, the result of the database statement without using the result of applying the predicate to the data row.
Public/Granted literature
- US20170147592A1 PROCESSING DATABASE STATEMENTS FOR A RELATIONAL DATABASE Public/Granted day:2017-05-25
Information query