公开(公告)号：US09881049B2

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

申请号：US15366611

申请日：2016-12-01

Applicant: International Business Machines Corporation

Inventor： Ronald J. Barber ,  Bishwaranjan Bhattacharjee ,  Guy M. Lohman ,  Chandrasekaran Mohan ,  Vijayshankar Raman ,  Mohammad Sadoghi Hamedani ,  Richard S. Sidle ,  Adam J. Storm ,  Xun Xue

IPC: G06F7/00 ,  G06F17/30

CPC classification number: G06F17/30377 ,  G06F17/303 ,  G06F17/30303 ,  G06F17/30348 ,  G06F17/30368 ,  G06F17/30371 ,  G06F17/30504

Abstract: A first request may be received to update a first set of values. The first set of values may be stored at a first location within a first data page of a database. The first location may be read-only. In response to the receiving of the first request, a first set of records may be inserted into a second data page. The first set of records may include the update of the first set of values. In response to the inserting, a forward pointer may be stored in the first data page that points to the first set of records on the second data page. One or more committed values may be identified on the second data page. In response to the identifying, the one or more committed values may be merged from the second data page to a third data page.

公开(公告)号：US20140032765A1

公开(公告)日：2014-01-30

申请号：US13950414

申请日：2013-07-25

Applicant: International Business Machines Corporation

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

IPC: G06F9/50

CPC classification number: G06F17/30362 ,  G06F9/5005 ,  G06F9/5038 ,  G06F9/524 ,  G06F9/526

Abstract: 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.

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

公开(公告)号：US11853284B2

公开(公告)日：2023-12-26

申请号：US16555721

申请日：2019-08-29

Applicant: International Business Machines Corporation

Inventor： Ronald J. Barber ,  Bishwaranjan Bhattacharjee ,  Mohammad Sadoghi Hamedani ,  Guy M. Lohman ,  Chandrasekaran Mohan ,  Vijayshankar Raman ,  Richard S. Sidle ,  Adam J. Storm ,  Xun Xue

IPC: G06F16/23

CPC classification number: G06F16/2343 ,  G06F16/2315 ,  G06F16/2365 ,  G06F16/2379

Abstract: A method includes storing an anchor row vector identification for an anchor row to a local memory. It is determined whether the anchor row vector identification is visible based on isolation requirements. The anchor row vector identification is accessed upon a determination that the anchor row vector identification is visible, and the row vector identification is re-read from the local memory. It is determined whether the anchor row vector identification has not changed since a start of the accessing. Upon a determination that the anchor row vector identification has not changed, read anchor row fields are returned. A first check history is performed on an anchor row history tuple sequence number (TSN) for the anchor row.

公开(公告)号：US09940346B2

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

申请号：US14338452

申请日：2014-07-23

Applicant: International Business Machines Corporation

Inventor： 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 classification number: G06F17/30362 ,  G06F9/5005 ,  G06F9/5038 ,  G06F9/524 ,  G06F9/526

Abstract: 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.

公开(公告)号：US09646044B2

公开(公告)日：2017-05-09

申请号：US14554280

申请日：2014-11-26

Applicant: International Business Machines Corporation

Inventor： Ronen Grosman ,  Matthew A. Huras ,  Bret R. Olszewski ,  Keriley K. Romanufa ,  Aamer U. Sachedina ,  Xun Xue

IPC: G06F7/00 ,  G06F17/00 ,  G06F17/30 ,  G06F15/16

CPC classification number: G06F17/30377 ,  G06F17/30171 ,  G06F17/30362 ,  G06F17/30466

Abstract: Technology for applying locks to memory pages. More specifically, a sticky lock is chosen by matching observed usage patterns with predetermined patterns associated with various sticky locks and/or types of stick locks increase database performance by reducing required communications and information transfers.

公开(公告)号：US09633070B2

公开(公告)日：2017-04-25

申请号：US14230185

申请日：2014-03-31

Applicant: International Business Machines Corporation

Inventor： Ronen Grosman ,  Matthew A. Huras ,  Bret R. Olszewski ,  Keriley K. Romanufa ,  Aamer U. Sachedina ,  Xun Xue

IPC: G06F15/16 ,  G06F17/30

CPC classification number: G06F17/30377 ,  G06F17/30171 ,  G06F17/30362 ,  G06F17/30466

Abstract: According to embodiments of the present invention, one or more computer processors determine that a predetermined workload threshold associated with an invalidated object is not exceeded and transmits an invalidation command associated with the invalidated object to the owner of the invalidated object. The one or more computer processors instruct the modifier of the invalidated object to retain possession of a first lock on the object beyond the transaction. The one or more computer processors determine that a usage pattern associated with the invalidated object matches a predetermined usage pattern for selecting a lock that can be retained beyond an associated transaction and transmits a second lock a requestor. The one or more computer processors instruct the modifier to release possession of the first lock to the owner and transmit a first image of the current version of the invalidated object to the owner for subsequent transmission to the requestor.

