Nested dimensions presentation structures

• US 8,671,363 B2
• Filed: 11/19/2008
• Issued: 03/11/2014
• Est. Priority Date: 11/19/2008
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Choudhury, Akhil
• Primary Examiner(s): ALVESTEFFER, STEPHEN D
• Application Number:
  US12/274,212
• Publication Number:
  US 20100125813A1
• Time in Patent Office: 1,938 Days
• Field of Search: 715/853, 707/E17.044
• US Class Current: 715/853
• CPC Class Codes: G06F 16/2246 Trees, e.g. B+trees

Abstract

A method and apparatus for rendering data on a display is provided. A configurable number of dimensions are rendered on the display in a manner that depicts a sequential relationship between the configurable number of dimensions. Each rendered dimension on the display depicts one or more dimension instances. For the rendered dimension having the lowest sequential position in the sequential relationship between the configurable number of dimensions (hereafter the “lowest sequential dimension”), a determination is made as to whether hierarchical data is associated with a particular dimension instance of the lowest sequential dimension, and if so, at least a top level node of a tree of nodes is rendered in association with the particular dimension instance of the lowest sequential dimension on the display. Each node of the tree of nodes may, but need not, comprise a row of data.

Claims

1. A method for rendering data on a display, comprising:

rendering two or more dimensions on said display in a manner that depicts a sequential relationship between said two or more dimensions by indentation along a first direction;

wherein each rendered dimension on said display depicts multiple dimension instances aligned in a second direction relative to one another and aligned in the second direction relative to a name, wherein each dimension instance is an instance of a dimension of said name;

wherein the second direction is perpendicular to the first direction;

for a first dimension in said sequential relationship rendered at furthest indentation along the first direction on said display, performing;

upon determining that data is associated with a first instance of said first dimension, rendering on said display closer to the first instance than to a second instance of said second dimension, at least a top level node of a tree of nodes in association with a first control, wherein said tree of nodes contains said data in one or more child nodes of said top level node and at least said top level node is initially rendered;

wherein a first name of the first dimension is rendered on said display indented furthest along the first direction relative to a second name of a second dimension;

wherein said first instance is rendered indented furthest along the first direction relative to the second instance of said second dimension;

wherein multiple first instances of the first dimension including said first instance are rendered aligned in the second direction relative to one another and aligned in the second direction relative to the first name, and multiple second instances of the second dimension including said second instance are rendered aligned in the second direction relative to one another and aligned in the second direction relative to the second name; and

in response to user selection of said first control, rendering at least one of said child nodes with a second control and with at least said top level node and said names on said display.

2. The method of claim 1, wherein said rendering said two or more dimensions further comprises:

upon determining that a certain dimension instance of a certain dimension of said two or more dimensions satisfies a test, rendering said certain dimension on said display without rendering said certain dimension instance.

3. The method of claim 1, wherein:

all of said one or more child nodes are rendered on said display in a manner that graphically depicts each of said one or more child nodes to be child nodes of said top level node.

4. The method of claim 1, wherein said tree of nodes further includes one or more child nodes of said top level node, and wherein only said top level node of said tree of nodes is initially rendered on said display, and wherein the method further comprises:

retrieving child data corresponding to said one or more child nodes of said top level node, wherein said retrieving said child data is not performed until after said user selection is received, and

updating said display to render said one or more child nodes on said display using said child data.

5. The method of claim 1, wherein a particular node of said tree of nodes contains a link to a web page that contains additional information about said particular node.

6. The method of claim 1, further comprising:

receiving user input that specifies how many of said two or more dimensions to render on said display.

7. The method of claim 1, wherein said tree of nodes is part of a tree table, and wherein each node of said tree of nodes comprises a row of data.

8. The method of claim 1, further comprising:

rendering a second tree of nodes in association with a second dimension instance of said particular dimension on said display, wherein said second dimension instance is not said particular dimension instance.

9. The method of claim 1, wherein said tree of nodes further includes one or more child nodes of said top level node, and wherein only said top level node of said tree of nodes is initially rendered on said display, and wherein the method further comprises:

updating said display to render said one or more child nodes on said display using child data, wherein said child data was retrieved prior to receipt of said user input.

10. One or more non-transitory machine-readable storage media storing one or more sequences of instructions for rendering data on a display, which when executed, cause:

rendering two or more dimensions on said display in a manner that depicts a sequential relationship between said two or more dimensions by indentation along a first direction;

