Flexible limiters for managing resource distribution

A system comprising:

• one or more processors;
• and
• one or more computer-readable memories coupled to the one or more processors and having instructions stored thereon that are executable by the one or more processors to perform operations comprising:
• in response to receiving a request for the execution of a first statement at one or more threads associated with parallel processing at the system, obtaining a first snapshot object of an initial hierarchy of workload classes organizing sets of statements, wherein the first snapshot object includes pointers to limiters defined for the workload classes and the statements within the initial hierarchy, wherein each limiter defines an allowable number of threads for parallel execution of jobs created for a statement or a workload class, and wherein each of the limiters is applied to a respective workload class and one or more child workload classes or statements in aggregation;
• performing a modification to the hierarchy of workload classes during runtime of the one or more jobs;
• obtaining a second snapshot object of a modified hierarchy of the workload classes;
• and
• completing the execution of one or more created jobs for the execution of the first statement based on complying with limits as aggregately calculated for the first statement according to application of the limiters defined for the initial hierarchy of workload classes.

A non-transitory, computer-readable medium coupled to one or more processors and having instructions stored thereon which, when executed by the one or more processors, cause the one or more processors to perform operations comprising:

• in response to receiving a request for the execution of a first statement at one or more threads associated with parallel processing at a system, obtaining a first snapshot object of an initial hierarchy of workload classes organizing sets of statements, wherein the first snapshot object includes pointers to limiters defined for the workload classes and the statements within the initial hierarchy, wherein each limiter defines an allowable number of threads for parallel execution of jobs created for a statement or a workload class, and wherein each of the limiters is applied to a respective workload class and one or more child workload classes or statements in aggregation;
• performing a modification to the hierarchy of workload classes during runtime of the one or more jobs;
• obtaining a second snapshot object of a modified hierarchy of the workload classes;
• and
• completing the execution of one or more created jobs for the execution of the first statement based on complying with limits as aggregately calculated for the first statement according to application of the limiters defined for the initial hierarchy of workload classes.