Patent ID: 7774372

Claim:
A computer system configured to provide additional temporary tables to a relational database management system comprising: a memory within which is resident a global temporary database descriptor having a limited number of object descriptors available for objects of global scope, each object descriptor having a unique object identifier value; at least one processor configured to execute a plurality of threads; and program code configured to be executed by the at least one processor to: process database requests from a plurality of database requests to determine whether each of the temporary objects that will be created or accessed in response to a particular request of the database requests is a local temporary object available only to a particular database session or a global temporary object available to a plurality of concurrently running database sessions; create a plurality of local temporary database descriptors, within the memory, where each of the plurality of local temporary database descriptors is created in response to a request determined to require a local temporary object for a particular database session, the local temporary object referenced by an object descriptor stored in a local temporary database descriptor; and create a plurality of local temporary object descriptors, within the memory for each of the local temporary database descriptors, where each of the local temporary object descriptors so created has a unique value.