wherein each rendered dimension on said display depicts multiple dimension instances aligned in a second direction relative to one another and aligned in the second direction relative to a name, wherein each dimension instance is an instance of a dimension of said name;

wherein the second direction is perpendicular to the first direction;

for a first dimension in said sequential relationship rendered along the first direction on said display, performing;

upon determining that data is associated with a first instance of said first dimension, rendering on said display at least a top level node of a tree of nodes in association with a control, wherein said tree of nodes contains said data in one or more child nodes of said top level node and at least said top level node is initially rendered;

wherein a first name of the first dimension is rendered on said display indented along the first direction relative to a second name of a second dimension;

wherein said first instance is rendered indented along the first direction relative to a second instance of said second dimension;

wherein multiple first instances of the first dimension including said first instance are rendered aligned in the second direction relative to one another and aligned in the second direction relative to the first name, and multiple second instances of the second dimension including said second instance are rendered aligned in the second direction relative to one another and aligned in the second direction relative to the second name; and

in response to user selection of said control, rendering at least one of said child nodes with an additional control and with at least said top level node and said names on said display.

11. The one or more non-transitory machine-readable storage media of claim 10, wherein said rendering said two or more dimensions further comprises:

upon determining that a certain dimension instance of a certain dimension of said two or more dimensions is not associated with any data, rendering said certain dimension on said display without rendering said certain dimension instance.

12. The one or more non-transitory machine-readable storage media of claim 10, wherein said tree of nodes further includes one or more child nodes of said top level node, and wherein only said top level node of said tree of nodes is initially rendered on said display, and wherein:

all of said one or more child nodes are rendered on said display in addition to said top level node in a manner that graphically depicts each of said one or more child nodes to be child nodes of said top level node.

13. The one or more non-transitory machine-readable storage media of claim 10, wherein said tree of nodes further includes one or more child nodes of said top level node, and wherein only said top level node of said tree of nodes is initially rendered on said display, and wherein execution of the one or more sequences of instructions further causes:

in response to receiving user selection of said control, performing the steps of;

retrieving child data corresponding to said one or more child nodes of said top level node, wherein said retrieving said child data is not performed until after said user selection is received, and

updating said display to render said one or more child nodes on said display using said child data.

14. The one or more non-transitory machine-readable storage media of claim 10, wherein a particular node of said tree of nodes contains a link to a web page that contains additional information about said particular node.

15. The one or more non-transitory machine-readable storage media of claim 10, wherein execution of the one or more sequences of instructions further causes:

receiving user input that specifies how many of said two or more dimensions to render on said display.

16. The one or more non-transitory machine-readable storage media of claim 10, wherein said tree of nodes is part of a tree table, and wherein each node of said tree of nodes comprises a row of data.

17. The one or more non-transitory machine-readable storage media of claim 10, wherein execution of the one or more sequences of instructions further causes:

rendering a second tree of nodes in association with a second dimension instance of said particular dimension on said display, wherein said second dimension instance is not said particular dimension instance.

18. The one or more non-transitory machine-readable storage media of claim 10, wherein said tree of nodes further includes one or more child nodes of said top level node, and wherein only said top level node of said tree of nodes is initially rendered on said display, and wherein execution of the one or more sequences of instructions further causes:

in response to receiving user selection of said control, performing the step of;

updating said display to render said one or more child nodes on said display using child data, wherein said child data was retrieved prior to receipt of said user input.

19. A method for rendering data on a display, comprising:

rendering a configurable number of dimensions on said display in a manner that depicts a sequential relationship between said configurable number of dimensions by indentation along a first direction;

wherein each rendered dimension on said display depicts multiple dimension instances aligned relative to one another in a second direction perpendicular to the first direction, and wherein each dimension instance is an instance of a dimension;

for a particular dimension, rendered on said display, having the lowest sequential position in said sequential relationship, performing;

upon determining that hierarchical data is associated with a particular dimension instance of said particular dimension, rendering on said display at least a top level node of a tree of nodes in association with said particular dimension instance and a first control;

wherein a name of the particular dimension is rendered on said display indented relative to another name of another dimension, in a nested manner; and

wherein said particular dimension instance is rendered indented relative to another dimension instance of said another dimension, in said nested manner and corresponding to said dimensions;

wherein multiple particular dimension instances including said particular dimension instance are rendered aligned in the second direction relative to one another and aligned in the second direction relative to the name of the particular dimension and multiple another instances of said another dimension including said another dimension instance are aligned in the second direction relative to one another and aligned in the second direction relative to said another name; and

