USRE41902E1 - System, method and apparatus for wireless monitoring and management of computer systems - Google Patents

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

Info

Publication number
USRE41902E1
USRE41902E1 US11/498,300 US49830006A USRE41902E US RE41902 E1 USRE41902 E1 US RE41902E1 US 49830006 A US49830006 A US 49830006A US RE41902 E USRE41902 E US RE41902E
Authority
US
United States
Prior art keywords
information
respective
wireless device
display
data
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
US11/498,300
Inventor
Ari David Kaplan
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Xylon LLC
Original Assignee
Stavros Investments LLC
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Priority to US24752300P priority Critical
Priority to US09/964,912 priority patent/US6772169B2/en
Application filed by Stavros Investments LLC filed Critical Stavros Investments LLC
Priority to US11/498,300 priority patent/USRE41902E1/en
Application granted granted Critical
Publication of USRE41902E1 publication Critical patent/USRE41902E1/en
Assigned to EXPAND BEYOND CORPORATION reassignment EXPAND BEYOND CORPORATION ASSIGNMENT OF ASSIGNORS INTEREST (SEE DOCUMENT FOR DETAILS). Assignors: KAPLAN, ARI DAVID
Assigned to STAVROS INVESTMENTS LLC reassignment STAVROS INVESTMENTS LLC ASSIGNMENT OF ASSIGNORS INTEREST (SEE DOCUMENT FOR DETAILS). Assignors: EXPAND BEYOND CORPORATION
Assigned to XYLON LLC reassignment XYLON LLC MERGER (SEE DOCUMENT FOR DETAILS). Assignors: STAVROS INVESTMENTS LLC
Application status is Active legal-status Critical
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • HELECTRICITY
    • H04ELECTRIC COMMUNICATION TECHNIQUE
    • H04LTRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
    • H04L63/00Network architectures or network communication protocols for network security
    • H04L63/04Network architectures or network communication protocols for network security for providing a confidential data exchange among entities communicating through data packet networks
    • H04L63/0428Network architectures or network communication protocols for network security for providing a confidential data exchange among entities communicating through data packet networks wherein the data content is protected, e.g. by encrypting or encapsulating the payload
    • GPHYSICS
    • G06COMPUTING; CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/90Details of database functions independent of the retrieved data types
    • G06F16/95Retrieval from the web
    • G06F16/957Browsing optimisation, e.g. caching or content distillation
    • G06F16/9577Optimising the visualization of content, e.g. distillation of HTML documents
    • GPHYSICS
    • G06COMPUTING; CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F21/00Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
    • G06F21/60Protecting data
    • G06F21/62Protecting access to data via a platform, e.g. using keys or access control rules
    • G06F21/6218Protecting access to data via a platform, e.g. using keys or access control rules to a system of files or objects, e.g. local or distributed file system or database
    • G06F21/6227Protecting access to data via a platform, e.g. using keys or access control rules to a system of files or objects, e.g. local or distributed file system or database where protection concerns the structure of data, e.g. records, types, queries
    • HELECTRICITY
    • H04ELECTRIC COMMUNICATION TECHNIQUE
    • H04LTRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
    • H04L67/00Network-specific arrangements or communication protocols supporting networked applications
    • H04L67/04Network-specific arrangements or communication protocols supporting networked applications adapted for terminals or networks with limited resources or for terminal portability, e.g. wireless application protocol [WAP]
    • HELECTRICITY
    • H04ELECTRIC COMMUNICATION TECHNIQUE
    • H04LTRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
    • H04L67/00Network-specific arrangements or communication protocols supporting networked applications
    • H04L67/14Network-specific arrangements or communication protocols supporting networked applications for session management
    • HELECTRICITY
    • H04ELECTRIC COMMUNICATION TECHNIQUE
    • H04LTRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
    • H04L67/00Network-specific arrangements or communication protocols supporting networked applications
    • H04L67/26Push based network services
    • HELECTRICITY
    • H04ELECTRIC COMMUNICATION TECHNIQUE
    • H04LTRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
    • H04L67/00Network-specific arrangements or communication protocols supporting networked applications
    • H04L67/28Network-specific arrangements or communication protocols supporting networked applications for the provision of proxy services, e.g. intermediate processing or storage in the network
    • H04L67/2842Network-specific arrangements or communication protocols supporting networked applications for the provision of proxy services, e.g. intermediate processing or storage in the network for storing data temporarily at an intermediate stage, e.g. caching
    • H04L67/2852Network-specific arrangements or communication protocols supporting networked applications for the provision of proxy services, e.g. intermediate processing or storage in the network for storing data temporarily at an intermediate stage, e.g. caching involving policies or rules for updating, deleting or replacing the stored data based on network characteristics
    • HELECTRICITY
    • H04ELECTRIC COMMUNICATION TECHNIQUE
    • H04LTRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
    • H04L67/00Network-specific arrangements or communication protocols supporting networked applications
    • H04L67/28Network-specific arrangements or communication protocols supporting networked applications for the provision of proxy services, e.g. intermediate processing or storage in the network
    • H04L67/2866Architectural aspects
    • H04L67/2895Architectural aspects where the intermediate processing is functionally located closer to the data provider application, e.g. reverse proxies; in same machine, in same cluster or subnetwork
    • HELECTRICITY
    • H04ELECTRIC COMMUNICATION TECHNIQUE
    • H04LTRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
    • H04L69/00Application independent communication protocol aspects or techniques in packet data networks
    • H04L69/30Definitions, standards or architectural aspects of layered protocol stacks
    • H04L69/32High level architectural aspects of 7-layer open systems interconnection [OSI] type protocol stacks
    • H04L69/322Aspects of intra-layer communication protocols among peer entities or protocol data unit [PDU] definitions
    • H04L69/329Aspects of intra-layer communication protocols among peer entities or protocol data unit [PDU] definitions in the application layer, i.e. layer seven
    • HELECTRICITY
    • H04ELECTRIC COMMUNICATION TECHNIQUE
    • H04LTRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
    • H04L63/00Network architectures or network communication protocols for network security
    • H04L63/16Implementing security features at a particular protocol layer
    • H04L63/166Implementing security features at a particular protocol layer at the transport layer
    • HELECTRICITY
    • H04ELECTRIC COMMUNICATION TECHNIQUE
    • H04WWIRELESS COMMUNICATION NETWORKS
    • H04W24/00Supervisory, monitoring or testing arrangements
    • HELECTRICITY
    • H04ELECTRIC COMMUNICATION TECHNIQUE
    • H04WWIRELESS COMMUNICATION NETWORKS
    • H04W76/00Connection management
    • H04W76/10Connection setup
    • H04W76/11Allocation or use of connection identifiers
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10STECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00Data processing: database and file management or data structures
    • Y10S707/99931Database or file accessing
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10STECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00Data processing: database and file management or data structures
    • Y10S707/99931Database or file accessing
    • Y10S707/99933Query processing, i.e. searching
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10STECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00Data processing: database and file management or data structures
    • Y10S707/99931Database or file accessing
    • Y10S707/99933Query processing, i.e. searching
    • Y10S707/99935Query augmenting and refining, e.g. inexact access
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10STECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00Data processing: database and file management or data structures
    • Y10S707/99941Database schema or data structure
    • Y10S707/99943Generating 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.

Description

This application claims the benefit of U.S. Provisional Application Serial No. 60/247,523, filed Nov. 9, 2000.

FIELD OF THE INVENTION

The present invention generally relates to a system, a method and an apparatus for the wireless monitoring and management of computer, software and database systems. More specifically, the present invention provides a portable wireless monitoring and management tool that may be used remotely by a database or system administrator.

BACKGROUND OF THE INVENTION

With the proliferation of computer systems and networks to carry out and support many of the activities and communications of modern businesses, a failure of a computer system, software system, network or database may result in extremely extensive downtime which translates into lost revenue and often includes bad publicity. For example, if a network, software system or database application of a bank were impaired, then certain or all financial transactions of the bank may not be able to process until such systems or applications are operable and/or functioning. A need exists to reduce software, network and database failure rates and downtimes while increasing performance and operational efficiency.

Traditionally, software, network and database monitoring and/or management has been confined to hard-wired environments where system administrators or database administrators (DBAs) must be physically present and available at all times in the event that a problem or situation occurs that requires human intervention to fix and correct. For many companies, a system administrator or a DBA employed or utilized by the company on a full time basis is extremely costly. For other companies, recruiting, training and maintaining a staff of system administrators or DBAs is simply not an economically viable option.

The present invention overcomes these deficiencies and limitations of prior techniques by allowing for system, network and/or database monitoring and management from portable handheld wireless devices.

The present invention allows monitoring and maintaining of computer systems, networks and databases using portable, handheld, wireless devices. As a result, system administrators, network administrators and DBAs may be freed from the constraints of their home and office computers and may monitor, update, and fix computer and software systems, networks and databases from any location and at any time. The present invention, therefore, provides an important advantage in a competitive global economy where companies cannot afford lengthy software, network or database failures or downtime, or inadequate response time to address such failures.

