公开(公告)号：US20240362231A1

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

申请号：US18764977

申请日：2024-07-05

Applicant: Snowflake Inc.

Inventor： Rachel Frances Blum ,  Justin Langseth ,  Michael Earle Rainey

IPC: G06F16/2455 ,  G06F16/242 ,  G06F16/27 ,  G06F21/62

CPC classification number: G06F16/24565 ,  G06F16/2443 ,  G06F16/27 ,  G06F21/6227

Abstract: Embodiments of the present disclosure may provide a data clean room architecture that dynamically restricts data included in the clean room. The data clean room architecture can implement row access policy or dynamic data masking for row and column based restrictions of data provided through the clean room. The data clean room architecture can provide a limited set of data that does not require obfuscation of data for direction matching and correlation of data in the different datasets, such as matching user identifiers or emails.

公开(公告)号：US20230169203A1

公开(公告)日：2023-06-01

申请号：US18162709

申请日：2023-01-31

Applicant: Snowflake Inc.

Inventor： Justin Langseth ,  Michael Earle Rainey ,  William L. Stratton, JR.

IPC: G06F21/62 ,  H04L9/40 ,  G06F16/9535 ,  G06F16/27

CPC classification number: G06F21/6227 ,  H04L63/0421 ,  G06F16/9535 ,  G06F16/27 ,  H04L9/0643

Abstract: Embodiments of the present disclosure may provide a data clean room allowing encryption based data analysis across multiple accounts, including different provider database user accounts that provide user data and a network service and a requesting user that generates one or more clean room requests. The data clean room may also restrict which data may be used in the analysis and may restrict the output.

公开(公告)号：US11620409B2

公开(公告)日：2023-04-04

申请号：US17932610

申请日：2022-09-15

Applicant: Snowflake Inc.

Inventor： Rachel Frances Blum ,  Justin Langseth ,  Michael Earle Rainey

IPC: G06F21/00 ,  G06F21/62 ,  G06F16/245 ,  G06F16/27

Abstract: Disclosed herein are methods and systems for secure data comparison using data clean rooms. In an embodiment, a computer system generates a replica database based on a provider database, which stores a cross reference table that cross references a client dataset of a client database and a provider dataset of the provider database. The system receives, at the replica database, a table that is generated by the client database using the cross-reference table. The system transmits, from the replica database, the table to the provider database. The system receives, at the replica database, a results dataset that is generated by the provider database by applying a database statement to the provider database using the table generated by the client database. The system shares, from the replica database, the results dataset with the client database.

公开(公告)号：US20240362206A1

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

申请号：US18765585

申请日：2024-07-08

Applicant: Snowflake Inc.

Inventor： Rachel Frances Blum ,  Justin Langseth ,  Michael Earle Rainey

IPC: G06F16/242 ,  G06F16/2455 ,  G06F16/27

CPC classification number: G06F16/242 ,  G06F16/2456 ,  G06F16/27

Abstract: Embodiments of the present disclosure may provide a data sharing system implemented as a local application of a distributed database. A query from a query template can be validated and executed against shared dataset that comprises portions of data from the database dataset and additional portions of data from another database of the distributed database.

公开(公告)号：US12067005B2

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

申请号：US17816420

申请日：2022-07-31

Applicant: Snowflake Inc.

Inventor： Rachel Frances Blum ,  Justin Langseth ,  Michael Earle Rainey

IPC: G06F16/30 ,  G06F16/242 ,  G06F16/2455 ,  G06F16/27

CPC classification number: G06F16/242 ,  G06F16/2456 ,  G06F16/27

Abstract: Embodiments of the present disclosure may provide a data sharing system implemented as a local application of a distributed database. A query from a query template can be validated and executed against shared dataset that comprises portions of data from the database dataset and additional portions of data from another database of the distributed database.

公开(公告)号：US11928115B2

公开(公告)日：2024-03-12

申请号：US18161541

申请日：2023-01-30

Applicant: Snowflake Inc.

Inventor： Rachel Frances Blum ,  Justin Langseth ,  Michael Earle Rainey

IPC: G06F16/2455 ,  G06F16/242 ,  G06F16/27 ,  G06F21/62

CPC classification number: G06F16/24565 ,  G06F16/2443 ,  G06F16/27 ,  G06F21/6227

Abstract: Disclosed herein are systems and methods for query processing with restrictions in a database clean room. In an embodiment, a system receives a query directed to a combination of a first source dataset from a first database account of a distributed database and a second source dataset from a second database account of the distributed database. The system generates an approved statements table that contains database statement language that can be executed against the combination of the first and second source datasets. Based on determining that the approved statements table includes the query, the system executes the query to produce results data, and stores the results data in the first database account.

公开(公告)号：US20230169213A1

公开(公告)日：2023-06-01

申请号：US18162701

申请日：2023-01-31

Applicant: Snowflake Inc.

Inventor： Rachel Frances Blum ,  Justin Langseth ,  Michael Earle Rainey

IPC: G06F21/62 ,  G06F16/245 ,  G06F16/27

CPC classification number: G06F21/6254 ,  G06F16/245 ,  G06F16/27

Abstract: A distributed database generates a cross reference table that cross references a first dataset from a first database account and a second dataset from a second account. The distributed database receives a query directed to a combination of the first and second datasets, and generates an interim table in the first database account by applying the query to the cross reference table and the first dataset. The distributed database generates results data in the second database account by applying the query to the interim table and the second dataset, and stores the results data in the first database account.

公开(公告)号：US20230011376A1

公开(公告)日：2023-01-12

申请号：US17932610

申请日：2022-09-15

Applicant: Snowflake Inc.

Inventor： Rachel Frances Blum ,  Justin Langseth ,  Michael Earle Rainey

IPC: G06F21/62 ,  G06F16/27 ,  G06F16/245

Abstract: Disclosed herein are methods and systems for secure data comparison using data clean rooms. In an embodiment, a computer system generates a replica database based on a provider database, which stores a cross reference table that cross references a client dataset of a client database and a provider dataset of the provider database. The system receives, at the replica database, a table that is generated by the client database using the cross-reference table. The system transmits, from the replica database, the table to the provider database. The system receives, at the replica database, a results dataset that is generated by the provider database by applying a database statement to the provider database using the table generated by the client database. The system shares, from the replica database, the results dataset with the client database.

公开(公告)号：US20230004670A1

公开(公告)日：2023-01-05

申请号：US17664135

申请日：2022-05-19

Applicant: Snowflake Inc.

Inventor： Justin Langseth ,  Michael Earle Rainey ,  William L. Stratton, JR.

IPC: G06F21/62 ,  G06F16/9535 ,  G06F16/27 ,  H04L9/40

Abstract: Embodiments of the present disclosure may provide a data clean room allowing encryption based data analysis across multiple accounts, including different provider database user accounts that provide user data and a network service and a requesting user that generates one or more clean room requests. The data clean room may also restrict which data may be used in the analysis and may restrict the output.

公开(公告)号：US20240346017A1

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

申请号：US18643760

申请日：2024-04-23

Applicant: Snowflake Inc.

Inventor： Rachel Frances Blum ,  Justin Langseth ,  Michael Earle Rainey

IPC: G06F16/242 ,  G06F16/2455 ,  G06F16/27

CPC classification number: G06F16/242 ,  G06F16/2456 ,  G06F16/27

Abstract: Embodiments of the present disclosure may provide a data sharing system implemented as a local application of a distributed database. A query from a query template can be validated and executed against shared dataset that comprises portions of data from the database dataset and additional portions of data from another database of the distributed database.