Invention Grant
- Patent Title: Database query processing on encrypted data
-
Application No.: US15164369Application Date: 2016-05-25
-
Publication No.: US10210266B2Publication Date: 2019-02-19
- Inventor: Panagiotis Antonopoulos , Kapil Vaswani , Krishna Nibhanupudi , Neerumalla Bala Rama Koteswara Rao
- Applicant: Microsoft Technology Licensing, LLC
- Applicant Address: US WA Redmond
- Assignee: Microsoft Technology Licensing, LLC
- Current Assignee: Microsoft Technology Licensing, LLC
- Current Assignee Address: US WA Redmond
- Agency: Fiala & Weaver P.L.L.C.
- Main IPC: G06F17/30
- IPC: G06F17/30 ; H04L9/14 ; H04L9/00 ; H04L29/06

Abstract:
Methods, systems, apparatuses, and computer program products are provided for secure handling of queries by a data server and a database application. A parameterized query is received from a client. Table column metadata is loaded for one or more table columns referenced by the parameterized query. Datatypes of expressions in the parameterized query are derived with any parameters and variables of the parameterized query indicated as having unknown datatypes. Unsupported datatype conversions in the parameterized query are determined. An encryption scheme is inferred for any parameters and variables to generate an inferred encryption scheme set. The datatypes of expressions in the parameterized query are re-derived with any parameters and variables having their inferred encryption schemes. Encryption key metadata corresponding to the inferred encryption scheme set is loaded. An encryption configuration is transmitted to the client that includes the inferred encryption scheme for any parameters and variables.
Public/Granted literature
- US20170344646A1 DATABASE QUERY PROCESSING ON ENCRYPTED DATA Public/Granted day:2017-11-30
Information query