System and method for an order handling data model with item-level granularity

• US 8,489,436 B1
• Filed: 06/04/2010
• Issued: 07/16/2013
• Est. Priority Date: 06/04/2010
• Status: Active Grant

• Current Assignee: Amazon Technologies, Inc. (Amazon.com, Inc.)
• Original Assignee: Amazon Technologies, Inc. (Amazon.com, Inc.)
• Inventors: Panzitta, Michael J., Xiang, Xin, Swensen, Gregory R., Weight, Christopher F.
• Primary Examiner(s): Dunham, Jason B.
• Assistant Examiner(s): Puri, Venay
• Application Number:
  US12/794,519
• Time in Patent Office: 1,138 Days
• Field of Search: None
• US Class Current: 705/7
• CPC Class Codes: G06Q 10/087 Inventory or stock management, e.g. order filling, procurement or balancing against orders

Abstract

Various embodiments of a system and method for an order handling data model with item-level granularity are described. Embodiments may include an order handling system configured to, for a given purchase order received from an ordering entity, generate within a data store a purchase order data object, item data objects for items of the purchase order, and message data objects for messages associated with item data objects. In various embodiments, the order handling system may also generate in the data store mapping information for mapping each of the different data objects for a given purchase order together. The order handling system may also provide to the ordering entity a notification for a particular item. The notification may be based on information accessed from the item data object corresponding to the particular item or information accessed from other data objects associated with that item data object according to the mapping information.

Claims

1. A system, comprising:

a data store;

one or more computers, the one or more computers comprising one or more memories and one or more processors, wherein the one or more memories comprise program instructions executable by the one or more computers to implement an order handling system configured to;

for a purchase order received from an ordering entity, generate a purchase order data object comprising one or more attributes associated with the purchase order and store the purchase order data object within the data store;

for each of one or more items specified by the purchase order, generate a respective item data object comprising one or more attributes and store that item data object within the data store;

for each of multiple notification messages associated with the purchase order, generate a corresponding message data object comprising one or more attributes and store that message data object within the data store;

generate within the data store mapping information that specifies;

each message data object is associated with one or more of the multiple item data objects, and each of the multiple item data objects are associated with the respective purchase order;

evaluate the mapping information to determine a relationship between a particular message data object, an associated item data object, and an associated purchase order data object to which the item data object is mapped;

based on the determined relationship, identify the particular message data object to be used for generating a notification provided to the ordering entity for the particular item and the associated item data object;

generate the notification based on information from the particular message data object associated with that item data object according to said mapping information; and

provide to the ordering entity the notification for the particular item and the associated item data object.

2. The system of claim 1, wherein the order handling system is configured to:

receive from the ordering entity a status request for an item of the purchase order;

in response to the status request, determine a state of that item from an attribute of the corresponding item data object within said data store, wherein the state of that item indicates whether an order for that item has been successfully placed with an order processing system; and

provide the ordering entity with information specifying the state of the item.

3. The system of claim 1, wherein the order handling system is configured to:

receive from the ordering entity a request for one or more notification messages associated with a particular item of the purchase order, and

in response to the request, determine one or more notification messages generated for that item by;

identifying the item data object that corresponds to the particular item in the data store;

based on said mapping information, identifying one or more message data objects that are associated with the identified item data object; and

provide the ordering entity with at least one message specified by an identified message data object.

4. The system of claim 3, wherein the message provided was generated more recently than other messages generated for the particular item.

5. The system of claim 1, wherein said notification messages include one or more of:

a message indicating that an order for an item of the purchase order has been confirmed, a message indicating that an order for an item of the purchase order has been delayed, or a message indicating that a shipment include an item of the purchase order has been shipped.

6. The system of claim 1, wherein at least some of the mapping information is stored as part of the generated data objects, wherein a data field of a given data object includes an identifier of another data object to which the given data object is associated.

7. The system of claim 1, wherein at least some of the mapping information is stored within a mapping data object that maps each message data object to one or more item data objects.

8. The system of claim 1, wherein each group of different groups of the message data objects form a message chain, wherein said mapping information associates each message data object of a given chain together.

9. The system of claim 8, wherein at least one message data object of the message chain includes a message sent to the ordering entity and at least one other message data object of the message chain includes a message received from the ordering entity.

10. The system of claim 1, wherein said notification is generated according to a format that is different than the format of the message data object corresponding to the particular item.

11. A computer-implemented method, comprising:

for a purchase order received from an ordering entity, generating a purchase order data object comprising one or more attributes associated with the purchase order and storing the purchase order data object within a data store;

for each of one or more items specified by the purchase order, generating a respective item data object comprising one or more attributes and store that item data object within the data store;

for each of multiple notification messages associated with the purchase order, generating a corresponding message data object comprising one or more attributes and storing that message data object within the data store;

generating within the data store mapping information that specifies;

each message data object is associated with one or more of the multiple item data objects, and each of the multiple item data objects are associated with the respective purchase order;

evaluating the mapping information to determine a relationship between a particular message data object, an associated item data object, and an associated purchase order data object to which the item data object is mapped;

