Invention Grant
- Patent Title: Systems and methods for increasing database access concurrency
-
Application No.: US15665273Application Date: 2017-07-31
-
Publication No.: US10558625B2Publication Date: 2020-02-11
- Inventor: Wilson Chang-Yi Hsieh , Alexander Lloyd , Eric Hugh Veach
- Applicant: Google LLC
- Applicant Address: US CA Mountain View
- Assignee: Google LLC
- Current Assignee: Google LLC
- Current Assignee Address: US CA Mountain View
- Agency: Lerner, David, Littenberg, Krumholz & Mentlik, LLP
- Main IPC: G06F16/21
- IPC: G06F16/21 ; G06F16/23

Abstract:
The various embodiments described herein include methods, devices, and systems for reading and writing data from a database table. In one aspect, a method of reading and writing data from a database table, includes: (1) initiating a write transaction to write data to a first non-key column of a row of the database table, the database table having a plurality of rows, each row comprising a primary key and a plurality of non-key columns; (2) locking the first non-key column; and (3) in accordance with a determination that the second non-key column is not locked, initiating a read transaction to read data from the second non-key column, where initiation of the read transaction occurs prior to completion of the write transaction.
Public/Granted literature
- US20170357674A1 Systems and Methods for Increasing Database Access Concurrency Public/Granted day:2017-12-14
Information query