- 专利标题: Systems and methods for increasing database access concurrency
-
申请号: US17824348申请日: 2022-05-25
-
公开(公告)号: US11853269B2公开(公告)日: 2023-12-26
- 发明人: Wilson Cheng-Yi Hsieh , Alexander Lloyd , Eric Hugh Veach
- 申请人: Google LLC
- 申请人地址: US CA Mountain View
- 专利权人: Google LLC
- 当前专利权人: Google LLC
- 当前专利权人地址: US CA Mountain View
- 代理机构: Lerner David LLP
- 主分类号: G06F16/21
- IPC分类号: G06F16/21 ; G06F16/23
摘要:
The various embodiments described herein include methods, devices, and systems for reading and writing data from a database table. In one aspect, a method includes: (1) initiating a read transaction to read from a first non-key column of a row in the database table, the database table having a plurality of rows, each row comprising a primary key and a plurality of non-key columns, the initiating including: (a) determining that a write transaction holds a lock on a second non-key column of the row in the database table, and (b) determining that no lock is held on the first non-key column; and (2) in response, concurrently reading data from the first non-key column and writing a new column value to the second non-key column; where each non-key column includes a last-write timestamp that indicates when the last write occurred for the respective non-key column.
公开/授权文献
信息查询