Improving data availability during failure detection and recovery processing in a shared resource system
    22.
    发明授权
    Improving data availability during failure detection and recovery processing in a shared resource system 有权
    在共享资源系统中的故障检测和恢复处理期间提高数据可用性

    公开(公告)号:US08046633B2

    公开(公告)日:2011-10-25

    申请号:US12635599

    申请日:2009-12-10

    IPC分类号: G06F11/00

    摘要: A system and method for managing shared resources is disclosed. The system includes a primary coherency processing unit which processes lock requests from a plurality of data processing hosts, the primary coherency processing unit also storing a first current lock state information for the plurality of data processing hosts, the first current lock state information including a plurality of locks held by the plurality of data processing hosts. The system further includes a standby coherency processing unit storing fewer locks than the primary coherency processing unit, the locks stored by the standby coherency processing unit being a subset of locks included in the first current lock state information, the standby coherency unit configured to perform a plurality of activities of the primary coherency processing unit using the subset of locks in response to a failure of the primary coherency processing unit.

    摘要翻译: 公开了一种用于管理共享资源的系统和方法。 该系统包括处理来自多个数据处理主机的锁定请求的主相关处理单元,该主相关处理单元还存储多个数据处理主机的第一当前锁定状态信息,第一当前锁定状态信息包括多个 由多个数据处理主机持有的锁。 所述系统还包括备用一致性处理单元,其存储比所述主相关处理单元更少的锁,由所述备用一致性处理单元存储的所述锁是包括在所述第一当前锁定状态信息中的锁的子集,所述备用一致性单元被配置为执行 响应于主要一致性处理单元的故障,主要一致性处理单元的多个活动使用锁定子集。

    Methods for Achieving Efficient Coherent Access to Data in a Cluster of Data Processing Computing Nodes
    23.
    发明申请
    Methods for Achieving Efficient Coherent Access to Data in a Cluster of Data Processing Computing Nodes 审中-公开
    在数据处理计算节点集群中实现对数据的有效连贯访问的方法

    公开(公告)号:US20110137861A1

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

    申请号:US12634463

    申请日:2009-12-09

    IPC分类号: G06F17/00 G06F15/167

    CPC分类号: G06F16/2308

    摘要: A coherency manager provides coherent access to shared data by receiving a copy of updated database data from a host computer through RDMA, the copy including updates to a given database data; storing the copy of the updated database data as a valid copy of the given database data in local memory; invalidating local copies of the given database data on other host computers through RDMA; receiving acknowledgements from the other host computers through RDMA that the local copies of the given database data have been invalidated; and sending an acknowledgement of receipt of the copy of the updated database data to the host computer through RDMA. When the coherency manager receives a request for the valid copy of the given database data from a host computer through RDMA, it retrieves the valid copy of the given database data from the local memory and returns the valid copy through RDMA.

    摘要翻译: 一个一致性管理器通过从主计算机通过RDMA接收更新的数据库数据的副本来提供对共享数据的一致访问,该副本包括对给定数据库数据的更新; 将更新的数据库数据的副本存储为本地存储器中的给定数据库数据的有效副本; 通过RDMA使其他主机上的给定数据库数据的本地副本无效; 通过RDMA从其他主机计算机接收到给定数据库数据的本地副本已被无效的确认; 并通过RDMA向主计算机发送对更新的数据库数据的副本的接收的确认。 当一致性管理器通过RDMA从主机接收到给定数据库数据的有效副本的请求时,它从本地存储器检索给定数据库数据的有效副本,并通过RDMA返回有效副本。

    ENHANCED RELATIONAL DATABASE MANAGEMENT SYSTEM AND METHOD
    24.
    发明申请
    ENHANCED RELATIONAL DATABASE MANAGEMENT SYSTEM AND METHOD 审中-公开
    增强的关系数据库管理系统和方法

    公开(公告)号:US20080154842A1

    公开(公告)日:2008-06-26

    申请号:US11613773

    申请日:2006-12-20

    IPC分类号: G06F17/30

    摘要: A method to enhance relational database management system resiliency and query operations by minimizing CPU overhead and database page access latency and by facilitating database restoration and query efficiency. The method includes creating a clean database page in a buffer pool of a relational database management system, granting exclusive access to the clean database page within the buffer pool to an application that transitions the clean database page to a dirty database page by altering data store thereon, immediately downgrading exclusive access to the dirty database page to shared access in response to receiving an exclusive access termination request from the application, writing the dirty database page to a physical log, and releasing share access to the dirty database page.

    摘要翻译: 通过最小化CPU开销和数据库页面访问延迟以及促进数据库恢复和查询效率来增强关系数据库管理系统弹性和查询操作的方法。 该方法包括在关系数据库管理系统的缓冲池中创建干净的数据库页面,授予对缓冲池内的干净数据库页面的独占访问权,通过改变其上的数据存储将清理数据库页面转换到脏数据库页面的应用程序 响应于从应用程序接收到独占访问终止请求,将脏数据库页面写入物理日志,并释放对脏数据库页面的共享访问,立即将对脏数据库页面的独占访问权降级到共享访问。

    Latch mechanism for concurrent computing environments

    公开(公告)号:US07013463B2

    公开(公告)日:2006-03-14

    申请号:US09894215

    申请日:2001-06-27

    IPC分类号: G06F9/46

    CPC分类号: G06F9/52

    摘要: A system, method and computer readable medium containing programming structions for an improved latch mechanism for use in a programming environment running concurrent tasks is disclosed. According to one aspect of the present invention, a latch is provided to a first task which is requesting access to a resource. After such access, the first task holds the latch, which is also released from the first task. The first task holding the latch marks the latch stealable, and if the latch is not marked stolen by another task, the first task can mark the latch unstealable. In another embodiment of the present invention, if the first task is provided a latch marked stealable, the resource associated with the stealable latch will be placed in a consistent state before the first task accesses the resource.

    Method for performing a warm shutdown and restart of a buffer pool
    26.
    发明授权
    Method for performing a warm shutdown and restart of a buffer pool 有权
    执行缓冲池的热关机和重新启动的方法

    公开(公告)号:US08738579B2

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

    申请号:US10852914

    申请日:2004-05-24

    IPC分类号: G06F7/00 G06F17/00

    摘要: A system and a method for performing a warm shutdown and restart of a buffer pool. The buffer content, including pages and control structures associated with these pages, is partitioned into blocks, where block is saved to a disk as a sequential file. The size of each block is selected to provide an optimal I/O efficiency during buffer pool shutdown and restart operations. Blocks can be saved simultaneously using a plurality of writer threads. During restart of the buffer pool, the control information is read from the disk and restored to the buffer pool using reader threads. The buffer pool may be made available for reference to pages while the reader threads are enabled to read the saved information by blocks, to facilitate a more rapid restoration of information in the buffer pool.

    摘要翻译: 用于执行缓冲池的热关机和重新启动的系统和方法。 包括与这些页面相关联的页面和控制结构的缓冲区内容被分割成块,其中块被作为顺序文件保存到磁盘。 选择每个块的大小以在缓冲池关闭和重新启动操作期间提供最佳的I / O效率。 可以使用多个写入器线程同时保存块。 在重新启动缓冲池期间,从磁盘读取控制信息,并使用读取器线程将其还原到缓冲池。 可以使缓冲池可用于参考页面,同时读取器线程能够通过块读取保存的信息,以便于缓冲池中的信息更快速地恢复。

    Failure detection and fencing in a computing system
    27.
    发明授权
    Failure detection and fencing in a computing system 失效
    计算系统中的故障检测和防护

    公开(公告)号:US08352798B2

    公开(公告)日:2013-01-08

    申请号:US12635338

    申请日:2009-12-10

    IPC分类号: G06F11/00

    CPC分类号: G06F11/0793 G06F11/0715

    摘要: A method, computer program product, and system for detecting and fencing off a failed entity instance so that failover time in the computing system is reduced. Upon detection of a failed entity, for example a failed process, a signal handler invokes an operating system interface to fence off the failed instance from modifying its persistent state, so that the entity may be re-instantiated prior to termination of the failed instance. This approach reduces failover time and eliminates split-brain problems without compromising access to the failed instance to obtain diagnostic information, core dumps, and the like.

    摘要翻译: 一种用于检测和防范故障实体实例的方法,计算机程序产品和系统,从而减少计算系统中的故障转移时间。 在检测到失败的实体(例如失败的过程)时,信号处理器调用操作系统接口来阻止失败的实例修改其持久状态,使得可以在失败的实例终止之前重新实例化该实体。 这种方法可以减少故障转移时间并消除分裂问题,而不会影响对故障实例的访问,以获取诊断信息,核心转储等。

    IMPROVING DATA AVAILABILITY DURING FAILURE DETECTION AND RECOVERY PROCESSING IN A SHARED RESOURCE SYSTEM
    28.
    发明申请
    IMPROVING DATA AVAILABILITY DURING FAILURE DETECTION AND RECOVERY PROCESSING IN A SHARED RESOURCE SYSTEM 有权
    在共享资源系统中的故障检测和恢复处理过程中改善数据可用性

    公开(公告)号:US20110145627A1

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

    申请号:US12635599

    申请日:2009-12-10

    IPC分类号: G06F11/20 G06F9/50

    摘要: A system and method for managing shared resources is disclosed. The system includes a primary coherency processing unit which processes lock requests from a plurality of data processing hosts, the primary coherency processing unit also storing a first current lock state information for the plurality of data processing hosts, the first current lock state information including a plurality of locks held by the plurality of data processing hosts. The system further includes a standby coherency processing unit storing fewer locks than the primary coherency processing unit, the locks stored by the standby coherency processing unit being a subset of locks included in the first current lock state information, the standby coherency unit configured to perform a plurality of activities of the primary coherency processing unit using the subset of locks in response to a failure of the primary coherency processing unit.

    摘要翻译: 公开了一种用于管理共享资源的系统和方法。 该系统包括处理来自多个数据处理主机的锁定请求的主相关处理单元,该主相关处理单元还存储多个数据处理主机的第一当前锁定状态信息,第一当前锁定状态信息包括多个 由多个数据处理主机持有的锁。 所述系统还包括备用一致性处理单元,其存储比所述主相关处理单元更少的锁,由所述备用一致性处理单元存储的所述锁是包括在所述第一当前锁定状态信息中的锁的子集,所述备用一致性单元被配置为执行 响应于主要一致性处理单元的故障,主要一致性处理单元的多个活动使用锁定子集。

    AUTOMATIC DETECTION AND CORRECTION OF HOT PAGES IN A DATABASE SYSTEM
    29.
    发明申请
    AUTOMATIC DETECTION AND CORRECTION OF HOT PAGES IN A DATABASE SYSTEM 失效
    自动检测和校正数据库系统中的热页

    公开(公告)号:US20100223243A1

    公开(公告)日:2010-09-02

    申请号:US12394786

    申请日:2009-02-27

    IPC分类号: G06F12/02 G06F17/30

    CPC分类号: G06F17/30306

    摘要: According to one embodiment of the present invention, a method for detecting and correcting hot pages in a database system is provided. According to one embodiment of the present invention, a method includes monitoring transactions involving pages in a database and determining if one of the transactions had to wait for access to one of the pages; incrementing a page contention counter each time one of the transactions had to wait for access to one of the pages. The method then determines if the page contention counter exceeds a predetermined threshold and monitors transactions on one of the pages for which the page contention count was exceeded. The method then determines if a row was accessed in the page for which the page contention count was exceeded and increments a reference count for the accessed row. the accessed rows are flagged when the reference count exceeds a second predetermined threshold. The flagged rows are moved to another page in the database.

    摘要翻译: 根据本发明的一个实施例,提供了一种在数据库系统中检测和校正热页面的方法。 根据本发明的一个实施例,一种方法包括监视涉及数据库中的页面的事务,并确定其中一个事务是否必须等待访问其中一个页面; 每次其中一个事务必须等待访问其中一个页面时,增加页面争用计数器。 该方法然后确定页面争用计数器是否超过预定阈值,并且监视超出页面争用次数的页面之一上的事务。 该方法然后确定在超出页面争用次数的页面中是否访问了一行,并增加访问行的引用计数。 当参考计数超过第二预定阈值时,所访问的行被标记。 标记的行被移动到数据库中的另一个页面。