Invention Grant
- Patent Title: Resource provisioning in database systems
-
Application No.: US17663248Application Date: 2022-05-13
-
Publication No.: US11514064B2Publication Date: 2022-11-29
- Inventor: Jeffrey Rosen , Abdul Munir , Jiaqi Yan , William Waddington , Prasanna Rajaperumal , Thierry Cruanes
- 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/24
- IPC: G06F16/24 ; G06F16/2458 ; G06F16/2453 ; G06F16/2455 ; G06F9/50

Abstract:
Resource provisioning systems and methods are described. In an embodiment, a system includes a plurality of shared storage devices collectively storing database data, an execution platform, and a compute service manager. The compute service manager is configured to determine a task to be executed in response to a trigger event and determine a query plan for executing the task, wherein the query plan comprises a plurality of discrete subtasks. The compute service manager is further configured to assign the plurality of discrete subtasks to one or more nodes of a plurality of nodes of the execution platform, determine whether execution of the task is complete, and in response to determining the execution of the task is complete, store a record in the plurality of shared storage devices indicating the task was completed.
Public/Granted literature
- US20220269676A1 RESOURCE PROVISIONING IN DATABASE SYSTEMS Public/Granted day:2022-08-25
Information query