SUPPORT SHARING THE SAME TABLE FOR PROTECTED AND NON-PROTECTED DATA COLUMNS

摘要

Systems and methods are provided for supporting sharing the same table for protected and non-protected data columns. Different data object can be defined on the same database table. A discriminate flag can be defined to identify the data object to which a particular row belongs. The discriminate flag can be built into the data object so that rows belong to the data object are picked up during a query. Data protection can then be configured at the data object level so that rows that belong to the data object are subject to protection such as encryption or tokenization.

主权项

1. A method comprising:
receiving, by a computing device, a definition of a database table having a plurality of columns that support a plurality of data objects; receiving, by the computing device, information identifying at least one of the plurality of columns as an entity discriminator attribute; designating, by the computing device, the at least one of the plurality of columns as the entity discriminator attribute, wherein a query with respect to at least one data object of the plurality of data objects returns a set of rows having the entity discriminator attribute associated with the at least one data object; receiving, by the computing device, information identifying at least one attribute of a plurality of attributes of the at least one data object as a protected field; and designating, by the computing device, the at least attribute as a protected field.