US 11,734,252 B2
Online determination of result set sensitivity
Alex Umansky, Akko (IL); David Edward Brookler, Maalot (IL); Gilad Mittelman, Kiryat Motzkin (IL); Shai Kariv, Zofit (IL); Tomer Levav, Haifa (IL); and Tomer Weisberg, Haifa (IL)
Assigned to MICROSOFT TECHNOLOGY LICENSING, LLC, Redmond, WA (US)
Filed by Microsoft Technology Licensing, LLC, Redmond, WA (US)
Filed on Nov. 7, 2017, as Appl. No. 15/806,293.
Prior Publication US 2019/0138625 A1, May 9, 2019
Int. Cl. G06F 16/23 (2019.01); G06F 16/245 (2019.01); G06F 16/25 (2019.01); G06F 21/62 (2013.01)
CPC G06F 16/2358 (2019.01) [G06F 16/245 (2019.01); G06F 16/256 (2019.01); G06F 21/6245 (2013.01)] 20 Claims
OG exemplary drawing
 
1. A system comprising:
a data store storing metadata;
a memory device storing processor-executable process steps; and
a processing unit to execute the processor-executable process steps to cause the system to:
receive a database query from a database client;
determine output columns associated with a database query;
determine a plurality of data sources associated with the determined output columns;
determine, based on the metadata, information types associated with each of the determined data sources;
determine, based on the metadata, sensitivity information associated with each of the determined data sources, wherein the determined sensitivity information of a first data source of the determined data sources is determined based on a combination of table-level sensitivity information associated with an entirety of a database table associated with the first data source and dedicated sensitivity information associated with a column that resides in the database table;
determine result set sensitivity information based on the determined sensitivity information associated with each of the determined data sources, wherein the result set sensitivity information includes, for each determined information type, the most sensitive classification of the determined sensitivity information for the determined information type;
acquire a result set based on the database query; and
transmit the result set and the result set sensitivity information to the database client.