Internal resource provisioning in database systems

A method comprising:

• determining that a materialized view of a database table is stale in response to determining that a new version of source data associated with the database table has been generated;
• in response to determining that the materialized view of the database table is stale, determining a database task to be executed in a database for providing a refreshed materialized view of the database table, the database task comprising a plurality of discrete subtasks;
• storing the database task at an execution platform that is distinct from a computing system;
• assigning the plurality of discrete subtasks to one or more nodes of a plurality of nodes of the execution platform;
• dividing processing of the plurality of discrete subtasks based on metadata of database data;
• determining whether execution of the database task is complete based at least in part on whether the plurality of discrete subtasks have been completed by the one or more nodes;
• and
• in response to determining that execution of the database task is complete, storing a record indicating that the database task is completed.

A non-transitory computer-readable medium storing instructions that, when executed by one or more computer processors of one or more computing devices, cause the one or more computing devices to perform operations comprising:

• determining that a materialized view of a database table is stale in response to determining that a new version of source data associated with the database table has been generated;
• in response to determining that the materialized view of the database table is stale, determining a database task to be executed in a database for providing a refreshed materialized view of the database table, the database task comprising a plurality of discrete subtasks;
• storing the database task at an execution platform that is distinct from the one or more computing devices;
• assigning the plurality of discrete subtasks to one or more nodes of a plurality of nodes of the execution platform;
• dividing processing of the plurality of discrete subtasks based on metadata of database data;
• determining whether execution of the database task is complete based at least in part on whether the plurality of discrete subtasks have been completed by the one or more nodes;
• and
• in response to determining that execution of the database task is complete, storing a record indicating that the database task is completed.