Invention Grant
- Patent Title: Managing database failover based on transaction request time
-
Application No.: US18123108Application Date: 2023-03-17
-
Publication No.: US12158897B2Publication Date: 2024-12-03
- Inventor: Benoit Dageville , Eric Robinson , Martin Hentschel
- Applicant: Snowflake Inc.
- Applicant Address: US MT Bozeman
- Assignee: Snowflake Inc.
- Current Assignee: Snowflake Inc.
- Current Assignee Address: US MT Bozeman
- Agency: Womble Bond Dickinson (US) LLP
- Main IPC: G06F16/00
- IPC: G06F16/00 ; G06F16/245 ; G06F16/27 ; H04L67/1097

Abstract:
Methods and systems of managing database failure based on transaction request time is disclosed. A method includes copying a first dataset stored in a primary deployment to a secondary deployment to generate a second dataset. The method includes determining a first arrival time of a first request to perform a first transaction. The method includes determining a second arrival time of a second request to perform a second transaction. The method includes executing the first transaction on the first dataset at the primary deployment in response to determining the first arrival time of the first request to perform the first transaction. The method includes executing the second transaction on the second dataset at the secondary deployment in response to determining the second arrival time of the second request to perform the second transaction.
Public/Granted literature
- US20230267131A1 MANAGING DATABASE FAILOVER BASED ON TRANSACTION REQUEST TIME Public/Granted day:2023-08-24
Information query