System, method and apparatus for wireless monitoring and management of computer systems

• US RE41,902 E1
• Filed: 08/03/2006
• Issued: 10/26/2010
• Est. Priority Date: 11/09/2000
• Status: Expired due to Term

• Current Assignee: Byteweavr, LLC (Ascend Innovation Management, LLC)
• Original Assignee: Stavros Investments LLC (Intellectual Ventures LLC)
• Inventors: Kaplan, Ari David
• Primary Examiner(s): LEROUX, ETIENNE PIERRE
• Application Number:
  US11/498,300
• Time in Patent Office: 1,545 Days
• Field of Search: 707/1, 707/2, 707/3, 707/10, 707/104.1, 707/102, 715/798, 709/203, 709/217
• US Class Current: 1/1
• CPC Class Codes: G06F 16/9577 Optimising the visualization of content, e.g. distillation of HTML documents
• CPC Class Codes: G06F 21/6227 where protection concerns the structure of data, e.g. records, types, queries
• CPC Class Codes: H04L 63/0428 wherein the data content is protected, e.g. by encrypting or encapsulating the payload
• CPC Class Codes: H04L 63/166 at the transport layer
• CPC Class Codes: H04L 67/04 specially adapted for terminals or networks with limited capabilities; specially adapted for terminal portability
• CPC Class Codes: H04L 67/14 Session management for real-time applications in data packet communications networks H04L65/1066
• CPC Class Codes: H04L 67/26 Push based network services broadcast or multicast push services H04L12/1859
• CPC Class Codes: H04L 67/2852 involving policies or rules for updating, deleting or replacing the stored data based on network characteristics replacement control in memory systems G06F12/12
• CPC Class Codes: H04L 67/2895 Intermediate processing functionally located close to the data provider application, e.g. reverse proxies
• CPC Class Codes: H04L 69/329 in the application layer [OSI layer 7]
• CPC Class Codes: H04W 24/00 Supervisory, monitoring or testing arrangements
• CPC Class Codes: H04W 76/11 Allocation or use of connection identifiers
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99935 Query augmenting and refining, e.g. inexact access
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

A system, a method and an apparatus are provided for the wireless monitoring and management of computer systems, networks, software systems or databases on a portable and/or handheld device which may monitor, update, and fix the system from any location and at any time. More specifically, the system, the method and the apparatus provide for the wireless monitoring and management of such systems by formatting information on a handheld screen of a wireless device, automatically wrapping portions of information for browsing on wireless devices, displaying information in a graph or other format on a wireless device, and/or auto-scaling of graphs on a wireless device.

Claims

1. A method for wirelessly monitoring and management of managing databases wherein results are displayed on a wireless device, the method comprising the steps of :

receiving database information at the wireless device, and altering respective portions of the database information to represent respective altered database information for display at respective locations on a display of the wireless device based on respective sizes of the information represented by the respective portions and respective sizes of the respective locations; and

displaying the altered database information on the display of the wireless device such that each of the respective altered information fits within its respective location on the display of the wireless device.

2. A method for formatting results on a screen of a wireless device, the method comprising the steps of :

querying data records from a database;

anticipating a number of the data records to be retrieved from the database;

retrieving the data records from the database;

storing the data records on a server;

choosing a threshold number;

determining if the data records retrieved from the database is greater than the threshold number; and

displaying the data records at a display area on a display screen of the wireless device based on the results of the threshold comparison, the displaying including altering certain respective data records to represent respective altered data records for display at respective locations on the display screen of the wireless device based on respective sizes of the information represented by the respective portions and respective sizes of the respective locations.

3. The method of claim 2 wherein the displaying further comprises the step of :

displaying the data records not greater than the threshold number on a single screen of the display of the wireless device.

4. The method of claim 2 wherein the displaying further comprises the steps of :

breaking certain of the data records into portions;

wrapping each of the portions and displaying each of the wrapped portions at respective said locations on the display screen of the wireless device.

5. The method of claim 4 further comprising the step of :

determining a number of data records in each of the portions.

6. The method of claim 4 further comprising the step of :

