公开(公告)号：US20250117387A1

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

申请号：US18987419

申请日：2024-12-19

Applicant: Snowflake Inc.

Inventor： Thierry Cruanes ,  Benoit Dageville ,  Igor Demura ,  Brian Charles Forney ,  Weili Gu ,  Yujie Li ,  Mohammad Saber Mirzaei ,  Jaeyun Noh ,  Jiaqi Yan

IPC: G06F16/2453

Abstract: Interleaved infrastructure can interleave fragment execution during query compilation. For example, compilation can be paused, and a plan fragment is executed. The results of the plan fragment can be fed back into the compiler, which can then restart the compilation and modify the compilation based on the results of the plan fragment execution. The interleaved workflow provides a flexible, robust infrastructure, which can enable and improve a variety of database features and query optimizations.

公开(公告)号：US20250123895A1

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

申请号：US18484958

申请日：2023-10-11

Applicant: Snowflake Inc.

Inventor： Brian Charles Forney

IPC: G06F9/50

Abstract: A system and method of execution node provisioning of a data store with fairness during oversubscription. The method includes scanning, during a first iteration, a queue to identify a first batch of processing requests associated with a plurality of accounts. The method includes determining a total count of demanded execution nodes to satisfy the first batch of processing requests. The method includes determining, based on the total count of demanded execution nodes, an inability for a pool of available execution nodes of a data store to satisfy the first batch of processing requests. The method includes allocating, by a processing device, the first batch of processing requests to the pool of available execution nodes according to a rationing procedure to reduce a latency time associated with processing the first batch of processing requests.

公开(公告)号：US20240345877A1

公开(公告)日：2024-10-17

申请号：US18300738

申请日：2023-04-14

Applicant: Snowflake Inc.

Inventor： Igor Demura ,  Brian Charles Forney ,  Weili Gu ,  Mohammad Saber Mirzaei ,  William Waddington ,  Jiaqi Yan

IPC: G06F9/48 ,  G06F9/54

CPC classification number: G06F9/4881 ,  G06F9/547

Abstract: Techniques for creating child jobs in network-based data systems are described. A request to create a child job for a parent job can be received at a first compute service manager. A child job token can be generated, and a request message can be generated including the child job token and configuration information. The request message can be transmitted to a second compute service manager, where the child job can be constructed linking the child job to the parent job based on the child job token and configuration information. A response message can be received from the second compute service manager including confirmation that the child job was created.

公开(公告)号：US20240256540A1

公开(公告)日：2024-08-01

申请号：US18162486

申请日：2023-01-31

Applicant: Snowflake Inc.

Inventor： Thierry Cruanes ,  Benoit Dageville ,  Igor Demura ,  Brian Charles Forney ,  Weili Gu ,  Yujie Li ,  Mohammad Saber Mirzaei ,  Jaeyun Noh ,  Jiaqi Yan

IPC: G06F16/2453

CPC classification number: G06F16/24542 ,  G06F16/24532 ,  G06F16/2454

Abstract: Interleaved infrastructure can interleave fragment execution during query compilation. For example, compilation can be paused, and a plan fragment is executed. The results of the plan fragment can be fed back into the compiler, which can then restart the compilation and modify the compilation based on the results of the plan fragment execution. The interleaved workflow provides a flexible, robust infrastructure, which can enable and improve a variety of database features and query optimizations.

公开(公告)号：US12210525B2

公开(公告)日：2025-01-28

申请号：US18162486

申请日：2023-01-31

Applicant: Snowflake Inc.

Inventor： Thierry Cruanes ,  Benoit Dageville ,  Igor Demura ,  Brian Charles Forney ,  Weili Gu ,  Yujie Li ,  Mohammad Saber Mirzaei ,  Jaeyun Noh ,  Jiaqi Yan

IPC: G06F16/24 ,  G06F16/2453

Abstract: Interleaved infrastructure can interleave fragment execution during query compilation. For example, compilation can be paused, and a plan fragment is executed. The results of the plan fragment can be fed back into the compiler, which can then restart the compilation and modify the compilation based on the results of the plan fragment execution. The interleaved workflow provides a flexible, robust infrastructure, which can enable and improve a variety of database features and query optimizations.