System and method for managing presentation of data

• US 20050198011A1
• Filed: 03/04/2004
• Published: 09/08/2005
• Est. Priority Date: 03/04/2004
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Barsness, Eric L., Santosuosso, John M., Ruhlow, Randy W.
• Granted Patent: US 7,171,424 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: Y10S 707/954 Relational
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

A system, method and article of manufacture for presentation of data on a display device and, more particularly, for managing presentation of data in a tabular form on a display device. One embodiment provides a method of managing display of requested data on a display device. The method comprises, in response to a request for data, receiving the requested data in a tabular form having a plurality of columns and rows ordered according to an initial order; re-ordering at least one of the columns and rows, wherein the re-ordering is done on the basis of rules configured to intelligently arrange presentation of the requested data to a user; and outputting the re-ordered requested data for display on the display device.

Claims

1. A method of managing display of requested data on a display device, the method comprising:

in response to a request for data, receiving the requested data in a tabular form having a plurality of columns and rows ordered according to an initial order;

re-ordering at least one of the columns and rows, wherein the re-ordering is done on the basis of rules configured to intelligently arrange presentation of the requested data to a user; and

outputting the re-ordered requested data for display on the display device.

2. The method of claim 1, further comprising:

determining at least one of a weighting for each column and a weighting for each row of the plurality of columns and rows; and

wherein the re-ordering is performed on the basis of the determined weightings.

3. The method of claim 2, wherein the determined weightings are based on at least one of:

(i) metadata describing an organizational structure of the requested data in the data source, (ii) statistical analysis information associated with the requested data in the data source, (iii) attributes of the request for data, (iv) historical information concerning the requested data, and (v) properties of the requested data.

4. The method of claim 1, further comprising:

determining data abnormalities in the requested data.

5. The method of claim 1, wherein the request for data is a query issued against a database and the requested data is a query result.

6. The method of claim 1, wherein the requested data is received from a server-side data source and the re-ordering is done by a client-side application.

7. The method of claim 1, wherein the re-ordering is done for emphasizing critical data.

8. The method of claim 1, further comprising:

determining, from the data source, metadata describing an organizational structure of the requested data; and

wherein the re-ordering is performed on the basis of the determined metadata.

9. The method of claim 8, wherein the determined metadata includes metadata related to N columns of the plurality of columns, where N is an integer.

10. The method of claim 9, wherein the determined metadata describes for each of the N columns at least one of:

(i) an index over the column;

(ii) a previously created temporary index over the column;

(iii) a referential constraint over the column;

(iv) a check constraint over the column;

(v) a key associated with the column;

(vi) a trigger associated with the column;

(vii) a point of time associated with creation of the column; and

(viii) a character code set used in the column.

11. The method of claim 8, wherein the determined metadata describes whether one or more of the plurality of columns and rows is hidden in the data source.

12. The method of claim 8, wherein the determined metadata describes whether one or more of the plurality of columns and rows has been sorted in the data source.

13. The method of claim 1, further comprising:

performing statistical analysis for the requested data to generate statistical information; and

wherein the re-ordering is performed on the basis of the statistical information.

14. The method of claim 13, wherein the statistical information describes for each column of N columns of the plurality of columns, where N is an integer:

(i) a frequency of display;

(ii) a frequency of selection;

(iii) a frequency of update;

(iv) a total number of contained values; and

(v) a number of unique contained values.

15. The method of claim 13, wherein the statistical information describes for each row of M rows of the plurality of rows, where M is an integer:

(i) a frequency of display;

(ii) a frequency of selection;

(iii) a frequency of update;

(iv) a total number of contained values; and

(v) a number of unique contained values.

16. The method of claim 13, wherein the statistical information describes physical locations in the data source.

17. The method of claim 1, further comprising:

determining attributes of the request for data; and

wherein the re-ordering is performed on the basis of the determined attributes.

18. The method of claim 17, wherein the request for data is a SQL query issued against a database, the requested data is a query result and the attributes indicate for each column of the plurality of columns whether the column is included in one of a WHERE clause, an ORDER BY clause and a GROUP BY clause of the SQL query.

19. The method of claim 1, further comprising:

determining historical information parameters for the requested data; and

wherein the re-ordering is performed on the basis of the determined historical information parameters.

20. The method of claim 19, wherein the historical information parameters describe for each column of N columns of the plurality of columns, where N is an integer, at least one of:

(i) a previous user interaction with the column;

(ii) a previous user selection of the column; and

(iii) a previous request for the column in similar requests for data.

21. The method of claim 19, wherein the historical information parameters describe for each row of M rows of the plurality of rows, where M is an integer, at least one of:

(i) a previous user interaction with the row;

(ii) a previous user selection of the row; and

(iii) a previous request for the row in similar requests for data.

22. The method of claim 1, further comprising:

determining properties of the requested data; and

wherein the re-ordering is performed on the basis of the determined properties.

23. The method of claim 22, wherein the determined properties include properties related to N columns of the plurality of columns, where N is an integer.

25. A computer readable medium containing a program which, when executed, performs a process of managing display of requested data on a display device, the process comprising:

in response to a request for data, receiving the requested data in a tabular form having a plurality of columns and rows ordered according to an initial order;

re-ordering at least one of the columns and rows, wherein the re-ordering is done on the basis of rules configured to intelligently arrange presentation of the requested data to a user; and

