Abstract: Examples of a no rollback threshold for an audit trail are disclosed. In one example implementation according to aspects of the present disclosure, a method may include processing, by a computing system, a database transaction, and determining, by the computing system, whether a transaction span of the transaction exceeds a no rollback threshold for an audit trail. The method may include, in response to determining that the transaction span exceeds the no rollback threshold, converting, by the computing system, the transaction into a no rollback transaction. Additionally, the method may include, in response to determining that the transaction span exceeds the no rollback threshold, abandoning, by the computing system, the transaction if an error is encountered during the processing the transaction.

Abstract: Regulating enterprise database warehouse resource usage can include identifying a number of queries in an enterprise database warehouse (EDW) and regulating EDW resource usage among the number of queries.

Abstract: A method for transaction registration is described herein. The method includes sending, for a transaction manager, a registration request for a transaction. The method also performing data accesses on a data server. The registration request is non-blocking to the data accesses. The method further includes performing a two-phase commit process for the data server if the registration request is accepted. Additionally, the method includes handling the rollback if the transaction registration is rejected.

Abstract: A method for transaction registration is described herein. The method includes sending, for a transaction manager, a registration request for a transaction. The method also performing data accesses on a data server. The registration request is non-blocking to the data accesses. The method further includes performing a two-phase commit process for the data server if the registration request is accepted. Additionally, the method includes handling the rollback if the transaction registration is rejected.

Abstract: Regulating enterprise database warehouse resource usage can include identifying a number of queries in an enterprise database warehouse (EDW) and regulating EDW resource usage among the number of queries.

Abstract: Examples of a no rollback threshold for an audit trail are disclosed. In one example implementation according to aspects of the present disclosure, a method may include processing, by a computing system, a database transaction, and determining, by the computing system, whether a transaction span of the transaction exceeds a no rollback threshold for an audit trail. The method may include, in response to determining that the transaction span exceeds the no rollback threshold, converting, by the computing system, the transaction into a no rollback transaction. Additionally, the method may include, in response to determining that the transaction span exceeds no rollback threshold, abandoning, by the computing system, the transaction if an error is encountered during the processing the transaction.

Abstract: A plurality of transaction domains include transaction managers owning respective transactions, where a first of the transactions is uniquely identified by a unique identifier that indicates a first of the transaction managers that owns the first transaction, the unique identifier relating to the transaction domain in which the first transaction manager is included. The first transaction manager receives a request from a requester that initiated the first transaction, the request sent to the first transaction manager based on the unique identifier of the first transaction.

Abstract: A method of processing a transaction includes processing a transaction workload in a primary process pair on a first node in a cluster of nodes, the processing using at least one stable storage volume for storing a database and another stable storage volume for storing a log, the at least one stable storage volume and the log storage volume forming a log storage group. The method further includes performing checkpointing operations via the network from the primary process pair to a backup process pair while processing the transaction workload, the backup process pair operating on a second node in the cluster of nodes. The method further includes detecting a failure making the first node inoperable or inaccessible, and after detecting the failure, engaging the backup process pair to take over the transaction processing workload of the primary process pair, the backup process pair being configured to operate with the log storage group used by the primary process pair on the failed node.

Abstract: A method of processing a transaction includes processing a transaction workload in a primary process pair on a first node in a cluster of nodes, the processing using at least one stable storage volume for storing a database and another stable storage volume for storing a log, the at least one stable storage volume and the log storage volume forming a log storage group. The method further includes performing checkpointing operations via the network from the primary process pair to a backup process pair while processing the transaction workload, the backup process pair operating on a second node in the cluster of nodes. The method further includes detecting a failure making the first node inoperable or inaccessible, and after detecting the failure, engaging the backup process pair to take over the transaction processing workload of the primary process pair, the backup process pair being configured to operate with the log storage group used by the primary process pair on the failed node.

Abstract: A method of transferring a transaction workload of a primary process pair. The primary pair has access to a stable storage volume for storing data items and a log for storing transaction processing updates to data items. A backup process pair is established for the primary pair and information is transferred thereto so that it can take over for the primary pair should that pair fail. Additionally, a lock table is maintained and update records are written to the log by the primary pair. The update records include any locks from the lock table that related to the update records. When a failure of the primary pair occurs, the storage volume is locked, and the backup pair reads the log to reconstruct a lock table. Once the locks have been reconstructed, the lock on the storage volume is released and the backup pair operates to process the workload.