based on the determined relationship, identifying the particular message data object to be used for generating a notification provided to the ordering entity for the particular item and the associated item data object;

generating the notification based on information from the particular message data object associated with that item data object according to said mapping information; and

providing to the ordering entity the notification for the particular item and the associated item data object.

12. The computer-implemented method of claim 11, wherein the method comprises:

receiving from the ordering entity a status request for an item of the purchase order;

in response to the status request, determining a state of that item from an attribute of the corresponding item data object within said data store, wherein the state of that item indicates whether an order for that item has been successfully placed with an order processing system; and

providing the ordering entity with information specifying the state of the item.

13. The computer-implemented method of claim 11, wherein the method comprises:

receiving from the ordering entity a request for one or more notification messages associated with a particular item of the purchase order, and

in response to the request, determining one or more notification messages generated for that item by;

identifying the item data object that corresponds to the particular item in the data store;

based on said mapping information, identifying one or more message data objects that are associated with the identified item data object; and

providing the ordering entity with at least one message specified by an identified message data object.

14. The computer-implemented method of claim 13, wherein the message provided was generated more recently than other messages generated for the particular item.

15. The computer-implemented method of claim 11, wherein said notification messages include one or more of:

a message indicating that an order for an item of the purchase order has been confirmed, a message indicating that an order for an item of the purchase order has been delayed, or a message indicating that a shipment include an item of the purchase order has been shipped.

16. The computer-implemented method of claim 11, wherein at least some of the mapping information is stored as part of the generated data objects, wherein a data field of a given data object includes an identifier of another data object to which the given data object is associated.

17. The computer-implemented method of claim 11, wherein at least some of the mapping information is stored within a mapping data object that maps each message data object to one or more item data objects.

18. The computer-implemented method of claim 11, wherein each group of different groups of the message data objects form a message chain, wherein said mapping information associates each message data object of a given chain together.

19. The computer-implemented method of claim 18, wherein at least one message data object of the message chain includes a message sent to the ordering entity and at least one other message data object of the message chain includes a message received from the ordering entity.

20. The computer-implemented method of claim 11, wherein said notification is generated according to a format that is different than the format of the message data object corresponding to the particular item.

21. A computer-readable storage medium, storing program instructions computer-executable on a computer system to implement an order handling system configured to:

for a purchase order received from an ordering entity, generate a purchase order data object comprising one or more attributes associated with the purchase order and store the purchase order data object within a data store;

for each of one or more items specified by the purchase order, generate a respective item data object comprising one or more attributes and store that item data object within the data store;

for each of multiple notification messages associated with the purchase order, generate a corresponding message data object comprising one or more attributes and store that message data object within the data store;

generate within the data store mapping information that specifies;

each message data object is associated with one or more of the multiple item data objects, and each of the multiple item data objects are associated with the respective purchase order;

evaluate the mapping information to determine a relationship between a particular message data object, an associated item data object, and an associated purchase order data object to which the item data object is mapped;

based on the determined relationship, identify the particular message data object to be used for generating a notification provided to the ordering entity for the particular item and the associated item data object;

generate the notification based on information from the particular message data object associated with that item data object according to said mapping information; and

provide to the ordering entity the notification for the particular item and the associated item data object.

22. The computer-readable storage medium of claim 21, wherein the order handling system is configured to:

receive from the ordering entity a status request for an item of the purchase order;

in response to the status request, determine a state of that item from an attribute of the corresponding item data object within said data store, wherein the state of that item indicates whether an order for that item has been successfully placed with an order processing system; and

provide the ordering entity with information specifying the state of the item.

23. The computer-readable storage medium of claim 21, wherein the order handling system is configured to:

receive from the ordering entity a request for one or more notification messages associated with a particular item of the purchase order, and

in response to the request, determine one or more notification messages generated for that item by;

identifying the item data object that corresponds to the particular item in the data store;

based on said mapping information, identifying one or more message data objects that are associated with the identified item data object; and

provide the ordering entity with at least one message specified by an identified message data object.

24. The computer-readable storage medium of claim 23, wherein the message provided was generated more recently than other messages generated for the particular item.

25. The computer-readable storage medium of claim 21, wherein said notification messages include one or more of:

a message indicating that an order for an item of the purchase order has been confirmed, a message indicating that an order for an item of the purchase order has been delayed, or a message indicating that a shipment include an item of the purchase order has been shipped.

26. The computer-readable storage medium of claim 21, wherein at least some of the mapping information is stored as part of the generated data objects, wherein a data field of a given data object includes an identifier of another data object to which the given data object is associated.

27. The computer-readable storage medium of claim 21, wherein at least some of the mapping information is stored within a mapping data object that maps each message data object to one or more item data objects.

28. The computer-readable storage medium of claim 21, wherein each group of different groups of the message data objects form a message chain, wherein said mapping information associates each message data object of a given chain together.

29. The computer-readable storage medium of claim 28, wherein at least one message data object of the message chain includes a message sent to the ordering entity and at least one other message data object of the message chain includes a message received from the ordering entity.

30. The computer-readable storage medium of claim 21, wherein said notification is generated according to a format that is different than the format of the message data object corresponding to the particular item.