Abstract: A transaction is received. The transaction involves a data in a relational database management system. A page in the relational database management system is determined with the data. Whether the page has a hybrid lock enabled is determined using a hybrid lock hash table. Responsive to determining the page has the hybrid lock enabled, whether the page is above the hot page threshold is determined.

Abstract: A computer-implemented method of optimizing data rollback is disclosed. The method receives a request to perform a task on a disk storage. The method initiates the task by reading a plurality of data pages from the disk storage to a database buffer. Each of the plurality of data pages on the database buffer are modified to form a plurality of dirty pages. In response to reaching and/or exceeding a database buffer threshold, a portion of the plurality of dirty pages on the database buffer are externalized to a rollback buffer. In response to reaching and/or exceeding a rollback buffer threshold, a subset of the portion of the plurality of dirty pages on the rollback buffer are externalized to the disk storage. The method detects a task cancelling activity prior to completion of the task; and performs a rollback of the plurality of dirty pages to a pre-task state.

Abstract: A computer-implemented method of optimizing data rollback is disclosed. The method receives a request to perform a task on a disk storage. The method initiates the task by reading a plurality of data pages from the disk storage to a database buffer. Each of the plurality of data pages on the database buffer are modified to form a plurality of dirty pages. In response to reaching and/or exceeding a database buffer threshold, a portion of the plurality of dirty pages on the database buffer are externalized to a rollback buffer. In response to reaching and/or exceeding a rollback buffer threshold, a subset of the portion of the plurality of dirty pages on the rollback buffer are externalized to the disk storage. The method detects a task cancelling activity prior to completion of the task; and performs a rollback of the plurality of dirty pages to a pre-task state.