公开(公告)号：US08046633B2

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

申请号：US12635599

申请日：2009-12-10

申请人： Matthew A. Huras ,  Roger L. Zheng ,  Aamer Sachedina ,  James L. Finnie ,  Keriley K. Romanufa ,  Xun Xue ,  Andrew D. Buckler ,  Stewart L. Palmer

发明人： Matthew A. Huras ,  Roger L. Zheng ,  Aamer Sachedina ,  James L. Finnie ,  Keriley K. Romanufa ,  Xun Xue ,  Andrew D. Buckler ,  Stewart L. Palmer

IPC分类号： G06F11/00

CPC分类号： G06F9/526 ,  G06F11/2028 ,  G06F11/2038 ,  G06F11/2046 ,  G06F2201/825

摘要： 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.

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

公开(公告)号：US08666958B2

公开(公告)日：2014-03-04

申请号：US12626714

申请日：2009-11-27

申请人： James L. Finnie ,  Ronen Grosman ,  Matthew A. Huras ,  Keriley K. Romanufa ,  Aamer Sachedina ,  Garret F. Swart ,  Xun Xue ,  Roger L. Q. Zheng

发明人： James L. Finnie ,  Ronen Grosman ,  Matthew A. Huras ,  Keriley K. Romanufa ,  Aamer Sachedina ,  Garret F. Swart ,  Xun Xue ,  Roger L. Q. Zheng

IPC分类号： G06F7/00

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.

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

公开(公告)号：US20110131192A1

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

申请号：US12626714

申请日：2009-11-27

申请人： James L. Finnie ,  Ronen Grosman ,  Matthew A. Huras ,  Keriley K. Romanufa ,  Aamer Sachedina ,  Xun Xue ,  Roger L.Q. Zheng

发明人： James L. Finnie ,  Ronen Grosman ,  Matthew A. Huras ,  Keriley K. Romanufa ,  Aamer Sachedina ,  Xun Xue ,  Roger L.Q. Zheng

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.

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

公开(公告)号：US09229970B2

公开(公告)日：2016-01-05

申请号：US12632750

申请日：2009-12-07

申请人： Ronen Grosman ,  Matthew A. Huras ,  Timothy R. Malkemus ,  Keriley K. Romanufa ,  Aamer Sachedina ,  Kelly W. Schlamb ,  Nickolay V. Tchervenski ,  Xun Xue

发明人： Ronen Grosman ,  Matthew A. Huras ,  Timothy R. Malkemus ,  Keriley K. Romanufa ,  Aamer Sachedina ,  Kelly W. Schlamb ,  Nickolay V. Tchervenski ,  Xun Xue

IPC分类号： G06F17/00 ,  G06F17/30 ,  G06F11/14

CPC分类号： G06F17/30368 ,  G06F11/1471 ,  G06F17/30353 ,  G06F17/30377

摘要： An ordering of operations in log records includes: performing update operations on a database object by a node; writing log records for the update operations into a local buffer by the node, the log records each including a local virtual timestamp; determining that a log flush to write the log records in the local buffer to a persistent storage is to be performed; in response, sending a request from the node to a log flush sequence server for a log flush sequence number; receiving the log flush sequence number by the node; inserting the log flush sequence number into the log records in the local buffer; and performing the log flush to write the log records in the local buffer to the persistent storage, where the log records written to the persistent storage comprises the local virtual timestamps and the log flush sequence number.

摘要翻译： 日志记录中的操作排序包括：由节点对数据库对象执行更新操作; 将更新操作的日志记录由节点写入本地缓冲区，每个日志记录包括本地虚拟时间戳; 确定要执行将本地缓冲区中的日志记录写入永久存储器的日志刷新; 作为响应，向日志刷新序列服务器发送来自节点的请求以用于日志刷新序列号; 由节点接收日志刷新序列号; 将日志刷新序列号插入到本地缓冲区中的日志记录中; 并执行日志刷新以将本地缓冲区中的日志记录写入永久存储器，其中写入永久存储器的日志记录包括本地虚拟时间戳和日志刷新序列号。

公开(公告)号：US20110137861A1

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

申请号：US12634463

申请日：2009-12-09

