Patent ID: 11921719
Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 0:
1. A computer-implemented method comprising:
training a machine learning model by:
generating a set of training queries using at least one of a query workload and relationships between tables in a database;
building a query graph for each of the set of training queries;
computing, for each training query of the set of training queries, a selectivity based at least in part on the query graph; and
building, based at least in part on the set of training queries, an initial join result distribution as a collection of query graphs;

compiling new queries in a new query workload using input including at least one change selected from a group consisting of new queries based on workloads, new tables, and changes to data; and
performing retraining the machine learning model using the new query workload to create updates and updating the collection of query graphs using the updates.