Patent ID: 11934398
Assignee: MICROSOFT TECHNOLOGY LICENSING, LLC
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 9:
10. A system, comprising:
one or more processors;
memory in electronic communication with the one or more processors; and
instructions stored in the memory, the instructions being executable by the one or more processors to:
receive a plurality of predicates for a parametric query;
determine a plurality of query features for the parametric query based on the plurality of predicates, the plurality of query features indicating likelihoods that rows from one or more datasets of a relational database satisfies one or more predicates of the plurality of predicates;
maintain a cache of execution plans, the cache of execution plans including a plurality of execution plans that have been pre-selected for a type of query associated with the parametric query;
apply a plan selection model to the plurality of query features to identify a first execution plan from the cache execution plans, the plan selection model being trained to identify a given execution plan from the plurality of execution plans pre-selected for the type of query based on a predicted cost of executing a given query having a corresponding set of query features; and
cause the parametric query to be processed by an execution engine in accordance with the first execution plan.