申请人： Rodney C. Burnett ,  David A. Elko ,  Ronen Grosman ,  Jimmy R. Hill ,  Matthew A. Huras ,  Mark A. Kowalski ,  Daniel H. Lepore ,  Keriley K. Romanufa ,  Aamer Sachedina ,  Xun Xue

发明人： Rodney C. Burnett ,  David A. Elko ,  Ronen Grosman ,  Jimmy R. Hill ,  Matthew A. Huras ,  Mark A. Kowalski ,  Daniel H. Lepore ,  Keriley K. Romanufa ,  Aamer Sachedina ,  Xun Xue

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返回有效副本。

公开(公告)号：US20110137874A1

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

申请号：US12632750

申请日：2009-12-07

申请人： Ronen Grosman ,  Matthew A. Huras ,  Timothy R. Malkemus ,  Keriley K. Romanufa ,  Aamer Sachedina ,  Kelly W. Schlamb ,  Nickolay V. Tchervenski ,  Xun Xue

发明人： Ronen Grosman ,  Matthew A. Huras ,  Timothy R. Malkemus ,  Keriley K. Romanufa ,  Aamer Sachedina ,  Kelly W. Schlamb ,  Nickolay V. Tchervenski ,  Xun Xue

IPC分类号： G06F17/00

CPC分类号： G06F17/30368 ,  G06F11/1471 ,  G06F17/30353 ,  G06F17/30377

摘要： An ordering of operations in log records includes: performing update operations on a shared database object by a node; writing log records for the update operations into a local buffer by the node, the log records each including a local virtual timestamp; determining that a log flush to write the log records in the local buffer to a persistent storage is to be performed; in response, sending a request from the node to a log flush sequence server for a log flush sequence number; receiving the log flush sequence number by the node; inserting the log flush sequence number into the log records in the local buffer; and performing the log flush to write the log records in the local buffer to the persistent storage, where the log records written to the persistent storage comprises the local virtual timestamps and the log flush sequence number.

摘要翻译： 日志记录中的操作顺序包括：由节点对共享数据库对象执行更新操作; 将更新操作的日志记录由节点写入本地缓冲区，每个日志记录包括本地虚拟时间戳; 确定要执行将本地缓冲区中的日志记录写入永久存储器的日志刷新; 作为响应，向日志刷新序列服务器发送来自节点的请求以用于日志刷新序列号; 由节点接收日志刷新序列号; 将日志刷新序列号插入到本地缓冲区中的日志记录中; 并执行日志刷新以将本地缓冲区中的日志记录写入永久存储器，其中写入永久存储器的日志记录包括本地虚拟时间戳和日志刷新序列号。

公开(公告)号：US08140721B2

公开(公告)日：2012-03-20

申请号：US10921469

申请日：2004-08-19

申请人： Aamer Sachedina ,  Matthew A. Huras ,  Keriley K. Romanufa

发明人： Aamer Sachedina ,  Matthew A. Huras ,  Keriley K. Romanufa

IPC分类号： G06F3/00 ,  G06F5/00

CPC分类号： G06F17/30312

摘要： For an information retrieval system coupled to a buffer pool maintaining a plurality of pages of recently accessed information for subsequent re-access, a technique for starting the buffer pool is provided. The technique facilitates a quicker start to the buffer pool by deferring allocation of page storing portions, for example, until they are needed. The technique makes the buffer pool available for storing pages while deferring allocation of a page storing portion of the buffer pool and allocates the page storing portion of the buffer pool in response to a demand to store pages to the buffer pool. The technique may be used to re-start a buffer pool with pages stored to a memory coupled to the information retrieval system where the pages where stored upon a buffer pool shutdown. Further, buffer pool readers or prefetchers may be configured to read pages for storing to the buffer pool and allocate the page storing portions of the buffer pool in response to instructions to read particular pages.