outputting the re-ordered requested data for display on the display device.

24. The method of claim 26, wherein the determined properties describe for each of the N columns at least one:

(i) the contained values;

(ii) a similarity between contained values;

(iii) a total number of contained values;

(iv) a range of contained values; and

(v) a size of the column.

26. The computer readable medium of claim 25, wherein the process further comprises:

determining at least one of a weighting for each column and a weighting for each row of the plurality of columns and rows; and

wherein the re-ordering is performed on the basis of the determined weightings.

27. The computer readable medium of claim 26, wherein the determined weightings are based on at least one of:

(i) metadata describing an organizational structure of the requested data in the data source, (ii) statistical analysis information associated with the requested data in the data source, (iii) attributes of the request for data, (iv) historical information concerning the requested data, and (v) properties of the requested data.

28. The computer readable medium of claim 25, wherein the process further comprises:

determining data abnormalities in the requested data.

29. The computer readable medium of claim 25, wherein the request for data is a query issued against a database and the requested data is a query result.

30. The computer readable medium of claim 25, wherein the requested data is received from a server-side data source and the re-ordering is done by a client-side application.

31. The computer readable medium of claim 25, wherein the re-ordering is done for emphasizing critical data.

32. The computer readable medium of claim 25, wherein the process further comprises:

determining, from the data source, metadata describing an organizational structure of the requested data; and

wherein the re-ordering is performed on the basis of the determined metadata.

33. The computer readable medium of claim 32, wherein the determined metadata includes metadata related to N columns of the plurality of columns, where N is an integer.

34. The computer readable medium of claim 33, wherein the determined metadata describes for each of the N columns at least one of:

(i) an index over the column;

(ii) a previously created temporary index over the column;

(iii) a referential constraint over the column;

(iv) a check constraint over the column;

(v) a key associated with the column;

(vi) a trigger associated with the column;

(vii) a point of time associated with creation of the column; and

(viii) a character code set used in the column.

35. The computer readable medium of claim 32, wherein the determined metadata describes whether one or more of the plurality of columns and rows is hidden in the data source.

36. The computer readable medium of claim 32, wherein the determined metadata describes whether one or more of the plurality of columns and rows has been sorted in the data source.

37. The computer readable medium of claim 25, wherein the process further comprises:

performing statistical analysis for the requested data to generate statistical information; and

wherein the re-ordering is performed on the basis of the determined statistical information.

38. The computer readable medium of claim 37, wherein the determined statistical information describes for each column of N columns of the plurality of columns, where N is an integer:

(i) a frequency of display;

(ii) a frequency of selection;

(iii) a frequency of update;

(iv) a total number of contained values; and

(v) a number of unique contained values.

39. The computer readable medium of claim 37, wherein the determined statistical information describes for each row of M rows of the plurality of rows, where M is an integer:

(i) a frequency of display;

(ii) a frequency of selection;

(iii) a frequency of update;

(iv) a total number of contained values; and

(v) a number of unique contained values.

40. The computer readable medium of claim 37, wherein the determined statistical information describes physical locations in the data source.

41. The computer readable medium of claim 25, wherein the process further comprises:

determining attributes of the request for data; and

wherein the re-ordering is performed on the basis of the determined attributes.

42. The computer readable medium of claim 41, wherein the request for data is a SQL query issued against a database, the requested data is a query result and the attributes indicate for each column of the plurality of columns whether the column is included in one of a WHERE clause, an ORDER BY clause and a GROUP BY clause of the SQL query.

43. The computer readable medium of claim 25, wherein the process further comprises:

determining historical information parameters for the requested data; and

wherein the re-ordering is performed on the basis of the determined historical information parameters.

44. The computer readable medium of claim 43, wherein the historical information parameters describe for each column of N columns of the plurality of columns, where N is an integer, at least one of:

(i) a previous user interaction with the column;

(ii) a previous user selection of the column; and

(iii) a previous request for the column in similar requests for data.

45. The computer readable medium of claim 43, wherein the historical information parameters describe for each row of M rows of the plurality of rows, where M is an integer, at least one of:

(i) a previous user interaction with the row;

(ii) a previous user selection of the row; and

(iii) a previous request for the row in similar requests for data.

46. The computer readable medium of claim 25, wherein the process further comprises:

determining properties of the requested data; and

wherein the re-ordering is performed on the basis of the determined properties.

47. The computer readable medium of claim 46, wherein the determined properties include properties related to N columns of the plurality of columns, where N is an integer.

48. The computer readable medium of claim 47, wherein the determined properties describe for each of the N columns at least one:

(i) the contained values;

(ii) a similarity between contained values;

(iii) a total number of contained values;

(iv) a range of contained values; and

(v) a size of the column.

49. A data processing system comprising:

a data source;

a display device; and

a re-ordering application program residing in memory for managing display of requested data on the display device, the re-ordering application program being configured for;

in response to a request for data, receiving the requested data in a tabular form having a plurality of columns and rows ordered according to an initial order;

re-ordering at least one of the columns and rows, wherein the re-ordering is done on the basis of rules configured to intelligently arrange presentation of the requested data to a user; and

outputting the re-ordered requested data for display on the display device.

50. The data processing system of claim 49, further comprising:

a requesting application program residing in memory for issuing the request for data.