COORDINATED HASH TABLE INDEXES TO FACILITATE REDUCING DATABASE RECONFIGURATION TIME

    公开(公告)号:US20180060318A1

    公开(公告)日:2018-03-01

    申请号:US15245005

    申请日:2016-08-23

    CPC classification number: G06F17/3033 G06F17/30289

    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.

Patent Agency Ranking