Approaches to Reducing Lock Communications In a Shared Disk Database
    1.
    发明申请
    Approaches to Reducing Lock Communications In a Shared Disk Database 有权
    在共享磁盘数据库中减少锁定通信的方法

    公开(公告)号:US20110131192A1

    公开(公告)日:2011-06-02

    申请号:US12626714

    申请日:2009-11-27

    IPC分类号: G06F17/30 G06F15/16

    CPC分类号: G06F17/30362

    摘要: Lock communications in a shared disk database system is reduced by several approaches: sending a single message to a lock manager for locks required for an operation and locks that will be required in the future, the operations may include row update, row delete, large scan, and row insert; performing an operation in two executions, where in a first execution locks required for the operation is determined without performing the operation, and in a second execution a single message is sent to a lock manager for the required locks and the operation is performed; in free space searching, sending a single message to a lock manager for row and page locks before a row insert is actually performed; and granting locks in an unfair manner.

    摘要翻译: 在共享磁盘数据库系统中锁定通信可以通过以下几种方法进行减少:向锁管理器发送单个消息,以获得将来需要的操作所需的锁和操作可能包括行更新,行删除,大扫描 ,和行插入; 执行两次执行中的操作,其中在不执行操作的情况下确定操作所需的第一执行锁定,并且在第二执行中,单个消息被发送到锁管理器以进行所需的锁并且执行操作; 在可用空间搜索中,在实际执行行插入之前,向锁管理器发送行和页锁的单个消息; 并以不公平的方式给予锁。