公开(公告)号：US20170075951A1

公开(公告)日：2017-03-16

申请号：US15366611

申请日：2016-12-01

Applicant: International Business Machines Corporation

Inventor： Ronald J. Barber ,  Bishwaranjan Bhattacharjee ,  Guy M. Lohman ,  Chandrasekaran Mohan ,  Vijayshankar Raman ,  Mohammad Sadoghi Hamedani ,  Richard S. Sidle ,  Adam J. Storm ,  Xun Xue

IPC: G06F17/30

CPC classification number: G06F17/30377 ,  G06F17/303 ,  G06F17/30303 ,  G06F17/30348 ,  G06F17/30368 ,  G06F17/30371 ,  G06F17/30504

Abstract: A first request may be received to update a first set of values. The first set of values may be stored at a first location within a first data page of a database. The first location may be read-only. In response to the receiving of the first request, a first set of records may be inserted into a second data page. The first set of records may include the update of the first set of values. In response to the inserting, a forward pointer may be stored in the first data page that points to the first set of records on the second data page. One or more committed values may be identified on the second data page. In response to the identifying, the one or more committed values may be merged from the second data page to a third data page.

公开(公告)号：US09547659B1

公开(公告)日：2017-01-17

申请号：US14974612

申请日：2015-12-18

Applicant: International Business Machines Corporation

Inventor： Ronald J. Barber ,  Bishwaranjan Bhattacharjee ,  Guy M. Lohman ,  Chandrasekaran Mohan ,  Vijayshankar Raman ,  Mohammad Sadoghi Hamedani ,  Richard S. Sidle ,  Adam J. Storm ,  Xun Xue

IPC: G06F7/00 ,  G06F17/30

CPC classification number: G06F17/30377 ,  G06F17/303 ,  G06F17/30303 ,  G06F17/30348 ,  G06F17/30368 ,  G06F17/30371 ,  G06F17/30504

Abstract: A first request may be received to update a first set of values. The first set of values may be stored at a first location within a first data page of a database. The first location may be read-only. In response to the receiving of the first request, a first set of records may be inserted into a second data page. The first set of records may include the update of the first set of values. In response to the inserting, a forward pointer may be stored in the first data page that points to the first set of records on the second data page. One or more committed values may be identified on the second data page. In response to the identifying, the one or more committed values may be merged from the second data page to a third data page.

Abstract translation: 可以接收第一请求以更新第一组值。 第一组值可以存储在数据库的第一数据页内的第一位置。 第一个位置可能是只读的。 响应于接收到第一请求，可以将第一组记录插入到第二数据页中。 第一组记录可能包括更新第一组值。 响应于插入，可以将前向指针存储在指向第二数据页上的第一组记录的第一数据页中。 可以在第二数据页上识别一个或多个提交值。 响应于识别，一个或多个提交值可以从第二数据页合并到第三数据页。

公开(公告)号：US10831741B2

公开(公告)日：2020-11-10

申请号：US15831183

申请日：2017-12-04

Applicant: International Business Machines Corporation

Inventor： Xun Xue ,  Steven R. Pearson ,  Roger L. Q. Zheng ,  Kevin J. Cherkauer

IPC: G06F16/23 ,  G06F11/14 ,  G06F11/20

Abstract: Techniques for data replication from a primary system to a standby system. A first buffer portion of a transaction log buffer is allocated to a first transaction at a primary system. Upon determining that the first buffer portion is fully formed, before the log data is written to the storage on the primary system, and before the transaction log buffer is entirely full, the log data in the first buffer portion is transmitted to the standby system, from the primary system. Upon writing the log data to the storage on the primary system and after the log data in the first buffer portion is transmitted to the standby system, a notification is transmitted to the standby system, from the primary system, where the standby system is configured to process the received log data responsive to receiving the notification from the primary system.

公开(公告)号：US09922077B2

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

申请号：US15366562

申请日：2016-12-01

Applicant: International Business Machines Corporation

Inventor： Ronald J. Barber ,  Bishwaranjan Bhattacharjee ,  Guy M. Lohman ,  Chandrasekaran Mohan ,  Vijayshankar Raman ,  Mohammad Sadoghi Hamedani ,  Richard S. Sidle ,  Adam J. Storm ,  Xun Xue

IPC: G06F7/00 ,  G06F17/00 ,  G06F17/30

CPC classification number: G06F17/30377 ,  G06F17/303 ,  G06F17/30303 ,  G06F17/30348 ,  G06F17/30368 ,  G06F17/30371 ,  G06F17/30504

Abstract: A first request may be received to update a first set of values. The first set of values may be stored at a first location within a first data page of a database. The first location may be read-only. In response to the receiving of the first request, a first set of records may be inserted into a second data page. The first set of records may include the update of the first set of values. In response to the inserting, a forward pointer may be stored in the first data page that points to the first set of records on the second data page. One or more committed values may be identified on the second data page. In response to the identifying, the one or more committed values may be merged from the second data page to a third data page.