发明授权
- 专利标题: Cache-conscious concurrency control scheme for database systems
- 专利标题(中): 数据库系统的缓存意识并发控制方案
-
申请号: US10162731申请日: 2002-06-04
-
公开(公告)号: US07293028B2公开(公告)日: 2007-11-06
- 发明人: Sang K. Cha , Sangyong Hwang , Kihong Kim , Keunjoo Kwon
- 申请人: Sang K. Cha , Sangyong Hwang , Kihong Kim , Keunjoo Kwon
- 申请人地址: DE Walldorf
- 专利权人: SAP AG
- 当前专利权人: SAP AG
- 当前专利权人地址: DE Walldorf
- 代理机构: Schwegman, Lundberg & Woessner, P. A.
- 主分类号: G06F7/00
- IPC分类号: G06F7/00 ; G06F17/30
摘要:
An optimistic, latch-free index traversal (“OLFIT”) concurrency control scheme is disclosed for an index structure for managing a database system. In each node of an index tree, the OLFIT scheme maintains a latch, a version number, and a link to the next node at the same level of the index tree. Index traversal involves consistent node read operations starting from the root. To ensure the consistency of node read operations without latching, every node update operation first obtains a latch and increments the version number after update of the node contents. Every node read operation begins with reading the version number into a register and ends with verifying if the current version number is consistent with the register-stored version number. If they are the same, the read operation is consistent. Otherwise, the node read is retried until the verification succeeds. The concurrency control scheme of the present invention is applicable to many index structures such as the B+-tree and the CSB+-tree.
公开/授权文献
信息查询