Predictive Database Pool Preparation

A computer program product comprising a computer useable medium having a computer readable program, wherein the computer readable program, when executed on a data processing system, causes the data processing system to:

• read information from a first execution plan, wherein the first execution plan comprises a set of nodes that represent first individual database statements of a sequence of first database statements and wherein each node in the set of nodes comprises information regarding first pool resource requirements for executing the first sequence of database statements, in response to an execution request for a second individual database statement of a second sequence of database statements;
• process the information and evaluate second pool resource requirements for execution of individual database statements of the second sequence of database statements;
• send a preparation request for pool modification based on the evaluated second pool resource requirements to an asynchronous pool preparation queue;
• execute the second individual database statement of the second sequence of database statements;
• and
• store information indicative of the progression of execution of the second individual database statement in a position register.

A system for operating a relational database management system (RDBMS), the system comprising:

• a processor;
• and
• a memory coupled to the processor, wherein the memory comprises instructions which, when executed by the processor, causes the processor to:
• read information from a first execution plan, wherein the first execution plan comprises a set of nodes that represent first individual database statements of a sequence of first database statements and wherein each node in the set of nodes comprises information regarding first pool resource requirements for executing the first sequence of database statements, in response to an execution request for a second individual database statement of a second sequence of database statements;
• process the information and evaluate second pool resource requirements for execution of individual database statements of the second sequence of database statements;
• send a preparation request for pool modification based on the evaluated second pool resource requirements to an asynchronous pool preparation queue;
• execute the second individual database statement of the second sequence of database statements;
• and
• store information indicative of the progression of execution of the second individual database statement in a position register.