Invention Grant
- Patent Title: Stream object type for query processing
-
Application No.: US18048912Application Date: 2022-10-24
-
Publication No.: US11860850B2Publication Date: 2024-01-02
- Inventor: Istvan Cseri , Tyler Jones , Daniel Mills , Daniel E. Sotolongo
- Applicant: Snowflake Inc.
- Applicant Address: US MT Bozeman
- Assignee: Snowflake Inc.
- Current Assignee: Snowflake Inc.
- Current Assignee Address: US MT Bozeman
- Agency: Schwegman Lundberg & Woessner, P.A.
- Main IPC: G06F16/23
- IPC: G06F16/23 ; G06F16/2455 ; G06F16/27 ; G06F16/22

Abstract:
Provided herein are systems and methods for a stream object configuration, including configuring and processing streams on views and streams on tables. For example, a method includes parsing, by at least one hardware processor, a received query to determine a plurality of data processing operations associated with a base table. A stream object on the base table is generated. The stream object includes a plurality of query results from executing the plurality of data processing operations and a corresponding plurality of time stamps of times the plurality of query results are obtained. A stream expansion of the stream object is performed. The stream expansion is based on computing changes to the base table from the plurality of data processing operations.
Public/Granted literature
- US20230092367A1 STREAM OBJECT TYPE FOR QUERY PROCESSING Public/Granted day:2023-03-23
Information query