Locking Protocol for Partitioned and Distributed Tables
    1.
    发明申请
    Locking Protocol for Partitioned and Distributed Tables 有权
    分区和分布式表的锁定协议

    公开(公告)号:US20140156619A1

    公开(公告)日:2014-06-05

    申请号:US13750194

    申请日:2013-01-25

    IPC分类号: G06F17/30

    摘要: Systems, methods and computer program product embodiments for providing a locking protocol for partitioned and distributed database tables are disclosed herein. A locking method includes executing, by at least one processor, a first database transaction on a second node, attempting to acquire and acquiring a lock on the second node in intentional exclusive mode, executing, by the at least one processor, a second database transaction on a first node, acquiring a lock on the first node in exclusive mode and waiting to acquire a lock on the second node in exclusive mode, routing, by the at least one processor, the first database transaction to the first node and unsuccessfully trying to acquire a lock on the first node and committing, by the at least one processor, the first database transaction.

    摘要翻译: 本文公开了用于为分区和分布式数据库表提供锁定协议的系统,方法和计算机程序产品实施例。 锁定方法包括由至少一个处理器执行第二节点上的第一数据库事务,尝试以有意的排他模式获取和获取第二节点上的锁定,由至少一个处理器执行第二数据库事务 在第一节点上,以独占模式获取第一节点上的锁定,并且以排他模式等待获取第二节点上的锁定,由至少一个处理器将第一数据库事务路由到第一节点,并且不成功地尝试 获得第一节点上的锁并由至少一个处理器提交第一数据库事务。

    Locking protocol for partitioned and distributed tables
    2.
    发明授权
    Locking protocol for partitioned and distributed tables 有权
    分区表和分布式表的锁定协议

    公开(公告)号:US09501502B2

    公开(公告)日:2016-11-22

    申请号:US13750194

    申请日:2013-01-25

    IPC分类号: G06F17/30

    摘要: Systems, methods and computer program product embodiments for providing a locking protocol for partitioned and distributed database tables are disclosed herein. A locking method includes executing, by at least one processor, a first database transaction on a second node, attempting to acquire and acquiring a lock on the second node in intentional exclusive mode, executing, by the at least one processor, a second database transaction on a first node, acquiring a lock on the first node in exclusive mode and waiting to acquire a lock on the second node in exclusive mode, routing, by the at least one processor, the first database transaction to the first node and unsuccessfully trying to acquire a lock on the first node and committing, by the at least one processor, the first database transaction.

    摘要翻译: 本文公开了用于为分区和分布式数据库表提供锁定协议的系统,方法和计算机程序产品实施例。 锁定方法包括由至少一个处理器执行第二节点上的第一数据库事务,尝试以有意的排他模式获取和获取第二节点上的锁定,由至少一个处理器执行第二数据库事务 在第一节点上,以独占模式获取第一节点上的锁定,并且以排他模式等待获取第二节点上的锁定,由至少一个处理器将第一数据库事务路由到第一节点,并且不成功地尝试 获得第一节点上的锁并由至少一个处理器提交第一数据库事务。