However, despite the flexibility provided by wireless devices, such devices introduce a number of different challenges due to their portable and wireless environment. Such challenges include limitations related to transmission and receiving speed (limited by available wireless bandwidth), the periodic loss of signal, reduced device size and reduced display size, and unique security concerns caused by the wireless environment. In addition, for handheld wireless devices, limitations exist regarding data entry; namely, handheld wireless devices typically do not include keyboards, and text may require entering through handwriting and/or other techniques.

A need, therefore, exists for an improved system, method and apparatus for the monitoring and management of computer systems, software systems, networks and databases. In addition, a need exists to reduce failure rates and downtimes while increasing performance and operational efficiency of such systems.

SUMMARY OF THE INVENTION

The present invention provides a system, a method and an apparatus for the wireless monitoring and management of computer systems, software systems, networks and databases.

To this end, in an embodiment of the present invention, a method is provided for the wireless monitoring and management of such systems where information is displayed on a wireless device. The method comprises the steps of: formatting information on a screen of the wireless device by wrapping portions of data sets; browsing on the wireless device between portions of data sets; displaying system or database information in a predetermined format on the wireless device; and scaling the information in the predetermined format on the wireless device.

In another embodiment of the present invention, a method is provided for formatting results on a screen of a wireless device. The method comprises 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 web or application 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 on the wireless device.

In an embodiment, the method displays the data records not greater than the threshold number on a single screen of the wireless device.

In an embodiment, the method comprises the steps of: breaking data records into portions; wrapping each of the portions; and providing a display area on the screen of the wireless device for each of the portions of data records that has been wrapped.

In an embodiment, the method determines a number of data records in each of the portions.

In an embodiment, the method navigates among each of the portions of data records.

In an embodiment, the method encloses the display area in a solid box. In an embodiment, the method 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 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.

In an embodiment, the method comprises the step of highlighting text from the data records within the display area.

In an embodiment, the method inputs retrieved data into a graphing program, displays the data in a graph; and displays the data on an axis. The graph may be a bar-chart, a pie-chart, or the like.

In another embodiment of the present invention, a method is provided for formatting results on a screen of a wireless device by breaking columns in a table. The method comprises 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; and choosing break points in the table.

In an embodiment, the method breaks columns in a table is further comprised of the step of breaking columns with identical text by displaying the identical text on one line of the table.

In an embodiment, the method highlights the text of the table. In an embodiment, the method compares a display order of data and a frequency of repetition for the columns in the table.

In another embodiment of the present invention, a method is provided for formatting data records on a screen of a wireless device by using a scroll mechanism associated with the wireless device. The method comprises of the steps of: shifting each of the data records on the screen; keeping each of the data records together on the screen; and locking one of the data records while shifting the remaining data records on the screen associated with the wireless device.

In an embodiment, the method highlights a selection of the data records.

In yet another embodiment of the present invention, a system is provided for the monitoring and management of databases. The system has a wireless device having a screen and a wrapping means. The system also has a web server associated with the database wherein the wireless device remotely accesses the database.

In another embodiment of the present invention, a system is provided 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 has a wireless device having means for retrieving data query results. The system has an application and/or web server having a memory associated with the application/web 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.

In another embodiment of the present invention, a system is provided for formatting results on a screen of a wireless device. The system has a database with text of data defined by tables having columns and an application or web server in remote communication with the wireless device. The server determines a width of each of the columns, chooses columns with identical text and breaks columns with identical text.

In an embodiment, the system has a means for highlighting the text of data.

In an embodiment, the system has a 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.

In yet another embodiment of the present invention, a system is provided for formatting data records on a wireless device. The system has a screen and a scrolling mechanism. The scrolling mechanism may shift the data records on the screen. The scrolling mechanism keeps each of the data records together. The scrolling mechanism further locks one of the data records while shifting a remainder of the data records on the screen.

In an embodiment, the system has a means for highlighting the data records.

In another embodiment of the present invention, an apparatus is provided for monitoring and management of a database. The apparatus has a wireless means providing remote access to an application or web server, queries data records from the server wherein the application or web server is associated with the database and further wherein the wireless means anticipates a number of data records to be retrieved from a 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 retrieved to the threshold number, and means for displaying the data records in a predetermined format wherein the means for displaying is associated with the wireless means.

In an embodiment, the apparatus has a means for highlighting the data records.

In an embodiment, the apparatus has a means for navigating between each of the data records.

It is, therefore, an advantage of the present invention to provide a system, an apparatus and a method that reduces downtime. To this end, application and database downtime is dramatically reduced. To fix a system, network or database problem, system administrators or DBAs do not spend critical time driving to a fixed location such as to home or to work, booting up a computer, or dialing-in to a server or ISP.

Another advantage of the present invention is to provide a system, an apparatus and a method that significantly reduces analysis and troubleshooting time. This time is particularly important for mission-critical systems. The system, apparatus and method of the present invention provide the tools to readily identify troubleshooting issues.

Another advantage of the present invention is to provide a system, an apparatus and a method that reduces DBA staff burnout. Staff no longer needs to completely interrupt a weekend or weeknight for minor issues when they can monitor and troubleshoot issues from anywhere using the system, the apparatus and the method of the present invention.

Yet another advantage of the present invention is to provide a system, an apparatus and a method that increases confidence in management. Managers may rest easier knowing that their staff has complete and immediate access to their software systems, networks and/or databases from any location at any time.

Further, another advantage of the present invention is to provide a system, an apparatus and a method that allows for monitoring multiple databases, systems or networks from one console.

Still further, another advantage of the present invention is to provide a system, an apparatus and a method that improve the productivity and manageability of the DBA staff.

Yet another advantage of the present invention is to provide a system, an apparatus and a method that reduce the learning curve of new DBAs when they start a job.

Another advantage of the present invention is to provide a system, an apparatus and a method that reduce or eliminate the need for custom-written scripts that are common among the database communities, such as, for example, a database community using a database management tool provided by, for example, the Oracle Corporation.

Additional features and advantages of the present invention are described in, and will be apparent from, the detailed description of the presently preferred embodiments and from the drawings.

BRIEF DESCRIPTION OF THE DRAWINGS

FIG. 1 illustrates a flowchart for retrieval of data from a database and determination of whether the number of records exceeds the threshold for wrapping in an embodiment of the present invention;

FIG. 2 illustrates a black box diagram of a system for the display of database information on a graph on a wireless device in an embodiment of the present invention; and

FIG. 3 illustrates a plan view of a wireless device in an embodiment of the present invention.

DETAILED DESCRIPTION OF THE INVENTION

The following description provides, by way of example, an implementation of the advantageous concepts and techniques of the present invention in connection with a system and methods for the wireless monitoring and management of databases. It should be understood, however, that the concepts and techniques may be readily implemented with respect to other similar systems, such as a computer system, software system or network. The advantages of the present invention will be similarly realized for such other systems. Merely by way of example, the following description relates to one particular embodiment or application of the present invention for database monitoring and management. It is not intended to limit the invention to such an embodiment or application. To the contrary, it is intended that the invention covers all variations, equivalents and embodiments embraced by the scope and spirit of the appended claims.

According to one preferred embodiment, the present invention generally provides a system, a method and an apparatus for the wireless monitoring and management of databases. To this end, the present invention provides a system, a method and an apparatus for formatting results on a handheld screen. In addition, the present invention provides a system, a method and a apparatus for automatically wrapping portions of data sets for browsing on wireless devices. Further, the present invention provides a system, a method and an apparatus for displaying database information in a graph on a wireless device. Still further, the present invention provides a system, a method and an apparatus for auto-scaling of graphs on a wireless device.

To format results on a handheld and/or portable and/or wireless screen (hereinafter “screen”), displaying the results of a database query is provided on a desktop computer as ample space is provided to display many columns and records of data. However, the size of the screen is generally several times smaller. When using databases such as, for example, the database for desktop computers by Oracle Corporation, all data is displayed on one line for each record as follows:

Heading 1 Heading2 Heading3 Heading4 Heading5
Record1 rec1_Col2 rec1_Col3 rec1_Col4 rec1_Col5
column1
Record2 rec2_Col2 rec2_Col3 rec2_Col4 rec2_Col5
column1
Record3 rec3_Col2 rec3_Col3 rec3_Col4 rec3_Col5
column1

In the example above, text is not wrapped within each column as the text is sometimes cutoff: LONG data types are cutoff to 80 characters by default, and if the total line size is larger than the LINESIZE value (defaulted to 80 characters), then the heading and record displays are wrapped on 2, 3, 4 or more lines. To complicate matters, if the PAGESIZE value is greater than 0 (the default is 12), then the heading repeats within each PAGESIZE increment, making text difficult to read. A sample Oracle output of the query “SELECT OWNER, TABLE_NAME, TABLESPACE_NAME, PCT_FREE, PCT_USED, INITAL_EXTENT, NEXT_EXTENT, MIN_EXTENTS, MAX_EXTENTS, PCT_INCREASE FROM ALL_TABLES” is shown as follows:

OWNER TABLE_NAME TABLESPACE_NAME PCT_FREE PCT_USED
INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE
SYSTEM EMPLOYEES SYSTEM 10 90
11241 4096 1 255 0

