Virtual product hierarchies

• US 9,785,910 B2
• Filed: 12/02/2013
• Issued: 10/10/2017
• Est. Priority Date: 12/02/2013
• Status: Active Grant

• Current Assignee: Information Resources Incorporated
• Original Assignee: Information Resources Incorporated
• Inventors: Tilwani, Prakash, Potter, II, Robert E., Noojibail, Sheila J.
• Primary Examiner(s): Obaid, Fateh M
• Application Number:
  US14/093,950
• Publication Number:
  US 20150154534A1
• Time in Patent Office: 1,408 Days
• Field of Search: None
• CPC Class Codes: G06Q 10/087 Inventory or stock management, e.g. order filling, procurement or balancing against orders

Abstract

A base hierarchy of products or the like can be user-modified into a virtual hierarchy that is represented as a collection of changes to the base hierarchy rather than a new hierarchy stored in memory. The collection of changes can be used to enable user interactions such as queries, displays, and writes using the virtual hierarchy as thought it were an actual hierarchy stored in memory, with aspects of the virtual hierarchy dynamically created using a collection of procedures based on the changes and corresponding inverses. The representation of the modified hierarchy can be dynamically displayed to a user or otherwise processed in the same manner as other hierarchies and hierarchical data.

Claims

1. A method for computer-based real time modification and management of hierarchical data comprising:

storing a base hierarchy that categorizes a collection of inventory including a number of consumer products into a number of levels of categories in a database management system;

receiving a plurality of desired changes to the base hierarchy from a user within a graphical user interface of a computer, wherein the desired changes collectively characterize a modified hierarchy categorizing the number of consumer products, and wherein the plurality of desired changes reflect marketplace performance data of the number of consumer products;

storing the plurality of desired changes logically separately from the base hierarchy as change data using a database tool, wherein each item of change data includes an instruction to add, delete, or move a node between the base hierarchy and the modified hierarchy, the instruction received from the user through a drag-and-drop operation of the node on a visual representation of one or more of the base hierarchy and the modified hierarchy displayed on the graphical user interface, wherein each item of change data is an invertible instruction with a corresponding instruction that undoes the change, and wherein an order of the change data is maintained for a plurality of items of change data;

dynamically displaying a representation of the modified hierarchy to the user in the graphical user interface with a user interface tool executing on the computer by rendering the base hierarchy as modified according to each item of change data;

receiving a query with respect to the modified hierarchy in the graphical user interface; and

processing the query by performing the steps of;

identifying an inverse for each of the plurality of desired changes, thereby identifying a plurality of inverses;

using the plurality of inverses in a reverse of the order, determining a modified query with respect to the base hierarchy; and

processing the modified query with respect to the base hierarchy.

2. The method of claim 1 wherein dynamically displaying the representation of the modified hierarchy includes iteratively rendering the plurality of changes with respect to the base hierarchy, without modifying a data file corresponding to the base hierarchy.

3. The method of claim 1 wherein each of the plurality of desired changes is selected from the group consisting of:

adding a node at a specified location, deleting a node at a specified location, and moving a node from an initial location to a destination location.

4. The method of claim 1 further comprising displaying a representation of the base hierarchy to the user in the graphical user interface, wherein the plurality of changes are received via a plurality of drag-and-drop instructions in the graphical user interface.

5. The method of claim 1 wherein:

each of the plurality of desired changes is selected from the group consisting of;

adding a node at a specified location, deleting a node at a specified location, and moving a node from an initial location to a destination location;

the inverse of adding a node at a specified location is deleting a node from the specified location;

the inverse of deleting a node at a specified location is adding a node at the specified location; and

the inverse of moving a node from an initial location to a destination location is moving a node from the destination location to the initial location.

6. The method of claim 1 wherein the plurality of changes are received in an order, and further wherein the plurality of inverses is used in a reverse order to determine the modified query.

17. The method of claim 1 wherein each category in one of the number of levels of categories contains a collection of products that share a common attribute.

18. The method of claim 1 wherein one or more leaf nodes in the base hierarchy contain performance data including sales data for a corresponding product.

7. A computer program product comprising computer executable code embodied in a non-transitory computer readable medium that, when executing on one or more computing devices, performs the steps of:

storing a base hierarchy that categorizes a collection of inventory including a number of consumer products into a number of levels of categories in a database management system;

receiving a plurality of desired changes to the base hierarchy from a user within a graphical user interface of a computer, wherein the desired changes collectively characterize a modified hierarchy categorizing the number of consumer products, and wherein the plurality of desired changes reflect marketplace performance data of the number of consumer products;

