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

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

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

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

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

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

公开(公告)号：US07107294B2

公开(公告)日：2006-09-12

申请号：US10752026

申请日：2004-01-07

申请人： Keriley K. Romanufa ,  Jeffrey J. Goss ,  Matthew A. Huras ,  Catherine S. McArthur ,  Dale M. McInnis ,  Michael J. Winer ,  Roger L. Q. Zheng

发明人： Keriley K. Romanufa ,  Jeffrey J. Goss ,  Matthew A. Huras ,  Catherine S. McArthur ,  Dale M. McInnis ,  Michael J. Winer ,  Roger L. Q. Zheng

IPC分类号： G06F17/30

CPC分类号： G06F17/30371 ,  G06F17/30368 ,  Y10S707/99938 ,  Y10S707/99953

摘要： A method and system for suspending log-based updates to a database in a manner that permits resumption of log-based updating without reinitializing the database. The method and system thereby permit efficient alternation between a log-based update mode and a database access mode. Unplayed log records are protected as revisions of database pages at the time that the log-based update was suspended. This approach permits log-based updating to resume at the same point at which log-based updating was suspended. In order to ensure consistent data for access while in database access mode, a roll-back procedure creates consistent data pages that are used for access and discarded when log-based update resumes.

摘要翻译： 一种方法和系统，用于以允许恢复基于日志的更新而不重新初始化数据库的方式将日志更新挂起到数据库。 因此，该方法和系统允许基于日志的更新模式和数据库访问模式之间的有效交替。 在日志更新被挂起时，未播放的日志记录将作为数据库页面的修订保护。 这种方法允许基于日志的更新在基于日志的更新被暂停的同一点恢复。 为了在数据库访问模式下确保访问一致的数据，回滚过程创建用于访问的一致数据页，并在基于日志的更新恢复时丢弃。

公开(公告)号：US07203802B2

公开(公告)日：2007-04-10

申请号：US10425163

申请日：2003-04-29

申请人： Matthew A. Huras ,  Quanhua Hong ,  Catherine S. McArthur ,  Lorysa M. Meadowcroft ,  Shaun K. Thornborough ,  Michael J. Winer ,  Roger L. Q. Zheng

发明人： Matthew A. Huras ,  Quanhua Hong ,  Catherine S. McArthur ,  Lorysa M. Meadowcroft ,  Shaun K. Thornborough ,  Michael J. Winer ,  Roger L. Q. Zheng

IPC分类号： G06F12/00

CPC分类号： G06F17/30368

摘要： A memory buffer facilitates log catchup for online operations. Certain designated areas of memory are allocated for one or more buffers for use during online operations (e.g., reorganization, create index, etc.). Concurrent update activities to the target object write informational records into the one or more buffers. If the buffers become full, the informational records may be written to logs for persistent storage. After online operations finish building all or a suitable portion of the shadow object, log catchup is performed by first applying activities in the informational records from the buffer and thereafter applying activities from logs, if necessary. The invention helps solve the drawbacks of log catchup since the buffer contains only the information related to the target shadow object. Also it does not involve physical I/Os, as these records are all in memory.

摘要翻译： 内存缓冲区有助于日志追踪在线操作。 某些指定的存储区域被分配用于在线操作期间使用的一个或多个缓冲器（例如，重组，创建索引等）。 目标对象的并发更新活动将信息记录写入一个或多个缓冲区。 如果缓冲区已满，则可将信息记录写入日志以进行持久存储。 在线操作完成构建阴影对象的所有或适当部分后，通过首先在缓冲区中的信息记录中应用活动，然后在必要时从日志应用活动来执行日志追踪。 本发明有助于解决日志追踪的缺点，因为缓冲器仅包含与目标影子对象相关的信息。 此外，它不涉及物理I / O，因为这些记录都在内存中。

公开(公告)号：US07069366B2

公开(公告)日：2006-06-27

申请号：US10346214

申请日：2003-01-18

申请人： Sarah Posner ,  Miroslaw A. Flasza ,  Jeffrey J. Goss ,  Matthew A. Huras ,  Catherine S. McArthur ,  Lorysa M. Meadowcroft ,  Michael J. Winer ,  Roger L. Q. Zheng

发明人： Sarah Posner ,  Miroslaw A. Flasza ,  Jeffrey J. Goss ,  Matthew A. Huras ,  Catherine S. McArthur ,  Lorysa M. Meadowcroft ,  Michael J. Winer ,  Roger L. Q. Zheng

IPC分类号： G06F12/00

CPC分类号： G06F9/526 ,  G06F17/30492 ,  G06F2209/522 ,  G06F2209/523

摘要： A system and method handle resource transaction requests. The system marks a waiting transaction request, having an access mode which is incompatible with the access mode of the executing transaction, with an ignore bit, so that a transaction request with an access mode compatible with the access mode of the executing transaction may receive a lock in order to access the resource. The transaction request is then marked with a bypass indicator such that when the executing transactions are finished accessing the resource, the waiting transaction request may be notified that it may have access to the resource. The system includes the ignore bit so that each transaction request that arrives after the ignore bit has been set, does not suffer from a long waiting time before being provided access to the resource.

摘要翻译： 系统和方法处理资源事务请求。 该系统标记具有与执行事务的访问模式不兼容的访问模式的等待事务请求，具有忽略位，使得具有与执行事务的访问模式兼容的访问模式的事务请求可以接收 锁定以访问资源。 然后，交易请求被标记旁路指示符，使得当执行的事务完成访问资源时，可以通知等待的事务请求它可以访问该资源。 该系统包括忽略位，使得在忽略位之后到达的每个事务请求在被提供给资源的访问之前不会受到漫长的等待时间的困扰。

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

摘要翻译： 用于日志传送从主系统到通信耦合待机系统的数据复制的方法，系统和程序产品。 本发明的实施例可以在备用系统，主要系统和事务日志数据被写入主系统之间的存储器之前接收事务日志数据。 实施例然后可以从主系统接收指示对应的日志数据被写入主系统上的存储并且响应于接收到通知的通知可以处理所接收的事务日志数据。

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

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

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