公开(公告)号：US20200242118A1

公开(公告)日：2020-07-30

申请号：US16851800

申请日：2020-04-17

Applicant: SNOWFLAKE INC.

Inventor： Benoit Dageville ,  Jiansheng Huang ,  Shige Takeda ,  Abdul Q. Munir

IPC: G06F16/2453 ,  G06F16/11 ,  G06F16/16 ,  G06F16/2455 ,  G06F16/14

Abstract: A method, system, and apparatus for managing a persistent query result set are disclosed. A resource manager is disclosed that receives a query from a client over a computer network. A computer database server is disclosed that executes the query and generates a result set based on and in response to the received query. An execution platform is disclosed that divides the result set into a plurality of chunks, wherein each chunk comprises a portion of the generated result set. The resource manager adds metadata to each of the plurality of chunks. A first chunk of the plurality of chunks comprises metadata pointing to the plurality of chunks. The resource manager delivers at least the first chunk of the plurality of chunks to the client in response to the query. The execution platform offloads the remaining plurality of chunks to cloud storage in parallel.

公开(公告)号：US11921716B1

公开(公告)日：2024-03-05

申请号：US18453079

申请日：2023-08-21

Applicant: Snowflake Inc.

Inventor： Hossein Ahmandi ,  Jayanta Das ,  Joshua Klahr ,  Boyung Lee ,  Wenye Li ,  Abdul Q. Munir ,  Yi Pan

IPC: G06F16/00 ,  G06F16/2453 ,  G06F16/2455 ,  G06F16/27

CPC classification number: G06F16/24537 ,  G06F16/2456 ,  G06F16/278 ,  G06F16/24544

Abstract: A method includes parsing a query to determine a plurality of data processing operations associated with the query and including an AS OF JOIN operation between first time series data in a first table and second time series data in a second table. A query plan of the query is generated. The query plan includes a plurality of nodes corresponding to the plurality of data processing operations. At least one of the plurality of nodes corresponding to the AS OF JOIN operation is modified to generate a modified query plan of the query. The modifying is based on applying a UNION operation on at least a first portion of column data in the first table and the second table to obtain a combined table. Execution of the query by at least one of a plurality of computing nodes is scheduled based on the modified query plan.

公开(公告)号：US10671605B2

公开(公告)日：2020-06-02

申请号：US15097107

申请日：2016-04-12

Applicant: SNOWFLAKE INC.

Inventor： Benoit Dageville ,  Jiansheng Huang ,  Shige Takeda ,  Abdul Q. Munir

IPC: G06F16/2453 ,  G06F16/14 ,  G06F16/2455 ,  G06F16/11 ,  G06F16/16

Abstract: A method, system, and apparatus for managing a persistent query result set are disclosed. A resource manager is disclosed that receives a query from a client over a computer network. A computer database server is disclosed that executes the query and generates a result set based on and in response to the received query. An execution platform is disclosed that divides the result set into a plurality of chunks, wherein each chunk comprises a portion of the generated result set. The resource manager adds metadata to each of the plurality of chunks. A first chunk of the plurality of chunks comprises metadata pointing to the plurality of chunks. The resource manager delivers at least the first chunk of the plurality of chunks to the client in response to the query. The execution platform offloads the remaining plurality of chunks to cloud storage in parallel.

公开(公告)号：US20250068628A1

公开(公告)日：2025-02-27

申请号：US18392385

申请日：2023-12-21

Applicant: Snowflake Inc.

Inventor： Hossein Ahmandi ,  Jayanta Das ,  Joshua Klahr ,  Boyung Lee ,  Wenye Li ,  Abdul Q. Munir ,  Yi Pan

IPC: G06F16/2453 ,  G06F16/2455 ,  G06F16/27

Abstract: A method includes generating, by at least one hardware processor, a query plan of a query. The query includes a JOIN operation between first time series data and second time series data. At least one node in the query plan corresponding to the JOIN operation is modified to generate a modified query plan. The modifying is based on replacing the at least one node with a new node including a UNION operation. The UNION operation is based on the first time series data and the second time series data. Execution of the query is scheduled based on the modified query plan.

公开(公告)号：US11836132B2

公开(公告)日：2023-12-05

申请号：US16851800

申请日：2020-04-17

Applicant: SNOWFLAKE INC.

Inventor： Benoit Dageville ,  Jiansheng Huang ,  Shige Takeda ,  Abdul Q. Munir

IPC: G06F16/2453 ,  G06F16/11 ,  G06F16/14 ,  G06F16/16 ,  G06F16/2455 ,  H04L67/06 ,  H04L67/1097

CPC classification number: G06F16/24539 ,  G06F16/125 ,  G06F16/156 ,  G06F16/162 ,  G06F16/2455

Abstract: A method, system, and apparatus for managing a persistent query result set are disclosed. A resource manager is disclosed that receives a query from a client over a computer network. A computer database server is disclosed that executes the query and generates a result set based on and in response to the received query. An execution platform is disclosed that divides the result set into a plurality of chunks, wherein each chunk comprises a portion of the generated result set. The resource manager adds metadata to each of the plurality of chunks. A first chunk of the plurality of chunks comprises metadata pointing to the plurality of chunks. The resource manager delivers at least the first chunk of the plurality of chunks to the client in response to the query. The execution platform offloads the remaining plurality of chunks to cloud storage in parallel.