navigating between each of the portions of data records.

7. The method of claim 2 further comprising the step of :

displaying a solid box enclosing the display area.

8. The method of claim 2 wherein for each data record, the displaying further comprises the steps of :

calculating a width in pixels of text in each data record;

computing a sum of the pixels;

calculating a width in pixels of a field in a respective said location in the display area;

entering the text on a first line of the field to the extent of the width in pixels of the text allowed in the width in pixels of the field in the display area; and

entering the text on a second line of the field to the extent of the width in pixels of the text allowed in the width in pixels of the field in the display area.

9. The method of claim 2 further comprising the step of :

highlighting text from the data records within the display area.

10. The method of claim 2 further comprising the steps of :

inputting retrieved data into a graphing program; and

displaying the data in a graph.

11. The method of claim 10 further comprising the step of :

displaying the data on an axis.

12. The method of claim 10 wherein the graph is a bar-chart.

13. A method for formatting results on a screen of a wireless device by breaking columns in a table, the method comprising the steps of :

comparing columns of text in the table;

determining how many columns to display horizontally to provide a best visual perception;

determining a width of each of the columns to display;

choosing break points in the table, and altering respective portions of the database information representing the table to represent an altered format table;

displaying the altered format table having the determined number of horizontally displayed columns, the determined widths of each of the columns and the chosen break points.

14. The method of claim 13 wherein the displaying further comprises the step of :

breaking columns with identical text by displaying the identical text on one line of the table.

15. The method of claim 13 further comprising the step of :

highlighting the text of the table.

16. The method of claim 13 further comprising the step of :

comparing a display order of data and a frequency of repetition for the columns in the table.

17. A method for formatting data records on a screen of a wireless device by using a scroll mechanism associated with the wireless device, the method comprising the steps of :

shifting the data records on the screen;

keeping the data records together on the screen; and

locking one of the data records currently being displayed in a single area on the screen while shifting a remainder of the data records currently being displayed in the single area on the screen associated with the wireless device.

18. The method of claim 17 further comprising the step of :

highlighting a selection of the data records.

19. A system for monitoring and management of managing a database, the system comprising:

a wireless device having a screen and a wrapping means which determines respective sizes of respective portions of data in comparison to respective locations in which those respective portions are to be displayed on the screen, and alters the respective portions of data to represent respective altered information so that the respective altered information fit within their respective locations on the screen; and

a server associated with the database wherein the wireless device remotely accesses the database to retrieve the data.

20. A system for formatting data query results stored in a database wherein the database has text of data defined by a plurality of characters wherein each of the plurality of characters is defined by a number of pixels, the system comprising:

a wireless device having means for retrieving the data query results;

a server having a memory associated with the server wherein the server has a means for remotely accessing the text data associated with the database and transferring the text of data to the wireless device; and

the wireless device further having a display screen and a display controller which determines respective sizes of respective portions of the text data in comparison to respective locations in which those respective portions are to be displayed on the screen, and modifies the respective portions of text data so that the respective portions of the data fit within their respective locations.

21. A system for formatting results on a screen of a wireless device, the system comprising:

a database with text of data defined by tables having columns; and

a server in remote communication with the wireless device wherein the server determines a width of the columns, chooses the columns having an identical text and breaks the columns with the identical text by altering respective portions of the data to represent respective altered data so that the columns are displayable on a single display screen.

22. The system of claim 21 further comprising:

means for highlighting the text of data.

23. The system of claim 21 further comprising:

means for comparing a display order of the text of data; and

means for comparing a frequency of repetition for the columns in the table of the text of data.

24. A system for formatting data records on a wireless device, the system comprising:

a screen; and

a scrolling mechanism for shifting the data records on the screen wherein the scrolling mechanism keeps each of the data records together in a single display area on the screen and locks one of the data records currently being displayed in the single display area while shifting a remainder of the data records currently being displayed in the single display area on the screen.

25. The system of claim 24 further comprising:

means for highlighting the data records.

26. An apparatus for monitoring and management of managing a database, the apparatus comprising:

