The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
May. 27, 2025
Filed:
Jan. 31, 2024
Snowflake Inc., Bozeman, MT (US);
Khalid Zaman Bijon, Santa Cruz, CA (US);
Thierry Cruanes, San Mateo, CA (US);
Simon Holm Jensen, Menlo Park, CA (US);
Allison Waingold Lee, Pebble Beach, CA (US);
Daniel N. Meredith, Laguna Beach, CA (US);
Subramanian Muralidhar, Mercer Island, WA (US);
David Schultz, Piedmont, CA (US);
Zixi Zhang, San Mateo, CA (US);
Snowflake Inc., Bozeman, MT (US);
Abstract
A database system facilitates secure data sharing by implementing projection constraints within a query processing framework. Upon receiving a query directed to a shared dataset, the system, utilizing hardware processors, identifies a subset of data within the dataset that is subject to a projection constraint policy. The applicability of the projection constraint is determined based on the context of the query, which is derived from a data sharing agreement. The system processes the query by selectively restricting the projection of data values from constrained columns, while allowing specific operations to be performed on the data. The output generated in response to the query is compliant with the projection constraint policy, providing derived data based on the allowed operations without revealing the actual data values. This ensures the confidentiality of sensitive information while enabling collaborative data analysis and sharing among various users of the database system.