in response to user selection of said first control, rendering at least one of said nodes with a second control and with said top level node and said names on said display.

20. The method of claim 19, wherein each node of said tree of nodes comprises a row of data.

21. One or more non-transitory machine-readable storage media storing one or more sequences of instructions for rendering data on a display, which when executed, cause:

rendering a configurable number of dimensions on said display in a manner that depicts a sequential relationship between said configurable number of dimensions by indentation along a first direction;

wherein each rendered dimension on said display depicts multiple dimension instances aligned relative to one another in a second direction perpendicular to the first direction, and wherein each dimension instance is an instance of a dimension;

for a particular dimension, rendered on said display, having the lowest sequential position in said sequential relationship, performing;

upon determining that hierarchical data is associated with a particular dimension instance of said particular dimension, rendering on said display at least a top level node of a tree of nodes in association with said particular dimension instance and a first control;

wherein a name of the particular dimension is rendered on said display indented relative to another name of another dimension, in a nested manner; and

wherein said particular dimension instance is rendered indented relative to another dimension instance of said another dimension, in said nested manner and corresponding to said dimensions;

wherein multiple particular dimension instances including said particular dimension instance are rendered aligned in the second direction relative to one another and aligned in the second direction relative to the name of the particular dimension and multiple another instances of said another dimension including said another dimension instance are aligned in the second direction relative to one another and aligned in the second direction relative to said another name; and

in response to user selection of said first control, rendering at least one of said nodes with a second control and with said top level node and said names on said display.

22. The one or more non-transitory machine-readable storage media of claim 21, wherein each node of said tree of nodes comprises a row of data.

23. An apparatus comprising a memory and a processor for rendering data on a display, the apparatus comprising:

means for rendering two or more dimensions on said display in a manner that depicts a sequential relationship between said two or more dimensions by indentation along a first direction;

wherein each rendered dimension on said display depicts multiple dimension instances aligned in a second direction relative to one another and aligned in the second direction relative to a name, wherein each dimension instance is an instance of a dimension of said name;

wherein the second direction is perpendicular to the first direction;

for a first dimension in said sequential relationship rendered at furthest indentation along the first direction on said display, means for performing comprising;

responsive to determining that data is associated with a first instance of said first dimension, means for rendering on said display closer to the first instance than to a second instance of said second dimension, at least a top level node of a tree of nodes in association with a first control, wherein said tree of nodes contains said data in one or more child nodes of said top level node and at least said top level node is initially rendered;

wherein a first name of the first dimension is rendered on said display indented furthest along the first direction relative to a second name of a second dimension;

wherein said first instance is rendered indented furthest along the first direction relative to the second instance of said second dimension;

wherein multiple first instances of the first dimension including said first instance are rendered aligned in the second direction relative to one another and aligned in the second direction relative to the first name, and multiple second instances of the second dimension including said second instance are rendered aligned in the second direction relative to one another and aligned in the second direction relative to the second name; and

responsive to user selection of said first control, means for rendering at least one of said child nodes with a second control and with at least said top level node and said names on said display.

24. The apparatus of claim 23, wherein each node of said tree of nodes comprises a row of data.

25. An apparatus comprising a memory and a processor for rendering data on a display, the apparatus comprising:

means for rendering a configurable number of dimensions on said display in a manner that depicts a sequential relationship between said configurable number of dimensions by indentation along a first direction;

wherein each rendered dimension on said display depicts multiple dimension instances aligned relative to one another in a second direction perpendicular to the first direction, and wherein each dimension instance is an instance of a dimension;

for a particular dimension, rendered on said display, having the lowest sequential position in said sequential relationship, means for performing comprising;

responsive to determining that hierarchical data is associated with a particular dimension instance of said particular dimension, means for rendering on said display at least a top level node of a tree of nodes in association with said particular dimension instance and a first control;

wherein a name of the particular dimension is rendered on said display indented relative to another name of another dimension, in a nested manner; and

wherein said particular dimension instance is rendered indented relative to another dimension instance of said another dimension, in said nested manner and corresponding to said dimensions;

wherein multiple particular dimension instances including said particular dimension instance are rendered aligned in the second direction relative to one another and aligned in the second direction relative to the name of the particular dimension and multiple another instances of said another dimension including said another dimension instance are aligned in the second direction relative to one another and aligned in the second direction relative to said another name; and

responsive to user selection of said first control, means for rendering at least one of said nodes with a second control and with said top level node and said names on said display.

26. The apparatus of claim 25, wherein each node of said tree of nodes comprises a row of data.