Systems and methods for displaying data including hierarchical headers

Patent metadata

Field	Value
Publication number	US-11501062-B1
Application number	US-202016790487-A
Country	US
Kind code	B1
Filing date	Feb 13, 2020
Priority date	Feb 13, 2020
Publication date	Nov 15, 2022
Grant date	Nov 15, 2022

Abstract

Systems and methods for displaying hierarchical table headers as disclosed. The systems and methods can include operations performed by a viewer engine. The operations can include detecting a user interaction with a display of a portion of data. The operations can further include determining a second portion of the data to display. The operations can additionally include obtaining data information for the second portion of the data. The data information can include information about headers for the second portion of the data and information about child-parent relationships between the headers. The operations can include determining one or more hierarchical headers for the second portion of the data. The operations can further include rendering a table including the second portion of the data. The operations can additionally include displaying a display depicted the one or more hierarchical headers and a subset of the table including the second portion of the data.

First claim

What is claimed is:

1. A non-transitory, computer-readable medium containing instructions that, when executed by at least one processor of a system, cause the system to perform operations, comprising:
detecting, by a viewer engine, a user interaction with a display of a portion of data;
determining, by the viewer engine and based on the user interaction, a second portion of the data to display;
obtaining, by the viewer engine from a view model, data information for the second portion of the data, the data information comprising:
information about headers for the second portion of the data, and
information about child-parent relationships between the headers;

creating, by the viewer engine using the data information, a table including one or more hierarchical headers, creation of the table comprising:
determining, by back-tracing the child-parent relationships between the headers from child headers to parent headers, a hierarchical relationship among individual headers in a hierarchical header of the one or more hierarchical headers;
determining a first number of levels of the hierarchical header based on the hierarchical relationship;
determining positions and extents for the individual headers based on the hierarchical relationship; and
determining a second number of levels in the hierarchical header, the second number being a number of the levels in the hierarchical header spanned by one of the individual headers, the determination of the second number comprising:
determining that the one of the individual headers is a leaf node in a tree representing child-parent relationships among the individual headers;
determining a depth of the one of the individual headers in the tree; and
allocating a number of additional levels to the one of the individual headers based on the first number of levels of the hierarchical header and the depth of the one of the individual headers in the tree; and

displaying, by the viewer engine, a display depicting at least a subset of the table including the second portion of the data.

2. The non-transitory, computer-readable medium of claim 1 , wherein obtaining the data information comprises:
requesting, by the viewer engine from the view model, the data information; and
receiving the data information in response to the request.

3. The non-transitory, computer-readable medium of claim 1 , wherein obtaining the data information comprises:
receiving data information pushed to the viewer engine by the view model.

4. The non-transitory, computer-readable medium of claim 1 , wherein the method further comprises:
receiving, by the view model from a datasource, the data information in response to a request from the view model to the datasource; or
receiving, by the view model from the datasource, data streamed by the datasource.

5. The non-transitory, computer-readable medium of claim 4 , wherein:
the view model receives data streamed by the datasource; and
the datasource comprises a software tool, network edge device, or sensor configured to generate streaming data.

6. The non-transitory, computer-readable medium of claim 1 , wherein:
the user interaction comprises adjustment of a position in a scrollbar; and
determining an updated portion of the table to display comprises mapping the adjusted position in the scrollbar to at least one of a row index or column index for the data based on a total number of rows or columns for the data.

7. The non-transitory, computer-readable medium of claim 1 , wherein:
a number of rows or columns for the portion of the data depends on a width of the display and an estimated row height or column width.

8. The non-transitory, computer-readable medium of claim 1 , wherein:
the first number of levels of the hierarchical header is based on:
a maximum tree height for the hierarchical header; and
a previous maximum number of levels.

9. The non-transitory, computer-readable medium of claim 1 , wherein:
determining extents for the individual headers based on the child-parent relationships comprises:
determining extents of child headers of a second one of the individual headers; and
determining an extent of the second one of the individual headers based on the determined extents of the child headers.

10. The non-transitory, computer-readable medium of claim 1 , wherein:
the user interaction comprises selecting a level in the hierarchical header, and
scrolling through adjacent sets of rows or columns, the adjacent sets corresponding to adjacent headers at the selected level in the hierarchical header.

11. The non-transitory, computer-readable medium of claim 1 , wherein:
the display depicts a subset of rows and columns in the table.

12. A method, comprising:
receiving, by a viewer engine in response to a user interaction, data information from a view model, the data information comprising:
information about column headers for a portion of data, and
information about child-parent relationships between the column headers;

creating a hierarchical column header, creation of the hierarchical column header comprising:
back-tracing the child-parent relationships for the column headers from child headers to parent headers to determine a hierarchical relationship among the column headers; and
determining a number of levels in the hierarchical column header based on the child-parent relationships, the determination comprising:
determining a maximum height among trees representing child-parent relationships for the column headers; and
comparing the maximum height to a maximum number of levels determined for previously displayed hierarchical headers; and

displaying the portion of the data together with the hierarchical column header.

13. The method of claim 12 , wherein:
creation of the hierarchical column header comprises:
positioning the column headers in the hierarchical column header based on the child-parent relationships between the column headers.

14. The method of claim 12 , wherein:
creation of the hierarchical column header comprises:
determining extents for the column headers based on the child-parent relationships, comprising:
determining extents of child column headers of one of the column headers; and
determining an extent of the one of the column headers based on the determined extents of the child column headers.

15. The method of claim 12 , wherein the method further comprises:
receiving, by the view model from a datasource, the data information in response to a request from the view model to the datasource; or
receiving, by the view model from the datasource, data streamed by the datasource.

16. The method of claim 12 , wherein:
the view model receives data streamed by a datasource; and
the datasource comprises a software tool, network edge device, or sensor configured to generate streaming data.

17. The method of claim 12 , wherein:
the user interaction comprises adjustment of a position in a scrollbar; and
the data information received from the view model is requested by the viewer engine based on a mapping of the adjusted position in the scrollbar to at least one of a row index or column index for the data based on a total number of rows or columns for the data.

18. A system comprising:
at least one processor; and
at least one non-transitory, computer-readable medium containing instructions that, when executed by the at least one processor, cause the system to perform operations comprising:
receiving, by a viewer engine in response to a user interaction, data information from a view model, the da

Assignees

• Mathworks Inc

Inventors

• Santos Peter
• Voccia Jason
• Jani Divyesh
• Scaringi Stephen

Classifications

• G06F40/18 Primary

  of spreadsheets (form-filling G06F40/174) · CPC title

• G06F40/137

  Hierarchical processing, e.g. outlines · CPC title

• G06F3/0485

  Scrolling or panning · CPC title

• G06F3/04855

  Interaction with scrollbars · CPC title