Kyndryl, Inc.

Prasanna Veeraraghavan

Sriram Lakshminarasimhan

Suryanarayana K Rao

Chandan Kumar Vishwakarma

Sundar Sarangarajan

Saravanan Dakshnamoorthy

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.

Hybrid locking mechanism in relational database management systems

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.

Growing community of inventors

Chennai, India

Prasanna Veeraraghavan