Invention Grant
US09430274B2 Efficient methods and systems for consistent read in record-based multi-version concurrency control
有权
高效的方法和系统,用于一致性读取基于记录的多版本并发控制
- Patent Title: Efficient methods and systems for consistent read in record-based multi-version concurrency control
- Patent Title (中): 高效的方法和系统,用于一致性读取基于记录的多版本并发控制
-
Application No.: US14229519Application Date: 2014-03-28
-
Publication No.: US09430274B2Publication Date: 2016-08-30
- Inventor: Guogen Zhang
- Applicant: FutureWei Technologies, Inc.
- Applicant Address: US TX Plano
- Assignee: Futurewei Technologies, Inc.
- Current Assignee: Futurewei Technologies, Inc.
- Current Assignee Address: US TX Plano
- Agency: Slater Matsil, LLP
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F9/46 ; G06F17/30

Abstract:
System and method embodiments are provided for consistent read in a record-based multi-version concurrency control (MVCC) in database (DB) management systems. In an embodiment, a method in a record-based multi-version concurrent control (MVCC) database (DB) management system for a snapshot consistent read includes copying a system commit transaction identifier (TxID) and a current log record sequence number (LSN) from a transaction log at a start of a reader without backfilling of a commit LSN of a transaction to records that are changed and without copying an entire transaction table by the reader; and determining whether a record is visible according to a record TxID, the commit TxID and a current LSN, wherein a transaction table is consulted only when the record TxID is equal to or larger than a commit TxID at a transaction start.
Public/Granted literature
- US20150278281A1 Efficient Methods and Systems for Consistent Read in Record-Based Multi-Version Concurrency Control Public/Granted day:2015-10-01
Information query