专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明授权

US07499954B2 Consistent reintegration of a failed primary instance 失效
标题翻译：失败的主要实例的一致重新整合
公开(公告)号：US07499954B2
公开(公告)日：2009-03-03
申请号：US10978548
申请日：2004-11-01
申请人： Kevin J. Cherkauer , Scott D. Lashley , Steven R. Pearson , Effi Ofer , Xun Xue , Roger L. Q. Zheng
发明人： Kevin J. Cherkauer , Scott D. Lashley , Steven R. Pearson , Effi Ofer , Xun Xue , Roger L. Q. 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.
摘要翻译：提供了一种方法和系统，用于将失败的主实例作为新的辅助实例提供一致的重新集成，并实现截断日志记录。在主实例失败时，可以将辅助实例重新分配为新的主实例。在重新集成之前，可能会截断新主要实例的日志位置之后的失败主数据库的任何部分，然后比较新的主实例和新的辅助实例的日志位置。在有限的情况下，在故障点之后由失败的主实例生成的日志数据的截断是可能的，并且支持将故障主要重新集成为具有有限开销的新辅助实例。

2. 发明授权

US09864772B2 Log-shipping data replication with early log record fetching 有权
公开(公告)号：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.

3. 发明申请

US20120084260A1 LOG-SHIPPING DATA REPLICATION WITH EARLY LOG RECORD FETCHING 有权
标题翻译：使用早期日志记录进行日志传送数据复制
公开(公告)号：US20120084260A1
公开(公告)日：2012-04-05
申请号：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分类号： G06F12/16 , G06F17/30
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.
摘要翻译：用于日志传送从主系统到通信耦合待机系统的数据复制的方法，系统和程序产品。本发明的实施例可以在备用系统，主要系统和事务日志数据被写入主系统之间的存储器之前接收事务日志数据。实施例然后可以从主系统接收指示对应的日志数据被写入主系统上的存储并且响应于接收到通知的通知可以处理所接收的事务日志数据。

4. 发明申请

US20120089735A1 Two-Level Management of Locks on Shared Resources 有权
标题翻译：共享资源锁两级管理
公开(公告)号：US20120089735A1
公开(公告)日：2012-04-12
申请号：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
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.
摘要翻译：在包括一个或多个主节点和多个次节点的共享数据系统中，主节点上的全局锁管理器通过与次节点上的本地锁管理器交换抽象锁状态来管理用于共享资源的锁。抽象锁定状态包括节点上正在请求或被授予锁定的所有应用程序的特定表示。这些特定锁定状态的交换而不是单独的请求通过增加并发性和减少机外通信来提高性能。节点上的全局死锁检测器与辅助节点上的本地死锁检测器一起检测并解决全局死锁。

5. 发明授权

US08868748B2 Two-level management of locks on shared resources 有权
标题翻译：共享资源上锁的两级管理
公开(公告)号：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.
摘要翻译：在包括一个或多个主节点和多个次节点的共享数据系统中，主节点上的全局锁管理器通过与次节点上的本地锁管理器交换抽象锁状态来管理用于共享资源的锁。抽象锁定状态包括节点上正在请求或被授予锁定的所有应用程序的特定表示。这些特定锁定状态的交换而不是单独的请求通过增加并发性和减少机外通信来提高性能。节点上的全局死锁检测器与辅助节点上的本地死锁检测器一起检测并解决全局死锁。

6. 发明授权

US08666958B2 Approaches to reducing lock communications in a shared disk database 有权
标题翻译：减少共享磁盘数据库中的锁通信的方法
公开(公告)号：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.
摘要翻译：在共享磁盘数据库系统中锁定通信可以通过以下几种方法进行减少：向锁管理器发送单个消息，以获得将来需要的操作所需的锁和操作可能包括行更新，行删除，大扫描，和行插入; 执行两次执行中的操作，其中在不执行操作的情况下确定操作所需的第一执行锁定，并且在第二执行中，单个消息被发送到锁管理器以进行所需的锁并且执行操作; 在可用空间搜索中，在实际执行行插入之前，向锁管理器发送行和页锁的单个消息; 并以不公平的方式给予锁。

7. 发明申请

