Optimizing selection of materialized views for automatic creation or refresh

A method, comprising:

• identifying, by a database system, a plurality of materialized views for creation or refresh;
• determining, by the database system, a subset of the plurality of materialized views for creation or refresh according to an optimization technique that selects the subset of the plurality of materialized views according to a maximized performance benefit for performing subsequent queries by maintaining the subset of the plurality of materialized views, wherein the maximized performance benefit for performing subsequent queries is determined based on a workload of the database system caused by a set of previously received queries that can be performed using one or more of the plurality of materialized views and a benefit function used to evaluate the set of previously received queries with respect to the plurality of materialized views, wherein at least a first materialized view of the subset of the plurality of materialized views does exist in the database system, and wherein at least a second materialized view of the subset of the plurality of materialized views does not yet exist in the database system;
• individually selecting, by the database system, a number of materialized views from the subset of the plurality of materialized views up to a managed number of execution slots available to perform respective operations for the number of materialized views in parallel according to a performance benefit-based order of the subset of the plurality of materialized views, including selecting the first materialized view of the subset of the plurality of materialized views that does exist and the second materialized view of the subset of the plurality materialized views that does not yet exist;
• and
• performing, by the database system, the of selected number of materialized views from the subset of the plurality of materialized views.

One or more non-transitory, computer-readable storage media, storing program instructions that when executed on or across one or more computing devices cause the one or more computing devices to implement:

• identifying, by a database system, a plurality of materialized views for creation or refresh;
• determining, by the database system, a subset of the plurality of materialized views for creation or refresh according to an optimization technique that selects the subset of the plurality of materialized views according to a maximized performance benefit for performing subsequent queries by maintaining the subset of the plurality of materialized views, wherein the maximized performance benefit for performing subsequent queries is determined based on a workload of the database system caused by a set of previously received queries that can be performed using one or more of the plurality of materialized views and a benefit function used to evaluate the set of previously received queries with respect to the plurality of materialized views, wherein at least a first materialized view of the subset of the plurality of materialized views does exist in the database system, and wherein at least a second materialized view of the subset of the plurality of materialized views does not yet exist in the database system;
• individually obtaining, by the database system, a number of materialized views from the subset of the plurality of materialized views up to a managed number of execution slots available to perform respective operations for the number of materialized views in parallel from a task queue that orders the subset of the plurality of materialized views according to respective performance benefit, including refresh of the first materialized view of the subset of the plurality of materialized views that does exist and the second materialized view of the subset of the plurality materialized views that does not yet exist;
• and
• causing, by the database system, the performance of the respective operations of the selected number of materialized views from the subset of the plurality of materialized views.