Invention Application
- Patent Title: DATA OVERLAP COUNT ADJUSTMENT IN A MULTIPLE TENANT DATABASE SYSTEM
-
Application No.: US17847681Application Date: 2022-06-23
-
Publication No.: US20220327232A1Publication Date: 2022-10-13
- Inventor: Justin Langseth , Matthew J. Glickman , Christian Kleinerman , Robert Muglia , Daniel Freundel , Thierry Cruanes , Allison Waingold Lee
- Applicant: SNOWFLAKE INC.
- Applicant Address: US MT Bozeman
- Assignee: SNOWFLAKE INC.
- Current Assignee: SNOWFLAKE INC.
- Current Assignee Address: US MT Bozeman
- Main IPC: G06F21/62
- IPC: G06F21/62 ; G06F16/2455 ; H04L9/32

Abstract:
Systems, methods, and devices for generating a secure join of database data are disclosed. A method creates a secure view of datapoints of a consumer account and processes, using a secure user defined function (UDF), the datapoints of the consumer account and datapoints of a provider account to generate a secure join key. The datapoints of the consumer account are provided to the secure UDF using the secure view. The method further performs, by a processor, an analysis of the datapoints of the consumer account and the datapoints of the provider account of the secure join key. The analysis returns a count value of overlapping datapoints between the consumer account and the provider account. The method further adjusts the count value of overlapping datapoints based on a number of distinct rows associated with the provider account, and provides the adjusted count value of overlapping datapoints to the consumer account.
Public/Granted literature
- US11461493B1 Data overlap count adjustment in a multiple tenant database system Public/Granted day:2022-10-04
Information query