Invention Grant
- Patent Title: Managing persistent database result sets
-
Application No.: US15097107Application Date: 2016-04-12
-
Publication No.: US10671605B2Publication Date: 2020-06-02
- Inventor: Benoit Dageville , Jiansheng Huang , Shige Takeda , Abdul Q. Munir
- Applicant: SNOWFLAKE INC.
- Applicant Address: US CA San Mateo
- Assignee: Snowflake Inc.
- Current Assignee: Snowflake Inc.
- Current Assignee Address: US CA San Mateo
- Agency: Womble Bond Dickinson (US) LLP
- Agent Daniel E. Ovanezian
- Main IPC: G06F16/2453
- 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.
Public/Granted literature
- US20170293626A1 MANAGING PERSISTENT DATABASE RESULT SETS Public/Granted day:2017-10-12
Information query