storing the plurality of desired changes logically separately from the base hierarchy as change data using a database tool, wherein each item of change data includes an instruction to add, delete, or move a node between the base hierarchy and the modified hierarchy, the instruction received from the user through a drag-and-drop operation of the node on a visual representation of one or more of the base hierarchy and the modified hierarchy displayed on the graphical user interface, wherein each item of change data is an invertible instruction with a corresponding instruction that undoes the change, and wherein an order of the change data is maintained for a plurality of items of change data;

dynamically displaying a representation of the modified hierarchy to the user in the graphical user interface with a user interface tool executing on the computer by rendering the base hierarchy as modified according to each item of change data;

receiving a query with respect to the modified hierarchy in the graphical user interface; and

processing the query by performing the steps of;

identifying an inverse for each of the plurality of desired changes, thereby identifying a plurality of inverses;

using the plurality of inverses in a reverse of the order, determining a modified query with respect to the base hierarchy; and

processing the modified query with respect to the base hierarchy.

8. The computer program product of claim 7, wherein dynamically displaying the representation of the modified hierarchy includes iteratively rendering the plurality of changes with respect to the base hierarchy without modifying a data file corresponding to the base hierarchy.

9. The computer program product of claim 7 wherein each of the plurality of desired changes is selected from the group consisting of:

adding a node at a specified location, deleting a node at a specified location, and moving a node from an initial location to a destination location.

10. The computer program product of claim 7 further comprising code that performs the step of displaying a representation of the base hierarchy to the user in the graphical user interface, wherein the plurality of changes are received via a plurality of drag-and-drop instructions in the graphical user interface.

11. The computer program product of claim 7 wherein:

each of the plurality of desired changes is selected from the group consisting of;

adding a node at a specified location, deleting a node at a specified location, and moving a node from an initial location to a destination location;

the inverse of adding a node at a specified location is deleting a node from the specified location;

the inverse of deleting a node at a specified location is adding a node at the specified location; and

the inverse of moving a node from an initial location to a destination location is moving a node from the destination location to the initial location.

12. The computer program product of claim 7 wherein the plurality of changes are received in an order, and further wherein the plurality of inverses is used in a reverse order to determine the modified query.

19. The computer program product of claim 7 wherein each category in one of the number of levels of categories contains a collection of products that share a common attribute.

20. The computer program product of claim 7 wherein one or more leaf nodes in the base hierarchy contain performance data including sales data for a corresponding product.

13. A system for computer-based real time modification and management of hierarchical data, the system comprising:

one or more processors; and

memory bearing instructions that, when executed, cause the one or more processors to perform the steps of;

storing a base hierarchy that categorizes a collection of inventory including a number of consumer products into a number of levels of categories in a database management system;

receiving a plurality of desired changes to the base hierarchy from a user within a graphical user interface of a computer, wherein the desired changes collectively characterize a modified hierarchy categorizing the number of consumer products, and wherein the plurality of desired changes reflect marketplace performance data of the number of consumer products;

storing the plurality of desired changes logically separately from the base hierarchy as change data with a database tool, wherein each item of change data includes an instruction to add, delete, or move a node between the base hierarchy and the modified hierarchy, the instruction received from the user through a drag-and-drop operation of the node on a visual representation of one or more of the base hierarchy and the modified hierarchy displayed on the graphical user interface, wherein each item of change data is an invertible instruction with a corresponding instruction that undoes the change, and wherein an order of the change data is maintained for a plurality of items of change data;

dynamically displaying a representation of the modified hierarchy to the user in the graphical user interface with a user interface tool executing on the computer by rendering the base hierarchy as modified according to each item of change data;

receiving a query with respect to the modified hierarchy in the graphical user interface; and

processing the query by performing the steps of;

identifying an inverse for each of the plurality of desired changes, thereby identifying a plurality of inverses;

using the plurality of inverses in a reverse of the order, determining a modified query with respect to the base hierarchy; and

processing the modified query with respect to the base hierarchy.

14. The system of claim 13 wherein dynamically displaying the representation of the modified hierarchy includes iteratively rendering the plurality of changes with respect to the base hierarchy, without modifying a data file corresponding to the base hierarchy.

15. The system of claim 13 wherein each of the plurality of desired changes is selected from the group consisting of:

adding a node at a specified location, deleting a node at a specified location, and moving a node from an initial location to a destination location.

16. The system of claim 13 further comprising instructions that cause the processor to display a representation of the base hierarchy to the user in the graphical user interface, wherein the plurality of changes are received via a plurality of drag-and-drop instructions in the graphical user interface.