METHOD AND SYSTEM FOR OPTIMIZING RENDERING OF DATA TABLES

• US 20140237343A1
• Filed: 02/21/2013
• Published: 08/21/2014
• Est. Priority Date: 02/21/2013
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Villani, Massimo
• Granted Patent: US 10,445,421 B2
• Time in Patent Office: Days
• US Class Current: 715/227
• CPC Class Codes: G06F 40/103 Formatting, i.e. changing of presentation of documents automatic justification G06F40/189; automatic line break hyphenation G06F40/191
• CPC Class Codes: G06F 40/177 of tables; using ruled lines

Abstract

A method, system and computer program product for determining optimal column widths used in the rendering of data tables displayed in a graphical user interface. The method includes receiving a table parameter associated with the contents of the table and determining if the table parameter has changed. If the table parameter has changed, statistical values are calculated for visible columns of the table. A user choice for a run time column width and a default column width are received for each of the columns. A readability index for data displayed in the visible columns is calculated. A maximum readability index for visible columns is calculated. The optimal column widths based on the maximum readability index are determined. The column widths are set to the optimal column widths. The optimal column widths are stored as meta-data. The table of data is displayed using the optimal column widths.

Claims

1. A computer implemented method of rendering a table of data, the method comprising:

receiving at least one table parameter associated with the contents of the table;

determining if the at least one table parameter has changed;

in response to the at least one table parameter changing, calculating based on the table parameter, two or more statistical values for a plurality of visible columns of the table;

receiving a user choice for a run time column width and a default column width associated with a column width for each of the columns in the table;

calculating at least one readability index for data displayed in the visible columns using at least one of a data type, the statistical values, the run time column width and the default column width;

calculating a maximum readability index for the visible columns;

determining based on the maximum readability index, one or more optimal column widths for display of the data;

setting the column widths for the visible columns to the optimal column widths;

storing the optimal column widths as meta-data; and

displaying the table of data using the optimal column widths.

2. The method of claim 1, further comprising:

receiving the meta-data containing the optimal column widths;

determining if the run time column width has changed;

in response to the run time column width being changed, determining new optimal column widths for display of the data;

setting the column widths for visible columns to the new optimal column widths; and

displaying the table of data using the new optimal column widths.

3. The method of claim 1, further comprising:

receiving the meta-data containing the optimal column widths;

determining if the run time column width has changed;

in response to the run time column width not being changed, setting the column widths for visible columns to the optimal columns widths; and

displaying the table of data using the optimal column widths.

4. The method of claim 1, further comprising:

in response to the at least one table parameter not being changed, continuing to receive the at least one table parameter associated with the contents of the table.

5. The method of claim 1, wherein calculating the statistical values further comprises:

calculating an average column width for visible columns; and

calculating a standard deviation of the column widths for visible columns.

6. The method of claim 1, wherein calculating the at least one readability index further comprises:

calculating a worst readability index; and

calculating a best readability index.

7. The method of claim 1, wherein the maximum readability index for visible columns is calculated using a linear optimization system.

8. A data processing system comprising:

at least one memory;

a processor in communication with the memory, the processor operable to execute instructions which cause the processor to;

receive at least one table parameter associated with the contents of the table;

determine if the at least one table parameter has changed;

in response to the at least one table parameter changing, calculate based on the table parameter, two or more statistical values for a plurality of visible columns of the table;

receive a user choice for a run time column width and a default column width associated with a column width for each of the columns in the table;

calculate at least one readability index for data displayed in the visible columns using at least one of a data type, the statistical values, the run time column width and the default column width;

calculate a maximum readability index for visible columns;

determine based on the maximum readability index, one or more optimal column widths for display of the data;

set the column widths for the visible columns to the optimal column widths;

store the optimal column widths as meta-data; and

display the table of data using the optimal column widths.

9. The data processing system of claim 8, further comprising instructions that cause the processor to:

receive the meta-data containing the optimal column widths;

determine if the run time column width has changed;

in response to the run time column width being changed, determine new optimal column widths for display of the data;

set the column widths for visible columns to the new optimal column widths; and

display the table of data using the new optimal column widths.

10. The data processing system of claim 8, further comprising instructions that cause the processor to:

receive the meta-data containing the optimal column widths;

determine if the run time column width has changed;

in response to the run time column width not being changed, set the column widths for visible columns to the optimal column widths; and

display the table of data using the optimal column widths.

11. The data processing system of claim 8, further comprising instructions that cause the processor to:

in response to the at least one table parameter not being changed, continue to receive the at least one table parameter associated with the contents of the table.

12. The data processing system of claim 8, wherein calculating the statistical values further comprises instructions that cause the processor to:

calculate an average column width for visible columns; and

calculate a standard deviation of the column widths for visible columns.

13. The data processing system of claim 8, wherein calculating the at least one reliability index further comprises instructions that cause the processor to:

calculate a worst readability index; and

calculate a best readability index.

14. The data processing system of claim 8, wherein the maximum readability index for visible columns is calculated using a linear optimization system.

15. A computer program product comprising:

a computer readable storage device; and

program code on the computer readable storage device that when executed within a data processing device, the program code provides the functionality of;

receiving at least one table parameter associated with the contents of the table;

determining if the at least one table parameter has changed;

in response to the at least one table parameter changing, calculating based on the table parameter, two or more statistical values for a plurality of visible columns of the table;

receiving a user choice for a run time column width and a default column width associated with a column width for each of the columns in the table;

calculating at least one readability index for data displayed in the visible columns using at least one of a data type, the statistical values, the run time column width and the default column width;

calculating a maximum readability index for visible columns;

determining based on the maximum readability index, one or more optimal column widths for display of the data;

setting the column widths for the visible columns to the optimal column widths;

storing the optimal column widths as meta-data; and

displaying the table of data using the optimal column widths.

16. The computer program product of claim 15, further comprising program code on the computer readable storage device that when executed within the data processing device, the program code provides the functionality of:

receiving the meta-data containing the optimal column widths;

determining if the run time column width has changed;

in response to the run time column width being changed, determining new optimal column widths for display of the data;

setting the column widths for visible columns to the new optimal column widths; and

displaying the table of data using the new optimal column widths.

17. The computer program product of claim 15, further comprising program code on the computer readable storage device that when executed within the data processing device, the program code provides the functionality of:

receiving the meta-data containing the optimal column widths;

determining if the run time column width has changed;

in response to the run time column width not being changed, setting the column widths for visible columns to the optimal columns widths; and

displaying the table of data using the optimal column widths.

18. The computer program product of claim 15, further comprising program code on the computer readable storage device that when executed within the data processing device, the program code provides the functionality of:

in response to the at least one table parameter not being changed, continuing to receive the at least one table parameter associated with the contents of the table.

19. The computer program product of claim 15, wherein calculating the statistical values further comprises program code on the computer readable storage device that when executed within the data processing device, the program code provides the functionality of:

calculating an average column width for visible columns; and

calculating a standard deviation of the column widths for visible columns.

20. The computer program product of claim 15, wherein calculating the at least one readability index further comprises program code on the computer readable storage device that when executed within the data processing device, the program code provides the functionality of:

calculating a worst readability index; and

calculating a best readability index.