US20060218204A1 Log stream validation in log shipping data replication systems 审中-公开
标题翻译：日志传送数据复制系统中的日志流验证
公开(公告)号：US20060218204A1
公开(公告)日：2006-09-28
申请号：US11089993
申请日：2005-03-25
申请人： Effi Ofer , David Mooney , Steven Pearson , Xun Xue , Kevin Cherkauer
发明人： Effi Ofer , David Mooney , Steven Pearson , Xun Xue , Kevin Cherkauer
IPC分类号： G06F17/30
CPC分类号： G06F11/202 , G06F11/1471 , G06F11/2097
摘要： A data processing implemented method and system and article of manufacture are provided for determining compatibility between a primary instance and a standby instance, the primary instance being characterized by a first log position indicator and a primary log chain fingerprint (FP-P) and the secondary instance being characterized by a second log position indicator and a secondary log chain fingerprint (FP-S); the FP-P and the FP-S each uniquely identifying a prescribed history of an associated data processing system. The method, for example, includes a series of steps comprising: comparing the first log position indicator with the second log position indicator to determine compatibility between the secondary instance and the primary instance; comparing the primary log chain fingerprint (FP-P) with the secondary log chain fingerprint (FP-S) to determine compatibility between the secondary instance and the primary instance; and indicating that the secondary instance is compatible with the primary instance when both of the above comparisons determine compatibility.
摘要翻译：提供了一种数据处理实现的方法和系统及制品，用于确定主实例和备用实例之间的兼容性，主要实例由第一对数位置指示符和主日志链指纹（FP-P）表征，次要其特征在于第二对数位置指示器和辅助对数链指纹（FP-S）; FP-P和FP-S每个唯一地标识相关联的数据处理系统的规定历史。该方法例如包括一系列步骤，包括：将第一日志位置指示符与第二日志位置指示符进行比较，以确定辅助实例与主实例之间的兼容性; 将主日志链指纹（FP-P）与辅助日志链指纹（FP-S）进行比较，以确定辅助实例与主实例之间的兼容性; 并且当上述两个比较确定兼容性时，指示辅助实例与主实例兼容。

8. 发明申请

US20060095478A1 Consistent reintegration a failed primary instance 失效
标题翻译：重新整合失败的主要实例
公开(公告)号：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.
摘要翻译：提供了一种方法和系统，用于将失败的主实例作为新的辅助实例提供一致的重新集成，并实现截断日志记录。在主实例失败时，可以将辅助实例重新分配为新的主实例。在重新集成之前，可能会截断新主要实例的日志位置之后的失败主数据库的数据库日志的任何部分，然后比较新的主实例和新的辅助实例的日志位置。在有限的情况下，在故障点之后由失败的主实例生成的日志数据的截断是可能的，并且支持将故障主要重新集成为具有有限开销的新辅助实例。

9. 发明申请

US20110145627A1 IMPROVING DATA AVAILABILITY DURING FAILURE DETECTION AND RECOVERY PROCESSING IN A SHARED RESOURCE SYSTEM 有权
标题翻译：在共享资源系统中的故障检测和恢复处理过程中改善数据可用性
公开(公告)号：US20110145627A1
公开(公告)日：2011-06-16
申请号：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/20 , G06F9/50
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.
摘要翻译：公开了一种用于管理共享资源的系统和方法。该系统包括处理来自多个数据处理主机的锁定请求的主相关处理单元，该主相关处理单元还存储多个数据处理主机的第一当前锁定状态信息，第一当前锁定状态信息包括多个由多个数据处理主机持有的锁。所述系统还包括备用一致性处理单元，其存储比所述主相关处理单元更少的锁，由所述备用一致性处理单元存储的所述锁是包括在所述第一当前锁定状态信息中的锁的子集，所述备用一致性单元被配置为执行响应于主要一致性处理单元的故障，主要一致性处理单元的多个活动使用锁定子集。

10. 发明申请

US20100223243A1 AUTOMATIC DETECTION AND CORRECTION OF HOT PAGES IN A DATABASE SYSTEM 失效
标题翻译：自动检测和校正数据库系统中的热页
公开(公告)号：US20100223243A1
公开(公告)日：2010-09-02
申请号：US12394786
申请日：2009-02-27
申请人： Matthew Albert Huras , Keriley Kay Romanufa , Aamer Sachedina , Xun Xue
发明人： Matthew Albert Huras , Keriley Kay Romanufa , Aamer Sachedina , Xun Xue
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.
摘要翻译：根据本发明的一个实施例，提供了一种在数据库系统中检测和校正热页面的方法。根据本发明的一个实施例，一种方法包括监视涉及数据库中的页面的事务，并确定其中一个事务是否必须等待访问其中一个页面; 每次其中一个事务必须等待访问其中一个页面时，增加页面争用计数器。该方法然后确定页面争用计数器是否超过预定阈值，并且监视超出页面争用次数的页面之一上的事务。该方法然后确定在超出页面争用次数的页面中是否访问了一行，并增加访问行的引用计数。当参考计数超过第二预定阈值时，所访问的行被标记。标记的行被移动到数据库中的另一个页面。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式