a wireless means providing remote access to a server wherein the wireless means queries data records from the server wherein the server is associated with the database and further wherein the wireless means anticipates a number of data records to be retrieved from the database;

means for choosing a threshold number;

means for retrieving the data records from the database;

means for comparing a number of the retrieved data records to the threshold number; and

means for displaying the data records on a display screen of the wireless means based on the results of the threshold comparison, wherein the means for displaying is associated with the wireless means and operates to alter certain respective data records to represent respective altered data records for display at respective locations on the display screen of the wireless means based on respective sizes of the information represented by the respective portions and respective sizes of the respective locations.

27. The apparatus of claim 26 further comprising:

means for highlighting the data records.

28. The apparatus of claim 26 further comprising:

means for navigating between each of the data records.

29. A method for wirelessly monitoring and management of a system selected from the group comprising a network system, a computer system a software system, or a database managing an information processing system, wherein information from the system is displayed on a wireless device, the method comprising the steps of :

formatting information from the system for display on a screen of the wireless device by altering respective portions of the information to represent respective altered portions of information for display at respective locations on the display screen of the wireless device based on respective sizes of the information represented by the respective portions and respective sizes of the respective locations;

displaying the information in a predetermined format on the screen by wrapping portions of the information and so that all of the information fits within respective designated locations on the screen; and

browsing on the wireless device between portions of the information.

30. A method for formatting information on a screen of a wireless device, the method comprising the steps of :

querying a system for information;

anticipating a volume of information to be retrieved from the database system;

retrieving the information from the system;

storing the information on a server;

choosing a threshold volume of information;

determining if the volume of information retrieved from the system is greater than the threshold; and

displaying the information at a display area on the screen of the wireless device based on the results of the threshold comparison, the displaying including altering respective portions of the information to represent respective altered portions of information for display at respective locations on the screen of the wireless device based on respective sizes of the information represented by the respective portions and respective sizes of the respective locations.

31. The method of claim 30 wherein the displaying further comprises the steps of :

displaying a subset of the information having a volume not greater than the threshold corresponding to a single screen of the wireless device.

32. The method of claim 30 wherein the displaying further comprises the steps of :

breaking the information into subsets;

wrapping each of the subsets and displaying each of the wrapped subsets at respective said locations on the display screen of the wireless device.

33. The method of claim 32 further comprising the step of :

determining a volume of information in each of the subsets.

34. The method of claim 32 further comprising the step of :

navigating between each of the subsets of information.

35. The method of claim 30 wherein the displaying further comprises the steps of :

displaying a solid box enclosing the display area.

36. The method of claim 30 further comprising the step of :

highlighting text from the information records within the display area.

37. The method of claim 30 further comprising the steps of :

inputting retrieved information data into a graphing program; and

displaying the data in a graph.

38. The method of claim 37 further comprising the step of :

displaying the information on an axis.

39. The method of claim 37 wherein the graph is a bar-chart.

40. A method for formatting information on a screen of a wireless device by using a scroll mechanism associated with the wireless device, the method comprising the steps of :

shifting the information on the screen;

keeping the information together on the screen; and

locking a subset of the information currently being displayed in a single area on the screen while shifting a remainder of the information currently being displayed in the single area on the screen associated with the wireless device.

41. The method of claim 40 further comprising the step of :

highlighting a selection of the information.

42. A system for formatting information on a wireless device, the system comprising:

a screen; and

a scrolling mechanism for shifting a first subset of the information currently being displayed in a single area on the screen wherein the scrolling mechanism keeps the information of the first subset together and locks a second subset of the information currently being displayed in the single area on the screen while shifting a remainder of the first subset of information on the screen.

43. The system of claim 42 further comprising:

means for highlighting a portion of the information.

44. An apparatus for monitoring and management managing information from a system, the apparatus comprising:

a wireless means providing remote access to a server wherein the wireless means queries information from the server wherein the server is associated with the system and further wherein the wireless means anticipates a volume of information to be retrieved from the system;

means for choosing a threshold volume of information;

means for retrieving the information from the system;

means for comparing a volume of information to the threshold volume of information; and

