Matrix Tree Presentation Structures

• US 20100125779A1
• Filed: 11/19/2008
• Published: 05/20/2010
• 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
• Granted Patent: US 8,327,256 B2
• Time in Patent Office: Days
• US Class Current: 715/227
• CPC Class Codes: G06F 16/248 Presentation of query results

Abstract

Approaches for rendering data on a display are provided using matrix tree and matrix tree table presentation structures. A matrix table is rendered on a display. The matrix table comprises a set of columns and a set of rows. Each column is associated with a different dimension instance of a first dimension, and each row is associated with a different dimension instance of a second dimension. The intersection of each column and row is a cell. In one approach, a tree of nodes is rendered within at least one cell of the matrix table. In another approach, a tree table is rendered within at least one cell of the matrix table. The tree table comprises a tree of nodes, where each node of the tree of nodes comprises a row of data. A tree of nodes in a cell of the matrix table may be expanded or collapsed upon request.

Claims

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

rendering a matrix table on said display, wherein said matrix table comprises a set of columns and a set of rows, wherein each column in said set of columns contains data pertaining to a different instance of a first dimension, wherein each row in said set of rows contains data pertaining to a different instance of a second dimension, wherein the first dimension is different than said second dimension, and wherein the intersection of each column, of said set of columns, with each row, of said set of rows, is a cell; and

rendering, within at least one cell of said matrix table, a tree table, wherein said tree table comprises a tree of nodes, and wherein each node of said tree of nodes comprises a row of data.

2. The method of claim 1, wherein said tree of nodes includes at least a top level node and one or more child nodes of said top level node, and wherein only said top level node of said tree of nodes is rendered on said display.

3. The method of claim 1, wherein said tree of nodes includes at least a top level node and 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:

in response to receiving user input, causing said one or more child nodes of said top level node to be 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 includes at least a top level node and 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:

in response to receiving user input that selects said top level node, 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 input 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 said data rendered on said display includes both hierarchical data and relational data, wherein said hierarchical data is rendered in said tree of nodes, and wherein said relational data is rendered in said matrix table.

6. The method of claim 1, wherein one or more cells of said matrix table do not contain a tree table.

7. 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.

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

rendering a matrix table on said display, wherein said matrix table comprises a set of columns and a set of rows, wherein each column in said set of columns contains data pertaining to a different instance of a first dimension, wherein each row in said set of rows contains data pertaining to a different instance of a second dimension, wherein said first dimension is different than said second dimension, and wherein the intersection of each column of said matrix table with each row of said matrix table is a cell;

rendering, within a first cell of said matrix table, a first tree of nodes; and

rendering, within a different cell of said matrix table than said first cell, a second tree of nodes,

wherein said first tree of nodes displays hierarchical data for a first pair of instances of dimensions, wherein said second tree of nodes displays hierarchical data for a second pair of instances of dimensions, and wherein said first pair of instances of dimensions is different than said second pair of instances of dimensions.

9. The method of claim 8, wherein said first tree of nodes includes a top level node and one or more child nodes of said top level node, and wherein only said top level node of said first tree of nodes is rendered on said display.

10. The method of claim 8, wherein said first tree of nodes includes at least a top level node and one or more child nodes of said top level node, and wherein only said top level node of said first tree of nodes is initially rendered on said display, and wherein the method further comprises:

in response to receiving user input, causing said one or more child nodes of said top level node to be 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.

11. The method of claim 8, wherein said first tree of nodes includes at least a top level node and one or more child nodes of said top level node, and wherein only said top level node of said first tree of nodes is initially rendered on said display, and wherein the method further comprises:

in response to receiving user input that selects said top level node, 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 said user input is received, and

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

12. The method of claim 8, wherein said data rendered on said display includes both hierarchical data and relational data, wherein said hierarchical data is rendered in said first tree of nodes and said second tree of nodes, and wherein said relational data is rendered in said matrix table.

13. The method of claim 8, wherein one or more cells of said matrix table do not contain a tree of nodes.

14. A machine-readable storage medium storing one or more sequences of instructions for rendering data on a display, which when executed, cause:

rendering a matrix table on said display, wherein said matrix table comprises a set of columns and a set of rows, wherein each column in said set of columns contains data pertaining to an instance of a first dimension, wherein each row in said set of rows contains data pertaining to an instance of a different dimension than said first dimension, and wherein the intersection of each column, of said set of columns, with each row, of said set of rows, is a cell; and

rendering, within at least one cell of said matrix table, a tree table, wherein said tree table comprises a tree of nodes, and wherein each node of said tree of nodes comprises a row of data.

15. The machine-readable storage medium of claim 14, wherein said tree of nodes includes at least a top level node and one or more child nodes of said top level node, and wherein only said top level node of said tree of nodes is rendered on said display.

16. The machine-readable storage medium of claim 14, wherein said tree of nodes includes at least a top level node and 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 said one or more sequences of instructions further causes:

in response to receiving user input, causing said one or more child nodes of said top level node to be 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.

17. The machine-readable storage medium of claim 14, wherein said tree of nodes includes at least a top level node and 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 said one or more sequences of instructions further causes:

in response to receiving user input that selects said top level node, 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 input is received, and

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

18. The machine-readable storage medium of claim 14, wherein said data rendered on said display includes both hierarchical data and relational data, wherein said hierarchical data is rendered in said tree of nodes, and wherein said relational data is rendered in said matrix table.

19. The machine-readable storage medium of claim 14, wherein one or more cells of said matrix table do not contain a tree table.

20. The machine-readable storage medium of claim 14, wherein a particular node of said tree of nodes contains a link to a web page that contains additional information about said particular node.

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

rendering a matrix table on said display, wherein said matrix table comprises a set of columns and a set of rows, wherein each column in said set of columns contains data pertaining to an instance of a first dimension, wherein each row in said set of rows contains data pertaining to an instance of a different dimension than said first dimension, and wherein the intersection of each column of said matrix table with each row of said matrix table is a cell;

rendering, within a first cell of said matrix table, a first tree of nodes; and

rendering, within a different cell of said matrix table than said first cell, a second tree of nodes,

wherein said first tree of nodes displays hierarchical data for a first pair of instances of dimensions, wherein said second tree of nodes displays hierarchical data for a second pair of instances of dimensions, and wherein said first pair of instances of dimensions is different than said second pair of instances of dimensions.

22. The machine-readable storage medium of claim 21, wherein said first tree of nodes includes a top level node and one or more child nodes of said top level node, and wherein only said top level node of said first tree of nodes is rendered on said display.

23. The machine-readable storage medium of claim 21, wherein said first tree of nodes includes at least a top level node and one or more child nodes of said top level node, and wherein only said top level node of said first tree of nodes is initially rendered on said display, and wherein execution of said one or more sequences of instructions further causes:

in response to receiving user input, causing said one or more child nodes of said top level node to be 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.

24. The machine-readable storage medium of claim 21, wherein said first tree of nodes includes at least a top level node and one or more child nodes of said top level node, and wherein only said top level node of said first tree of nodes is initially rendered on said display, and wherein execution of said one or more sequences of instructions further causes:

in response to receiving user input that selects said top level node, 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 said user input is received, and

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

25. The machine-readable storage medium of claim 21, wherein said data rendered on said display includes both hierarchical data and relational data, wherein said hierarchical data is rendered in said first tree of nodes and said second tree of nodes, and wherein said relational data is rendered in said matrix table.