公开(公告)号：US11243811B1

公开(公告)日：2022-02-08

申请号：US17390265

申请日：2021-07-30

Applicant: Snowflake Inc.

Inventor： Qiming Jiang ,  Orestis Kostakis ,  Abdul Munir ,  Prayag Chandran Nirmala ,  Jeffrey Rosen

IPC: G06F9/46 ,  G06F9/50 ,  G06F16/2455 ,  G06N5/04 ,  G06N20/00

Abstract: The subject technology requests information related to usage history metadata from a metadata database. The subject technology receives the requested information from the metadata database, the requested information comprising information related to user demand. The subject technology predicts a size value indicating an amount of computing resources to request for executing a set of queries based on the usage history metadata. The subject technology determines, during a prefetch window of time within a first period of time, a current size of freepool of computing resources. The subject technology, in response to the current size of the freepool of computing resources being smaller than the predicted size value, sends a request for additional computing resources to include in the freepool of computing resources.

公开(公告)号：US11138038B1

公开(公告)日：2021-10-05

申请号：US17173717

申请日：2021-02-11

Applicant: Snowflake Inc.

Inventor： Qiming Jiang ,  Orestis Kostakis ,  Abdul Munir ,  Prayag Chandran Nirmala ,  Jeffrey Rosen

IPC: G06F9/46 ,  G06F9/50 ,  G06N5/04 ,  G06F16/2455 ,  G06N20/00

Abstract: The subject technology determines usage history metadata. The subject technology predicts a size value indicating an amount of computing resources to request for executing a set of queries based at least in part on the usage history metadata. The subject technology determines, during a prefetch window of time within a first period of time, a current size of a freepool of computing resources. The subject technology, in response to the current size of the freepool of computing resources being smaller than the predicted size value, sends a request for additional computing resources to include in the freepool of computing resources. The subject technology receives an indication that the request for additional computing resources was granted. The subject technology performs an operation to include the additional computing resources in the freepool of computing resources.

公开(公告)号：US11372679B1

公开(公告)日：2022-06-28

申请号：US17647635

申请日：2022-01-11

Applicant: Snowflake Inc.

Inventor： Qiming Jiang ,  Orestis Kostakis ,  Abdul Munir ,  Prayag Chandran Nirmala ,  Jeffrey Rosen

IPC: G06F9/46 ,  G06F9/50 ,  G06F16/2455 ,  G06N5/04 ,  G06N20/00

Abstract: The subject technology requests information related to usage history metadata from a metadata database. The subject technology receives the requested information from the metadata database, the requested information comprising information related to user demand. The subject technology predicts a size value indicating an amount of computing resources to request for executing a set of queries based on the usage history metadata. The subject technology determines, during a prefetch window of time within a first period of time, a current size of freepool of computing resources. The subject technology, in response to the current size of the freepool of computing resources being smaller than the predicted size value, sends a request for additional computing resources to include in the freepool of computing resources.

公开(公告)号：US12242496B2

公开(公告)日：2025-03-04

申请号：US18151327

申请日：2023-01-06

Applicant: Snowflake Inc.

Inventor： Marco H. Kroll ,  Mariusz Kwiczala ,  Prayag Chandran Nirmala ,  William Waddington ,  Shijie Xu

IPC: G06F16/25 ,  G06F9/48 ,  G06F16/2455

Abstract: The subject technology receives a query, the query comprising a set of query statements. The subject technology determines that a set of resources to be utilized by the query during execution is provided by a slot, the slot comprising an allocation of resources provided by a virtual warehouse. The subject technology performs a first scheduling process for execution of the query using the slot. The subject technology determines that an available slot is provided by the virtual warehouse. The subject technology executes, using the virtual warehouse, the query using the available slot.

公开(公告)号：US20240232213A1

公开(公告)日：2024-07-11

申请号：US18151327

申请日：2023-01-06

Applicant: Snowflake Inc.

Inventor： Marco H. Kroll et al. ,  Mariusz Kwiczala ,  Prayag Chandran Nirmala ,  William Waddington ,  Shijie Xu

IPC: G06F16/25 ,  G06F9/48 ,  G06F16/2455

CPC classification number: G06F16/254 ,  G06F9/4881 ,  G06F16/2455

Abstract: The subject technology receives a query, the query comprising a set of query statements. The subject technology determines that a set of resources to be utilized by the query during execution is provided by a slot, the slot comprising an allocation of resources provided by a virtual warehouse. The subject technology performs a first scheduling process for execution of the query using the slot. The subject technology determines that an available slot is provided by the virtual warehouse. The subject technology executes, using the virtual warehouse, the query using the available slot.