Abstract: Methods for capturing temporary database tables for analyzing a database query are provided. Aspects include obtaining a capture pattern and the database query having a sequence of statements. Aspects also include determining that a first statement of the sequence of statements matches the capture pattern, creating a list of temporary tables based on the first statement, and determining that a second statement of the sequence of statements includes one of a drop, commit, and truncate commands that correspond to a table in the list of temporary tables. Aspects further include creating a copy of the table in the list of temporary tables, generating an updated first statement by replacing a reference to the table in the list of temporary tables with a reference to the copy of the table, removing the table from the list of temporary tables, and executing the database query by performing the sequence of statements.

Abstract: In several aspects for storing a table, in which the table is configured for comprising records having values of one or more attributes, a processor creates a pseudo table representing the table, the creating comprising defining an empty version of the table in a program. One or more records may be inserted in the pseudo table by encoding attribute values of the one or more records as inline data in the program. In response to determining that the pseudo table satisfies a materialization criterion, the pseudo table may be materialized by creating the table with the records encoded in the program and removing the program.

Abstract: A system and method for a database management system. The method comprises: receiving a database transaction for inserting a set of records in a database table of the database management system or for creating indexes. The database transaction may be executed using the database management system. The database management system may rollback the database transaction by truncating the database table or the created indexes.

Abstract: A method for generating a copy of a database using a data streaming protocol is disclosed. The method comprises setting up a structure of a secondary database, prioritizing data objects to be copied from a primary database to the secondary database, copying data objects from the primary database to the secondary database using a data streaming protocol, restoring data corresponding to the data object in the secondary database in parallel to copying data objects from the primary database to the secondary database, applying changes made to the data corresponding to the data object in the primary database during the time of copying, after the data object has been copied, and making available the secondary database for usage once all data objects have been copied from the primary database to the secondary database so that a usable copy of the primary database is created.

Abstract: An approach includes collecting metadata indicative of a computer system comprising (i) a primary database, configured to connect to a secondary database, and (ii) the secondary database that replicates the primary database. The approach further includes receiving, at the primary database from a requestor, a query referencing the primary database. The approach further includes, responsive to receiving the query, performing an offload including: determining a first load on the primary database; responsive to the first load satisfying a first offload condition, determining, using the metadata, whether a second load on the secondary database satisfies a second offload condition; and responsive to the second load satisfying the second offload condition, offloading at least part of the query to the secondary database in order to cause the at least part of the query to be executed by the secondary database. The method further includes providing to the requestor results of the query.

Abstract: A system and method for a database management system. The method comprises: receiving a database transaction for inserting a set of records in a database table of the database management system or for creating indexes. The database transaction may be executed using the database management system. The database management system may rollback the database transaction by truncating the database table or the created indexes.

Abstract: A tool for replacing a first database node of a database management system by a second database node. The tool receives an indication that the first database node received a data access request for accessing a database shared between the first database node and the second database node. The tool duplicates the data access request at the first database node. Responsive to a determination that the duplicated data access request includes a data changing statement and a previously executed statement, the tool modifies the duplicated data access request to prevent execution of the data changing statement and the previously executed statement at the second database node. The tool executes the modified duplicated data access request at the second database node. The tool replaces, based on a replacement condition being met, the first database node with the second database node in the database management system.

Abstract: A tool for replacing a first database node of a database management system by a second database node. The tool receives an indication that the first database node received a data access request for accessing a database shared between the first database node and the second database node. The tool duplicates the data access request at the first database node. Responsive to a determination that the duplicated data access request includes a data changing statement and a previously executed statement, the tool modifies the duplicated data access request to prevent execution of the data changing statement and the previously executed statement at the second database node. The tool executes the modified duplicated data access request at the second database node. The tool replaces, based on a replacement condition being met, the first database node with the second database node in the database management system.

Abstract: A method for generating a copy of a database using a data streaming protocol is disclosed. The method comprises setting up a structure of a secondary database, prioritizing data objects to be copied from a primary database to the secondary database, copying data objects from the primary database to the secondary database using a data streaming protocol, restoring data corresponding to the data object in the secondary database in parallel to copying data objects from the primary database to the secondary database, applying changes made to the data corresponding to the data object in the primary database during the time of copying, after the data object has been copied, and making available the secondary database for usage once all data objects have been copied from the primary database to the secondary database so that a usable copy of the primary database is created.