摘要翻译： 对于一个信息检索系统，耦合到缓冲池，保持多页最近访问的信息用于随后的重新访问，提供了启动缓冲池的技术。 该技术通过延迟页面存储部分的分配来促进对缓冲池的更快启动，例如直到需要它们。 该技术使得缓冲池可用于存储页面，同时延迟缓冲池的页面存储部分的分配，并且响应于将页面存储到缓冲池的需求而分配缓冲池的页面存储部分。 该技术可用于重新启动缓冲池，其中页面存储到耦合到信息检索系统的存储器，其中存储在缓冲池关闭时的页面。 此外，缓冲池读取器或预取器可以被配置为读取用于存储到缓冲池的页面，并响应于读取特定页面的指令来分配存储缓冲器池的部分的页面。

公开(公告)号：US08024741B2

公开(公告)日：2011-09-20

申请号：US11457572

申请日：2006-07-14

申请人： Aamer Sachedina ,  Matthew A. Huras ,  Keriley K. Romanufa

发明人： Aamer Sachedina ,  Matthew A. Huras ,  Keriley K. Romanufa

IPC分类号： G06F9/46

CPC分类号： G06F9/52

摘要： A computer system dynamically scales back latch requests for system resources. Tasks seeking access to system resources each dynamically determine the probability that the task will gain access to the latch relating to a given system resource. Where the task estimates that its probability is below a defined threshold, the task will suspend itself for a defined sleep time. The task dynamically adjusts the length of the sleep time based on the number of times the task enters the suspended state and on the relative changes in the estimated probability that the task will gain access to the resource.

摘要翻译： 计算机系统动态地缩小系统资源的锁存请求。 寻求访问系统资源的任务每个动态地确定任务将获得对与给定系统资源相关联的锁存器的访问的概率。 在任务估计其概率低于定义的阈值的情况下，任务将暂停自己定义的休眠时间。 任务根据任务进入暂停状态的次数以及任务将获得资源访问的概率的相对变化动态调整睡眠时间长度。

公开(公告)号：US07085911B2

公开(公告)日：2006-08-01

申请号：US10422925

申请日：2003-04-23

申请人： Aamer Sachedina ,  Matthew A. Huras ,  Keriley K. Romanufa

发明人： Aamer Sachedina ,  Matthew A. Huras ,  Keriley K. Romanufa

IPC分类号： G06F12/06

CPC分类号： G06F17/30595 ,  G06F12/0806 ,  G06F17/3033

摘要： A hash table for a collection of data items includes a set of hash buckets, each hash bucket being associated with a subset of the collection of data items, and a set of properties entries in each of the hash buckets. Each properties entry includes a pointer to an associated data item in the subset associated with the bucket and a set of representative values identifying the associated data item. A hash table can also include bucket groups defining a second level hash table to permit resizing of the hash table.

公开(公告)号：US06807540B2

公开(公告)日：2004-10-19

申请号：US09872831

申请日：2001-05-31

申请人： Matthew A. Huras ,  Sean W. McKeough ,  Timothy J. Vincent ,  Xun Xue ,  Roger L. Zheng

发明人： Matthew A. Huras ,  Sean W. McKeough ,  Timothy J. Vincent ,  Xun Xue ,  Roger L. Zheng

IPC分类号： G06F1730

CPC分类号： G06F9/526 ,  G06F17/30362 ,  Y10S707/99938 ,  Y10S707/99945

摘要： A system and method for managing deadlocks in a database management system (DBMS) for a demultiplexed database system. The DBMS supports applications that are capable of holding and retaining locks on database resources while disassociated from worker agents. The system and method includes an application scheduler for managing requests for access to the database, and a deadlock detector for identifying a deadlock. The application scheduler assigns one worker agent to an application requesting access to a database resource, assigns a flag to an application holding a lock on the database resource while disassociated from a worker agent, and in cooperation with the deadlock detector, resolves the deadlock between the application requesting access and the flagged application holding the lock.

摘要翻译： 一种用于管理解复用数据库系统的数据库管理系统（DBMS）中的死锁的系统和方法。 DBMS支持能够保留和保留数据库资源上的锁定的应用程序，同时与工作代理程序解除关联。 该系统和方法包括用于管理对数据库的访问请求的应用调度器，以及用于识别死锁的死锁检测器。 应用程序调度器向请求访问数据库资源的应用程序分配一个工作代理，在与工作代理解除关联的同时向持有数据库资源的锁定的应用程序分配标志，并且与死锁检测器协作解决了 请求访问的应用程序和持有锁定的标记应用程序。