Invention Grant
- Patent Title: Coordinated hash table indexes to facilitate reducing database reconfiguration time
-
Application No.: US15245005Application Date: 2016-08-23
-
Publication No.: US10296498B2Publication Date: 2019-05-21
- Inventor: Chen Yang , Wilson Wai Shun Chan , Tolga Yurek , Eugene Reddy Ho
- Applicant: Oracle International Corporation
- Applicant Address: US CA Redwood Shores
- Assignee: ORACLE INTERNATIONAL CORPORATION
- Current Assignee: ORACLE INTERNATIONAL CORPORATION
- Current Assignee Address: US CA Redwood Shores
- Agency: Hickman Palermo Becker Bingham LLP
- Main IPC: G06F16/22
- IPC: G06F16/22 ; G06F16/21

Abstract:
According to embodiments, reconfiguration of lock masters for a cluster of nodes is optimized using coordinated hash indexes to index into the master hash table and into local hash tables stored on the nodes of the cluster. A DBMS uses a hybrid hash index, a portion of which represents a corresponding master hash index, to index into both the master hash table and into a local hash table for a given lock. The hash index used to store lock metadata in a particular local hash table bucket, on a particular node, encodes the lock master index, for a master hash table, to which the locks in the local hash table bucket correspond. Only the portions of the local hash table on the lock master that correspond to the index of the master hash table bucket need to be scanned in order to perform needed tasks for lock master reconfiguration.
Public/Granted literature
- US20180060318A1 COORDINATED HASH TABLE INDEXES TO FACILITATE REDUCING DATABASE RECONFIGURATION TIME Public/Granted day:2018-03-01
Information query