Abstract: An object type translator (OTT) determines one or more database object types. The one or more database object types are mapped to a first structural language type definition code. After being generated, the user may add user code to the first structural language type definition code. During regeneration of these files, the first structural language type definition code is then parsed to determine the user code that has been added, based on the start and end markers that the user code segments have been marked with. OTT maps these user-code segments to the corresponding database types and keeps track of the mapping and the user code. When the OTT starts generating the second structural language code, the OTT determines a position where the user code should be inserted into the second structural language type definition code using that mapping. The user code is then inserted in the second structural language code in the position determined.

Abstract: A system, method, computer program and system for suspending a result set and continuing from a suspended result set for a cursor is disclosed. The rows from a row source corresponding to the cursor result set are suspended into storage so that when a fetch is requested the data can be sent (continued) from the suspended storage and does not depend on the original cursor row source or session to be available.

Abstract: A system, method, computer program and system for suspending a result set and continuing from a suspended result set for transparent session migration is disclosed. The rows from a row source are suspended into storage, so that after session migration, the client fetches can transparently continue from the suspended result set.

Abstract: When a request for a shutdown of a server (e.g. database server) is requested, existing sessions established for the clients are migrated to another server. Some sessions may not be migrated for various reasons; these sessions may be terminated without migrating them.

Abstract: An object type translator (OTT) determines one or more database object types. The one or more database object types are mapped to a first structural language type definition code. After being generated, the user may add user code to the first structural language type definition code. During regeneration of these files, the first structural language type definition code is then parsed to determine the user code that has been added, based on the start and end markers that the user code segments have been marked with. OTT maps these user-code segments to the corresponding database types and keeps track of the mapping and the user code. When the OTT starts generating the second structural language code, the OTT determines a position where the user code should be inserted into the second structural language type definition code using that mapping. The user code is then inserted in the second structural language code in the position determined.

Abstract: A server side connection pool provides pooling of server connections. Thus, client side processes do not create groups of dedicated resources. Clients are provided the capability to communicate to a server side connection broker process to GET a pooled server connection comprising connection state plus a thread of execution for doing some work, whereby requesting the work can bypass the connection broker process and go directly to the assigned pooled connection. Once the client issues a RELEASE to release the pooled connection back to the pool, a completely different client process on potentially a different client middle tier machine can reuse the same pooled connection. The server-side connection pool can be logically partitioned into sub-pools that correspond to connection classes that typically correspond to respective applications. A client process can request a pooled connection having a particular state, where a stored procedure can be executed to generate such state.

Abstract: Files of software to be installed in a computer are packaged as follows. A source file is prepared to contain at least a declaration of an array of sufficient space to accommodate the files to be packaged. The source file is compiled into an executable file. Thereafter, the array in the executable file is overwritten with data from each file being packaged. Depending on the embodiment, the address of where each file begins in the executable file and each file's name may be stored in the same executable file or in a different file. The stored file names are used to identify an address of a file from its name, when the named file is first accessed. In several embodiments, the operating system loads the executable file as a library that is automatically shared by multiple instances of the application (or by multiple applications), to efficiently use physical memory.

Abstract: An object type translator (OTT) determines one or more database object types. The one or more database object types are mapped to a first structural language type definition code. After being generated, the user may add user code to the first structural language type definition code. During regeneration of these files, the first structural language type definition code is then parsed to determine the user code that has been added, based on the start and end markers that the user code segments have been marked with. OTT maps these user-code segments to the corresponding database types and keeps track of the mapping and the user code. When the OTT starts generating the second structural language code, the OTT determines a position where the user code should be inserted into the second structural language type definition code using that mapping. The user code is then inserted in the second structural language code in the position determined.

Abstract: A method for providing memory management for objects is described. Specifically, techniques are described for providing common memory management code to objects that are instances of different classes and for releasing a memory management subtree that starts with a particular object in the memory management tree. A memory management template provides common pre-processor memory management code. A specialized version of the memory management template is used to create a specialized template subclass. When a memory management operator of an object that is an instance of the specialized template subclass is invoked the common memory management code in the specialized template is executed. Memory is associated with each object in a hierarchical tree. Data for the memory is maintained that reflects the hierarchical tree relationship between the objects. A subtree and the associated memory can be released without an application program tracking the relationships.

Abstract: A method, system, and computer program product is disclosed for caching results in a client-side cache. Embodiments of a method, a system, and a computer program product are disclosed that associate a first snapshot of a database with a client that indicates a state of the database after a last database request by the client, and indicate any number of invalid cached results in the client cache for the client based upon the first snapshot. In some embodiments, the method further includes receiving a second snapshot that indicates a state of the database upon receipt of a database server request by the client, and updating the first snapshot with the second snapshot.

