Snowflake Inc. patent applications on March 20th, 2025
Patent Applications by Snowflake Inc. on March 20th, 2025
Snowflake Inc.: 2 patent applications
Snowflake Inc. has applied for patents in the areas of G06F16/2453 (2), G06F16/22 (1), G06F16/11 (1), G06F16/242 (1) G06F16/2272 (1), G06F16/24534 (1)
With keywords such as: pivot, column, row, query, values, dynamic, sql, engine, framework, and keyword in patent application abstracts.
Patent Applications by Snowflake Inc.
20250094403. DATAFRAME WORKLOADS USING READ-ONLY DATA SNAPSHOTS_simplified_abstract_(snowflake inc.)
Inventor(s): Srilakshmi Chintala of Seattle WA US for snowflake inc., Jianzhun Du of Kirkland WA US for snowflake inc., Naresh Kumar of Santa Clara CA US for snowflake inc., Srinath Shankar of Belmont CA US for snowflake inc., Leonhard Franz Spiegelberg of San Francisco CA US for snowflake inc., Eric Shawn Vandendberg of Saratoga CA US for snowflake inc., Andong Zhan of San Mateo CA US for snowflake inc., Yun Zou of Sunnyvale CA US for snowflake inc.
IPC Code(s): G06F16/22, G06F16/11, G06F16/242, G06F16/2453
CPC Code(s): G06F16/2272
Abstract: a method provides deterministic row ordering for query result sets in a database system. a framework receives a query referencing a database table and generating a row index column in response. the framework generates the row index column that involves determining an order associated with source files underlying the referenced table and assigns each table row a unique index value based on the file order and row position within the files. the framework executes the received query to produce a result set ordered by the generated row index column. the framework determines row order based on analyzing underlying data file metadata and facilitates returning the result set with consistent, reliable ordering, enabling stable positional-based access semantics when querying distributed database tables.
Inventor(s): Srilakshmi Chintala of Seattle WA US for snowflake inc., Jianzhun Du of Kirkland WA US for snowflake inc., Naresh Kumar of Santa Clara CA US for snowflake inc., Jaeyun Noh of Sunnyvale CA US for snowflake inc., Srinath Shankar of Belmont CA US for snowflake inc., Leonhard Franz Spiegelberg of San Francisco CA US for snowflake inc., Eric Shawn Vandenberg of Saratoga CA US for snowflake inc., Jiaqi Yan of Menlo Park CA US for snowflake inc., Andong Zhan of San Mateo CA US for snowflake inc., Yun Zou of Sunnyvale CA US for snowflake inc.
IPC Code(s): G06F16/2453
CPC Code(s): G06F16/24534
Abstract: examples provide a method for performing dynamic pivot queries employing panda-compatible semantics inside a cloud data platform workload. a sql engine receives a pivot query specifying a pivot column for dynamically determining pivot values in a dynamic pivot operation. the sql engine identifies, in the pivot query, a keyword or a subquery indicating dynamic determination of the pivot values. based on identifying the keyword or the subquery indicating the dynamic determination of the pivot values, the sql engine determines distinct pivot values for the pivot column by evaluating the keyword or executing the subquery. the evaluating of the keyword includes issuing a query to a data store to obtain the distinct pivot values for the pivot column. the sql engine performs the dynamic pivot operation using the distinct pivot values for the pivot column.