-
公开(公告)号:US20220035949A1
公开(公告)日:2022-02-03
申请号:US17160924
申请日:2021-01-28
Applicant: Snowflake Inc.
Inventor: Rachel Frances Blum , Joshua James Chacona , Christian Kleinerman , Justin Langseth , William L. Stratton, JR.
IPC: G06F21/62 , G06F16/22 , G06F16/2455
Abstract: Embodiments of the present disclosure may provide a data clean room allowing secure data analysis across multiple accounts, without the use of third parties. Each account may be associated with a different company or party. The data clean room may provide security functions to safeguard sensitive information. For example, the data clean room may restrict access to data in other accounts. The data clean room may also restrict which data may be used in the analysis and may restrict the output. The overlap data may be anonymized to prevent sensitive information from being revealed.
-
公开(公告)号: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.
-
公开(公告)号:US11809600B2
公开(公告)日:2023-11-07
申请号:US18104281
申请日:2023-01-31
Applicant: Snowflake Inc.
Inventor: Rachel Frances Blum , Joshua James Chacona , Christian Kleinerman , Justin Langseth , William L. Stratton, Jr.
IPC: G06F21/62 , G06F16/22 , G06F16/2455
CPC classification number: G06F21/6254 , G06F16/2282 , G06F16/2455 , G06F21/6263
Abstract: Embodiments of the present disclosure may provide a data clean room allowing secure data analysis across multiple accounts, without the use of third parties. Each account may be associated with a different company or party. The data clean room may provide security functions to safeguard sensitive information. For example, the data clean room may restrict access to data in other accounts. The data clean room may also restrict which data may be used in the analysis and may restrict the output. The overlap data may be anonymized to prevent sensitive information from being revealed.
-
公开(公告)号: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.
-
公开(公告)号:US10970419B1
公开(公告)日:2021-04-06
申请号:US16944929
申请日:2020-07-31
Applicant: Snowflake Inc.
Inventor: Rachel Frances Blum , Joshua James Chacona , Christian Kleinerman , Justin Langseth , William L. Stratton, Jr.
IPC: G06F21/62 , G06F16/2455 , G06F16/22
Abstract: Embodiments of the present disclosure may provide a data clean room allowing secure data analysis across multiple accounts, without the use of third parties. Each account may be associated with a different company or party. The data clean room may provide security functions to safeguard sensitive information. For example, the data clean room may restrict access to data in other accounts. The data clean room may also restrict which data may be used in the analysis and may restrict the output. The overlap data may be anonymized to prevent sensitive information from being revealed.
-
公开(公告)号:US20250013648A1
公开(公告)日:2025-01-09
申请号:US18892783
申请日:2024-09-23
Applicant: Snowflake Inc.
Inventor: Rachel Frances Blum , Justin Langseth , Michael Earle Rainey
IPC: G06F16/2455 , G06F16/242 , G06F16/27 , G06F21/62
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.
-
公开(公告)号:US20240168958A1
公开(公告)日:2024-05-23
申请号:US18425312
申请日:2024-01-29
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.
-
-
-
-
-
-
-
-
-