18162710. QUERY VALIDATION AND PROCESSING IN DATA CLEAN ROOMS simplified abstract (Snowflake Inc.)

From WikiPatents
Jump to navigation Jump to search

QUERY VALIDATION AND PROCESSING IN DATA CLEAN ROOMS

Organization Name

Snowflake Inc.

Inventor(s)

Rachel Frances Blum of South Orange NJ (US)

Justin Langseth of Kailua HI (US)

Michael Earle Rainey of Kennewick WA (US)

QUERY VALIDATION AND PROCESSING IN DATA CLEAN ROOMS - A simplified explanation of the abstract

This abstract first appeared for US patent application 18162710 titled 'QUERY VALIDATION AND PROCESSING IN DATA CLEAN ROOMS

Simplified Explanation

The abstract describes a method for securely sharing data between a provider and a consumer in a database system. Here is a simplified explanation of the abstract:

  • The method involves creating a secure environment called a "clean room" in the provider's database account.
  • An application instance is installed in the consumer's account, which allows access to the clean room.
  • The provider shares their data with the clean room, making it accessible to the consumer through the application instance.
  • The provider also shares a query template with the consumer through the application instance.
  • The consumer generates a query based on the template, and the system validates it.
  • The query is executed, and the results are stored in the consumer's database account.

Potential applications of this technology:

  • Secure data sharing between different parties in a database system.
  • Collaborative data analysis where sensitive data needs to be protected.
  • Controlled access to specific data sets within a database.

Problems solved by this technology:

  • Ensuring data privacy and security when sharing sensitive information.
  • Allowing controlled access to specific data without exposing the entire database.
  • Enabling collaboration and analysis while maintaining data integrity.

Benefits of this technology:

  • Enhanced data security through the use of clean rooms and controlled access.
  • Efficient and streamlined data sharing process between providers and consumers.
  • Improved collaboration and analysis capabilities while protecting sensitive data.


Original Abstract Submitted

A method includes generating a defined access clean room in a provider database account, as well as installing, in a consumer account, an application instance that implements the defined access clean room. The method also includes sharing, by the provider database account, source provider data with the defined access clean room, where the sharing makes the source provider data accessible to the consumer database account via the application instance. The method further includes sharing, by the provider database account, a query template with the consumer database account via the application instance. Additionally, the method includes receiving a query generated by the consumer database account based on the query template, validating that the query is consistent with the query template, responsively generating query results by executing the query, as well as storing the query results in the consumer database account.