公开(公告)号：US08868748B2

公开(公告)日：2014-10-21

申请号：US12902116

申请日：2010-10-11

申请人： Gopi K. Attaluri ,  James L. Finnie ,  Stewart L. Palmer ,  Piotr M. Plachta ,  Garret F. Swart ,  Xun Xue ,  Roger L. Q. Zheng

发明人： Gopi K. Attaluri ,  James L. Finnie ,  Stewart L. Palmer ,  Piotr M. Plachta ,  Garret F. Swart ,  Xun Xue ,  Roger L. Q. Zheng

IPC分类号： G06F15/173 ,  G06F17/30 ,  G06F9/52 ,  G06F9/50

CPC分类号： G06F17/30362 ,  G06F9/5005 ,  G06F9/5038 ,  G06F9/524 ,  G06F9/526

摘要： In a shared data system comprising one or more primary nodes and a plurality of secondary nodes, global lock manager on a primary node manages locks for shared resources by exchanging an abstract lock state with local lock managers on the secondary nodes. The abstract lock state includes a particular representation of all of the applications on the nodes that are requesting or are granted locks. The exchange of these particular lock states instead of individual requests improves performance by increasing concurrency and reducing off-machine communication. A global deadlock detector on a node detects and resolves global deadlocks, in conjunction with local deadlock detectors on the secondary nodes.

摘要翻译： 在包括一个或多个主节点和多个次节点的共享数据系统中，主节点上的全局锁管理器通过与次节点上的本地锁管理器交换抽象锁状态来管理用于共享资源的锁。 抽象锁定状态包括节点上正在请求或被授予锁定的所有应用程序的特定表示。 这些特定锁定状态的交换而不是单独的请求通过增加并发性和减少机外通信来提高性能。 节点上的全局死锁检测器与辅助节点上的本地死锁检测器一起检测并解决全局死锁。

公开(公告)号：US08583756B2

公开(公告)日：2013-11-12

申请号：US12243101

申请日：2008-10-01

申请人： Jack Hon Wai Ng ,  Jeffrey J. Goss ,  Hebert W. Pereyra ,  Kaarel Truuvert ,  Xun Xue

发明人： Jack Hon Wai Ng ,  Jeffrey J. Goss ,  Hebert W. Pereyra ,  Kaarel Truuvert ,  Xun Xue

IPC分类号： G06F15/167

CPC分类号： G06F9/5016

摘要： A database management system in which a plurality of nodes form a database instance, each node including a communication manager for dynamically configuring inter-nodal communication resources. The communication manager receives communication resource allocation requests from clients or a self-tuning algorithm. A resource self-tuning mechanism allocates or de-allocates memory blocks used for communication resource elements dynamically in real time without cycling the instance. Memory blocks are de-allocated asynchronously by placing associated communication resource elements in quarantine until all communication resource elements associated with the memory block are quarantined.

摘要翻译： 一种数据库管理系统，其中多个节点形成数据库实例，每个节点包括用于动态配置节点间通信资源的通信管理器。 通信管理器从客户端接收通信资源分配请求或自调整算法。 资源自整定机制实时分配或解除分配用于通信资源元素的存储块，而不需要循环实例。 通过将关联的通信资源元素放置在隔离中，直到与存储器块相关联的所有通信资源元素被隔离，才能异步地分配内存块。

公开(公告)号：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.

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

公开(公告)号：US07433945B2

公开(公告)日：2008-10-07

申请号：US10410856

申请日：2003-04-09

申请人： Jack Hon Wai Ng ,  Jeffrey J. Goss ,  Hebert W. Pereyra ,  Kaarel Truuvert ,  Xun Xue

发明人： Jack Hon Wai Ng ,  Jeffrey J. Goss ,  Hebert W. Pereyra ,  Kaarel Truuvert ,  Xun Xue

IPC分类号： G06F15/173

CPC分类号： G06F9/5016

摘要： A database management system in which a plurality of nodes form a database instance, each node including a communication manager for dynamically configuring inter-nodal communication resources. The communication manager receives communication resource allocation requests from clients or a self-tuning algorithm. A resource self-tuning mechanism allocates or de-allocates memory blocks used for communication resource elements dynamically in real time without cycling the instance. Memory blocks are de-allocated asynchronously by placing associated communication resource elements in quarantine until all communication resource elements associated with the memory block are quarantined.

