US 2008/0288561 A1Published application

Computer program product and method for database management system supporting multiple temporary tables

AssigneeInternational Business Machines Corporation

InventorsRamanaKumari M. Croisettier, Paramesh S. Desai, James Z. Teng

Life of this patent

Estimating the term…

Loading patent…

Abstract

A computer system and a relational database management system (RDMS) computer program product are described for interfacing a number of concurrently running database sessions with a large database in which a plurality of local temporary object database descriptors are used in lieu of a single global temporary object database descriptor where the global and each of the local temporary object database descriptors include identifiers for temporary objects, each of the local temporary object database descriptors is associated with a single database session and each of the global database descriptors is shared among multiple database sessions.

Claims6

Dependent claims

A computer system adapted 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 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

6 more elements

A relational database management system (DBMS) computer program product for managing user-defined objects of global scope and objects of local scope comprising:

a system temporary database object manager module adapted to support temporary database objects where certain of such temporary database objects are created automatically in response to user database requests and certain other of such temporary database objects are declared in explicit response to other user database requests, the temporary objects so created or declared as one of
an object of global scope wherein the attributes thereof are shared globally between database sessions and
an object of local scope wherein the attributes thereof are kept local to a particular database session, wherein objects of global scope are associated with a global temporary object database descriptor and objects of local scope are associated with a local temporary object database descriptor;
wherein the system temporary database object manager module is further configured to
manage object identifiers within a global temporary object database descriptor for those attributes that are shared globally and manage object identifiers within a plurality of local temporary object database descriptors for those attributes that are kept local to a particular database session;
a create module configured to generate, in response to a database request to create one of
an object of global scope in response to a database request for creating an object of global scope, the object of global scope having a unique global database identifier derived from the global temporary object database descriptor and an object of local scope in response to a database request for creating an object of local scope, the object of local scope having a local database identifier derived from the local temporary object database descriptor associated with the particular database session, the local database identifier being unique relative to the local temporary object database descriptor;
wherein
the create module is further configured to generate the local temporary object database descriptor for a particular database session in response to a first database request for creating an object of local scope originating from a client application;
and
a database request interpreter module configured to distinguish a database request referencing an object of global scope from a database request referencing an object of local scope.

8 more elements

Dependencies are inferred from the claim text.