CPC G06F 16/24542 (2019.01) [G06F 11/3466 (2013.01); G06F 16/9024 (2019.01); G06N 20/00 (2019.01)] | 20 Claims |
1. A method performed by a computing system, the method comprising:
determining, for each of a plurality of query sets in a plurality of query jobs, a query set feature representation, based on a first intermediate representation of features corresponding to each of a plurality of default query plan graphs and a second intermediate representation of features corresponding to each of a plurality of respective optimized query plan graphs;
executing a first subset of the query sets;
generating execution data of each query set of the first subset, the first subset selected based on a difference, determined by a difference model, between a default value of a performance metric and an optimized value of the performance metric associated with each of the query sets with respective ones of the query set feature representations; and
deploying, to a query optimizer in a database host, optimized query models corresponding to a second subset of the query sets that is selected from the first subset based on a retrained version of the difference model that is retrained according to the execution data.
|