Patent ID: 7908268

Claim:
A computer implemented method of operating a relational database management system (RDBMS), the method comprising: reading 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 second individual database statements of a second sequence of database statements; processing the information and evaluating second pool resource requirements for execution of the second individual database statements of the second sequence of database statements; sending a preparation request for pool modification based on the evaluated second pool resource requirements to an asynchronous pool preparation queue; executing the second individual database statements of the second sequence of database statements, wherein after executing a last of the second individual database statements thereby forming a last executed database statement, the last executed database statement is marked as a leaf node, wherein the leaf node comprises metrics, and wherein the metrics comprise: a summary of all used database descriptors (DBDs) of all nodes in the respective path of the leaf node of the last executed database statement, the DBDs resulting from execution of the last executed database statement; a maximum of used storage for caching resource identifiers (RIDs) of all nodes in this path of the leaf node of the last executed database statement, the RIDs resulting from execution of the last executed database statement; a maximum of used sort pool size of all nodes in this path of the leaf node of the last executed database statement; and a list of all used cursor tables (CTs) of all nodes in this path of the leaf node of this last database statement, the CTs resulting from querying pool resource requirements for executing the last executed database statement; and storing information indicative of the progression of execution of the second individual database statements in a position register.