Invention Grant
- Patent Title: Query plans for analytic SQL constructs
-
Application No.: US17972003Application Date: 2022-10-24
-
Publication No.: US12079244B2Publication Date: 2024-09-03
- Inventor: Thierry Cruanes , Benoit Dageville , Allison Waingold Lee
- Applicant: SNOWFLAKE INC.
- Applicant Address: US MT Bozeman
- Assignee: Snowflake Inc.
- Current Assignee: Snowflake Inc.
- Current Assignee Address: US MT Bozeman
- Agency: Womble Bond Dickinson (US) LLP
- Main IPC: G06F15/16
- IPC: G06F15/16 ; A61F5/56 ; G06F9/48 ; G06F9/50 ; G06F16/14 ; G06F16/182 ; G06F16/21 ; G06F16/22 ; G06F16/23 ; G06F16/2453 ; G06F16/2455 ; G06F16/2458 ; G06F16/25 ; G06F16/27 ; G06F16/28 ; G06F16/951 ; G06F16/9535 ; G06F16/9538 ; H04L67/1095 ; H04L67/1097 ; H04L67/568

Abstract:
A system and method for managing data storage and data access with querying data in a distributed system without buffering the results of intermediate operations in persistent storage. The method includes pushing, by a first operator, as a result of executing a query plan, an intermediate result to a plurality of secondary operators. Processing of the intermediate result by the plurality of secondary operators is delayed to coordinate generation of a plurality of second results based on beginning a final consumption operation of the plurality of second results.
Public/Granted literature
- US20230042949A1 QUERY PLANS FOR ANALYTIC SQL CONSTRUCTS Public/Granted day:2023-02-09
Information query