公开(公告)号：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.

公开(公告)号：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.

公开(公告)号：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.