The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Dec. 24, 2019
Filed:
Jun. 14, 2017
Microsoft Technology Licensing, Llc, Redmond, WA (US);
Raghav Kaushik, Kirkland, WA (US);
Aditya Nigam, Kirkland, WA (US);
Arvind Arasu, Redmond, WA (US);
Donald Alan Kossmann, Kirkland, WA (US);
Kenneth Eguro, Seattle, WA (US);
Nikhil Vithlani, Seattle, WA (US);
Panagiotis Antonopoulos, Redmond, WA (US);
Ravi Ramamurthy, Redmond, WA (US);
Michael Zwilling, Seattle, WA (US);
Cesar Galindo-Legaria, Redmond, WA (US);
Microsoft Technology Licensing, LLC, Redmond, WA (US);
Abstract
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.