Analysis of database performance reports for graphical presentation of summary results
View Patent ↗Computer implemented methods, programs and systems for displaying statistical data in a graphical user interface are provided. According to the method, baseline data is imported from a first report which corresponds to a trouble-free period. Similarly, critical data is imported from a second report corresponding to a trouble period. The imported data is compared and analyzed to create a results table, each cell in the results table corresponding to a timestamp and a statistical item. The cells in the results table contain a visual identifier according to the criticality of the comparison of the statistical items from the baseline data and the critical data. The results table is presented on a display to the user.
1. A computer implemented method for displaying statistical data in a graphical user interface, the method comprising:
importing baseline data from a first performance report that includes performance data for a first period identified as having satisfactory performance;
importing critical data from a second performance report that includes performance data for a second period identified as encompassing one or more performance problems;
creating a plurality of results tables, each result table being associated with a node in a database, wherein each row in the results tables corresponds to a statistical item, each column corresponds to a time period and each cell contains a visual identifier corresponding to a criticality value based on a comparison of statistical items from the baseline and the critical data;
combining the plurality of results tables into a summary results table, each cell in the summary results table having a criticality value corresponding to a most critical value of the corresponding cells in the plurality of results tables; and
presenting the summary results table on a display.
2. The computer implemented method as recited in claim 1 , wherein the visual identifier is a color associated with the criticality value of the cell.
3. The computer implemented method as recited in claim 1 , wherein the criticality value is a finite value associated with a deviation of the statistical item in the critical data from the statistical item in the baseline data.
4. The computer implemented method as recited in claim 1 , wherein presenting the summary results table further includes displaying the summary results table by rows and columns.
5. The computer implemented method as recited in claim 1 , further including,
presenting the plurality of results tables on the display.
6. The computer implemented method as recited in claim 5 , further including, assigning a table criticality to each of the plurality of results tables, the table criticality being an aggregate for the criticalities of all the cells in the each of the plurality of results tables, and
sorting the plurality of results tables according to the table criticality before presenting the plurality of results tables.
7. The computer implemented method as recited in claim 6 , further including,
discarding a subset of results tables with a lowest table criticality before presenting the plurality of results tables.
8. The computer implemented method as recited in claim 1 , further including,
adding to each cell in the summary results table a value representing a number of the corresponding cells in the plurality of results tables with a highest criticality value.
9. A computer program embedded in a non-transitory computer-readable storage medium, when executed by one or more processors, for displaying statistical data in a graphical user interface, the computer program comprising:
program instructions for importing baseline data from a first performance report that includes performance data for a first period identified as having satisfactory performance;
program instructions for importing critical data from a second performance report that includes performance data for a second period identified as encompassing one or more performance problems;
program instructions for creating a plurality of results tables, each result table being associated with a node in a database, wherein each row in the results tables corresponds to a statistical item, each column corresponds to a time period and each cell contains a visual identifier corresponding to a criticality value based on a comparison of statistical items from the baseline and the critical data;
program instructions for combining the plurality of results tables into a summary results table, each cell in the summary results table having a criticality value corresponding to a most critical value of the corresponding cells in the plurality of results tables; and
program instructions for presenting the summary results table on a display.
10. The computer program as recited in claim 9 , further comprising,
program instructions for presenting the plurality of results tables on the display.
11. The computer program as recited in claim 9 , further including,
program instructions for creating a zoomed results table for a results table by combining pairs of consecutive cells corresponding to a same statistical item into one cell in the zoomed table.
12. The computer program as recited in claim 10 ,
wherein the database has four nodes,
wherein each cell includes four spaces, and wherein each of the four spaces displays the visual identifier from one of the results tables.
13. The computer program as recited in claim 9 , further including,
a computer program including program instructions to automate a creation and presentation of the summary results table.
14. The computer program as recited in claim 9 , further including,
program instructions to reduce the results table by eliminating rows where all the cells in the row are trouble-free cells, and
program instructions to reduce the results table by eliminating columns where all the cells in the column are trouble-free cells.
15. A system for displaying statistical data in a graphical user interface, the system comprising:
a computer device having a processor; and
a memory, the memory including,
a first report including baseline database data from a first period identified as having satisfactory performance,
a second report including critical data from a second period identified as encompassing one or more performance problems, and
a report analysis program,
wherein program instructions from the report analysis program when executed by the processor cause the processor to,
create a plurality of results tables in memory, each result table being associated with a node in a database, wherein each row in the results tables corresponds to a statistical item, each column corresponds to a time period and each cell contains a visual identifier corresponding to a criticality value based on a comparison of statistical items from the baseline and the critical data,
combine the plurality of results tables into a summary results table, each cell in the summary results table having a criticality value corresponding to a most critical value of the corresponding cells in the plurality of results tables, and
present the summary results table on a display.
16. The system as recited in claim 15 , wherein baseline and critical data is collected every one of ten, fifteen, thirty, or sixty minutes.
17. The system as recited in claim 15 , wherein the statistical item is a wait event in a database.
18. The computer implemented method as recited in claim 1 , wherein the first performance report and the second performance report correspond to a same time period for different days.