Invention Grant
- Patent Title: Updating of a denormalized database object after updating, deleting, or inserting a record in a source database object
-
Application No.: US16411107Application Date: 2019-05-13
-
Publication No.: US11216460B2Publication Date: 2022-01-04
- Inventor: Marla Hay , Yvonne Zhou , Yu Chen , Michael Allan Friedman , 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: Nicholson, De Vos, Webster & Elliott, LLP
- Main IPC: G06F16/00
- 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.
Information query