means, associated with the wireless means, for displaying the information on a display screen of the wireless means based on the results of the threshold comparison, the displaying including altering respective portions of the information to represent respective altered portions of information for display at respective locations on the screen of the wireless means based on respective sizes of the information represented by the respective portions and respective sizes of the respective locations.

45. The apparatus of claim 44 further comprising:

means for highlighting the information.

46. The apparatus of claim 44 further comprising:

means for navigating between portions of the information.

47. A method for processing database information retrieved in a query for delivery over a network to a wireless device having a display, comprising:

altering portions of the database information to represent respective altered database information for display at respective locations on a display of the wireless device based on respective sizes of the information represented by the respective portions and respective sizes of the respective locations; and

displaying the altered database information on the display of the wireless device such that each of the respective altered information fits within its respective location on the display of the wireless device.

48. A wireless device for monitoring and managing an information processing system, comprising:

a receiver configured to receive information from the information processing system;

a display screen and a display screen controller, the display screen controller configured to alter respective portions of the received information to represent respective altered received information for display at respective locations on the display screen of the wireless device based on respective sizes of the received information represented by the respective portions and respective sizes of the respective locations; and

the display screen controller further configured to display the altered received information on the display screen of the wireless device such that each of the respective altered received information fits within its respective location on the display screen of the wireless device.

49. The wireless device of claim 48, further comprising:

a wrapping means configured to display the respective altered portions of information in a predetermined format on the display screen by wrapping portions of the respective altered portions of information so that all of the respective altered portions of information fit within respective designated locations on the display screen; and

a navigating means configured to receive from a user of the wireless device commands to browse on the wireless device between respective altered portions of the received information.

50. The wireless device of claim 48, wherein the receiver is configured to retrieve the information from a database system, further comprising:

a processor component configured to anticipate a volume of information to be retrieved from the database system;

the processor component comprising means for choosing a threshold volume of information which may be displayed on the display screen of the wireless device;

the processor component further including comparison means for determining if the volume of information retrieved from the database system is greater than the threshold; and

the display screen controller configured to display the information at a display area on the display screen of the wireless communications device based on the results of the threshold comparison, at least one of the processor component and display screen controller further configured to alter respective portions of the database information to represent respective altered portions of information for display at respective locations on the display screen of the wireless communication device based on respective sizes of the information represented by the respective portions and respective sizes of the respective locations.

51. The wireless device of claim 50, wherein the volume of information is the number of data records retrieved from the database as a result of a database query;

wherein the threshold volume is a threshold number of records suitable for display on the display screen of the wireless device;

wherein said comparison means of the processor component is further configured to determine if the number of data records retrieved from the database is greater than the threshold number; and

wherein said processor component is further configured to break the data records into portions suitable for display at a display area on the display screen of the wireless device based on the results of the threshold comparison.

52. The wireless device of claim 50, wherein the processor component and/or display controller are further configured to determine a width of the columns of a table of the database, choose the columns having an identical text, and break the columns with the identical text by altering respective portions of the data to represent respective altered data so that the columns are displayable on a single display screen of the wireless device.

53. The wireless device of claim 48, wherein the display screen further comprises a scrolling mechanism;

wherein said scrolling mechanism is configured to shift a first subset of the information currently being displayed in a single area on the display screen;

wherein the scrolling mechanism keeps the information of the first subset together and locks a second subset of the information currently being displayed in the single area on the display screen while shifting a remainder of the first subset of information on the display screen.

54. The wireless device of claim 53, wherein:

the receiver is configured to receive data records;

the scrolling mechanism is configured to shift the data records on the display screen; and

the scrolling mechanism keeps each of the data records together in a single display area on the display screen and locks one of the data records currently being displayed in the single display area while shifting a remainder of the data records currently being displayed in the single display area on the display screen.

55. The wireless device of claim 48, wherein the receiver is configured to receive query results of a database query;

wherein the database query results are comprised of text of data defined by a plurality of characters wherein each of the plurality of characters is comprised of a number of pixels; and

wherein for each data record at least one of the display controller and a processor component is configured to;

