Automatic resource allocation design for satisfying service level goals of mixed workload queries in a database system

A non-transitory computer-readable tangible medium, on which is recorded a computer program, the computer program comprising executable instructions, that, when executed, perform a method comprising:

• a database system receiving a query to be processed;
• the database system having resources;
• the database system assigning, based on input from a user, the query to a tier of resource allocation priorities in a hierarchy of tiers, the tier having been designated as being automatically managed by the database system, the tier having a plurality of levels of priority for resource allocation (LPRAs);
• the database system decomposing the query into a first step and a set of subsequent steps, the first step having a beginning and each of the set of subsequent steps having a respective beginning;
• the database system assigning the first step to a first LPRA, wherein executing the query at the first LPRA is projected by the database system to satisfy a service level goal (SLG) within a on_schedule_range of the SLG;
• and
• the database system determining during execution of the set of subsequent steps that the query is no longer projected to satisfy the SLG within the on_schedule_range of the SLG and, as a result, assigning one of the set of subsequent steps to a second LPRA different from the first LPRA, wherein executing the query at the second LPRA is projected by the database system to return execution of the query to within the on_schedule_range of the SLG.

A computer-implemented method comprising:

• a database system having resources and maintaining a hierarchical plurality of tiers of priorities for allocating database resources;
• the database system designating, based on input from a user, an automatically-managed tier from among the plurality of tiers as being automatically managed by the database system, the automatically-managed tier having a plurality of levels of priority for resource allocation (LPRAs);
• the database system receiving a query to be processed and an assignment of the query to a workload assigned to the automatically-managed tier;
• the database system decomposing the query into a first step and a set of subsequent steps, the first step having a beginning and each of the set of subsequent steps having a respective beginning;
• the database system assigning the first step to a first LPRA, wherein executing the query at the first LPRA is projected by the database system to satisfy a service level goal (SLG) within a on_schedule_range of the SLG;
• and
• the database system determining during execution of the set of subsequent steps that the query is no longer projected to satisfy the SLG within the on_schedule_range of the SLG and, as a result, assigning one of the set of subsequent steps to a second LPRA different from the first LPRA, wherein executing the query at the second LPRA is projected by the database system to return execution of the query to with the on_schedule_range of the SLG.