Invention Grant
- Patent Title: Managing concurrent transactions in database systems
-
Application No.: US17821670Application Date: 2022-08-23
-
Publication No.: US11709818B2Publication Date: 2023-07-25
- Inventor: Alexander Miller , William Waddington
- Applicant: Snowflake Inc.
- Applicant Address: US MT Bozeman
- Assignee: Snowflake Inc.
- Current Assignee: Snowflake Inc.
- Current Assignee Address: US MT Bozeman
- Agency: Schwegman Lundberg & Woessner, P.A.
- Main IPC: G06F16/248
- IPC: G06F16/248 ; G06F16/23 ; G06F16/2455 ; G06F16/22

Abstract:
The subject technology receives a first transaction, the first transaction to be executed on linearizable storage. The subject technology assigns, prior to performing a read operation, a first read version to the first transaction, the first read version indicating a first version of the linearizable storage, the first read version corresponding to a particular timestamp of a current time. The subject technology performs the read operation from the first transaction on a table in a database. The subject technology determines a first commit version identifier corresponding to first data resulting from the read operation. The subject technology proceeds to perform a particular write operation from the first transaction. The subject technology determines that the first commit version identifier fails to match a second commit version identifier corresponding to a second transaction. The subject technology aborts the particular write operation from the first transaction.
Public/Granted literature
- US20230011046A1 MANAGING CONCURRENT TRANSACTIONS IN DATABASE SYSTEMS Public/Granted day:2023-01-12
Information query