calculate a width as a number of pixels of a first line on the display screen on which the text data is to be displayed on the display screen;

calculate a width as a number of pixels of a second line on the display screen on which the text data to be displayed on the display screen;

enter the text data on the first line to the extent of the width in pixels of the text allowed in the width in pixels of the first line; and

enter the text data on the second line to the extent of the width in pixels of the text allowed in the width in pixels of the second line.

56. The wireless device of claim 48, wherein the display controller is further configured to display the received information on a graph.

57. The wireless device of claim 56, wherein said graphing means is further configured to display the received data on an axis.

58. The wireless device of claim 56, wherein said graphing means is further configured to display the received data in at least one of a bar-chart and a pie-chart format.

59. The wireless device of claim 56, wherein said graphing means is further configured to auto-scale the graph.

60. The wireless device of claim 59, wherein said graphing means auto-scales the graph by at least one of static scaling or dynamic scaling.

61. A server for wirelessly monitoring and managing an information processing system, wherein information retrieved from the information processing system is displayed on a display screen of a wireless device configured to receive information from the server, comprising:

a receiving component configured to retrieve information from a storage of the information processing system;

a formatting means configured to format the retrieved information for display on the display screen of the wireless device by altering respective portions of the information to represent respective altered portions of information for display at respective locations on the display screen of the wireless device based on respective sizes of the information represented by the respective portions and respective sizes of the respective locations.

62. The server of claim 61, wherein:

said server is a database server configured for receiving a database query from the wireless device and delivering results of the database query to the wireless device, the wireless device being configured to monitor and manage a database system via the display screen;

said formatting means is a resident program of the database server, the resident program configured to alter respective portions of the retrieved database information to represent respective altered database information for display at respective locations on the display screen of the wireless device based on respective sizes of the information represented by the respective portions and respective sizes of the respective locations;

a display controller of the wireless device may receive the respective altered database information; and

said display controller may display the received altered database information on the display screen of the wireless device such that each of the respective altered information fits within its respective location on the display screen of the wireless device.

63. The server of claim 62, further comprising a processor component configured to determine a volume of the information retrieved from the database as a result of the query;

wherein said processor component comprises a comparison means configured to determine if the volume of information retrieved from the database is greater than a threshold volume of information, wherein the threshold number pertains to a volume of information suitable for display on the display screen of the wireless device; and

wherein the processor component is configured to alter portions of the retrieved information to create portions suitable for display at a display area on the display screen of the wireless device based on the results of the threshold comparison, the processor configured to alter respective portions of the information for display at respective locations on the display screen of the wireless device based on respective sizes of the information represented by the respective portions and respective sizes of the respective locations.

64. The server of claim 63, wherein the volume of information is comprised of the number of data records retrieved from the database as a result of the database query, wherein:

the threshold volume of information is the number of data records suitable for display on the display screen of the wireless device;

said comparison means is further configured to determine if the number of data records retrieved from the database is greater than the threshold number; and

said processor component is further configured to break the data records into portions suitable for display at a display area on the display screen of the wireless device based on the results of the threshold comparison, the processor component configured to break certain respective data records to represent respective altered data records for display at respective locations on the display screen of the wireless device based on respective sizes of the information represented by the respective portions and respective sizes of the respective locations.

65. The server of claim 63, wherein the processor component is configured to alter portions of the retrieved information to create portions suitable for display at a display area on the display screen of the wireless device by wrapping the respective portions of retrieved database data to represent respective wrapped information so that the respective wrapped information fit within their respective locations on the display screen of the wireless device.

66. The server of claim 63, wherein the retrieved information is text of a data record defined by a plurality of characters wherein each of the plurality of characters is defined by a number of pixels:

and wherein for each data record the processor component of the server is configured to;

calculate a width as a number of pixels of a first line on the display screen of the wireless device on which the text data is to be displayed;

calculate a width as a number of pixels of a second line on the display screen on which the text data to be displayed on the display screen;

divide the text data on the first line to the extent of the width in pixels of the text allowed in the width in pixels of the first line; and

