System and method for identifying element usage in a deep element structure

• US 7,809,707 B2
• Filed: 07/23/2007
• Issued: 10/05/2010
• Est. Priority Date: 07/23/2007
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Nguyen, Dai, Poulin, Jerome, Falardeau, Simon
• Primary Examiner(s): Lee; Wilson
• Application Number:
  US11/880,590
• Publication Number:
  US 20090030871A1
• Time in Patent Office: 1,170 Days
• Field of Search: 707 1- 10, 707705-726, 707781-789
• US Class Current: 707/706
• CPC Class Codes: G06F 16/2453 Query optimisation

Abstract

A system for identifying usage of a target data element including both direct and indirect usage, within a data element structure where the target data element may have more than one parent data element. The system includes a usage processing engine configure to identify direct and indirect usage data elements for the target data element within the data element structure and a user interface configured to display the direct and indirect usage data elements for the target element in a hierarchical structure.

Claims

1. A system for identifying usage of a target data element within a data element structure, the system comprising:

a usage processing engine configured to identify a first plurality of usage data elements and a second plurality of usage data elements associated with the target data element within the data element structure, wherein identifying the first plurality of usage data elements includes identifying usage data elements that directly use the target data element within the data element structure, and wherein identifying the second plurality of usage data elements includes identifying usage data elements that indirectly use the target data element within the data element structure; and

a user interface configured to display the identified first plurality of usage data elements and the second plurality of usage data elements associated with the target data element in a hierarchical structure.

2. The system of claim 1, wherein the user interface is configured to allow a user to enter at least one query input parameter allowing the user to customize a usage query being processed by the usage processing engine.

3. The system of claim 2, wherein the at least one query input parameter includes a data element type parameter, wherein the data element type parameter is associated with a data element type.

4. The system of claim 1, wherein identifying the second plurality of usage data elements includes identifying all direct usage data elements for direct usage data elements associated with the target data element.

5. The system of claim 1, wherein identifying the second plurality of usage data elements includes identifying direct usage data elements for direct usage data elements associated with the target data element that would be affected by a change in the target data element.

6. The system of claim 1, wherein the first plurality of usage data elements and the second plurality of usage data elements displayed in the user interface include links allowing the user to access and manipulate the usage data elements.

7. The system of claim 1, wherein identifying the first plurality of usage data elements and the second plurality of usage data elements associated with the target data element includes identifying only those elements associated with a single particular indirect usage data element.

22. The system of claim 1, wherein each data element in the data element structure represents an article for sale in a retail environment.

24. The system of claim 2, wherein at least one query input parameter includes a query depth parameter, wherein the query depth parameter represents an indication of a number of data elements that indirectly use the target data element.

8. A method for identifying usage of a target data element within a data element structure, the method comprising:

receiving, from a user interface, a target data element identifier;

identifying a first plurality of usage data elements associated with the target data element within the data element structure, wherein identifying the first plurality of usage data elements includes identifying usage data elements that directly use the target data element within the data element structure;

identifying, using a usage processing engine, a second plurality of usage data elements associated with the target data element within the data element structures, wherein identifying the second plurality of usage data elements includes identifying usage data elements that indirectly use the target data element within the data element structure; and

displaying in the user interface the identified first plurality of usage data elements and the second plurality of usage data elements associated with the target element in a hierarchical structure.

9. The method of claim 8, wherein the user interface is configured to allow a user to enter at least one query input parameter allowing the user to customize a usage query being processed by the usage processing engine.

10. The method of claim 9, wherein the at least one query input parameter includes a data element type parameter, wherein the data element type parameter is associated with a data element type.

11. The method of claim 8, wherein identifying the second plurality of usage data elements includes identifying all direct usage data elements for direct usage data elements associated with the target data element.

12. The method of claim 8, wherein identifying the second plurality of usage data elements includes identifying direct usage data elements for direct usage data elements associated with the target data element that would be affect by to a change in the target data element.

13. The method of claim 8, wherein displaying the first plurality of usage data elements and the second plurality of usage data elements includes providing links allowing the user to access and manipulate the usage data elements.

14. The method of claim 8, wherein identifying the first plurality of usage data elements and the second plurality of usage data elements associated with the target data element includes identifying only those elements associated with a single particular indirect usage data element.

23. The system of claim 8, wherein each data element in the data element structure represents an article for sale in a retail environment.

25. The system of claim 9, wherein at least one query input parameter includes a query depth parameter, wherein the query depth parameter represents an indication of a number of data elements that indirectly use the target data element.

15. A system for identifying usage of a target data element, within a data element structure, comprising:

a memory queue configured to receive and store a listing of data elements, each data element including a plurality of data element fields and representing one or more software elements within a software workbench;

a usage processing engine configured to identify a first plurality of usage data elements and a second plurality of usage data elements associated with the target data element within the data element structure, wherein identifying the first plurality of usage data elements includes identifying usage data elements that directly use the target data element within the data element structure, and wherein identifying the second plurality of usage data elements includes identifying usage data elements that indirectly use the target data element within the data element structure; and

a user interface configured to display the identified first plurality of usage data elements and the second plurality of usage data elements associated with the target element in a hierarchical structure.

16. The system of claim 15, wherein the user interface is configured to allow a user to enter at least one query input parameter allowing the user to customize a usage query being processed by the usage processing engine.

17. The system of claim 16, wherein the at least one query input parameter includes a data element type parameter, wherein the data element type parameter is associated with a data element type.

18. The system of claim 15, wherein identifying the first plurality of usage data elements and the second plurality of usage data elements includes identifying all direct usage data elements for direct usage data elements associated with the target data element.

19. The system of claim 15, wherein identifying the first plurality of usage data elements and the second plurality of usage data elements includes identifying direct usage data elements for direct usage data elements associated with the target data element that would be affected by a change in the target data element.

20. The system of claim 15, wherein the first plurality of usage data elements and the second plurality of usage data elements displayed in the user interface include links allowing the user to access and manipulate the usage data elements.

21. The system of claim 15, wherein identifying the first plurality of usage data elements and the second plurality of usage data elements associated with the target data element includes identifying only those elements associated with a single particular indirect usage data element.

26. The system of claim 16, wherein at least one query input parameter includes a query depth parameter, wherein the query depth parameter represents an indication of a number of data elements that indirectly use the target data element.