However, the system, the method and the apparatus of the present invention may display data aligned and/or enclosed in clearly delineated boxes. The same difficult-to-read results from a database, such as, for example, the Oracle database described above, may be displayed on the apparatus of the present invention such that the displaying data is shown as follows:

TABLE
“SYSTEM EMPLOYEES” has the following storage:
Initial Next % Increase
Pct Used Pct Free Tablespace
Extents Min Extents Max Extents
31241 4096  0
90 10 SYSTEM
17 1 255

As seen from the above table, according to an embodiment of the invention, some field headings may be advantageously changed to shorter and more meaningful names. For example, instead of having a field heading of “PCT_INCREASE”, the system has changed the field heading to “% Increase”. Such a change, results in not only a more meaningful field heading, but also reduces the size required by two characters. Such a revision of the field names may be accomplished by any number of routines for recognizing field names or portions of field names and renaming them in a manner which is more likely desired by the user. As another different example, for information having a column heading “How Many Shares Have Been Traded Today on Wall Street”, the heading may be more conveniently changed to a shorter and more meaningful name for a user on a wireless device such as “Shares Traded Today.”

The present invention provides for display of data that may be more visually understandable and that may be displayed on smaller screen areas. By the system and the method of the present invention, text may be wrapped within each display area and may be enclosed by a solid box. Additionally, bold text may be used to represent the heading information (indicated by the “Initial” through “Max Extents” in the table above, identified as “SYSTEM.EMPLOYEES”. The use of bold text may provide better visual perception for the user to, for example, differentiate between headings and/or displayed data.

Wrapping of text may be based upon calculations of a width in pixels of each letter, number, and/or character. This calculation may identify the width of the field and may compute the sum of pixels until the line is filled. The calculation may continue on the next line until the next line is filled, and so on.

In known systems, wrapping occurs as part of the inherent operating systems. Therefore, wrapping is not handled by handheld operating systems; however, in an embodiment of the present invention, text may be wrapped within each box of each column. For example, the word “Product_ID” may have eight pixels across the “P”, six pixels for “r”, six pixels for “o”, five pixels for “d”, six pixels for “u”, five pixels for “c”, five pixels for “t”, six pixels for “_”, five pixels for “I”, and five pixels for “D”. A total of 57 pixels, is therefore, required to display “Product_ID”. If the box that contains “Product_ID” has fewer than 57 pixels, then, in an embodiment of the present invention, the displayed data may break into two or more lines. For example, assume that the box that contains “Product_ID” is 50 pixels across. The first line may hold “product” and “_” which totals 47 pixels. The “ID” which totals ten pixels may be displayed on the second line within the box, and the box may be extended vertically by one line. When one box for a line of the display is expanded vertically, then all of the boxes on the line are similarly enlarged vertically. Wrapping of text within a box is shown as follows:

Figure USRE041902-20101026-C00001

In another embodiment of the present invention, all data may be displayed by using a “break” column. The conventional method is to simply display all data for all rows. In an embodiment of the present invention, a “break” column may allow for more columns to be displayed in an easily understood format. For example, if a table has four columns, and the first column has some repeating values in the data, the conventional method is to simply display all data. For example, the results of a query that displays information on the makeup of a conventional method such as, for example, Oracle indexes, is shown as follows, with displaying all four columns formatted: SELECT INDEX_OWNER, INDEX_NAME, COLUMN_NAME, COLUMN_POSITION FROM ALL_ID_COLUMNS ORDER BY 1, 2, 4;

OWNER TABLE COLUMN POS
DEMO I_ITEM ORDER_ID 1
DEMO I_ITEM ITEM_ID 2
DEMO I_ITEM EMP_ID 3
DEMO I_LOCATION LOCATION_ID 1
DEMO I_PRICE PRODUCT_ID 1
DEMO I_PRICE START_DATE 2
DEMO I_PRODUCT$PRODUCT_ID PRODUCT_ID 1

In an embodiment of the present invention, the display may “break” the information on the first column more effectively. That is, display of the first column may be provided on one line and may be followed by the rest of the columns in the record. All subsequent records with the same first column value may then be displayed. In situations where two columns with repeating values exist, screens may have two columns as their break points. Having at least one column as a breakpoint may effectively reduce the width of the display by one column which is valuable on a small screen. The same information from the previous illustration is shown with the concept of “breaking” on the first column as provided by the present invention by displaying four columns with “owner” as the break column as follows:

-OWNER-
TABLE COLUMN POS
-DEMO-
I_ITEM ORDER_ID 1
I_ITEM ITEM_ID 2
I_ITEM EMP_ID 3
I_LOCATION LOCATION_ID 1
I_PRICE PRODUCT_ID 1
I_PRICE START_DATE 2
I_PRODUCT$ PRODUCT_ID 1
PRODUCT_ID

By “breaking” on the first column (“owner” in the above example), the area needed to display the information is approximately 25% smaller. AH information, however, may still be displayed. Further “breaking” of this data into a smaller size may also be possible. For example, if the first two columns (“owner” and “table” in the above example) are used as break points, only the remaining information may need to be repeated for each set of break points (“owner” and “table”). In addition, having two break points does not necessarily mean that the break points may be in separate boxes when displayed. The break points may be formatted to be displayed within one box, such as shown, for example, in the following table. The table illustrates breaking of “owner” and “table”. The “owner” and “table” are placed in one box, separated with a period and surrounded with dashes for better visual perception. As shown in the following table for displaying four columns with “owner” and “table” as the two break columns:

-OWNER TABLE-
COLUMN POS
-DEMO.I_ITEM-
ORDER_ID 1
ITEM_ID 2
EMP_ID 3
-DEMO.I_LOCATION-
LOCATION_ID 1
-DEMO.I_PRICE-
PRODUCT_ID 1
START_DATE 2
-DEMO.I_PRODUCT$PRODUCT_ID-
PRODUCT_ID 1

As seen in the above table, the display of data may be reduced from the initial four columns to only two columns and, as a result, improves the visual perception of the data. In the system of the present invention, each screen may have predetermined column positions and break points. An additional example is shown in the table below for displaying six columns from, for example, a result of a query with “owner” and “tablename” as the two break columns:

-Owner.TableName-
Constraint Type
Condition Status
TALMDR_TRADES_QUOTES_TIME_SUM_T-
SYS_C00997 C
“TRANS_FEE_CODE” IS NOT DISABLED
NULL
SYS_C00998 C
REC_DEL_IN (‘Y’, ‘N’) ENABLED
SYS_C00999 C
REC_DEL_IND NOT NULL ENABLED
-TAL.TRADE-DATE-T-
TRADE_DATE-PK ENABLED

Displaying the information from the table above without break points would have been more cluttered such as shown in the following table that displays six columns with no break points as follows:

Owner Tablename Constraint
Type Condition Status
TAL MDR_TRADES_QUOTE SYS_C00997
S_TIME_SUM
C “TRANS_FEE_CODE” IS DISABLED
NOT NULL
TAL MDR_TRADES_QUOTE SYS_C00998
S_TIME_SUM
C REC_DEL_IN ENABLED
(‘Y’, ‘N’)
TAL MDR_TRADES_QUOTE SYS_C00999
S_TIME_SUM
C REC_DEL_IND NOT ENABLED
NULL
TAL TRADE_DATE_T TRADE_DATE_PK
P ENABLED

The present invention may determine which columns (if any) are the break points. To this end, the present invention may identify the columns of data, the display order of the data, and/or the frequency of repetition for the ordered columns. From an identification of one or more of these values, a decision may be made to use break columns or not to use break columns. The present invention may also determine how many columns to display horizontally to provide the best visual perception for the user. In addition, the present invention may determine the width of each column to display. For example, the display in the previous table may be compacted visually by reducing the width of the first column and the third column. The following table shows the display of six columns with no break columns to reduce the width of the first column and the third column:

Owner Tablename Constraint
Type Condition Status
TAL MDR_TRADES_QUOTE SYS_C00997
S_TIME_SUM
C “TRANS_FEE_CODE” IS DISABLED
NOT NULL
TAL MDR_TRADES_QUOTE SYS_C00998
S_TIME_SUM
C REC_DEL_IN ENABLED
(‘Y’, ‘N’)
TAL MDR_TRADES_QUOTE SYS_C00999
S_TIME_SUM
C REC_DEL_IND NOT ENABLED
NULL
TAL TRADE_DATE_T TRADE_DATE_PK
P ENABLED

A limitation for viewing information is that when the information is larger than one screen size, a scroll bar is used to move the focus of the screen up or down. The scroll bar is similar to those scroll bars used with desktop computer software, such as word processors or Internet browsers. When using a scroll bar, the entire screen may be shifted up or down. As a result, the headings for the columns may scroll off of the screen.

As shown in the following table, the loss of viewing of header information after scrolling down is illustrated as follows:

Figure USRE041902-20101026-C00002

As shown by the above table, the beading information is not viewable which may cause difficulty in interpreting the data. In an embodiment of the present invention, the scrolling may be improved by the header information being held on the top of the screen while the user scrolls up or down. The data below the heading may shift while the header information always stays at the top of the screen. As a result, the visual perception of the user may be improved.

The effect of scrolling to the end of a data set, while the header remains at the top of the screen, is shown in the following table where header information may be maintained after scrolling down two lines (one record) as follows:

Figure USRE041902-20101026-C00003

Note that in the above table, the last line (“FRED”, “DEPT”, “EMP_PK”) refers only to the “owner”, “tablename”, and “constraint” fields of the data. The “type”, “condition”, and “status” fields are not shown. This result is due to the screen scrolling only by one line at a time that results in only one of the two lines for a record being displayed. In an embodiment of the present invention, a further improvement of the existing process for monitoring and management of databases, may be to scroll up and/or down an entire record using the scroll bars. For example, if a record spans two lines, as in the table above, then using the scroll bars may move the entire record, i.e. two lines, up and down. In the table above, only one line at a time was moved. The effects of scrolling one record at a time are shown in the following table. In the table below, header information and complete records may be maintained after scrolling down, and the records are not split off of the screen at the bottom as shown as follows:

Figure USRE041902-20101026-C00004

In addition to the foregoing, color coding of records, fields, and/or borders may further enhance visual perception particularly in environments in which color is important. For example, all of the heading fields may be displayed in green, and all of the data fields may be displayed in white. Another example may be that all of the “owner” data fields and the “owner” heading may be in blue while all of the other data may be yellow. By displaying data in varying colors, the data information may be easier to perceive and/or to interpret by the user.

In an embodiment of the present invention, portions of data sets for browsing on wireless devices may be automatically wrapped. Due to the conventional nature of querying databases, many results return a significant amount of data. For example, a query of all objects in a database may return hundreds or even thousands of records. The amount of time to transmit this information over a wireless device is generally prohibitive. Also, a limit on the amount of data retrieved in a single call by a wireless device, which is not a limit on non-wireless-based products, typically exists. This limit cuts-off any additional data received that may possibly cause errors in the received data. To avoid this issue, the system and method of the present invention wraps the data.

Referring now to the drawings wherein like numerals refer to like parts, FIG. 1 illustrates a flowchart of an embodiment of various methods incorporated by the apparatus and/or system of the present invention. The flowchart illustrates retrieval of data from a database and determination if the number of records exceeds the threshold for wrapping 30. A large number of records may be anticipated and/or may be transferred 32 from a database or server 12 to a web or application server 14. The data may be retrieved from the database server 12 and may be stored in a memory 16 associated with the web or application server 14.

A program resident on a web or application server 14 may choose a threshold number as identified at step 33. A threshold number of records may be established. For example, the threshold may be thirty records. Of course, a determination as to another number of records that may be more optimal based upon the size of the records may be made. The program resident on the web or application server 14 may determine whether or not a result set is significantly large to the user such that one screen 36 is ineffective to display, as shown in step 34.

As will be apparent to one of skill in the art, the screen size will vary from one particular wireless device to another. In a preferred embodiment, upon connection of a wireless device to the database server, various hardware and firmware parameters will be available or determined, either from a set of predetermined variables, or based upon pre-existing information corresponding to the type of wireless device being used. In any event, since the system of the invention preferably knows the size of the screen of the wireless device, the system can determine in step 34, for example, whether the information needs to be broken down into several different screens or if the information may be displayed on just a single screen (as illustrated in step 36).

If the result set is too large such that one screen 36 is ineffective to display the result set, the data may break into several portions 38 and/or may wrap several navigation buttons around the result 40. The records may be displayed such that several sets of records are spread out over several screens 39. The buttons may be implemented to assist the user in navigating among the set of records by using the “first” 42, “back” 44, “next” 46, or “last” 48 commands. In addition, there may be provided a “go to” button 49 that allows the user to jump to a specific record directly. The result set of the query may be wrapped around the “first” 42, “back” 44, “next” 46, “last” 48 or “go to” 49 buttons. The buttons may control going to the first set of thirty records, the previous set of thirty records, the next set of thirty records, and the final set of thirty records, for example, or in the case of the “go to” button would allow the user to jump to a specific record directly. This is shown in the following table where a set of data may be wrapped using “first” 42, “back” 44, “next” 46, “last” 48 or “go to” 49 buttons.

<First><Back><Next><Last><Go To>
OWNER TABLE_NAME
SCOTT EMP
SCOTT DEPT
SCOTT INVENTORY
. . . . . .

The user may scroll through thirty (or the threshold predetermined for each screen by the web or application server) records. Selecting “First” 42 may bring up the first thirty records. Selecting “Back” 44 may retrieve the previous thirty records in the set. Selecting “Next” 46 may retrieve the next thirty records in the set. Selecting “Last” 48 may bring up the last thirty records (or portion thereof) in the set. Selecting “Go To” 49 would prompt the user to input a particular record number which, when entered, begins the display with the particular record number entered.

An alternative to the “First” 42, “Back” 44, “Next” 46, or “Last” 48 may be through other words or graphics, as shown in the following table where sets of data may be wrapped using “first”, “back”, “next”, “last” or “go to” icon buttons.

Figure USRE041902-20101026-C00005

Computations 41 may be made to determine which sets of records are contained in the last screen. For example, if there are 43 records, then the first set may contain records 1-30. The last set may contain records 31-43.

The present invention may also allow for maneuvering, as identified at a step 50 in FIG. 1, among the sets of 30 (or the threshold) records by jumping, as shown at a step 52, directly to a particular set. Jumping 52 directly to a particular set may be accomplished by the display of numbers representing a set of data. The following table illustrates wrapping of sets of data using numbered buttons to jump among sets.

Jump to Set:

<Previous> 1 2 3 4 5 6 7 8 9 10 <Next>
OWNER TABLE_NAME
SCOTT EMP
SCOTT DEPT
SCOTT INVENTORY
. . . . . .

In another embodiment of the present invention, the number of records in each set may be determined and/or the number of sets to display may be determined. In the table above, ten sets may be displayed. Clicking on “Previous” may go to the previous ten sets, and clicking on “Next” may go to the next ten sets.

Between screens, session information may be stored on the system of the user that issued the query. Also, pointers may be maintained to the record that the user last requested which maintains to which set of thirty records is currently pointed, and enables the web or application server 14 to move among the sets of thirty records. Also, in the event that the session times out, the user must re-enter his or her password. However, the present invention may allow use of the current set of information without having to re-query or retrieve all data from the database an additional time.

Referring to FIG. 2, a black box diagram of, an embodiment of a system 10 for the display of database information on a graph 22 or other format on, for example, a wireless device 18 is illustrated. Database information is displayed in a graph 22 or other format on a wireless device 18. The wireless device 18 of the present invention may query a database server 12 for data through a web or application server 14. Data may be retrieved from the database server 12 and stored in a memory 16 on the web or application server 14. When the data is returned as the result of a query, the data may be transferred to a graphing program 20. The graphing program 20, which preferably may be a native program on the wireless device 18 (typically written in C or C++ but may be written in any language), may take the data and may display the date in a graph 22 on a screen of the wireless device 18. The graph 22 may be a bar-chart, pie-chart, or in an other format determined by the user, the DBA or the like.

The query of the wireless device 18 may extend the basic functionality of wireless applications which cannot process and graph data. In an embodiment of the present invention, data may be retrieved from the database server 12,

Figure USRE041902-20101026-C00006

automatically input the same into the graphing program, computed, and displayed as a graph 22 on the wireless devices 18 for the user. The following illustration is an example of a bar chart displayed by the invention. The graph 22 is displayed, followed by the actual data upon which the graph 22 is based.

-Tablespace-
Total Activity Reads Writes
-RBS-
37  11 26
-SYSTEM-
1109   1093 16
-OEM REPOSITORY-
4 3 1
-RBS-
4 3 1
-RBS-
4 3 1
-RBS-
4 3 1

The following illustration is an example of a pie-chart. Below is the percent of sorts in memory:

Sorts of Memory Sorts on disk Total Rows
798 84 11246
11% of Sorting was done in Memory
Figure USRE041902-20101026-C00007

In another embodiment of the present invention, graphs 22 or other formats on the wireless device 18 may be auto-scaled. A graph 22 may have static or dynamic scales for an axis. For example, percentages always fall between 0 and 100 percent. Thus, a graph 22 of percentage, for example, always has the same X-axis scale. Other graphs 22, such as, for example, the size of objects, may vary depending upon the particular context for the data. For example, a table may vary from ten units to 1,000 units, 100,000 units, 100,000,000 units, or more.

When creating the graph 22 on the wireless device 18, the graphing program 20 may first decide to display data on a static axis or a dynamically scalable axis, such as, for example, an x-axis. In cases where the scale is static, such as the PERCENTAGE in the illustration above (which is always 0-100), no scaling is needed. If the scale were to change depending on the data, a formula may be applied to correlate the X-axis tick marks. The following chart shows data graphed where the largest data size (USERS) is 13.5 M. The present invention may receive all data and then determine that 15 M is the appropriate largest size of data for the X-Axis. The present invention may then determine the major “tick” points, which, in the case of the bar chart shown below are 3 M, 6 M, 9 M, and 12 M. The following are the total size of tablespaces:

Figure USRE041902-20101026-C00008

The following bar chart shows similar data graphed for a larger database, in which case the largest tablespace is 450 M, with the X-Axis scaled for 500 M. The following are the total size of tablespaces:

Figure USRE041902-20101026-C00009

In this example, data of any size may be displayed on the handheld device.

Referring now to FIG. 3, the wireless device 18 is generally illustrated. The wireless device 18 may have buttons 64, a scroll bar 66, a display means 62, and a wireless means 68 for accessing the web server 14. In the embodiment illustrated in FIG. 3, the wireless device 18 is a dedicated device manufactured as a tool for wireless communication for the monitoring and management of databases. Further, the wireless device 18, as illustrated, may be any handheld device capable of wireless communication, such as, for example, a Palm pilot, telephone, or the like.

It should be understood that various changes and modifications to the presently preferred embodiments described herein will be apparent to those skilled in the art. Such changes and modifications may be made without departing from the spirit and scope of the present invention and without diminishing its attendant advantages.

Claims (80)

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.
US11/498,300 2000-11-09 2006-08-03 System, method and apparatus for wireless monitoring and management of computer systems Active USRE41902E1 (en)

Priority Applications (3)

Application Number Priority Date Filing Date Title
US24752300P true 2000-11-09 2000-11-09
US09/964,912 US6772169B2 (en) 2000-11-09 2001-09-27 System, method and apparatus for the wireless monitoring and management of computer systems
US11/498,300 USRE41902E1 (en) 2000-11-09 2006-08-03 System, method and apparatus for wireless monitoring and management of computer systems

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
US11/498,300 USRE41902E1 (en) 2000-11-09 2006-08-03 System, method and apparatus for wireless monitoring and management of computer systems

Related Parent Applications (1)

Application Number Title Priority Date Filing Date
US09/964,912 Reissue US6772169B2 (en) 2000-11-09 2001-09-27 System, method and apparatus for the wireless monitoring and management of computer systems

Publications (1)

Publication Number Publication Date
USRE41902E1 true USRE41902E1 (en) 2010-10-26

Family

ID=22935229

Family Applications (4)

Application Number Title Priority Date Filing Date
US10/040,524 Abandoned US20020146129A1 (en) 2000-11-09 2001-11-01 Method and system for secure wireless database management
US10/007,912 Active 2022-02-14 US7496554B2 (en) 2000-11-09 2001-11-08 Method and system for wireless database management
US11/498,300 Active USRE41902E1 (en) 2000-11-09 2006-08-03 System, method and apparatus for wireless monitoring and management of computer systems
US12/369,461 Active 2022-11-04 US8065284B2 (en) 2000-11-09 2009-02-11 Method and system for wireless database management

Family Applications Before (2)

Application Number Title Priority Date Filing Date
US10/040,524 Abandoned US20020146129A1 (en) 2000-11-09 2001-11-01 Method and system for secure wireless database management
US10/007,912 Active 2022-02-14 US7496554B2 (en) 2000-11-09 2001-11-08 Method and system for wireless database management

Family Applications After (1)

Application Number Title Priority Date Filing Date
US12/369,461 Active 2022-11-04 US8065284B2 (en) 2000-11-09 2009-02-11 Method and system for wireless database management

Country Status (3)

Country Link
US (4) US20020146129A1 (en)
AU (2) AU2883002A (en)
WO (2) WO2002039637A1 (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US8988418B1 (en) 2007-01-05 2015-03-24 Florelle, Inc. System and method for parametric display of modular aesthetic designs

Families Citing this family (106)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7406315B2 (en) * 2001-03-20 2008-07-29 Arraycomm Llc Method and apparatus for resource management in a wireless data communication system
US7702801B1 (en) * 2001-04-19 2010-04-20 Advanced Micro Devices, Inc. Determining logon status in a broadband network system and automatically restoring logon connectivity
US7363376B2 (en) * 2001-07-31 2008-04-22 Arraycomm Llc Method and apparatus for generating an identifier to facilitate delivery of enhanced data services in a mobile computing environment
US8020201B2 (en) * 2001-10-23 2011-09-13 Intel Corporation Selecting a security format conversion for wired and wireless devices
US8601566B2 (en) * 2001-10-23 2013-12-03 Intel Corporation Mechanism supporting wired and wireless methods for client and server side authentication
US7233960B1 (en) * 2001-10-31 2007-06-19 Numoda Corporation System and method for mobile wireless electronic data capture and distribution of a merchant card-processing application
KR100414794B1 (en) * 2001-11-22 2004-01-13 에스케이 텔레콤주식회사 Method for connecting a wireless internet service
EP1466261B1 (en) 2002-01-08 2018-03-07 Seven Networks, LLC Connection architecture for a mobile network
US8910241B2 (en) 2002-04-25 2014-12-09 Citrix Systems, Inc. Computer security system
US7644434B2 (en) * 2002-04-25 2010-01-05 Applied Identity, Inc. Computer security system
DE10226650B4 (en) * 2002-06-14 2004-07-22 Siemens Ag A method for controlling a data transmission procedure over radio channels
US7215638B1 (en) * 2002-06-19 2007-05-08 Meshnetworks, Inc. System and method to provide 911 access in voice over internet protocol systems without compromising network security
US7237024B2 (en) * 2002-10-15 2007-06-26 Aol Llc Cross-site timed out authentication management
US7346930B1 (en) 2002-10-31 2008-03-18 Sprint Communications Company L.P. Security framework bridge
US7454785B2 (en) * 2002-12-19 2008-11-18 Avocent Huntsville Corporation Proxy method and system for secure wireless administration of managed entities
US7394761B2 (en) * 2003-04-29 2008-07-01 Avocent Huntsville Corporation System and method for delivering messages using alternate modes of communication
US7346062B2 (en) * 2003-07-10 2008-03-18 International Business Machines Corporation Apparatus and method to coordinate calendar searches in a network scheduler given limited resources
US9262490B2 (en) 2004-08-12 2016-02-16 Oracle International Corporation Adaptively routing transactions to servers
US7447780B2 (en) * 2003-11-21 2008-11-04 Time Warner Cable, Inc. Technique for communicating information over a broadband communications network
WO2005057842A1 (en) * 2003-12-11 2005-06-23 Auckland Uniservices Limited A wireless lan system
US7263717B1 (en) * 2003-12-17 2007-08-28 Sprint Communications Company L.P. Integrated security framework and privacy database scheme
WO2005066737A1 (en) * 2003-12-31 2005-07-21 Applied Identity Method and system for establishing the identity of an originator of computer transactions
WO2006045102A2 (en) 2004-10-20 2006-04-27 Seven Networks, Inc. Method and apparatus for intercepting events in a communication system
US8010082B2 (en) 2004-10-20 2011-08-30 Seven Networks, Inc. Flexible billing architecture
US7706781B2 (en) 2004-11-22 2010-04-27 Seven Networks International Oy Data security in a mobile e-mail service
FI117152B (en) 2004-12-03 2006-06-30 Seven Networks Internat Oy The introduction of mobile e-mail settings
US9300641B2 (en) * 2005-02-11 2016-03-29 Nokia Corporation Method and apparatus for providing bootstrapping procedures in a communication network
US7752633B1 (en) 2005-03-14 2010-07-06 Seven Networks, Inc. Cross-platform event engine
US7796742B1 (en) 2005-04-21 2010-09-14 Seven Networks, Inc. Systems and methods for simplified provisioning
US8438633B1 (en) 2005-04-21 2013-05-07 Seven Networks, Inc. Flexible real-time inbox access
WO2006136660A1 (en) 2005-06-21 2006-12-28 Seven Networks International Oy Maintaining an ip connection in a mobile network
US8468126B2 (en) 2005-08-01 2013-06-18 Seven Networks, Inc. Publishing data in an information community
US7917468B2 (en) 2005-08-01 2011-03-29 Seven Networks, Inc. Linking of personal information management data
US7853563B2 (en) 2005-08-01 2010-12-14 Seven Networks, Inc. Universal data aggregation
US8069166B2 (en) 2005-08-01 2011-11-29 Seven Networks, Inc. Managing user-to-user contact with inferred presence information
US7769395B2 (en) 2006-06-20 2010-08-03 Seven Networks, Inc. Location-based operations and messaging
US9069870B2 (en) * 2006-07-12 2015-06-30 International Business Machines Corporation Client-side aggregation of context-sensitive request results where results for aggregation are asynchronously produced by multiple servers
US9432243B2 (en) * 2007-08-22 2016-08-30 International Business Machines Corporation Re-using asynchronous server-side results generated for a request context of one client to satisfy a request context of a different client
US20080127234A1 (en) * 2006-09-19 2008-05-29 International Business Machines Corporation Methods, systems, and computer program products for a remote request dispatcher extension framework for container based programming models
US8693494B2 (en) 2007-06-01 2014-04-08 Seven Networks, Inc. Polling
US8805425B2 (en) 2007-06-01 2014-08-12 Seven Networks, Inc. Integrated messaging
EP2224339A3 (en) 2007-09-12 2011-03-16 Citrix Systems, Inc. Methods and systems for generating desktop environments providing integrated access to remote and local resources
US8516539B2 (en) 2007-11-09 2013-08-20 Citrix Systems, Inc System and method for inferring access policies from access event records
US8990910B2 (en) 2007-11-13 2015-03-24 Citrix Systems, Inc. System and method using globally unique identities
US8364181B2 (en) 2007-12-10 2013-01-29 Seven Networks, Inc. Electronic-mail filtering for mobile devices
US8793305B2 (en) 2007-12-13 2014-07-29 Seven Networks, Inc. Content delivery to a mobile device from a content service
US9002828B2 (en) 2007-12-13 2015-04-07 Seven Networks, Inc. Predictive content delivery
US8107921B2 (en) 2008-01-11 2012-01-31 Seven Networks, Inc. Mobile virtual network operator
US8862657B2 (en) 2008-01-25 2014-10-14 Seven Networks, Inc. Policy based content service
US20090193338A1 (en) 2008-01-28 2009-07-30 Trevor Fiatal Reducing network and battery consumption during content delivery and playback
US9240945B2 (en) 2008-03-19 2016-01-19 Citrix Systems, Inc. Access, priority and bandwidth management based on application identity
US8943575B2 (en) * 2008-04-30 2015-01-27 Citrix Systems, Inc. Method and system for policy simulation
US8787947B2 (en) 2008-06-18 2014-07-22 Seven Networks, Inc. Application discovery on mobile devices
US8078158B2 (en) 2008-06-26 2011-12-13 Seven Networks, Inc. Provisioning applications for a mobile device
US8909759B2 (en) 2008-10-10 2014-12-09 Seven Networks, Inc. Bandwidth measurement
CN101730115B (en) 2008-10-24 2013-01-30 华为技术有限公司 Relay transmission method and device
US8990573B2 (en) 2008-11-10 2015-03-24 Citrix Systems, Inc. System and method for using variable security tag location in network communications
US8837716B2 (en) * 2009-02-02 2014-09-16 Apple Inc. Sensor derived authentication for establishing peer-to-peer networks
US8862696B2 (en) * 2009-09-08 2014-10-14 Sony Corporation Interconnecting applications on personal computers and mobile terminals through a web server
US20110219113A1 (en) * 2010-03-02 2011-09-08 Grewal Avininder Pal Singh Method and system for client assisted stateful handling of packets in a communications network
US9043731B2 (en) 2010-03-30 2015-05-26 Seven Networks, Inc. 3D mobile user interface with configurable workspace management
WO2012018556A2 (en) 2010-07-26 2012-02-09 Ari Backholm Mobile application traffic optimization
JP5620578B2 (en) 2010-07-26 2014-11-05 セブン ネットワークス インコーポレイテッド Mobile network traffic adjustment across multiple applications
US8838783B2 (en) 2010-07-26 2014-09-16 Seven Networks, Inc. Distributed caching for resource and mobile network traffic management
US9077630B2 (en) 2010-07-26 2015-07-07 Seven Networks, Inc. Distributed implementation of dynamic wireless traffic policy
WO2012054930A2 (en) * 2010-10-22 2012-04-26 Datavail Corporation Centralized private network and database monitoring
WO2012061430A2 (en) 2010-11-01 2012-05-10 Michael Luna Distributed management of keep-alive message signaling for mobile network resource conservation and optimization
GB2499534B (en) 2010-11-01 2018-09-19 Seven Networks Llc Caching adapted for mobile application behavior and network conditions
US8843153B2 (en) 2010-11-01 2014-09-23 Seven Networks, Inc. Mobile traffic categorization and policy for network use optimization while preserving user experience
US9060032B2 (en) 2010-11-01 2015-06-16 Seven Networks, Inc. Selective data compression by a distributed traffic management system to reduce mobile data traffic and signaling traffic
WO2012061437A1 (en) 2010-11-01 2012-05-10 Michael Luna Cache defeat detection and caching of content addressed by identifiers intended to defeat cache
US9330196B2 (en) 2010-11-01 2016-05-03 Seven Networks, Llc Wireless traffic management system cache optimization using http headers
US8484314B2 (en) 2010-11-01 2013-07-09 Seven Networks, Inc. Distributed caching in a wireless network of content delivered for a mobile application over a long-held request
WO2012060995A2 (en) 2010-11-01 2012-05-10 Michael Luna Distributed caching in a wireless network of content delivered for a mobile application over a long-held request
WO2012060997A2 (en) 2010-11-01 2012-05-10 Michael Luna Application and network-based long poll request detection and cacheability assessment therefor
GB2500327A (en) 2010-11-22 2013-09-18 Seven Networks Inc Optimization of resource polling intervals to satisfy mobile device requests
WO2012071283A1 (en) 2010-11-22 2012-05-31 Michael Luna Aligning data transfer to optimize connections established for transmission over a wireless network
GB2501416B (en) 2011-01-07 2018-03-21 Seven Networks Llc System and method for reduction of mobile network traffic used for domain name system (DNS) queries
EP2700019B1 (en) 2011-04-19 2019-03-27 Seven Networks, LLC Social caching for device resource sharing and management
WO2012149434A2 (en) 2011-04-27 2012-11-01 Seven Networks, Inc. Detecting and preserving state for satisfying application requests in a distributed proxy and cache system
US8832228B2 (en) 2011-04-27 2014-09-09 Seven Networks, Inc. System and method for making requests on behalf of a mobile device based on atomic processes for mobile network traffic relief
US9239800B2 (en) 2011-07-27 2016-01-19 Seven Networks, Llc Automatic generation and distribution of policy information regarding malicious mobile traffic in a wireless network
EP2789137A4 (en) 2011-12-06 2015-12-02 Seven Networks Inc A system of redundantly clustered machines to provide failover mechanisms for mobile traffic management and network resource conservation
US8934414B2 (en) 2011-12-06 2015-01-13 Seven Networks, Inc. Cellular or WiFi mobile traffic optimization based on public or private network destination
GB2498064A (en) 2011-12-07 2013-07-03 Seven Networks Inc Distributed content caching mechanism using a network operator proxy
US9277443B2 (en) 2011-12-07 2016-03-01 Seven Networks, Llc Radio-awareness of mobile device for sending server-side control signals using a wireless network optimized transport protocol
WO2013090834A1 (en) 2011-12-14 2013-06-20 Seven Networks, Inc. Operation modes for mobile traffic optimization and concurrent management of optimized and non-optimized traffic
WO2013090821A1 (en) 2011-12-14 2013-06-20 Seven Networks, Inc. Hierarchies and categories for management and deployment of policies for distributed wireless traffic optimization
US20130159511A1 (en) 2011-12-14 2013-06-20 Seven Networks, Inc. System and method for generating a report to a network operator by distributing aggregation of data
EP2801236A4 (en) 2012-01-05 2015-10-21 Seven Networks Inc Detection and management of user interactions with foreground applications on a mobile device in distributed caching
WO2013116856A1 (en) 2012-02-02 2013-08-08 Seven Networks, Inc. Dynamic categorization of applications for network access in a mobile network
WO2013116852A1 (en) 2012-02-03 2013-08-08 Seven Networks, Inc. User as an end point for profiling and optimizing the delivery of content and data in a wireless network
US8812695B2 (en) 2012-04-09 2014-08-19 Seven Networks, Inc. Method and system for management of a virtual network connection without heartbeat messages
US10263899B2 (en) 2012-04-10 2019-04-16 Seven Networks, Llc Enhanced customer service for mobile carriers using real-time and historical mobile application and traffic or optimization data associated with mobile devices in a mobile network
CN103491534B (en) * 2012-06-13 2016-05-18 株式会社理光 A transmitting device, a receiving device, a communication system and a control method
US8775631B2 (en) 2012-07-13 2014-07-08 Seven Networks, Inc. Dynamic bandwidth adjustment for browsing or streaming activity in a wireless network based on prediction of user behavior when interacting with mobile applications
US8838535B2 (en) * 2012-10-05 2014-09-16 Oracle International Corporation Providing services across systems that manage distributed replicas
US9161258B2 (en) 2012-10-24 2015-10-13 Seven Networks, Llc Optimized and selective management of policy deployment to mobile clients in a congested network to prevent further aggravation of network congestion
US20140149392A1 (en) * 2012-11-28 2014-05-29 Microsoft Corporation Unified search result service and cache update
US9307493B2 (en) 2012-12-20 2016-04-05 Seven Networks, Llc Systems and methods for application management of mobile device radio state promotion and demotion
US9241314B2 (en) 2013-01-23 2016-01-19 Seven Networks, Llc Mobile device with application or context aware fast dormancy
US8874761B2 (en) 2013-01-25 2014-10-28 Seven Networks, Inc. Signaling optimization in a wireless network for traffic utilizing proprietary and non-proprietary protocols
US8750123B1 (en) 2013-03-11 2014-06-10 Seven Networks, Inc. Mobile device equipped with mobile network congestion recognition to make intelligent decisions regarding connecting to an operator network
US9065765B2 (en) 2013-07-22 2015-06-23 Seven Networks, Inc. Proxy server associated with a mobile carrier for enhancing mobile traffic management in a mobile network
US9509827B2 (en) * 2014-03-12 2016-11-29 Intel IP Corporation Apparatus, system and method of managing at a mobile device execution of an application by a computing device
US9842148B2 (en) 2015-05-05 2017-12-12 Oracle International Corporation Method for failure-resilient data placement in a distributed query processing system

Citations (47)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US4739319A (en) * 1984-08-11 1988-04-19 Nippondenso Co., Ltd. Bar graph display apparatus
US5615268A (en) 1995-01-17 1997-03-25 Document Authentication Systems, Inc. System and method for electronic transmission storage and retrieval of authenticated documents
US5696898A (en) 1995-06-06 1997-12-09 Lucent Technologies Inc. System and method for database access control
US5696701A (en) 1996-07-12 1997-12-09 Electronic Data Systems Corporation Method and system for monitoring the performance of computers in computer networks using modular extensions
US5713018A (en) 1995-09-27 1998-01-27 Sun Microsystems, Inc. System and method for providing safe SQL-level access to a database
US5812131A (en) * 1997-03-07 1998-09-22 International Business Machines Corp. Mobile client computer programmed to process table displays
US5881232A (en) 1996-07-23 1999-03-09 International Business Machines Corporation Generic SQL query agent
US5926549A (en) 1996-02-12 1999-07-20 Bull S.A. Process for verifying the preservation of the integrity of an unprotected request sent by a client to a server by verifying the integrity of the response
US5963965A (en) 1997-02-18 1999-10-05 Semio Corporation Text processing and retrieval system and method
US6005561A (en) 1994-12-14 1999-12-21 The 3Do Company Interactive information delivery system
US6023762A (en) 1997-07-09 2000-02-08 Northern Telecom Limited Multi-view personalized communications agent
US6073168A (en) 1996-06-03 2000-06-06 Webtv Networks, Inc. Method for reducing delivery latency of an image or other secondary information associated with a file
US6088796A (en) 1998-08-06 2000-07-11 Cianfrocca; Francis Secure middleware and server control system for querying through a network firewall
US6098092A (en) * 1996-11-08 2000-08-01 Silicon Graphics, Inc. Server to dynamically generate graphics for the world wide web
US6097336A (en) 1999-01-08 2000-08-01 Trueposition, Inc. Method for improving the accuracy of a wireless location system
US6105006A (en) 1997-12-22 2000-08-15 Motorola Inc Transaction authentication for 1-way wireless financial messaging units
US6122666A (en) 1998-02-23 2000-09-19 International Business Machines Corporation Method for collaborative transformation and caching of web objects in a proxy network
US6128655A (en) 1998-07-10 2000-10-03 International Business Machines Corporation Distribution mechanism for filtering, formatting and reuse of web based content
US6141755A (en) 1998-04-13 2000-10-31 The United States Of America As Represented By The Director Of The National Security Agency Firewall security apparatus for high-speed circuit switched networks
US6170017B1 (en) 1997-05-08 2001-01-02 International Business Machines Corporation Method and system coordinating actions among a group of servers
US6178505B1 (en) 1997-03-10 2001-01-23 Internet Dynamics, Inc. Secure delivery of information in a network
US6182083B1 (en) 1997-11-17 2001-01-30 Sun Microsystems, Inc. Method and system for multi-entry and multi-template matching in a database
US6205440B1 (en) 1998-11-06 2001-03-20 International Business Machines Corporation Method of providing information from query results stored as source code files
US6233577B1 (en) 1998-02-17 2001-05-15 Phone.Com, Inc. Centralized certificate management system for two-way interactive communication devices in data networks
US6249755B1 (en) * 1994-05-25 2001-06-19 System Management Arts, Inc. Apparatus and method for event correlation and problem reporting
US6253326B1 (en) 1998-05-29 2001-06-26 Palm, Inc. Method and system for secure communications
US6263437B1 (en) 1998-02-19 2001-07-17 Openware Systems Inc Method and apparatus for conducting crypto-ignition processes between thin client devices and server devices over data networks
US6269402B1 (en) 1998-07-20 2001-07-31 Motorola, Inc. Method for providing seamless communication across bearers in a wireless communication system
US20010049277A1 (en) 2000-02-14 2001-12-06 Meyer Shane D. Secondary data encoded along with original data for generating responses to requests from wireless devices
US20020031230A1 (en) 2000-08-15 2002-03-14 Sweet William B. Method and apparatus for a web-based application service model for security management
US6359880B1 (en) 1997-03-11 2002-03-19 James E. Curry Public wireless/cordless internet gateway
US6389437B2 (en) * 1998-01-07 2002-05-14 Ion Systems, Inc. System for converting scrolling display to non-scrolling columnar display
US6405123B1 (en) 1999-12-21 2002-06-11 Televigation, Inc. Method and system for an efficient operating environment in a real-time navigation system
US6415138B2 (en) * 1997-11-27 2002-07-02 Nokia Mobile Phones Ltd. Wireless communication device and a method of manufacturing a wireless communication device
US6456603B1 (en) 1999-01-21 2002-09-24 Telefonaktiebolaget L M Ericsson (Publ) Method of supporting communications mobility in a telecommunications system
US6473609B1 (en) 1995-12-11 2002-10-29 Openwave Systems Inc. Method and architecture for interactive two-way communication devices to interact with a network
US6480891B1 (en) 1999-01-04 2002-11-12 3Com Corporation Embedded code memory size reduction in asynchronous mode transfer devices
US6516203B1 (en) 1999-12-22 2003-02-04 Bellsouth Intellectual Property Corporation Method and system for providing additional information to a subscriber based on a universal resource locator
US6574742B1 (en) 1999-11-12 2003-06-03 Insite One, Llc Method for storing and accessing digital medical images
US6587835B1 (en) 2000-02-09 2003-07-01 G. Victor Treyz Shopping assistance with handheld computing device
US6591306B1 (en) 1999-04-01 2003-07-08 Nec Corporation IP network access for portable devices
US6636873B1 (en) 2000-04-17 2003-10-21 Oracle International Corporation Methods and systems for synchronization of mobile devices with a remote database
US6636898B1 (en) 1999-01-29 2003-10-21 International Business Machines Corporation System and method for central management of connections in a virtual private network
US6642945B1 (en) * 2000-05-04 2003-11-04 Microsoft Corporation Method and system for optimizing a visual display for handheld computer systems
US6775291B1 (en) 1999-08-28 2004-08-10 Lg Information & Communications, Ltd. Wireless internet service method in gateway system
US6895234B1 (en) 1997-12-09 2005-05-17 Openwave Systems Inc. Method and apparatus for accessing a common database from a mobile device and a computing device
US6920487B2 (en) 1999-12-22 2005-07-19 Starhome Gmbh System and methods for global access to services for mobile telephone subscribers

Family Cites Families (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US2001A (en) * 1841-03-12 Sawmill
US2002A (en) * 1841-03-12 Tor and planter for plowing
US7035828B2 (en) * 2000-10-25 2006-04-25 Topmoxie, Inc. Method and system for modifying and transmitting data between a portable computer and a network
US6714944B1 (en) * 1999-11-30 2004-03-30 Verivita Llc System and method for authenticating and registering personal background data
US20020046091A1 (en) 2000-01-11 2002-04-18 Robert Mooers Interactive incentive marketing system
EP1188264B1 (en) * 2000-04-27 2012-08-08 KTFreetel Co., Ltd System and method for supervising repeater by using wireless mobile
US6792466B1 (en) * 2000-05-09 2004-09-14 Sun Microsystems, Inc. Trusted construction of message endpoints in a distributed computing environment
US7287072B1 (en) * 2000-10-17 2007-10-23 Sprint Communications Company L.P. Remote monitoring information management
US7577732B2 (en) * 2003-03-28 2009-08-18 Fujitsu Limited Information distribution service providing system

Patent Citations (47)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US4739319A (en) * 1984-08-11 1988-04-19 Nippondenso Co., Ltd. Bar graph display apparatus
US6249755B1 (en) * 1994-05-25 2001-06-19 System Management Arts, Inc. Apparatus and method for event correlation and problem reporting
US6005561A (en) 1994-12-14 1999-12-21 The 3Do Company Interactive information delivery system
US5615268A (en) 1995-01-17 1997-03-25 Document Authentication Systems, Inc. System and method for electronic transmission storage and retrieval of authenticated documents
US5696898A (en) 1995-06-06 1997-12-09 Lucent Technologies Inc. System and method for database access control
US5713018A (en) 1995-09-27 1998-01-27 Sun Microsystems, Inc. System and method for providing safe SQL-level access to a database
US6473609B1 (en) 1995-12-11 2002-10-29 Openwave Systems Inc. Method and architecture for interactive two-way communication devices to interact with a network
US5926549A (en) 1996-02-12 1999-07-20 Bull S.A. Process for verifying the preservation of the integrity of an unprotected request sent by a client to a server by verifying the integrity of the response
US6073168A (en) 1996-06-03 2000-06-06 Webtv Networks, Inc. Method for reducing delivery latency of an image or other secondary information associated with a file
US5696701A (en) 1996-07-12 1997-12-09 Electronic Data Systems Corporation Method and system for monitoring the performance of computers in computer networks using modular extensions
US5881232A (en) 1996-07-23 1999-03-09 International Business Machines Corporation Generic SQL query agent
US6098092A (en) * 1996-11-08 2000-08-01 Silicon Graphics, Inc. Server to dynamically generate graphics for the world wide web
US5963965A (en) 1997-02-18 1999-10-05 Semio Corporation Text processing and retrieval system and method
US5812131A (en) * 1997-03-07 1998-09-22 International Business Machines Corp. Mobile client computer programmed to process table displays
US6178505B1 (en) 1997-03-10 2001-01-23 Internet Dynamics, Inc. Secure delivery of information in a network
US6359880B1 (en) 1997-03-11 2002-03-19 James E. Curry Public wireless/cordless internet gateway
US6170017B1 (en) 1997-05-08 2001-01-02 International Business Machines Corporation Method and system coordinating actions among a group of servers
US6023762A (en) 1997-07-09 2000-02-08 Northern Telecom Limited Multi-view personalized communications agent
US6182083B1 (en) 1997-11-17 2001-01-30 Sun Microsystems, Inc. Method and system for multi-entry and multi-template matching in a database
US6415138B2 (en) * 1997-11-27 2002-07-02 Nokia Mobile Phones Ltd. Wireless communication device and a method of manufacturing a wireless communication device
US6895234B1 (en) 1997-12-09 2005-05-17 Openwave Systems Inc. Method and apparatus for accessing a common database from a mobile device and a computing device
US6105006A (en) 1997-12-22 2000-08-15 Motorola Inc Transaction authentication for 1-way wireless financial messaging units
US6389437B2 (en) * 1998-01-07 2002-05-14 Ion Systems, Inc. System for converting scrolling display to non-scrolling columnar display
US6233577B1 (en) 1998-02-17 2001-05-15 Phone.Com, Inc. Centralized certificate management system for two-way interactive communication devices in data networks
US6263437B1 (en) 1998-02-19 2001-07-17 Openware Systems Inc Method and apparatus for conducting crypto-ignition processes between thin client devices and server devices over data networks
US6122666A (en) 1998-02-23 2000-09-19 International Business Machines Corporation Method for collaborative transformation and caching of web objects in a proxy network
US6141755A (en) 1998-04-13 2000-10-31 The United States Of America As Represented By The Director Of The National Security Agency Firewall security apparatus for high-speed circuit switched networks
US6253326B1 (en) 1998-05-29 2001-06-26 Palm, Inc. Method and system for secure communications
US6128655A (en) 1998-07-10 2000-10-03 International Business Machines Corporation Distribution mechanism for filtering, formatting and reuse of web based content
US6269402B1 (en) 1998-07-20 2001-07-31 Motorola, Inc. Method for providing seamless communication across bearers in a wireless communication system
US6088796A (en) 1998-08-06 2000-07-11 Cianfrocca; Francis Secure middleware and server control system for querying through a network firewall
US6205440B1 (en) 1998-11-06 2001-03-20 International Business Machines Corporation Method of providing information from query results stored as source code files
US6480891B1 (en) 1999-01-04 2002-11-12 3Com Corporation Embedded code memory size reduction in asynchronous mode transfer devices
US6097336A (en) 1999-01-08 2000-08-01 Trueposition, Inc. Method for improving the accuracy of a wireless location system
US6456603B1 (en) 1999-01-21 2002-09-24 Telefonaktiebolaget L M Ericsson (Publ) Method of supporting communications mobility in a telecommunications system
US6636898B1 (en) 1999-01-29 2003-10-21 International Business Machines Corporation System and method for central management of connections in a virtual private network
US6591306B1 (en) 1999-04-01 2003-07-08 Nec Corporation IP network access for portable devices
US6775291B1 (en) 1999-08-28 2004-08-10 Lg Information & Communications, Ltd. Wireless internet service method in gateway system
US6574742B1 (en) 1999-11-12 2003-06-03 Insite One, Llc Method for storing and accessing digital medical images
US6405123B1 (en) 1999-12-21 2002-06-11 Televigation, Inc. Method and system for an efficient operating environment in a real-time navigation system
US6516203B1 (en) 1999-12-22 2003-02-04 Bellsouth Intellectual Property Corporation Method and system for providing additional information to a subscriber based on a universal resource locator
US6920487B2 (en) 1999-12-22 2005-07-19 Starhome Gmbh System and methods for global access to services for mobile telephone subscribers
US6587835B1 (en) 2000-02-09 2003-07-01 G. Victor Treyz Shopping assistance with handheld computing device
US20010049277A1 (en) 2000-02-14 2001-12-06 Meyer Shane D. Secondary data encoded along with original data for generating responses to requests from wireless devices
US6636873B1 (en) 2000-04-17 2003-10-21 Oracle International Corporation Methods and systems for synchronization of mobile devices with a remote database
US6642945B1 (en) * 2000-05-04 2003-11-04 Microsoft Corporation Method and system for optimizing a visual display for handheld computer systems
US20020031230A1 (en) 2000-08-15 2002-03-14 Sweet William B. Method and apparatus for a web-based application service model for security management

Non-Patent Citations (6)

* Cited by examiner, † Cited by third party
Title
PCT International Preliminary Examination Report mailed by the U.S. Receiving Office for Application No. PCT/US01/46752 on Nov. 19, 2002.
PCT International Preliminary Examination Report prepared by the U.S. Patent & Trademark Office for Application No. PCT/US01/46751, mailed on Dec. 26, 2002.
PCT International Preliminary Examination Report prepared by the U.S. Patent & Trademark Office for Application No. PCT/US01/46824, mailed on Sep. 4, 2002.
PCT International Search Report prepared by the U.S. Receiving Office for Application No. PCT/US01/46751, mailed on May 6, 2002.
PCT International Search Report prepared by the U.S. Receiving Office for Application No. PCT/US01/46752, mailed on Apr. 19, 2002.
PCT International Search Report prepared by the U.S. Receiving Office for Application No. PCT/US01/46824, mailed on Apr. 2, 2002.

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US8988418B1 (en) 2007-01-05 2015-03-24 Florelle, Inc. System and method for parametric display of modular aesthetic designs

Also Published As

Publication number Publication date
AU2883002A (en) 2002-05-21
US7496554B2 (en) 2009-02-24
US20020083044A1 (en) 2002-06-27
WO2002039646A3 (en) 2002-08-29
WO2002039646A2 (en) 2002-05-16
AU2883102A (en) 2002-05-21
US20020146129A1 (en) 2002-10-10
US20090150410A1 (en) 2009-06-11
WO2002039637A1 (en) 2002-05-16
US8065284B2 (en) 2011-11-22

Similar Documents

Publication Publication Date Title
US5864856A (en) Process and apparatus for simplifying access to information stored in databases
US6279016B1 (en) Standardized filtering control techniques
KR100446183B1 (en) Database System
US6260044B1 (en) Information storage and retrieval system for storing and retrieving the visual form of information from an application in a database
US8775560B2 (en) Host-based intelligent results related to a character stream
US6778993B2 (en) Generic attribute database system
US6789075B1 (en) Method and system for prioritized downloading of embedded web objects
US5987481A (en) Method and apparatus for using label references in spreadsheet formulas
AU2006291316B2 (en) Filtering user interface for a data summary table
US6349315B1 (en) Document output apparatus
JP2739015B2 (en) Method and a computer system into a multi-directional between the graphical format representation and a text format representation of a database query
US6480842B1 (en) Dimension to domain server
US5721900A (en) Method and apparatus for graphically displaying query relationships
JP3735684B2 (en) Computing apparatus and method for displaying data by the interactive split pie
US5630122A (en) Computerized report-based interactive database query interface
US7406477B2 (en) Database system with methodology for automated determination and selection of optimal indexes
EP0620516A1 (en) Computer system using the notebook metaphol
US6119126A (en) Object-relational query builder which determines existence of structures from information loaded from the server and cached locally on the client computing system
US20020161799A1 (en) Spreadsheet error checker
US6421662B1 (en) Generating and implementing indexes based on criteria set forth in queries
CA2617866C (en) User interface for creating a spreadsheet data summary table
EP1076865B1 (en) Database access tool
EP0509947A2 (en) Hypertext marker and method for dynamically displaying help information in an interactive data processing system
EP0660216B1 (en) Method and system for presenting alternatives for selection using adaptive learning
US5088052A (en) System for graphically representing and manipulating data stored in databases

Legal Events

Date Code Title Description
AS Assignment

Owner name: STAVROS INVESTMENTS LLC, NEVADA

Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNOR:EXPAND BEYOND CORPORATION;REEL/FRAME:025674/0226

Effective date: 20060125

Owner name: EXPAND BEYOND CORPORATION, ILLINOIS

Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNOR:KAPLAN, ARI DAVID;REEL/FRAME:025674/0130

Effective date: 20010924

FPAY Fee payment

Year of fee payment: 8

AS Assignment

Owner name: XYLON LLC, NEVADA

Free format text: MERGER;ASSIGNOR:STAVROS INVESTMENTS LLC;REEL/FRAME:037066/0882

Effective date: 20150813

FPAY Fee payment

Year of fee payment: 12