System and method for implementing accumulative rows within master tables

• US 20070233691A1
• Filed: 03/30/2006
• Published: 10/04/2007
• Est. Priority Date: 03/30/2006
• Status: Abandoned Application

• Current Assignee: SAP AG (SAP SE)
• Original Assignee: SAP AG (SAP SE)
• Inventors: Chaushev, Rosen
• Application Number:
  US11/395,679
• Publication Number:
  US 20070233691A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application

Abstract

A system and method are described for efficiently filtering and restoring tables within an enterprise application server. For example, one embodiment of the invention detects that a filtering function has been selected for a particular table node and responsively stores elements from the table node within a backup table collection. The filtering function is then performed to generate a filtered table node containing a subset of elements specified by the filtering function. Subsequently, upon detecting that the filtering function has been disabled, the table node may be restored from the backup table collection.

Claims

1. A method for accessing data in a master table, comprising:

providing a master table having multiple selectable principal elements and a selectable cumulative element, each principal element having a defined association with one or more items, the cumulative element having a defined association with one or more principal elements and a derived association with all items of the associated principal elements; and

populating a cumulative child table with all items associated with the cumulative element in response to selection of the cumulative element.

2. The method of claim 1 wherein the selectable principal elements comprise products and the items comprise components that constitute the products.

3. The method of claim 1 wherein providing the master table having the cumulative element comprises:

providing the master table having the cumulative element having a defined association with all principal elements of the master table.

4. The method of claim 1 further comprising:

associating with the cumulative element all items; and

populating the cumulative child table with each unique occurrence of every item of the associated principal elements.

5. The method of claim 1 further comprising:

dynamically, automatically reflecting in the derived associations of the cumulative element a modification to the defined association between a principal element and an associated item.

6. The method of claim 1 further comprising:

disabling a modification mechanism with which to modify the entries of the cumulative child table in response to the selection of the cumulative element.

7. The method as in claim 1 further comprising:

concurrently displaying the cumulative child table and the master table and within a Web browser in response to user selection of the cumulative element.

8. A system for accessing data in a master table, comprising:

a cumulative data module to generate a cumulative element within a master table having multiple selectable principal elements, each principal element having a defined association with one or more items, the cumulative element having a defined association with one or more principal elements and a derived association with all items of the associated principal elements; and

a child table module to populate a cumulative child table with all items associated with the cumulative element in response to selection of the cumulative element.

9. The system of claim 8 wherein the selectable principal elements comprise products and the items comprise components that constitute the products.

10. The system of claim 8 wherein the cumulative element has a defined association with all principal elements of the master table.

11. The system of claim 8 wherein, to establish the derived association, the cumulative data module associates with the cumulative element all items;

and the child table module populates the cumulative child table with each unique occurrence of every item of the associated principal elements.

12. The system of claim 8 wherein the cumulative data module dynamically, automatically reflects in the derived associations of the cumulative element a modification to the defined association between a principal element and an associated item.

13. The system of claim 8 wherein the child table module disables a modification mechanism with which to modify the entries of the cumulative child table in response to the selection of the cumulative element.

14. The system as in claim 8 further comprising:

a Web browser for concurrently displaying the cumulative child table and the master table in response to user selection of the cumulative element.

15. A machine-readable medium having program code stored thereon which, when executed by a machine, causes the machine to perform the operations of:

providing a master table having multiple selectable principal elements and a selectable cumulative element, each principal element having a defined association with one or more items, the cumulative element having a defined association with one or more principal elements and a derived association with all items of the associated principal elements; and

populating a cumulative child table with all items associated with the cumulative element in response to selection of the cumulative element.

16. The machine-readable medium of claim 15 wherein the selectable principal elements comprise products and the items comprise components that constitute the products.

17. The machine-readable medium of claim 15 wherein providing the master table having the cumulative element comprises:

providing the master table having the cumulative element having a defined association with all principal elements of the master table.

18. The machine-readable medium of claim 15 comprising additional program code to cause the machine to perform the operations of:

associating with the cumulative element all items; and

populating the cumulative child table with each unique occurrence of every item of the associated principal elements.

19. The machine-readable medium of claim 15 comprising additional program code to cause the machine to perform the operations of:

dynamically, automatically reflecting in the derived associations of the cumulative element a modification to the defined association between a principal element and an associated item.

20. The machine-readable medium of claim 15 comprising additional program code to cause the machine to perform the operations of:

disabling a modification mechanism with which to modify the entries of the cumulative child table in response to the selection of the cumulative element.

21. The machine-readable medium as in claim 15 further comprising:

concurrently displaying the cumulative child table and the master table and within a Web browser in response to user selection of the cumulative element.