Invention Grant
- Patent Title: Optimizations for long-lived statements in a database system
-
Application No.: US17649737Application Date: 2022-02-02
-
Publication No.: US11704305B1Publication Date: 2023-07-18
- Inventor: Chen Luo , Alexander Miller , William Waddington , Zhaohui Zhang
- 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/23
- IPC: G06F16/23 ; G06F9/52

Abstract:
The subject technology performs a search for a key in a regular space to locate a first visible version of the key. The subject technology determines that the first visible version of the key is not one of a N number of newest versions of the key. The subject technology performs a search of an undo space to locate a second visible version of the key. The subject technology determines whether the first visible version or the second visible version of the key is newer. The subject technology provides a newer version of the key between the first visible version and the second visible version of the key.
Public/Granted literature
- US20230244655A1 OPTIMIZATIONS FOR LONG-LIVED STATEMENTS IN A DATABASE SYSTEM Public/Granted day:2023-08-03
Information query