公开(公告)号：US20240370461A1

公开(公告)日：2024-11-07

申请号：US18772913

申请日：2024-07-15

Applicant: Snowflake Inc.

Inventor： Balachander Atur ,  Hazem Elmeleegy ,  Jung Lin Lee ,  Aditya G. Parameswaran ,  Devin Petersohn ,  Mahesh Shankar Vashishtha

IPC: G06F16/28 ,  G06F9/54 ,  G06F16/21 ,  G06F16/2452 ,  G06F16/248

Abstract: Systems and methods for providing access to information in a relational database via API-operations for dataframes, are disclosed. Exemplary implementations may: store information that represents an input dataframe; generate a first relation that represents the input dataframe, the first relation having a first schema; obtain a dataframe query to be performed on the input dataframe; translate the dataframe query into a sequence of relational database operations; perform the sequence of relational database operations on the first relation to generate a second relation; and present at least a portion of the second relation to a user, and/or perform other steps.

公开(公告)号：US12056100B1

公开(公告)日：2024-08-06

申请号：US18189837

申请日：2023-03-24

Applicant: Snowflake Inc.

Inventor： Balachandran Atur ,  Hazem Elmeleegy ,  Jung Lin Lee ,  Aditya G Parameswaran ,  Devin Petersohn ,  Mahesh Shankar Vashishtha

IPC: G06F16/21 ,  G06F16/28

CPC classification number: G06F16/213 ,  G06F16/283

Abstract: Systems and methods for converting dataframes to relational databases and/or vice versa, are disclosed. Exemplary implementations may: store information that represents a first dataframe; generate a first relation that represents the first dataframe, the first relation having a first schema; add a first ordering attribute to the set of attributes of the first relation; populate the first ordering attribute with numbers in accordance with a row numbering of the first dataframe; perform a relational database operation on the first relation that modifies the first relation into a second relation; create a second dataframe based on the second relation such that the row labels and the order of the rows are preserved for the (remaining) records and attributes of the second relation; and/or perform other steps.

公开(公告)号：US20240345998A1

公开(公告)日：2024-10-17

申请号：US18757144

申请日：2024-06-27

Applicant: Snowflake Inc.

Inventor： Balachander Atur ,  Hazem Elmeleegy ,  Jung Lin Lee ,  Aditya G. Parameswaran ,  Devin Petersohn ,  Mahesh Shankar Vashishtha

IPC: G06F16/21 ,  G06F16/28

CPC classification number: G06F16/213 ,  G06F16/283

Abstract: Systems and methods for converting dataframes to relational databases and/or vice versa, are disclosed. Exemplary implementations may: store information that represents a first dataframe; generate a first relation that represents the first dataframe, the first relation having a first schema; add a first ordering attribute to the set of attributes of the first relation; populate the first ordering attribute with numbers in accordance with a row numbering of the first dataframe; perform a relational database operation on the first relation that modifies the first relation into a second relation; create a second dataframe based on the second relation such that the row labels and the order of the rows are preserved for the (remaining) records and attributes of the second relation; and/or perform other steps.

公开(公告)号：US12072911B1

公开(公告)日：2024-08-27

申请号：US18192360

申请日：2023-03-29

Applicant: Snowflake Inc.

Inventor： Balachandran Atur ,  Hazem Elmeleegy ,  Jung Lin Lee ,  Aditya G Parameswaran ,  Devin Petersohn ,  Mahesh Shankar Vashishtha

IPC: G06F16/00 ,  G06F16/21 ,  G06F16/2452 ,  G06F16/248 ,  G06F16/28 ,  G06F9/54

CPC classification number: G06F16/283 ,  G06F16/212 ,  G06F16/2452 ,  G06F16/248 ,  G06F9/54

Abstract: Systems and methods for providing access to information in a relational database via API-operations for dataframes, are disclosed. Exemplary implementations may: store information that represents an input dataframe; generate a first relation that represents the input dataframe, the first relation having a first schema; obtain a dataframe query to be performed on the input dataframe; translate the dataframe query into a sequence of relational database operations; perform the sequence of relational database operations on the first relation to generate a second relation; and present at least a portion of the second relation to a user, and/or perform other steps.