公开(公告)号：US20200097680A1

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

申请号：US16139619

申请日：2018-09-24

Applicant: Salesforce.com, inc.

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

IPC: G06F21/62 ,  G06F17/30 ,  H04L29/06

Abstract: An indication of an action is received through and application program interface (API) provided by one or more hardware processing devices. The action corresponds to communication with a specified party. Multiple disparate tables stored in at least one database of a of a database environment associated with the one or more hardware processing devices are searched for records having the field property corresponding to the specified party. The field property from the corresponding multiple disparate tables are evaluated. A unified field property is determined based on the evaluation of the field property from the corresponding multiple disparate tables. The unified field property is returned through the 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.

公开(公告)号：US20180189349A1

公开(公告)日：2018-07-05

申请号：US15396291

申请日：2016-12-30

Applicant: salesforce.com, inc.

Inventor： Arjun Kumar Sirohi ,  Vikas Taneja ,  Kim Phillip Lichong ,  Michael Allan Friedman ,  Vidushi Sharma

IPC: G06F17/30

CPC classification number: G06F16/24539

Abstract: Predictive execution of query flows in an application aware database environment. A repository of previously received and registered database queries along with at least corresponding metadata having information about database query flows generating the database queries is maintained. Application metadata corresponding to a subsequent database query is received. The repository is checked to determine if the application metadata matches one of the previously received and registered database query flows. One or more queries corresponding to the query flow from the repository is/are retrieved if a match is determined. Execution of the retrieved one or more database queries is started prior to receiving the query from outside the repository.

公开(公告)号：US11270009B2

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

申请号：US16449261

申请日：2019-06-21

Applicant: salesforce.com, inc.

Inventor： Michael Allan Friedman

IPC: G06F21/60 ,  G06F21/71

Abstract: Methods and systems for using consent policies to determine whether to proceed with actions relative to persons based on a hierarchy of consent values for that person are described. Responsive to a query, records are retrieved which pertain to a person's consent for another entity to perform an action relative to the person in view of data privacy laws. A consent policy is selected. The selected consent policy includes rules that are configurable to reflect a manner to comply with data privacy laws. The selected consent policy is applied to the records. Applying the selected consent policy comprises applying rules to find a result for a second level of the hierarchy of consent values, determining a result for a first level of the hierarchy of consent values, and applying rules to determine whether to proceed with the action relative to the person.

公开(公告)号：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.

公开(公告)号：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.

公开(公告)号：US11249995B2

公开(公告)日：2022-02-15

申请号：US15396291

申请日：2016-12-30

Applicant: salesforce.com, inc.

Inventor： Arjun Kumar Sirohi ,  Vikas Taneja ,  Kim Lichong ,  Michael Allan Friedman ,  Vidushi Sharma

IPC: G06F16/2453

Abstract: Predictive execution of query flows in an application aware database environment. A repository of previously received and registered database queries along with at least corresponding metadata having information about database query flows generating the database queries is maintained. Application metadata corresponding to a subsequent database query is received. The repository is checked to determine if the application metadata matches one of the previously received and registered database query flows. One or more queries corresponding to the query flow from the repository is/are retrieved if a match is determined. Execution of the retrieved one or more database queries is started prior to receiving the query from outside the repository.

公开(公告)号：US11227069B2

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

申请号：US16139619

申请日：2018-09-24

Applicant: salesforce.com, inc.

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

IPC: G06F21/62 ,  H04L29/06 ,  G06F16/9535

Abstract: An indication of an action is received through and application program interface (API) provided by one or more hardware processing devices. The action corresponds to communication with a specified party. Multiple disparate tables stored in at least one database of a of a database environment associated with the one or more hardware processing devices are searched for records having the field property corresponding to the specified party. The field property from the corresponding multiple disparate tables are evaluated. A unified field property is determined based on the evaluation of the field property from the corresponding multiple disparate tables. The unified field property is returned through the API.

公开(公告)号：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.

公开(公告)号：US10936587B2

公开(公告)日：2021-03-02

申请号：US15396287

申请日：2016-12-30

Applicant: salesforce.com, inc.

Inventor： Arjun Kumar Sirohi ,  Vikas Taneja ,  Kim Lichong ,  Michael Allan Friedman ,  Vidushi Sharma

IPC: G06F16/30 ,  G06F16/2453

Abstract: Application-aware database environments. A repository of previously received and registered database queries is maintained that includes at least corresponding metadata having information about an application generating the database queries. A subsequent database query and application metadata corresponding to the subsequent database query can be received. The repository to determine if the subsequent database query and application metadata match one of the previously received database queries and application metadata. A matching previously received database query is retrieved from the repository if a match is determined. The retrieved database query is executed.