Microsoft Technology Licensing, LLC

Aditya Nigam

Donald Kossmann

Panagiotis Antonopoulos

Arvind Arasu

Kenneth Hiroshi Eguro

Raghav Kaushik

Ravi Ramamurthy

Nikhil Vithlani

Cesar Alejandro Galindo-Legaria

Michael I Zwilling

Donald Alan Kossmann

Computer systems, devices, and associated methods of evaluating an expression comprising restricted data are disclosed herein. In one embodiment, a method includes receiving a database statement from a client application and verifying the authenticity of the database statement. If the database statement is authentic, an approved expression is identified in the database statement for creating an evaluation rule. The method further includes restricting evaluation of expressions in a protected computing environment according to the created evaluation rule.

Expression evaluation of database statements for restricted data

Computer systems, devices, and associated methods of optimizing the execution of instructions of a database statement by a database server are disclosed herein. In one embodiment, a method includes identifying a potential execution plan for executing instructions of the database statement and estimating a cost for executing the execution plan. The cost can comprise an encrypted data processing cost associated with a operation in the execution plan of executing an operation on encrypted data in a protected computing environment. The method can include estimating the encrypted data processing cost in the protected computing environment based on statistics generated in the protected computing environment about a database table. In response to estimating the cost for executing the execution plan, comparing the cost to estimated costs of alternative execution plans, selecting the lowest-cost plan for execution, and executing the lowest-cost execution plan.

Execution optimization of database statements involving encrypted data

Growing community of inventors

Kirkland, WA, United States of America

Aditya Nigam