Invention Grant
- Patent Title: Techniques and architectures for managing privacy information and permissions queries across disparate database tables
-
Application No.: US16140428Application Date: 2018-09-24
-
Publication No.: US11216435B2Publication Date: 2022-01-04
- Inventor: Marla Hay , Yu Chen , Michael Allan Friedman , Yvonne Zhou , Shivan Kaul Sahib
- Applicant: salesforce.com, inc.
- Applicant Address: US CA San Francisco
- Assignee: salesforce.com, inc.
- Current Assignee: salesforce.com, inc.
- Current Assignee Address: US CA San Francisco
- Agency: Kwan & Olynick LLP
- Main IPC: G06F16/22
- IPC: G06F16/22 ; G06F21/62 ; G06F16/248 ; G06F16/2455

Abstract:
At least one database table of denormalized values corresponding to selected values of field properties in records across multiple disparate tables of the database environment is maintained. A structured query is received through a structured query language application program interface (API). The structured query to request a listing of records across the multiple disparate tables of the database environment. The database table is searched for indications corresponding to records across the multiple disparate tables of the database environment corresponding to the selected values indicating communication with a specified party. A listing of records from across the multiple disparate tables that satisfy the selected values is returned through the structured query language API.
Public/Granted literature
Information query