-
公开(公告)号：US11620110B1
公开(公告)日：2023-04-04
申请号：US17834668
申请日：2022-06-07
Applicant: Snowflake Inc.
Inventor： Jianzhun Du , Orestis Kostakis , Kristopher Wagner , Yijun Xie
Abstract: The subject technology receives a set of files corresponding to a library, the library comprising a set of functions included in the set of files. The subject technology parses the set of files. The subject technology identifies a set of functions in the set of files based on the parsing. The subject technology, for each function, registers the function as a user defined function (UDF) based on a set of input parameters utilized by the function and a type of parameter of each of the input parameters. The subject technology provides access to each registered function in a different application.
-
公开(公告)号：US20250094403A1
公开(公告)日：2025-03-20
申请号：US18393279
申请日：2023-12-21
Applicant: Snowflake Inc.
Inventor： Srilakshmi Chintala , Jianzhun Du , Naresh Kumar , Srinath Shankar , Leonhard Franz Spiegelberg , Eric Shawn Vandendberg , Andong Zhan , Yun Zou
IPC: G06F16/22 , G06F16/11 , G06F16/242 , G06F16/2453
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.
-
公开(公告)号：US12277101B2
公开(公告)日：2025-04-15
申请号：US18393279
申请日：2023-12-21
Applicant: Snowflake Inc.
Inventor： Srilakshmi Chintala , Jianzhun Du , Naresh Kumar , Srinath Shankar , Leonhard Franz Spiegelberg , Eric Shawn Vandenberg , Andong Zhan , Yun Zou
IPC: G06F16/22 , G06F16/11 , G06F16/242 , G06F16/2453
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.
-
Patent Agency Ranking
公开(公告)号：US20230393816A1
公开(公告)日：2023-12-07
申请号：US18362114
申请日：2023-07-31
Applicant: Snowflake Inc.
Inventor： Jianzhun Du , Orestis Kostakis , Kristopher Wagner , Yijun Xie
Abstract: The subject technology identifies a set of functions included in a set of files corresponding to a library. The subject technology, for each function in the set of functions, registers the function as a user defined function (UDF). The subject technology generates a name for the function based at least in part on a predetermined prefix, wherein the predetermined prefix comprises an alphanumeric string. The subject technology generates, using at least a particular set of input parameters utilized by the function and a particular type of parameter of each input parameter of the particular set of input parameters, a particular set of source code. The subject technology stores information corresponding to the function in a metadata database. The subject technology provides access to the function in a different application.
-
公开(公告)号：US20250094418A1
公开(公告)日：2025-03-20
申请号：US18525811
申请日：2023-11-30
Applicant: Snowflake Inc.
Inventor： Srilakshmi Chintala , Jianzhun Du , Naresh Kumar , Jaeyun Noh , Srinath Shankar , Leonhard Franz Spiegelberg , Eric Shawn Vandenberg , Jiaqi Yan , Andong Zhan , Yun Zou
IPC: G06F16/2453
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.
-
公开(公告)号：US12216648B1
公开(公告)日：2025-02-04
申请号：US18393324
申请日：2023-12-21
Applicant: Snowflake Inc.
Inventor： Srilakshmi Chintala , Jianzhun Du , Naresh Kumar , Srinath Shankar , Leonhard Franz Spiegelberg , Eric Shawn Vandenberg , Andong Zhan , Yun Zou
IPC: G06F16/242 , G06F16/2453 , G06F16/25
Abstract: A method includes receiving instructions to perform order-dependent DataFrame operation on data. In response to receiving the instructions, the framework analyzes the instructions to identify the order-dependent DataFrame operation, and generates an executable query corresponding to the identified order-dependent DataFrame operation. The framework executes the generated executable query on the data stored in the first database in the cloud data platform, creates a row position column that generates for each row a unique integer identifier, reproducible across multiple sessions and/or queries for the same underlying data to make the data accessible via positional indexing, and assigns each row of the first database a unique row index value based on the row position column and the row position column order. The framework orders a result from performing the order-dependent DataFrame operation based on the unique row index value assigned to each row of the first database, and returns the ordered result to the user.
-
公开(公告)号：US12050890B2
公开(公告)日：2024-07-30
申请号：US18362114
申请日：2023-07-31
Applicant: Snowflake Inc.
Inventor： Jianzhun Du , Orestis Kostakis , Kristopher Wagner , Yijun Xie
Abstract: The subject technology identifies a set of functions included in a set of files corresponding to a library. The subject technology, for each function in the set of functions, registers the function as a user defined function (UDF). The subject technology generates a name for the function based at least in part on a predetermined prefix, wherein the predetermined prefix comprises an alphanumeric string. The subject technology generates, using at least a particular set of input parameters utilized by the function and a particular type of parameter of each input parameter of the particular set of input parameters, a particular set of source code. The subject technology stores information corresponding to the function in a metadata database. The subject technology provides access to the function in a different application.
-
公开(公告)号：US11755291B1
公开(公告)日：2023-09-12
申请号：US18104020
申请日：2023-01-31
Applicant: Snowflake Inc.
Inventor： Jianzhun Du , Orestis Kostakis , Kristopher Wagner , Yijun Xie
Abstract: The subject technology identifies a set of functions in a set of files corresponding to a library. The subject technology, for each function, registers the function as a user defined function (UDF) based on a set of input parameters utilized by the function and a type of parameter of each of the input parameters. The subject technology provides access to each registered function in a different application.
-
-
-
-
-
-
-
Search Results
8
records
(took 0.015 seconds)
