Data object aggregation to manage an order summary

Patent metadata

Field	Value
Publication number	US-11301483-B2
Application number	US-201916599060-A
Country	US
Kind code	B2
Filing date	Oct 10, 2019
Priority date	Oct 10, 2019
Publication date	Apr 12, 2022
Grant date	Apr 12, 2022

Abstract

Methods, systems, and devices supporting data storage are described. A database system may store order information for an organization. This order information may span multiple steps of an order lifecycle, including order creation, order changes, order fulfillment, etc. To efficiently store order information for low-latency querying and data consistency, the database system may implement order summaries. For example, a database server may receive a new order data object associated with an order identifier and may create a corresponding order summary data object. If the database system receives any additional data objects associated with the same order identifier, the database server may update the order summary data object based on the additional data objects. If the database system receives a query for information related to the order, the system may retrieve queried values directly from the order summary data object, rather than aggregating data on-the-fly across multiple underlying data objects.

First claim

What is claimed is:

1. A method for data object aggregation at a database system, comprising:
receiving an order data object comprising an order identifier, the order data object having a first data object type;
creating an order summary data object in response to receiving the order data object;
receiving an additional data object associated with the order identifier, the additional data object having a second data object type different from the first data object type of the order data object;
updating the order summary data object in response to receiving the additional data object that is associated with the order identifier;
receiving a query for a value corresponding to a first field value at the order data object and a second field value at the additional data object, the first field value being for a first field type of the first data object type and the second field value being for a second field type of the second data object type, wherein the query comprises the order identifier; and
retrieving, in response to the query, the value directly from the updated order summary data object based at least in part on the updated order summary data object comprising information for both the order data object and the additional data object, wherein the retrieving comprises refraining from accessing the order data object and the additional data object in response to the query.

2. The method of claim 1 , wherein the order summary data object comprises a current state associated with the order identifier, the method further comprising:
storing the order summary data object at the database system.

3. The method of claim 2 , further comprising:
storing the order data object and the additional data object at the database system, wherein the order summary data object comprises a first indicator referencing the order data object and a second indicator referencing the additional data object.

4. The method of claim 1 , further comprising:
determining, upon receiving the order data object, that the database system does not currently store an existing order summary data object corresponding to the order identifier, wherein the order summary data object is created based at least in part on the determining that the database system does not currently store the existing order summary data object.

5. The method of claim 4 , further comprising:
determining, upon receiving the additional data object, that the database system currently stores the order summary data object corresponding to the order identifier, wherein the order summary data object is updated based at least in part on the determining that the database system currently stores the order summary data object.

6. The method of claim 1 , further comprising:
generating an initial value for an aggregate data field of the order summary data object based at least in part on the first field value for the order data object; and
calculating the value for the aggregate data field of the order summary data object based at least in part on the second field value for the additional data object, wherein the value is retrieved directly from the updated order summary data object based at least in part on the calculating.

7. The method of claim 6 , further comprising:
receiving a tag for the value; and
tagging the aggregate data field with the tag based at least in part on the order summary data object comprising the value for the aggregate data field, wherein the order data object and the additional data object do not comprise the value for tagging.

8. The method of claim 1 , further comprising:
receiving first information corresponding to the order data object via a first application programming interface (API) for a first system, wherein receiving the order data object comprises generating the order data object based at least in part on the first information; and
receiving second information corresponding to the additional data object via a second API different from the first API for a second system different from the first system, wherein receiving the additional data object comprises generating the additional data object based at least in part on the second information.

9. The method of claim 8 , wherein:
the first field value is represented in the first information using a first data format;
the second field value is represented in the second information using a second data format different from the first data format; and
the value is represented in the updated order summary data object using the first data format, the second data format, or a third data format different from the first data format and the second data format based at least in part on converting the first data format to a first converted data format for the order data object, converting the second data format to a second converted data format for the additional data object, or both.

10. The method of claim 1 , further comprising:
transmitting, for display in a user interface, a set of data associated with the order summary data object, wherein the query is received based at least in part on a user input to the user interface.

11. The method of claim 10 , further comprising:
transmitting, for display in the user interface, the retrieved value in response to the query, wherein the user interface is updated within a real-time time constraint based at least in part on retrieving the value directly from the updated order summary data object.

12. The method of claim 10 , wherein the user interface is associated with a tenant of the database system, an end-user for the tenant, or both.

13. The method of claim 1 , wherein the order summary data object inherits field-based security parameters from the order data object.

14. The method of claim 1 , further comprising:
receiving an additional query for an additional value corresponding to a third field value at the order data object, wherein the additional query comprises the order identifier;
determining that the order summary data object does not comprise the additional value; and
retrieving, in response to the additional query, the additional value from the order data object based at least in part on the order summary data object not comprising the additional value.

15. The method of claim 1 , further comprising:
activating order summaries at the database system;
identifying an additional order data object comprising an additional order identifier stored at the database system;
searching the database system for one or more additional data objects associated with the additional order identifier; and
building an additional order summary data object corresponding to the additional order identifier based at least in part on the additional order data object comprising the additional order identifier and the one or more additional data objects associated with the additional order identifier.

16. The method of claim 1 , wherein the additional data object comprises an additional order data object, a change order data object, a fulfillment order data object, or a return order data object.

17. The method of claim 16 , wherein:
the additional data object comprises the additional order data object associated with the order identifier and the updating comprises replacing current order information for the order summary data object comprising first order information associated with the order data object with second order information associated with the additional order data object;
the additional data object comprises the change order data object associated with the order identifier and the updating comprises mod

Assignees

• Salesforce Com Inc

Inventors

• Canel Lopez Osvaldo Rene
• Starukhin Michael
• Levine Susan
• Dandy Michael
• Derochemont Steven
• Hatker Amanda

Classifications

• G06F16/2358

  Change logging, detection, and notification (replication G06F16/27) · CPC title

• G06F16/252

  between a Database Management System and a front-end application · CPC title

• G06F16/2379

  Updates performed during online database operations; commit processing · CPC title

• G06Q30/0635 Primary

  replenishment orders; recurring orders · CPC title

• G06F16/25 Primary

  Integrating or interfacing systems involving database management systems · CPC title