HIERARCHY DISPLAY

• US 20100199223A1
• Filed: 02/03/2009
• Published: 08/05/2010
• Est. Priority Date: 02/03/2009
• Status: Abandoned Application

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Colner, Scott
• Application Number:
  US12/364,629
• Publication Number:
  US 20100199223A1
• Time in Patent Office: Days
• US Class Current: 715/853
• CPC Class Codes: G06F 16/26 Visual data mining; Browsing structured data

Abstract

A method for establishing a hierarchy display includes identifying a basis for a hierarchy. A root of a data set is determined using the basis. A hierarchy is configured beginning at the root. The hierarchy is populated with selected values from the data set. Supplemental data is generated based on the selected values. The hierarchy is embedded with the supplemental data. The resulting hierarchy is displayed.

Claims

1. A computer readable media having instructions stored thereon that, when executed by a processor, causes the processor to:

identify a basis for a hierarchy;

determine a root of a data set using the basis;

configure the hierarchy beginning at the root;

populate the hierarchy with selected values from the data set;

generate supplemental data based on the selected values;

embed the supplemental data within the populated hierarchy; and

display the hierarchy.

2. The computer readable media of claim 1, wherein the determination of the root comprises:

setting a key of the basis to be an active key;

determining if the active key has a parent;

designating the active key to be the root if the active key does not have a parent key; and

setting the parent key to be the active key if the active key has a parent.

3. The computer readable media of claim 1, wherein the selected values from the data set comprise:

an identifier to identify a member of the hierarchy; and

corresponding data associated with the identifier.

4. The computer readable media of claim 3, wherein the population of the hierarchy comprises:

populating the hierarchy with selected values for the root;

identifying data records that have the active key as the parent key;

populating the hierarchy with selected values for the identified data records;

setting the active key to be one of the keys of the identified data records; and

recursively determining if any data records of the data set have the active key as the parent key until all of the members of the hierarchy and their selected values populate the hierarchy.

5. The computer readable media of claim 1, further comprising instructions that cause the processor to:

create a node for each member of the hierarchy that is a parent, wherein each node comprises;

at least one member and corresponding data of the at least one member;

a node identifier to identify the node; and

a node summary to summarize the corresponding data of the node.

6. The computer readable media of claim 5, wherein the generation of supplemental data comprises:

generating a node identifier for each node;

generating a node summary for each node; and

assigning a number to each member based on a numbering scheme that designates a hierarchical position of the member.

7. The computer readable media of claim 6, wherein the generation of the node summary for the lowest level of the hierarchy comprises:

selecting a lowest level of the hierarchy;

for each node in the lowest level, calculating a sum for a branch of corresponding values within a first field;

for each node in the lowest level, calculating a sum for a branch of corresponding values within a second field; and

for each node in the lowest level, populating the node summary with the sum of the first field and the sum of the second field.

8. The computer readable media of claim 7, wherein the generation of the node summary for the next level of the hierarchy comprises:

selecting a next level of the hierarchy, the next level being one level above the lowest level;

for each node in the next level, calculating a sum for a branch of corresponding values within the first field;

for each node in the next level, calculating a sum for a branch of corresponding values within the second field; and

for each node in the next level, populating the node summary with the sum of the first field and the sum of the second field.

9. A hierarchy display system comprising:

a search tool to receive a hierarchy basis;

a data set that includes members of a hierarchy;

a processor enabled to establish a hierarchy display based in part on the hierarchy basis and the data set, the hierarchy display comprising;

a set of members, each member including an identifier to identify the member and corresponding financial data of the member; and

a node for each member of a hierarchy that is considered a parent, each node includes a node identifier to identify a node and a node summary to summarize the corresponding financial data of the node.

10. The hierarchy display system of claim 9, wherein the corresponding financial data includes an item balance, a past due balance, and a credit limit.

11. The hierarchy display system of claim 9, wherein the node summary includes a calculated sum of each item balance of every member of the node, a calculated sum of each past due balance of every member of the node, and a credit limit field.

12. The hierarchy display system of claim 9, wherein the node identifier is the first named member of the node.

13. The hierarchy display system of claim 9, wherein the identifiers are indented to denote hierarchy position, and the corresponding financial data are numerical values that are aligned in columns.

14. A computer implemented method for establishing a hierarchy display, the method comprising:

identifying a root key within a data set;

setting the root key to be the active key;

populating a hierarchy with an identifier and financial data of the root key;

identifying all data records in the data set that has the active key as a parent key;

populating the hierarchy with an identifier and financial data for each identified data record;

setting the active key to be one of the keys of the identified data records;

recursively iterating through the steps of identifying all data records, populating the hierarchy, and setting the active key until all hierarchy members from the data set populate the hierarchy;

creating a node for each member of a hierarchy that is considered a parent, each node includes a node identifier to identify a node and a node summary to summarize the corresponding financial data of the node; and

displaying the populated hierarchy on a single display screen.

15. The computer implemented method of claim 14, wherein the financial data of the root key and the financial data for the identified data records include an item balance, a past due balance, and a credit limit.

16. The computer implemented method of claim 14, wherein the node summary includes a calculated sum of each item balance of every member of the node, a calculated sum of each past due balance of every member of the node, and a credit limit field.

17. A system for establishing a hierarchy display, the system comprising:

means for identifying a basis for a hierarchy;

means for determining a root of a data set using the basis;

means for configuring the hierarchy beginning at the root;

means for populating the hierarchy with selected values from the data set, the selected values include an identifier to identify a member of the hierarchy and corresponding financial data;

means for generating supplemental data based on the corresponding financial data;

means for embedding the supplemental data within the populated hierarchy; and

means for displaying the hierarchy.

18. The system of claim 17, further comprising:

means for creating a node for each member of the hierarchy that is a parent, wherein each node comprises;

at least one member and corresponding financial data of the at least one member;

a node identifier to identify the node; and

a node summary that includes the supplemental data, the supplemental data summarizing the corresponding financial data.