divide the text data on the second line to the extent of the width in pixels of the text allowed in the width in pixels of the second line;

wherein said text will be displayed on the first line and the second line of the display of the wireless device so as to fit on the first line and the second line of the wireless device.

67. The server of claim 63, wherein the processor component is configured to retrieve a table of the database for visual display, the table of the database being comprised of columns of text;

the processor component further configured for determining a width of the columns of the table of the database, choosing the columns having an identical text, and breaking the columns with the identical text by altering respective portions of the data to represent respective altered data so that the columns are displayable on the display screen of the wireless device.

68. A user interface for wirelessly monitoring and managing an information processing system, comprising:

a display screen of a wireless device configured to receive information from the information processing system for display;

said user interface having a respective region at a respective location of said display screen configured to display a respective altered portion of the received information to represent a respective altered portion of information for display at the respective location on the display screen based on a respective size of the information represented by the respective portion and a respective size of the respective location, wherein said respective altered portion of information has been altered to conform to the respective size of the respective region; and

a navigation means configured to receive from a user of the wireless device commands to browse on the display screen of the wireless device between respective altered portions of the received information.

69. The user interface of claim 68, wherein said information processing system comprises a database system, and said received information comprises database data retrieved in response to a database query from the wireless device to the database system.

70. The user interface of claim 69, wherein said region configured to display an altered portion of the received information comprises a region configured to wrap the received database information to fit within the region.

71. The user interface of claim 69, wherein said navigation means comprises a scrolling mechanism configured to shift the data records on the display screen wherein the scrolling mechanism keeps each of the data records together in a single display area on the display screen and locks one of the data records currently being displayed in the single display area while shifting a remainder of the data records currently being displayed in the single display area on the display screen.

72. The user interface of claim 68, further comprising graphing means configured to display the received information on a graph.

73. The user interface of claim 72, wherein said graphing means is further configured to display the received data on an axis.

74. The user interface of claim 72, wherein said graphing means is further configured to display the received data in at least one of a bar-chart or a pie-chart.

75. The user interface of claim 72, wherein said graphing means is further configured to auto-scale the graph.

76. The user interface of claim 75, wherein said graphing means auto-scales the graph by at least one of static scaling or dynamic scaling.

77. A method for formatting information on a display screen of a wireless device, comprising:

querying a system for information;

anticipating a volume of information to be retrieved from the system;

retrieving the information from the system;

choosing a threshold volume of information;

determining if the volume of information retrieved from the system is greater than the threshold; and

displaying the information at a display area on the display screen of the wireless device based on the results of the threshold comparison, the displaying including altering respective portions of the information to represent respective altered portions of information for display at respective locations on the display screen of the wireless device based on respective sizes of the information represented by the respective portions and respective sizes of the respective locations.

78. The method of claim 77, wherein the system comprises a database and the volume of information comprises a number of records, further comprising:

querying data records from the database;

anticipating a number of the data records to be retrieved from the database;

retrieving the data records from the database;

choosing a threshold number of records;

determining if the number of data records retrieved from the database is greater than the threshold number of records; and

displaying the data records at a display area on a display screen of the wireless device based on the results of the threshold comparison, the displaying including altering certain respective data records to represent respective altered data records for display at respective locations on the display screen of the wireless device based on respective sizes of the information represented by the respective portions and respective sizes of the respective locations.

79. The method of claim 78, further comprising:

setting the threshold number in conformance with a number of records suitable for display on a display screen of the wireless device.

80. The method of claim 78, further comprising:

determining a text data of a data record of the retrieved data records, wherein the text comprises a plurality of characters, wherein each of the plurality of characters comprises a number of pixels;

calculating a width as a number of pixels of a first line on the display screen on which the text data of the data record is to be displayed on the display screen;

calculating a width as a number of pixels of a second line on the display screen on which the text data of the data record is to be displayed on the display screen;

entering the text data on the first line to the extent of the width in pixels of the text allowed in the width in pixels of the first line; and

entering the text data on the second line to the extent of the width in pixels of the text allowed in the width in pixels of the second line.