US 11,860,850 B2
Stream object type for query processing
Istvan Cseri, Seattle, WA (US); Tyler Jones, Redwood City, CA (US); Daniel Mills, Seattle, WA (US); and Daniel E. Sotolongo, Seattle, WA (US)
Assigned to Snowflake Inc., Bozeman, MT (US)
Filed by Snowflake Inc., Bozeman, MT (US)
Filed on Oct. 24, 2022, as Appl. No. 18/048,912.
Application 18/048,912 is a continuation of application No. 17/650,604, filed on Feb. 10, 2022, granted, now 11,514,023.
Application 17/650,604 is a continuation of application No. 17/460,974, filed on Aug. 30, 2021, granted, now 11,301,451.
Prior Publication US 2023/0092367 A1, Mar. 23, 2023
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/23 (2019.01); G06F 16/2455 (2019.01); G06F 16/27 (2019.01); G06F 16/22 (2019.01)
CPC G06F 16/2358 (2019.01) [G06F 16/2282 (2019.01); G06F 16/2456 (2019.01); G06F 16/24568 (2019.01); G06F 16/278 (2019.01)] 30 Claims
OG exemplary drawing
 
1. A system comprising:
at least one hardware processor; and
at least one memory storing instructions that cause the at least one hardware processor to perform operations comprising:
parsing a received query to determine a plurality of data processing operations associated with a base table;
generating a first stream object on the base table, the first stream object including a plurality of query results from executing the plurality of data processing operations on the base table and a corresponding plurality of time stamps of times the plurality of query results are obtained; and
performing a stream expansion of the first stream object, the stream expansion based on computing changes to the base table from the plurality of data processing operations and replacing the first stream object with a new data processing operation on the computed changes.