Matrix tree presentation structures

• US 8,327,256 B2
• Filed: 11/19/2008
• Issued: 12/04/2012
• 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): Hutton, Jr., Doug
• Assistant Examiner(s): Garmon, Brian
• Application Number:
  US12/274,172
• Publication Number:
  US 20100125779A1
• Time in Patent Office: 1,476 Days
• Field of Search: 715/201, 715/215, 715/227, 715/214, 707/798
• US Class Current: 715/214
• 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 plurality of matrix-level columns and a plurality of matrix-level rows;

wherein a first matrix-level column in said plurality of matrix-level columns contains data pertaining to a first instance of a first dimension, said first matrix-level column being identified on said display by a first matrix-level column name;

wherein a second matrix-level column in said plurality of matrix-level columns contains data pertaining to a second instance of said first dimension, said second matrix-level column being identified on said display by a second matrix-level column name;

wherein a first matrix-level row in said plurality of matrix-level rows contains data pertaining to a first instance of a second dimension, said first matrix-level row being identified on said display by a first matrix-level row name;

wherein a second matrix-level row in said plurality of matrix-level rows contains data pertaining to a second instance of said second dimension, said second matrix-level row being identified on said display by a second matrix-level row name;

wherein the first dimension is displayed perpendicular to said second dimension;

wherein said matrix table comprises a plurality of matrix-level cells formed by intersection of each matrix-level column in said plurality of matrix-level columns, with each matrix-level row in said plurality of matrix-level rows;

rendering, within at least a first matrix-level cell of said matrix table, a first expandable tree by including in a first cell-level row within a common matrix-level row in the plurality of matrix-level rows, a first top level node and a first control which allows expanded display of child nodes of the first top level node in additional cell-level rows in said common matrix-level row; and

rendering, within at least a second matrix-level cell of said matrix table, a second expandable tree by including in said first cell-level row within said common matrix-level row, a second top level node and a second control which allows expanded display of at least one child node of the second top level node in at least one of said additional cell-level rows in the common matrix-level row;

wherein said first expandable tree and said second expandable tree are displayed next to one another within said common matrix-level row, in the first matrix-level column and in the second matrix-level column respectively; and

wherein a plurality of first cell-level columns in the first matrix-level cell are identified in said display by a plurality of column names, and a plurality of second cell-level columns in the second matrix-level cell are identified in said display by another plurality of column names.

2. The method of claim 1, wherein said first expandable tree comprises one or more child nodes of said first top level node, and wherein only said first top level node of said first expandable tree of nodes is rendered on said display.

3. The method of claim 1, wherein said first expandable tree comprises one or more child nodes of said first top level node, and wherein only said first top level node of said first expandable 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 first 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 first top level node.

4. The method of claim 1, wherein first expandable tree comprises one or more child nodes of said first top level node, and wherein only said first top level node of said first expandable tree of nodes is initially rendered on said display, and wherein the method further comprises, in response to receiving user input that selects said first top level node:

retrieving child data corresponding to said one or more child nodes of said first 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 obtained by said retrieving.

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 first expandable 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 another tree table.

7. The method of claim 1, wherein a particular node of said first expandable 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 plurality of matrix-level columns and a plurality of matrix-level rows;

wherein a first matrix-level column in said plurality of matrix-level columns contains data pertaining to a first instance of a first dimension, said first matrix-level column being identified on said display by a first matrix-level column name;

wherein a second matrix-level column in said plurality of matrix-level columns contains data pertaining to a second instance of said first dimension, said second matrix-level column being identified on said display by a second matrix-level column name;

wherein a first matrix-level row in said plurality of matrix-level rows contains data pertaining to a first instance of a second dimension, said first matrix-level row being identified on said display by a first matrix-level row name;

wherein a second matrix-level row in said plurality of matrix-level rows contains data pertaining to a second instance of said second dimension, said second matrix-level row being identified on said display by a second matrix-level row name;

wherein the first dimension is displayed perpendicular to said second dimension;

wherein said matrix table comprises a plurality of matrix-level cells formed by intersection of each matrix-level column of said matrix table with each matrix-level row of said matrix table;

wherein a first matrix-level cell and a second matrix-level cell in said plurality of matrix-level cells are both present in a common matrix-level row in said plurality of matrix-level rows;

rendering, within at least the first matrix-level cell of said matrix table, a first expandable tree of nodes by including in a first cell-level row within a common matrix-level row in the plurality of matrix-level rows, a first top level node and a first control which allows expanded display of child nodes of the first top level node in additional cell-level rows in said common matrix-level row; and

rendering, within at least the second matrix-level cell of said matrix table, a second expandable tree of nodes by including in said first cell-level row within said common matrix-level row, a second top level node and a second control which allows expanded display of at least one child node of the second top level node in at least one of said additional cell-level rows in the common matrix-level row;

wherein said first expandable tree of nodes displays hierarchical data for the first instance of the first dimension in said additional cell-level rows, wherein said second expandable tree of nodes also displays hierarchical data for the second instance of the first dimension in said additional cell-level rows.

9. The method of claim 8, wherein said first expandable 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 expandable tree of nodes is rendered on said display.