Abstract: A method, system, and computer program product is disclosed for interacting with a client supported by a client-side cache. Embodiments of a method, a system, and a computer program product are disclosed that retrieve a first snapshot, indicating a state of the database after a last database request by the client, associated with the client, determine any number of invalid cached results for the client based on the first snapshot, and transmit the any number of invalid cached results and a second snapshot, an update for the first snapshot.

Abstract: An improved method, mechanism, and system for implementing, generating, and maintaining for implementing session pools is disclosed. Disclosed is a method, mechanism, and system for dynamic sizing of session pools, in which the number of sessions in a given session pool or sub-session pool can be dynamically adjusted upwards or downwards. Also disclosed is an approach for customizing a session in a session pool with a specific set of affinities and attributes, in which tags can be associated with the customized sessions. Tagging can be used to identify sessions to deallocate/reallocate to dynamically size the session or sub-session pools.

Abstract: Disclosed are improved methods, systems, and mediums for implementing a dynamic cursor cache. Cached cursors are tagged to facilitate identification and reuse of cursors from a cursor cache. Cursor caches and cursor usage are managed in an integrated and/or coordinated manner between multiple nodes that have related sets of cursors or cursor resources.

Abstract: One embodiment of the present invention provides a system that facilitates making an inter-process procedure call through a shared memory that is shared between a client process and a server process, wherein the client makes the inter-process procedure call as if the client is making a local procedure call, but the procedure call actually executes on the server. The system operates by receiving a request from the client through an Application Programming Interface (API) to make an inter-process procedure call. The system then allocates a section of the shared memory for the data structure parameters of the inter-process procedure call. Additionally, the client process acquires a lock on a commonly known section of shared memory called a Parameter Control Block. Once the lock is acquired, the client process stores parameters for the inter-process procedure call in the Parameter Control Block. Finally, the client process clears a Call_Done flag and releases the lock.

Abstract: Multiple groups of read-only files, for use by various components of an application program in a computer, are packaged as follows. Several executable files are prepared, each executable file corresponding to a group of read-only files used by one or more components. Each executable file includes an array that has sufficient space to accommodate the group of read-only files to be packaged therein. Each array in each executable file is overwritten with data from a corresponding group of read-only files. The presence or absence of each executable file for a group of read-only files is indicated by an index that is developed during initialization of components. Retrieval of data is from the executable files, if the index indicates, on first accessing each read-only file, that the corresponding executable file is present. If the executable file is indicated by the index as being absent, then the read-only file is directly accessed.

Abstract: When a request for a shutdown of a server (e.g. database server) is requested, existing sessions established for the clients are migrated to another server. Some sessions may not be migrated for various reasons; these sessions may be terminated without migrating them.

Abstract: A computer automatically identifies multiple occurrences of an abstract data type that is embedded within an object of metadata of another abstract data type (hereinafter “top-level” abstract data type), e.g. by recursively visiting each element of the top-level abstract data type. Then the computer automatically generates, for the top-level abstract data type, a top-level description that contains a description of each embedded abstract data type. At several locations in the top-level description that correspond to occurrences of a given embedded abstract data type in the top-level abstract data type, the computer automatically inserts offsets that identify a common position where the single description of that given embedded abstract data type is present in the top-level description. Use of multiple offsets that identify a common position of an embedded description reduces space otherwise occupied by multiple embedded descriptions in prior art's top-level descriptions.

Abstract: A method for providing memory management for objects is described. Specifically, techniques are described for providing common memory management code to objects that are instances of different classes and for releasing a memory management subtree that starts with a particular object in the memory management tree. A memory management template provides common pre-processor memory management code. A specialized version of the memory management template is used to create a specialized template subclass. When a memory management operator of an object that is an instance of the specialized template subclass is invoked the common memory management code in the specialized template is executed. Memory is associated with each object in a hierarchical tree. Data for the memory is maintained that reflects the hierarchical tree relationship between the objects. A subtree and the associated memory can be released without an application program tracking the relationships.

Abstract: A system, method, computer program and system for suspending a result set and continuing from a suspended result set for a cursor is disclosed. The rows from a row source corresponding to the cursor result set are suspended into storage so that when a fetch is requested the data can be sent (continued) from the suspended storage and does not depend on the original cursor row source or session to be available.

Abstract: A system, method, computer program and system for suspending a result set and continuing from a suspended result set for transparent session migration is disclosed. The rows from a row source are suspended into storage, so that after session migration, the client fetches can transparently continue from the suspended result set.