Hybrid Locking Mechanism in Relational Database Management Systems

1. A computer-implemented method for database management, the computer-implemented method comprising: receiving, by one or more computer processors, a transaction, wherein the transaction involves a data in a relational database management system; determining, by one or more computer processors, a page in the relational database management system with the data; determining, by one or more computer processors, whether the page has a hybrid lock enabled using a hybrid lock hash table; responsive to determining, by one or more computer processors, the page has the hybrid lock enabled, determining, by one or more computer processors, whether the page is above a hot page threshold.

2. The computer-implemented method of claim 1 , further comprising: responsive to determining, by one or more computer processors, the page is above the hot page threshold in the hybrid lock hash table, locking, by one or more computer processors, a candidate row of the page, wherein the candidate row contains at least part of the data.

3. The computer-implemented method of claim 2 , further comprising: providing, by one or more computer processors, access to the locked candidate row of the page; receiving, by one or more computer processors, an indication of completion of access to the locked candidate row; and responsive to receiving the indication, unlocking, by one or more computer processors, the locked candidate row of the page.

4. The computer-implemented method of claim 1 , further comprising: responsive to determining, by one or more computer processors, the page is not above the hot page threshold in the hybrid lock hash table, locking, by one or more computer processors, a candidate page of the page, wherein the candidate page contains at least part of the data.

5. The computer-implemented method of claim 1 , further comprising: receiving, by one or more computer processors, one or more factors; and updating, by one or more computer processors, the hybrid lock hash table using the one or more factors.

6. The computer-implemented method of claim 5 , wherein the one or more factors is selected from the group consisting of a bufferpool residency time, a number of transaction waiting for one or more pages in the relational database management system, and an amount of wait time for one or more pages in the relational database management system.

7. The computer-implemented method of claim 6 , wherein the bufferpool residency time is an amount of time a page of one or more pages in the relational database management system spends in a bufferpool, wherein the bufferpool is an area of memory that is allocated to relational database management system for caching data as it is read from a storage location.

8. A computer program product for database management, the computer program product comprising: one or more computer readable storage media; and program instructions stored on the one or more computer readable storage media, the program instructions comprising: program instructions to receive a transaction, wherein the transaction involves a data in a relational database management system; program instructions to determine a page in the relational database management system with the data; program instructions to determine whether the page has a hybrid lock enabled using a hybrid lock hash table; responsive to determining the page has the hybrid lock enabled, program instructions to determine whether the page is above a hot page threshold.

9. The computer program product of claim 8 , further comprising one or more of the following program instructions, stored on the one or more computer readable storage media, to: responsive to determining the page is above the hot page threshold in the hybrid lock hash table, lock a candidate row of the page, wherein the candidate row contains at least part of the data.

10. The computer program product of claim 9 , further comprising one or more of the following program instructions, stored on the one or more computer readable storage media, to: provide access to the locked candidate row of the page; receive an indication of completion of access to the locked candidate row; and responsive to receiving the indication, unlock the locked candidate row of the page.

11. The computer program product of claim 8 , further comprising one or more of the following program instructions, stored on the one or more computer readable storage media, to: responsive to determining the page is not above the hot page threshold in the hybrid lock hash table, lock a candidate page of the page, wherein the candidate page contains at least part of the data.

12. The computer program product of claim 8 , further comprising one or more of the following program instructions, stored on the one or more computer readable storage media, to: receive one or more factors; and update the hybrid lock hash table using the one or more factors.

13. The computer program product of claim 12 , wherein the one or more factors is selected from the group consisting of a bufferpool residency time, a number of transaction waiting for one or more pages in the relational database management system, and an amount of wait time for one or more pages in the relational database management system.

14. The computer program product of claim 13 , wherein the bufferpool residency time is an amount of time a page of one or more pages in the relational database management system spends in a bufferpool, wherein the bufferpool is an area of memory that is allocated to relational database management system for caching data as it is read from a storage location.

15. A computer system for database management, the computer system comprising: one or more computer processors; one or more computer readable storage media; and program instructions, stored on the one or more computer readable storage media for execution by at least one of the one or more computer processors, the program instructions comprising: program instructions to receive a transaction, wherein the transaction involves a data in a relational database management system; program instructions to determine a page in the relational database management system with the data; program instructions to determine whether the page has a hybrid lock enabled using a hybrid lock hash table; responsive to determining the page has the hybrid lock enabled, program instructions to determine whether the page is above a hot page threshold.

16. The computer system of claim 15 , further comprising one or more of the following program instructions, stored on the one or more computer readable storage media for execution by at least one of the one or more computer processors, to: responsive to determining the page is above the hot page threshold in the hybrid lock hash table, lock a candidate row of the page, wherein the candidate row contains at least part of the data.

17. The computer system of claim 16 , further comprising one or more of the following program instructions, stored on the one or more computer readable storage media for execution by at least one of the one or more computer processors, to: provide access to the locked candidate row of the page; receive an indication of completion of access to the locked candidate row; and responsive to receiving the indication, unlock the locked candidate row of the page.

18. The computer system of claim 16 , further comprising one or more of the following program instructions, stored on the one or more computer readable storage media for execution by at least one of the one or more computer processors, to: receive one or more factors; and update the hybrid lock hash table using the one or more factors.

19. The computer system of claim 18 , wherein the one or more factors is selected from the group consisting of a bufferpool residency time, a number of transaction waiting for one or more pages in the relational database management system, and an amount of wait time for one or more pages in the relational database management system.

20. The computer system of claim 15 , further comprising one or more of the following program instructions, stored on the one or more computer readable storage media for execution by at least one of the one or more computer processors, to: responsive to determining the page is not above the hot page threshold in the hybrid lock hash table, lock a candidate page of the page, wherein the candidate page contains at least part of the data.