摘要翻译： 一种数据库管理系统，其中多个节点形成数据库实例，每个节点包括用于动态配置节点间通信资源的通信管理器。 通信管理器从客户端接收通信资源分配请求或自调整算法。 资源自整定机制实时分配或解除分配用于通信资源元素的存储块，而不需要循环实例。 通过将关联的通信资源元素放置在隔离中，直到与存储器块相关联的所有通信资源元素被隔离，才能异步地分配内存块。

公开(公告)号：US20060095478A1

公开(公告)日：2006-05-04

申请号：US10978548

申请日：2004-11-01

申请人： Kevin Cherkauer ,  Scott Lashley ,  Steven Pearson ,  Effi Ofer ,  Xun Xue ,  Roger Zheng

发明人： Kevin Cherkauer ,  Scott Lashley ,  Steven Pearson ,  Effi Ofer ,  Xun Xue ,  Roger Zheng

IPC分类号： G06F17/30

CPC分类号： G06F11/2097 ,  G06F11/1662 ,  Y10S707/99953

摘要： A method and system are provided for providing a consistent reintegration of a failed primary instance as a new secondary instance with implementation of truncation of log records. Upon failure of a primary instance, a secondary instance may be reassigned as the new primary instance. Prior to reintegration, any portion of the database log of the failed primary that is after the log position of the new primary instance may be truncated, followed by a comparison of the log positions of both the new primary instance and the new secondary instance. In limited circumstances, the truncation of the log data generated by the failed primary instance after the point of failure is possible, and supports reintegration of the failed primary as a new secondary instance with limited overhead.

摘要翻译： 提供了一种方法和系统，用于将失败的主实例作为新的辅助实例提供一致的重新集成，并实现截断日志记录。 在主实例失败时，可以将辅助实例重新分配为新的主实例。 在重新集成之前，可能会截断新主要实例的日志位置之后的失败主数据库的数据库日志的任何部分，然后比较新的主实例和新的辅助实例的日志位置。 在有限的情况下，在故障点之后由失败的主实例生成的日志数据的截断是可能的，并且支持将故障主要重新集成为具有有限开销的新辅助实例。

公开(公告)号：US11640383B2

公开(公告)日：2023-05-02

申请号：US16192514

申请日：2018-11-15

申请人： Xun Xue ,  Chong Chen ,  Per-Ake Larson ,  Robin Grosman

发明人： Xun Xue ,  Chong Chen ,  Per-Ake Larson ,  Robin Grosman

IPC分类号： G06F16/23 ,  G06F16/21

摘要： Methods and systems are described for managing a shared database. One or more processing nodes may access a shared database. A common log node may manage the shared database. The common log node may validate database operations requested by the one or more processing nodes. During validation, the common log node may detect conflicts that occur between database operations requested by the one or more processing nodes.

公开(公告)号：US09864772B2

公开(公告)日：2018-01-09

申请号：US12895644

申请日：2010-09-30

申请人： Kevin J. Cherkauer ,  Steven R. Pearson ,  Xun Xue ,  Roger L. Q. Zheng

发明人： Kevin J. Cherkauer ,  Steven R. Pearson ,  Xun Xue ,  Roger L. Q. Zheng

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

CPC分类号： G06F17/30368 ,  G06F11/1471 ,  G06F11/2094 ,  G06F11/2097 ,  G06F17/30008 ,  G06F17/30377 ,  G06F2201/80

摘要： Methods, systems and program products for log-shipping data replication from a primary system to a communicatively-coupled standby system. Embodiments of the invention may receive transactional log data at a standby system, from the primary system, and before the transactional log data is written to storage on the primary system. Embodiments may then receive a notification from the primary system indicating that the corresponding log data was written to storage on the primary system, and responsive to receiving the notification, may process the received transactional log data.

公开(公告)号：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.

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

公开(公告)号：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.

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

公开(公告)号：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返回有效副本。