公开(公告)号：US20210149874A1

公开(公告)日：2021-05-20

申请号：US16777858

申请日：2020-01-30

Applicant: salesforce.com, inc.

Inventor： Marla Hay ,  Yvonne Zhou ,  Yu Chen ,  Shivan Kaul Sahib

IPC: G06F16/23 ,  G06Q10/10

Abstract: Implementations retrieve a first event that published to a first source of events responsive to updating, deleting, or inserting a first record in a database object that stores records relating to consent. The first event is processed. Processing the first event includes storing in an attribute of a second event an identifier for a second record that relates to the first record and that is in a second database object that stores records relating to consent. If the first record was inserted or updated, processing the first event includes storing in an attribute of the second event one or more identifiers and respective values of fields of the first record based on attributes of the first event.

公开(公告)号：US20200097574A1

公开(公告)日：2020-03-26

申请号：US16140428

申请日：2018-09-24

Applicant: salesforce.com, inc.

Inventor： Marla Hay ,  Yu Chen ,  Michael Allan Friedman ,  Yvonne Zhou ,  Shivan Kaul Sahib

IPC: G06F17/30 ,  G06F21/62

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.

公开(公告)号：US11216435B2

公开(公告)日：2022-01-04

申请号：US16140428

申请日：2018-09-24

Applicant: salesforce.com, inc.

Inventor： Marla Hay ,  Yu Chen ,  Michael Allan Friedman ,  Yvonne Zhou ,  Shivan Kaul Sahib

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.

公开(公告)号：US20210232700A1

公开(公告)日：2021-07-29

申请号：US16752506

申请日：2020-01-24

Applicant: salesforce.com, inc.

Inventor： Shivan Kaul Sahib ,  Marla Hay ,  Yvonne Zhou ,  Yu Chen

IPC: G06F21/62 ,  G06F16/2455

Abstract: Described are methods and systems for using policies to comply with a person's request for data pertaining to the person, pursuant to applicable data privacy laws. A policy is retrieved responsive to receiving a query that includes data to identify records that store data pertaining to the person. The policy indicates first and second database objects, and respective first and second sets of fields, which store data that pertains to persons. The policy is applied. Applying the policy includes retrieving, as first values, data stored in the first set of fields of a first record associated with the data in the query, and retrieving, as second values, data stored in the second set of fields of a second record associated with the first record. The first and second values, and the names of the fields from which they were retrieved, are stored in a document.

公开(公告)号：US20220083551A1

公开(公告)日：2022-03-17

申请号：US17534425

申请日：2021-11-23

Applicant: salesforce.com, inc.

Inventor： Marla Hay ,  Yvonne Zhou ,  Yu Chen ,  Michael Allan Friedman ,  Shivan Kaul Sahib

IPC: G06F16/2453 ,  G06F16/2455 ,  G06F16/23

Abstract: Methods and apparatus for updating a denormalized database object after updating, deleting, or inserting a record in a source database object are described. A first operation on a source database object that involves a record of the source database object being updated, deleted, or inserted is performed. A first part of a corresponding second operation involving a respective record of the denormalized database object being updated, deleted, or inserted is performed. A query result that references an aggregate field of a set of records in the denormalized database object is altered. The altering includes an aggregation operation using values in the query result being performed and altering that part of the query result that includes the aggregate field of the set of records. A second part is optionally performed to complete the corresponding second operation and update the denormalized database object.

公开(公告)号：US11216460B2

公开(公告)日：2022-01-04

申请号：US16411107

申请日：2019-05-13

Applicant: salesforce.com, inc.

Inventor： Marla Hay ,  Yvonne Zhou ,  Yu Chen ,  Michael Allan Friedman ,  Shivan Kaul Sahib

IPC: G06F16/00 ,  G06F16/2453 ,  G06F16/2455 ,  G06F16/23

Abstract: Methods and apparatus for updating a denormalized database object after updating, deleting, or inserting a record in a source database object are described. A first operation on a source database object that involves a record of the source database object being updated, deleted, or inserted is performed. A first part of a corresponding second operation involving a respective record of the denormalized database object being updated, deleted, or inserted is performed. A query result that references an aggregate field of a set of records in the denormalized database object is altered. The altering includes an aggregation operation using values in the query result being performed and altering that part of the query result that includes the aggregate field of the set of records. A second part is optionally performed to complete the corresponding second operation and update the denormalized database object.

公开(公告)号：US10783259B2

公开(公告)日：2020-09-22

申请号：US16051403

申请日：2018-07-31

Applicant: salesforce.com, inc.

Inventor： William C. Eidson ,  David Hacker ,  Yu Chen ,  Michael Goldberg Boilen ,  Shakti Prakash Das

IPC: G06F21/62 ,  G06F21/60 ,  H04L29/06 ,  G06F9/54 ,  H04L9/08 ,  G06F11/30 ,  G06F11/34 ,  H04L9/32 ,  H04L9/14 ,  H04L29/08

Abstract: A method and apparatus for tokenization of user-traceable data are described. User traceable data is data that is not directly personal data but can be traced back to the identity or an activity of the user. A first raw value is encrypted into a first token using a symmetric key encryption mechanism based on a combination of a second raw value including personal data of a user and a second token resulting from the tokenization of the second raw value where the first token is an anonymized representation of the first raw value.

公开(公告)号：US10740475B2

公开(公告)日：2020-08-11

申请号：US16051414

申请日：2018-07-31

Applicant: salesforce.com, inc.

Inventor： William C. Eidson ,  David Hacker ,  Yu Chen ,  Hui Fung Herman Kwong ,  Wolfgang Krause

IPC: G06F21/60 ,  H04L29/06 ,  H04L9/32 ,  G06F21/62 ,  G06F9/54 ,  H04L9/08 ,  G06F11/30 ,  G06F11/34 ,  H04L9/14 ,  H04L29/08

Abstract: A method and a system for enabling multiple log record consumers to comply with regulations and requirements regarding privacy and handling of data are described. A determination, based on a log record format being of a first of the log record types, that a first field from a raw log record is to be tokenized based on a first tokenization strategy of multiple tokenization strategies in the first log record type, is performed. Each one of the tokenization strategies identifies a tokenization mechanism from tokenization mechanisms for generating a token from a raw value to enable compliance with a set of regulations and requirements regarding privacy and the handling of data. For a first raw value in the first field a first token is generated that is an anonymized representation of the first raw value using a tokenization mechanism identified by the first tokenization strategy in the log record type.