10. The method of claim 8, wherein said first expandable 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 expandable 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 expandable 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 expandable 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:

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 expandable tree of nodes and said second expandable 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. One or more non-transitory computer readable media comprising a plurality of instructions that when executed by one or more processors coupled to a display cause:

rendering a matrix table on said display, wherein said matrix table comprises a plurality of matrix-level columns and a plurality of matrix-level rows;

wherein a first matrix-level column in said plurality of matrix-level columns contains data pertaining to a first instance of a first dimension, said first matrix-level column being identified on said display by a first matrix-level column name;

wherein a second matrix-level column in said plurality of matrix-level columns contains data pertaining to a second instance of said first dimension, said second matrix-level column being identified on said display by a second matrix-level column name;

wherein a first matrix-level row in said plurality of matrix-level rows contains data pertaining to a first instance of a second dimension, said first matrix-level row being identified on said display by a first matrix-level row name;

wherein a second matrix-level row in said plurality of matrix-level rows contains data pertaining to a second instance of said second dimension, said second matrix-level row being identified on said display by a second matrix-level row name;

wherein the first dimension is displayed perpendicular to said second dimension;

wherein said matrix table comprises a plurality of matrix-level cells formed by intersection of each matrix-level column in said plurality of matrix-level columns, with each matrix-level row in said plurality of matrix-level rows; and

wherein a first matrix-level cell and a second matrix-level cell in said plurality of matrix-level cells are both displayed in a common matrix-level row in said plurality of matrix-level rows;

rendering, within at least said first matrix-level cell of said matrix table, a first tree table that comprises a first expandable tree of nodes, by including in a first cell-level row within a common matrix-level row in the plurality of matrix-level rows, a first top level node and a first control which allows expanded display of child nodes of the first top level node in additional cell-level rows in said common matrix-level row;

wherein a plurality of first cell-level columns in the first matrix-level cell are identified in said display by a plurality of column names, and a plurality of second cell-level columns in the second matrix-level cell are identified in said display by another plurality column names identical to said plurality of column names;

rendering, within at least said second matrix-level cell of said matrix table, a second tree table that comprises a second expandable tree of nodes, by including in said first cell-level row within said common matrix-level row in the plurality of matrix-level rows, a second top level node and a second control which allows expanded display of at least one child node of the second top level node in at least one of said additional cell-level rows in the common matrix-level row.

15. The one or more non-transitory computer readable media of claim 14, wherein said node is a top level node and said first tree comprises 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 by execution of said plurality of instructions.

16. The one or more non-transitory computer readable media 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 first tree of nodes, and wherein said relational data is rendered in said matrix table and the method further comprises rendering within at least said second matrix-level cell of said matrix table, a second tree table.

17. One or more non-transitory computer readable media comprising a plurality of instructions that when executed by one or more processors coupled to a display cause:

rendering a matrix table on said display, wherein said matrix table comprises a plurality of matrix-level columns and a plurality of matrix-level rows;

wherein a first matrix-level column in said plurality of matrix-level columns contains data pertaining to a first instance of a first dimension, said first matrix-level column being identified on said display by a first matrix-level column name;

wherein a second matrix-level column in said plurality of matrix-level columns contains data pertaining to a second instance of said first dimension, said second matrix-level column being identified on said display by a second matrix-level column name;

wherein a first matrix-level row in said plurality of matrix-level rows contains data pertaining to a first instance of a second dimension, said first matrix-level row being identified on said display by a first matrix-level row name;

wherein a second matrix-level row in said plurality of matrix-level rows contains data pertaining to a second instance of said second dimension, said second matrix-level row being identified on said display by a second matrix-level row name;

wherein the first dimension is displayed perpendicular to said second dimension;

wherein said matrix table comprises a plurality of matrix-level cells formed by intersection of each matrix-level column of said matrix table with each matrix-level row of said matrix table;

wherein a first matrix-level cell and a second matrix-level cell in said plurality of matrix-level cells are both present in a common matrix-level row in said plurality of matrix-level rows;

rendering, within at least the first matrix-level cell of said matrix table, a first expandable tree of nodes, by including in a first cell-level row within a common matrix-level row in the plurality of matrix-level rows, a first top level node and a first control which allows expanded display of child nodes of the first top level node in additional cell-level rows in said common matrix-level row; and

rendering, within at least the second matrix-level cell of said matrix table, a second expandable tree of nodes by including in said first cell-level row within said common matrix-level row, a second top level node and a second control which allows expanded display of at least one child node of the second top level node in at least one of said additional cell-level rows in the common matrix-level row;

wherein said first expandable tree of nodes displays hierarchical data for the first instance of the first dimension in a plurality of cell-level rows, wherein said second expandable tree of nodes displays hierarchical data for the second instance of the first dimension in said plurality of cell-level rows.

18. The one or more non-transitory computer readable media of claim 17, wherein said first expandable 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 expandable tree of nodes is rendered on said display by execution of said plurality of instructions.

19. The one or more non-transitory computer readable media of claim 17, wherein said data rendered on said display includes both hierarchical data and relational data, wherein said hierarchical data is rendered in said first expandable tree of nodes and said second expandable tree of nodes, and wherein said relational data is rendered in said matrix table.