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

Claim 0:
1. A method, comprising:
receiving a plurality of predicates for a parametric query;
determining 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;
maintaining 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;
applying 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
causing the parametric query to be processed by an execution engine in accordance with the first execution plan.