US5881232A - Generic SQL query agent - Google Patents

Generic SQL query agent Download PDF

Info

Publication number
US5881232A
US5881232A US08/684,012 US68401296A US5881232A US 5881232 A US5881232 A US 5881232A US 68401296 A US68401296 A US 68401296A US 5881232 A US5881232 A US 5881232A
Authority
US
United States
Prior art keywords
agent
request
client computer
database management
management system
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.)
Expired - Fee Related
Application number
US08/684,012
Inventor
Josephine M. Cheng
HongHai Shen
Steven John Watts
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.)
International Business Machines Corp
Original Assignee
International Business Machines Corp
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
Application filed by International Business Machines Corp filed Critical International Business Machines Corp
Priority to US08/684,012 priority Critical patent/US5881232A/en
Assigned to INTERNATIONAL BUSINESS MACHINES CORPORATION reassignment INTERNATIONAL BUSINESS MACHINES CORPORATION ASSIGNMENT OF ASSIGNORS INTEREST (SEE DOCUMENT FOR DETAILS). Assignors: SHEN, HONGHAI, WATTS, STEVEN JOHN, CHENG, JOSEPHINE M.
Application granted granted Critical
Publication of US5881232A publication Critical patent/US5881232A/en
Anticipated expiration legal-status Critical
Expired - Fee Related legal-status Critical Current

Links

Images

Classifications

    • H—ELECTRICITY
    • H04—ELECTRIC COMMUNICATION TECHNIQUE
    • H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
    • H04L67/00—Network arrangements or protocols for supporting network services or applications
    • H04L67/01—Protocols
    • H04L67/02—Protocols based on web technology, e.g. hypertext transfer protocol [HTTP]
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/10—File systems; File servers
    • H—ELECTRICITY
    • H04—ELECTRIC COMMUNICATION TECHNIQUE
    • H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
    • H04L9/00—Cryptographic mechanisms or cryptographic arrangements for secret or secure communications; Network security protocols
    • H04L9/40—Network security protocols
    • H—ELECTRICITY
    • H04—ELECTRIC COMMUNICATION TECHNIQUE
    • H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
    • H04L67/00—Network arrangements or protocols for supporting network services or applications
    • H04L67/01—Protocols
    • H—ELECTRICITY
    • H04—ELECTRIC COMMUNICATION TECHNIQUE
    • H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
    • H04L69/00—Network arrangements, protocols or services independent of the application payload and not provided for in the other groups of this subclass
    • H04L69/30—Definitions, standards or architectural aspects of layered protocol stacks
    • H04L69/32—Architecture of open systems interconnection [OSI] 7-layer type protocol stacks, e.g. the interfaces between the data link level and the physical level
    • H04L69/322—Intralayer communication protocols among peer entities or protocol data unit [PDU] definitions
    • H04L69/329—Intralayer communication protocols among peer entities or protocol data unit [PDU] definitions in the application layer [OSI layer 7]

Definitions

  • the present invention relates generally to methods for accessing information stored in a database management system (DBMS), and in particular, to a generic query agent for providing optimized remote user access to database management systems.
  • DBMS database management system
  • the process of obtaining information from the DBMS is highly interactive, requiring short periods of high bandwidth, low-latency communications between the end user and the DBMS, followed by extended periods with little or no communications traffic.
  • LAN local area network
  • WAN wide area network
  • the user is typically provided access to the database via a desktop computer coupled directly by a (LAN) or a laptop computer coupled to the LAN via the Public Switched Telephone Network (PSTN).
  • PSTN Public Switched Telephone Network
  • DBMSs integrated database management systems
  • Mobile users also frequently require access to information which is stored in different DMBSs.
  • Mobile communications are available through cellular telephone, paging, and other radio networks, but using these communication links for providing access to DBMSs is problematic.
  • Cellular telephone communications offer low bandwidth, are quite expensive, and often unreliable.
  • Remote paging networks provide inexpensive reliable communications, but at the cost of low-bandwidth and high data latency. Therefore, there is a widely recognized need to provide an interface between mobile users and DBMSs using low bandwidth, high-latency mobile communication links.
  • a prior art solution to this problem is to implement client-agent-server (CAS) architecture, in which an agent's application is inserted between the mobile client application and the server.
  • CAS client-agent-server
  • One example of such a system is Oracle in MotionTM produced by the Oracle Corporation.
  • clients communicate with the agent via mobile communications link, causing the agent to execute work on behalf of the client.
  • the results of the agent's work is bundled into a single message and transmitted back to the client application where the results are displayed.
  • the present invention discloses a method, apparatus, and article of manufacture for providing access to a database management system to a remote user.
  • the present invention interprets and optimizes processing requests and provides for different receiving mechanisms. This is accomplished by implementing one or more optimization techniques, a token to capture common information, and through results caching.
  • the present invention also describes the use of a daemon and triggering mechanism to receive results.
  • the invention comprises the steps or elements of receiving a request from the remote user at an agent, interpreting the request, transforming the interpreted request into database management system commands at the agent, optionally processing the request to optimize the database management system commands, transmitting the database management system commands to the database management system, receiving a result from the database management system at the agent in response to database management system commands, transforming the result into a response message, and transmitting the response message from the agent to the remote user.
  • FIG. 1 is an architectural block diagram of the system
  • FIG. 2A is a flow chart showing the overall operation of the present invention.
  • FIG. 2B is a flow chart showing the operations performed to initiate access to the database management system
  • FIG. 2C is a flow chart showing the operations performed to receive the request from the remote user at the agent
  • FIG. 2D is a flow chart showing the operations performed to transform the request into DBMS commands
  • FIG. 2E is a flow chart showing the operations performed to process the request to optimize the DBMS commands
  • FIG. 2F is a flow chart showing the operations performed to transform the results from the DBMS commands into a response message
  • FIG. 2G is a flow chart showing the operations performed to transmit the response message from the agent to the remote user.
  • FIG. 1 is a diagram illustrating the overall architecture and showing an exemplary hardware environment of the present invention.
  • a remote user 100 communicates with the generic query agent 102 via a mobile link 101. These communications may be implemented with a personal data assistant (PDA) 110, a notebook or laptop computer 112 or a paging device 114.
  • PDA personal data assistant
  • the generic query agent 102 communicates with one or more database management systems (DBMSs) 104, 106, and 108 via communication links 105, 107, and 109 respectively, to transmit database management system commands and receive results in response to the database management system commands, which are eventually transmitted to the remote user 100 via the mobile link 101.
  • DBMSs database management systems
  • FIG. 1 also shows a typical implementation of the present invention, where the generic query agent 102 is implemented in a computer 103 operating under control of an operating system.
  • the generic query agent 102 is preferably effected by a software program 120 operating under control of the operating system.
  • software program 120 may also be tangibly embodied in a computer-readable medium, e.g. one or more fixed and/or removable data storage devices 122. Under control of the operating system, the software program 120 may be loaded from the data storage device 122 into the computer memory.
  • the software program 120 comprises instructions which, when read and executed by the processor 118, causes the computer 103 to perform the steps necessary to execute the steps or elements of the present invention.
  • DBMSs 104, 106, and 108 are also typically implemented by a DBMS computer 124 comprising a processor 126, a DBMS software program 128, data replication software instructions 129, and one or more fixed or removable data storage devices 130.
  • FIG. 1 is not intended to limit the present invention, and that alternative hardware environments may be used without departing from the scope of the present invention.
  • FIG. 2A is a flow chart showing the overall operation of the present invention.
  • Block 200 represents the remote user 100 initiating access between the remote user 100 and the DBMS 108.
  • block 202 illustrates the generic query agent 102 receiving a request, such as a database request from the remote user 100 at the generic query agent 102.
  • Block 204 shows the generic query agent 102 transforming the request into the DBMS 108 commands.
  • Block 206 shows the generic query agent 102 transmitting the DBMS commands from the generic query agent 102 to the DBMS 108.
  • the generic query agent 102 receives the results from the DBMS 108 at the generic query agent 102 in response to the DBMS commands.
  • Block 210 the generic query agent 102 transforms the results into a response message.
  • Block 212 shows the generic query agent transmitting the response message from the generic query agent 102 to the remote user 100.
  • Block 214 returns the operation flow to block 206 if updated response messages are requested.
  • FIG. 2B illustrates the operations performed to initiate access to the DBMS 108.
  • the generic query agent 102 receives an access request message from the remote user 100.
  • the generic query agent 102 determines whether the remote user 100 is authorized to access the DBMS 108. If the remote user 100 is not authorized to access the DBMS 108, the generic query agent 102 denies remote user 110 a token as illustrated in block 220. Generic query agent 102 processing thereafter returns to an idle state 222. If the remote user 100 is authorized to access the DBMS 108, the generic query agent 102 transmits a token from the generic query agent 102 to the remote user 100, as shown in block 224.
  • the generic query agent 102 determines whether a token was received by the generic query agent 102 from the remote user 100. If a token was not received, the generic query agent 102 enters the idle state 222. If a token was received from the remote user 100, the generic query agent 102 processes the token to verify that the remote user 100 is authorized to access DBMS 108, as shown in block 228. In one embodiment, the token granted to the remote user 100 has a pre-specified life, after which it can no longer be used by the remote user 100 to access the DBMS 108. In another embodiment, the life of the token is determined from current or past requests from the remote user 100.
  • the generic query agent 102 grants a token to the remote user 100 with a longer life.
  • token life based upon parameters supplied by the remote user 100, parameters known by the generic query agent 102 such as the availability of the mobile link 101 or the complexity of the DBMS 108 request, or the prior request history of the remote user 100, the generic query agent 102 may optimize the token life and minimize mobile link 101 communications.
  • FIG. 2C shows the operations performed to receive a request from remote user 100 at the generic query agent 102.
  • the generic query agent 102 reads the DBMS 108 request.
  • Block 232 illustrates the generic query agent 102 analyzing the DBMS 108 request to determine if mobile link 101 should be closed. If the mobile link should be closed 234, the generic query agent 102 causes the generic query agent 102 to close the mobile link 101, as shown in block 236. If the mobile link 101 should remain open, block 238 maintains the mobile link 101. It should be noted that in addition to the DBMS 108 request other parameters known by the generic query agent 102 can be used to determine whether the mobile link 101 should be closed or remain open.
  • the prior history of requests from the mobile user to the database 108, or the historical availability of the mobile link 101 at the time the results from the DBMS 108 will be available may be considered in the determination as to whether the mobile link 101 be maintained or closed.
  • other parameters may be used to make this determination.
  • a daemon 132 is invoked at the remote user 100 whenever required.
  • the generic query agent 102 will either wait for a connection request from the daemon 132 or periodically contact the daemon 132 proactively. Once communications are established, the query result will be sent to and stored at the remote user, and the daemon will notify the person making the request of the query result.
  • Message trafficking may also be implemented using a structured messaging system such as the MQ Series, developed by IBM.
  • message queues 134 are defined in the remote user 100 and the generic query agent 102.
  • a trigger is associated with the message queue 134 at the remote user 100. This trigger notifies the remote user 100 to invoke a query browser to display the query result once the result enters the message queue 134.
  • the remote user 100 can request that all mobile link 101 communications be suitably encrypted.
  • FIG. 2D is a flow chart showing the operations performed to transform the request from the remote user 100 into DBMS 108 commands.
  • the generic query agent 102 adapts the request to the DBMS 108 by converting the request into commands understandable by the DBMS 108. By performing this step, the present invention allows a wide variety of remote users 100 to communicate with a variety of DBMS 108 systems, without requiring special application software either at the remote user 100 or the DBMS 108, thereby providing a truly generic query agent 102.
  • Block 242 illustrates the generic query agent 102 processing the request from the remote user 100 to optimize DBMS 108 commands using a first optimization criteria.
  • Optimization criteria may include information regarding available communication channels or selected communication hierarchies other than first-come first-served.
  • FIG. 2E is a flow chart showing the operations performed to process the request from the remote user 100 to optimize the DBMS 108 commands using the first optimization criteria.
  • the generic query agent 102 accesses the optimization criteria. This information could have been sent with the request from the remote user 100, or stored in the generic query agent 102.
  • the generic query agent 102 accesses system information required to perform the optimization process, including information regarding the remote user 100, the request, the mobile link 101, generic query agent 102, to DBMS communication links 105-109, and DBMSs 104-108.
  • the generic query agent 102 performs optimization algorithms to optimize the request in block 248. The algorithms used to perform this processing are well known in the art.
  • the request is transmitted to the indicated DBMSs 104-108 via communication links 105-109. Thereafter, the generic query agent 102 receives the results from the DBMS 108 in response to the DBMS commands.
  • FIG. 2F is a flow chart showing the operations performed to transform the results into a response message.
  • the generic query agent 102 reads the results, and in block 252 determines if future updates were requested by the remote user 100. These future updates could be automatic, and based on a change in the data in the DBMS 108, requested over specific intervals of time, or requested through an identical DBMS command from the remote user 100. If future updates are requested, the generic query agent caches the result for future use, as shown in block 254. In block 256, the generic query agent 102 determines if the current DBMS 108 command is an update request. If so, block 258 processes the results to identify differences with cached results.
  • the generic query agent 102 processes the results to optimize the response message using a second optimization criteria.
  • the processes thereby performed are analogous to those illustrated in FIG. 2E. That is, a second optimization criteria is accessed, system information required to implement the optimization criteria is accessed, and optimization algorithms are performed on the system information in the second optimization criteria.
  • the generic query agent 102 converts the results into a format suitable for the remote agent 100. This format may be specified by the remote user 100 as a part of the request, or may be stored in the generic query agent 102.
  • FIG. 2G shows the operations performed to transmit the response message from the generic query agent 102 to remote user 100.
  • the generic query agent 102 determines if the mobile link was closed. If so, the generic query agent 102 processes the result to select the optimal remote link for response message transmission, as shown in block 266. Thereafter, as shown in block 268, the generic query agent 102 transmits the response message from the generic query agent 102 to the remote user 100 via the selected mobile link 101.
  • the present invention discloses a method and apparatus for providing access to a database management system to a remote user.
  • the method comprises the steps of receiving a request from the remote user at an agent, transforming the request in the database management system commands at the agent by processing the request to optimize the database system commands, transmitting the database management system commands to the database management system, receiving a result from the database management system at the agent in response to the database management system commands, transforming the result into a response message, and transmitting the response message from the agent to the remote user.

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Computer Networks & Wireless Communication (AREA)
  • Signal Processing (AREA)
  • Computer Security & Cryptography (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

A method, apparatus, and article of manufacture for providing access to information stored in a database management system. The method and apparatus uses an intelligent generic query agent to operate with a wide variety of remote users, and to allow implementation of a wide variety of optimization schemes. The method comprises receiving a request from the remote user at the agent, transforming the request into database management system commands optimized in accordance with user-specified optimization criteria, transmitting the database management system commands to the database management system, receiving the database management system command result from the database management system in the agent, transforming the database management system command result into a response message, and transmitting the response message to from the agent to the remote user.

Description

BACKGROUND OF THE INVENTION
1. Field of the Invention
The present invention relates generally to methods for accessing information stored in a database management system (DBMS), and in particular, to a generic query agent for providing optimized remote user access to database management systems.
2. Description of the Related Art
Large-scale integrated database management systems provide an efficient, consistent, and secure means for storing and retrieving vast amounts of data. This ability to manage massive amounts of information has become a virtual necessity in business today.
Usually, the process of obtaining information from the DBMS is highly interactive, requiring short periods of high bandwidth, low-latency communications between the end user and the DBMS, followed by extended periods with little or no communications traffic. Because local area network (LAN) or wide area network (WAN) communications are high bandwidth and low cost, the user is typically provided access to the database via a desktop computer coupled directly by a (LAN) or a laptop computer coupled to the LAN via the Public Switched Telephone Network (PSTN). This arrangement is the well known client-server architecture.
Businesses using integrated database management systems (DBMSs) have become increasingly mobile and service-oriented, raising the need for timely and inexpensive mobile access to database information. Mobile users also frequently require access to information which is stored in different DMBSs. Mobile communications are available through cellular telephone, paging, and other radio networks, but using these communication links for providing access to DBMSs is problematic. Cellular telephone communications offer low bandwidth, are quite expensive, and often unreliable. Remote paging networks provide inexpensive reliable communications, but at the cost of low-bandwidth and high data latency. Therefore, there is a widely recognized need to provide an interface between mobile users and DBMSs using low bandwidth, high-latency mobile communication links.
A prior art solution to this problem is to implement client-agent-server (CAS) architecture, in which an agent's application is inserted between the mobile client application and the server. One example of such a system is Oracle in Motion™ produced by the Oracle Corporation. In a client-agent-server architecture, clients communicate with the agent via mobile communications link, causing the agent to execute work on behalf of the client. The results of the agent's work is bundled into a single message and transmitted back to the client application where the results are displayed. By providing an asynchronous link, the shortcomings of the mobile link are reduced.
These prior art CAS architectures use a system-level approach to accomplish this task, using the combination of many components distributed throughout the network, including the mobile user and the database server. While these prior art systems reduce use of the mobile link by sending the results in a single message, this simple communication scheme is inadequate when dealing with a broad range of mobile users and database resources, and does not take advantage of the additional information available to the query agent to fully optimize communications.
SUMMARY OF THE INVENTION
To overcome the limitations in the prior art described above and to overcome other limitations that will become apparent upon reading and understanding the present specification, the present invention discloses a method, apparatus, and article of manufacture for providing access to a database management system to a remote user.
Unlike prior art systems, the present invention interprets and optimizes processing requests and provides for different receiving mechanisms. This is accomplished by implementing one or more optimization techniques, a token to capture common information, and through results caching. The present invention also describes the use of a daemon and triggering mechanism to receive results.
The invention comprises the steps or elements of receiving a request from the remote user at an agent, interpreting the request, transforming the interpreted request into database management system commands at the agent, optionally processing the request to optimize the database management system commands, transmitting the database management system commands to the database management system, receiving a result from the database management system at the agent in response to database management system commands, transforming the result into a response message, and transmitting the response message from the agent to the remote user.
BRIEF DESCRIPTION OF THE DRAWINGS
Referring now to the drawings in which like reference numbers represent corresponding parts throughout:
FIG. 1 is an architectural block diagram of the system;
FIG. 2A is a flow chart showing the overall operation of the present invention;
FIG. 2B is a flow chart showing the operations performed to initiate access to the database management system;
FIG. 2C is a flow chart showing the operations performed to receive the request from the remote user at the agent;
FIG. 2D is a flow chart showing the operations performed to transform the request into DBMS commands;
FIG. 2E is a flow chart showing the operations performed to process the request to optimize the DBMS commands;
FIG. 2F is a flow chart showing the operations performed to transform the results from the DBMS commands into a response message; and
FIG. 2G is a flow chart showing the operations performed to transmit the response message from the agent to the remote user.
DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENT
In the following description of the preferred embodiment, reference is made to the accompanying drawings which form a part hereof, and in which is shown by way of illustration the specific embodiment in which the invention may be practiced. It is to be understood that other embodiments may be utilized as structural changes may be made without departing from the scope of the present invention.
1. System Architecture
FIG. 1 is a diagram illustrating the overall architecture and showing an exemplary hardware environment of the present invention. A remote user 100 communicates with the generic query agent 102 via a mobile link 101. These communications may be implemented with a personal data assistant (PDA) 110, a notebook or laptop computer 112 or a paging device 114. The generic query agent 102 communicates with one or more database management systems (DBMSs) 104, 106, and 108 via communication links 105, 107, and 109 respectively, to transmit database management system commands and receive results in response to the database management system commands, which are eventually transmitted to the remote user 100 via the mobile link 101.
FIG. 1 also shows a typical implementation of the present invention, where the generic query agent 102 is implemented in a computer 103 operating under control of an operating system. The generic query agent 102 is preferably effected by a software program 120 operating under control of the operating system. Generally, software program 120 may also be tangibly embodied in a computer-readable medium, e.g. one or more fixed and/or removable data storage devices 122. Under control of the operating system, the software program 120 may be loaded from the data storage device 122 into the computer memory. The software program 120 comprises instructions which, when read and executed by the processor 118, causes the computer 103 to perform the steps necessary to execute the steps or elements of the present invention. Similarly, DBMSs 104, 106, and 108 are also typically implemented by a DBMS computer 124 comprising a processor 126, a DBMS software program 128, data replication software instructions 129, and one or more fixed or removable data storage devices 130.
Those skilled in the art will recognize that the exemplary environment illustrated in FIG. 1 is not intended to limit the present invention, and that alternative hardware environments may be used without departing from the scope of the present invention.
2. System Operation
FIG. 2A is a flow chart showing the overall operation of the present invention. Block 200 represents the remote user 100 initiating access between the remote user 100 and the DBMS 108. After access to the DBMS 108 is established, block 202 illustrates the generic query agent 102 receiving a request, such as a database request from the remote user 100 at the generic query agent 102. Block 204 shows the generic query agent 102 transforming the request into the DBMS 108 commands. Block 206 shows the generic query agent 102 transmitting the DBMS commands from the generic query agent 102 to the DBMS 108. In block 208, the generic query agent 102 receives the results from the DBMS 108 at the generic query agent 102 in response to the DBMS commands. In block 210, the generic query agent 102 transforms the results into a response message. Block 212 shows the generic query agent transmitting the response message from the generic query agent 102 to the remote user 100. Block 214 returns the operation flow to block 206 if updated response messages are requested.
FIG. 2B illustrates the operations performed to initiate access to the DBMS 108. In block 216 the generic query agent 102 receives an access request message from the remote user 100. In block 218, the generic query agent 102 determines whether the remote user 100 is authorized to access the DBMS 108. If the remote user 100 is not authorized to access the DBMS 108, the generic query agent 102 denies remote user 110 a token as illustrated in block 220. Generic query agent 102 processing thereafter returns to an idle state 222. If the remote user 100 is authorized to access the DBMS 108, the generic query agent 102 transmits a token from the generic query agent 102 to the remote user 100, as shown in block 224. In block 226, the generic query agent 102 determines whether a token was received by the generic query agent 102 from the remote user 100. If a token was not received, the generic query agent 102 enters the idle state 222. If a token was received from the remote user 100, the generic query agent 102 processes the token to verify that the remote user 100 is authorized to access DBMS 108, as shown in block 228. In one embodiment, the token granted to the remote user 100 has a pre-specified life, after which it can no longer be used by the remote user 100 to access the DBMS 108. In another embodiment, the life of the token is determined from current or past requests from the remote user 100. For example, if the remote user request requires lengthy DBMS 108 processing, or if mobile link 101 availability is known by the generic query agent 102 to be intermittent or otherwise compromised, the generic query agent 102 grants a token to the remote user 100 with a longer life. By selecting token life based upon parameters supplied by the remote user 100, parameters known by the generic query agent 102 such as the availability of the mobile link 101 or the complexity of the DBMS 108 request, or the prior request history of the remote user 100, the generic query agent 102 may optimize the token life and minimize mobile link 101 communications.
FIG. 2C shows the operations performed to receive a request from remote user 100 at the generic query agent 102. In block 230, the generic query agent 102 reads the DBMS 108 request. Block 232 illustrates the generic query agent 102 analyzing the DBMS 108 request to determine if mobile link 101 should be closed. If the mobile link should be closed 234, the generic query agent 102 causes the generic query agent 102 to close the mobile link 101, as shown in block 236. If the mobile link 101 should remain open, block 238 maintains the mobile link 101. It should be noted that in addition to the DBMS 108 request other parameters known by the generic query agent 102 can be used to determine whether the mobile link 101 should be closed or remain open. For example, the prior history of requests from the mobile user to the database 108, or the historical availability of the mobile link 101 at the time the results from the DBMS 108 will be available may be considered in the determination as to whether the mobile link 101 be maintained or closed. Similarly, other parameters may be used to make this determination.
Many different strategies can be employed to implement message trafficking between the remote user 100 and the generic query agent 102. For example, in one embodiment, a daemon 132 is invoked at the remote user 100 whenever required. The generic query agent 102 will either wait for a connection request from the daemon 132 or periodically contact the daemon 132 proactively. Once communications are established, the query result will be sent to and stored at the remote user, and the daemon will notify the person making the request of the query result. Message trafficking may also be implemented using a structured messaging system such as the MQ Series, developed by IBM. In this case, message queues 134 are defined in the remote user 100 and the generic query agent 102. A trigger is associated with the message queue 134 at the remote user 100. This trigger notifies the remote user 100 to invoke a query browser to display the query result once the result enters the message queue 134. Of course, in accordance with well known techniques, the remote user 100 can request that all mobile link 101 communications be suitably encrypted.
FIG. 2D is a flow chart showing the operations performed to transform the request from the remote user 100 into DBMS 108 commands. In block 240, the generic query agent 102 adapts the request to the DBMS 108 by converting the request into commands understandable by the DBMS 108. By performing this step, the present invention allows a wide variety of remote users 100 to communicate with a variety of DBMS 108 systems, without requiring special application software either at the remote user 100 or the DBMS 108, thereby providing a truly generic query agent 102. Block 242 illustrates the generic query agent 102 processing the request from the remote user 100 to optimize DBMS 108 commands using a first optimization criteria. This criteria may be supplied from the remote user 100 via the mobile link 101 along with the request, may be resident in the generic query agent 102, or any combination of both of these options. Optimization criteria may include information regarding available communication channels or selected communication hierarchies other than first-come first-served.
FIG. 2E is a flow chart showing the operations performed to process the request from the remote user 100 to optimize the DBMS 108 commands using the first optimization criteria. In block 244, the generic query agent 102 accesses the optimization criteria. This information could have been sent with the request from the remote user 100, or stored in the generic query agent 102. In block 246, the generic query agent 102 accesses system information required to perform the optimization process, including information regarding the remote user 100, the request, the mobile link 101, generic query agent 102, to DBMS communication links 105-109, and DBMSs 104-108. The generic query agent 102 performs optimization algorithms to optimize the request in block 248. The algorithms used to perform this processing are well known in the art. After this processing, the request is transmitted to the indicated DBMSs 104-108 via communication links 105-109. Thereafter, the generic query agent 102 receives the results from the DBMS 108 in response to the DBMS commands.
FIG. 2F is a flow chart showing the operations performed to transform the results into a response message. In block 250, the generic query agent 102 reads the results, and in block 252 determines if future updates were requested by the remote user 100. These future updates could be automatic, and based on a change in the data in the DBMS 108, requested over specific intervals of time, or requested through an identical DBMS command from the remote user 100. If future updates are requested, the generic query agent caches the result for future use, as shown in block 254. In block 256, the generic query agent 102 determines if the current DBMS 108 command is an update request. If so, block 258 processes the results to identify differences with cached results. As shown in block 260, the generic query agent 102 processes the results to optimize the response message using a second optimization criteria. The processes thereby performed are analogous to those illustrated in FIG. 2E. That is, a second optimization criteria is accessed, system information required to implement the optimization criteria is accessed, and optimization algorithms are performed on the system information in the second optimization criteria. Next, as shown in block 262, the generic query agent 102 converts the results into a format suitable for the remote agent 100. This format may be specified by the remote user 100 as a part of the request, or may be stored in the generic query agent 102.
FIG. 2G shows the operations performed to transmit the response message from the generic query agent 102 to remote user 100. In block 264, the generic query agent 102 determines if the mobile link was closed. If so, the generic query agent 102 processes the result to select the optimal remote link for response message transmission, as shown in block 266. Thereafter, as shown in block 268, the generic query agent 102 transmits the response message from the generic query agent 102 to the remote user 100 via the selected mobile link 101.
CONCLUSION
This concludes the description of the preferred embodiment of the present invention. In summary, the present invention discloses a method and apparatus for providing access to a database management system to a remote user. The method comprises the steps of receiving a request from the remote user at an agent, transforming the request in the database management system commands at the agent by processing the request to optimize the database system commands, transmitting the database management system commands to the database management system, receiving a result from the database management system at the agent in response to the database management system commands, transforming the result into a response message, and transmitting the response message from the agent to the remote user.
The foregoing description of the preferred embodiment of the invention have been presented for purposes of illustration and description. It is not intended to be exhaustive or to limit the invention to the precise form disclosed. Many modifications and variations are possible in light of the above teaching. It is intended that the scope of the invention be limited not by this detailed description, but rather by the claims appended hereto.

Claims (63)

What is claimed is:
1. A method of providing access to data stored at a database management system implemented by a server computer to a remote user operating a client computer, connected by a communications channel, comprising the steps of:
receiving a request from the client computer at an agent executed by an agent computer;
interpreting the request at the agent;
assigning a dynamically determined lifetime to a token;
communicating the token to the client computer;
determining whether to close the communications channel;
when it is determined that the communications channel is to be closed, closing the communications channel;
transforming the interpreted request into database management system commands at the agent;
transmitting the database management system commands to the database management system;
receiving a result from the database management system at the agent in response to the database management system commands;
transforming the result into a response message at the agent;
when the communications channel has been closed, re-opening the communications channel;
communicating the token from the client to the server;
verifying that the lifetime of the token has not expired; and
transmitting the response message from the agent to the client computer.
2. The method of claim 1, wherein the step of transforming the interpreted request comprises the step of processing the request to optimize the database management system commands according to a first optimization criteria.
3. The method of claim 2, wherein the database management system commands are optimized to reduce message traffic between the client computer and the agent.
4. The method of claim 2 wherein the request comprises the first optimization criteria.
5. The method of claim 2 wherein the first optimization criteria is stored in the agent.
6. The method of claim 2 further comprising the step of processing the result to optimize the response message according to a second optimization criteria.
7. The method of claim 6, wherein the response message is optimized to reduce message traffic between the client computer and the agent.
8. The method of claim 6, wherein the request comprises the second optimization criteria.
9. The method of claim 6, wherein the second optimization criteria is stored in the agent.
10. The method of claim 1, wherein the step of transforming the request into database management commands further comprises the step of translating the request into a format adapted to the database management system.
11. The method of claim 1, wherein the step of transforming the result into a response message comprises the step of converting the result into a format specified by the remote user at the agent.
12. The method of claim 1, wherein the request comprises an access token, and the method further comprising the steps of:
receiving an access request message from the client computer at the agent;
transmitting the token from the agent to the client computer when the remote user is authorized to access the database management system;
receiving the token from the client computer at the agent; and
processing the token to verify that the remote user is authorized to access the database management system.
13. The method of claim 12, wherein the token is transmitted from the client computer to the agent with the request.
14. The method of claim 1, wherein the lifetime of the token is determined from the request.
15. The method of claim 1, wherein the result comprises a first result and a second result, and the response message comprises a first response message and a second response message, and the method further comprises the steps of:
caching the first result in the agent; and
optimizing the second response message in the agent by including only information contained in the second result, but not present in the cache of the first result.
16. The method of claim 1 wherein the request and response message are communicated between the client computer and the agent via a daemon invoked at the client computer.
17. The method of claim 16 further comprising the step of periodically querying the daemon to determine if any requests are present.
18. The method of claim 1 wherein the client computer further comprises a first message queue associated with a trigger and a query browser to display the response message, the agent further comprises a second message queue, and the step of transmitting the response message to from the agent to the user comprises the steps of sending a message to the client computer to activate the trigger to invoke the query browser at the client computer.
19. The method of claim 1, wherein the lifetime of the token is determined from a history of transactions with the client.
20. The method of claim 1, wherein the lifetime of the token is determined from characteristics of the communications channel.
21. The method of claim 1, further comprising the step of selecting an optimal channel to use to re-open the communications channel.
22. An apparatus for providing access to data stored at a database management system implemented by a server computer to a remote user operating a client computer, connected by a communications channel, comprising:
an agent computer having a processor, a memory and a data storage device;
means, performed by the agent computer, for receiving a request from the client computer at the agent computer;
means, performed by the agent computer, for interpreting the request;
means, performed by the agent computer, for assigning a dynamically determined lifetime to a token;
means, performed by the agent computer, for communicating the token to the client computer;
means, performed by the agent computer, for determining whether to close the communications channel;
means, performed by the agent computer, for closing the communications channel, when it is determined that the communications channel is to be closed;
means, performed by the agent computer, for transforming the interpreted request into database management system commands at the agent;
means, performed by the agent computer, for transmitting the database management system commands to the database management system;
means, performed by the agent computer, for receiving a result from the database management system in response to the database management system commands;
means, performed by the agent computer, for transforming the result into a response message;
means, performed by the agent computer, for re-opening the communications channel, when the communications channel has been closed;
means, performed by the agent computer, for communicating the token from the client to the server;
means, performed by the agent computer, for verifying that the lifetime of the token has not expired; and
means, performed by the agent computer, for transmitting the response message to the client computer.
23. The apparatus of claim 22, further comprising means for processing the request to optimize the database management system commands according to a first optimization criteria.
24. The apparatus of claim 23 further comprising means for optimizing the database management system commands to reduce message traffic between the client computer and the agent.
25. The apparatus of claim 23, wherein the request comprises the first optimization criteria.
26. The apparatus of claim 23, wherein first optimization criteria is stored in the agent.
27. The apparatus of claim 23, further comprising means for processing the result to optimize the response message according to a second optimization criteria.
28. The apparatus of claim 27, further comprising means for optimizing the response message to reduce message traffic between the client computer and the agent.
29. The apparatus of claim 27, wherein the request comprises the second optimization criteria.
30. The apparatus of claim 27, further comprising means for storing the second optimization criteria in the agent.
31. The apparatus of claim 22, wherein the means for transforming the request into database management commands further comprises means for translating the request into a format adapted to the database management system.
32. The apparatus of claim 22, wherein the means for transforming the result into a response message further comprises means for converting the result into a format specified by the remote user at the agent.
33. The apparatus of claim 22, wherein the request comprises an access token, and the apparatus further comprises means for:
receiving an access request message from the client computer at the agent;
transmitting the token from the agent to the client computer when the remote user is authorized to access the database management system;
receiving the token from the client computer at the agent; and
processing the token to verify that the remote user is authorized to access the database management system.
34. The apparatus of claim 33, further comprising the means for transmitting the token from the client computer to the agent with the request.
35. The apparatus of claim 22, further comprising the means for determining the lifetime of the token from the request.
36. The apparatus of claim 22, wherein the result comprises a first result and a second result, and the response message comprises a first response message and a second response message, and the apparatus further comprises the means for:
caching the first result in the agent; and
optimizing the second response message in the agent by including only information contained in the second result, but not present in the cache of the first result.
37. The apparatus of claim 22, further comprising a daemon invoked at the client computer to communicate the request and response message between the client computer and the agent.
38. The apparatus of claim 37, further comprising means for periodically querying the daemon to determine if any requests are present.
39. The apparatus of claim 22, wherein the client computer further comprises a first message queue associated with a trigger and a query browser to display the response message, the agent further comprises a second message queue, and the means for transmitting the response message from the agent to the user further comprises a means for sending a message to the client computer to activate the trigger to invoke the query browser at the client computer.
40. The apparatus of claim 22, further comprising means for determining the lifetime of the token from a history of transactions with the client.
41. The apparatus of claim 22, further comprising means for determining the lifetime of the token from characteristics of the communications channel.
42. The apparatus of claim 22, further comprising means for selecting an optimal channel to use to re-open the communications channel.
43. A program storage device, readable by an agent computer having a processor, a memory, and a data storage device, tangibly embodying one or more programs of instructions executable by the agent computer to perform method steps of providing access to data stored at a database management system implemented by a server computer to a remote user operating a client computer, connected by a communications channel, the method comprising the steps of:
receiving a request from the client computer at an agent executed by the agent computer;
interpreting the request from the client computer;
assigning a dynamically determined lifetime to a token;
communicating the token to the client computer;
determining whether to close the communications channel;
when it is determined that the communications channel is to be closed, closing the communications channel;
transforming the interpreted request into database management system commands at the agent;
transmitting the database management system commands to the database management system;
receiving a result from the database management system at the agent in response to the database management system commands;
transforming the result into a response message at the agent;
when the communications channel has been closed, re-opening the communications channel;
communicating the token from the client to the server;
verifying that the lifetime of the token has not expired; and
transmitting the response message from the agent to the client computer.
44. The program storage device of claim 43, wherein the method steps further comprise the step of processing the request to optimize the database management system commands according to a first optimization criteria.
45. The program storage device of claim 44, wherein the method steps further comprise the step of optimizing the database management system commands to reduce message traffic between the client computer and the agent.
46. The program storage device of claim 44, wherein the request comprises the first optimization criteria.
47. The program storage device of claim 44, wherein first optimization criteria is stored in the agent.
48. The program storage device of claim 44, wherein the method steps further comprise the step of processing the result to optimize the response message according to a second optimization criteria.
49. The program storage device of claim 48, wherein the method steps further comprise the step of optimizing the response message to reduce message traffic between the client computer and the agent.
50. The program storage device of claim 48, wherein the request comprises the second optimization criteria.
51. The program storage device of claim 48, wherein the second optimization criteria is stored in the agent.
52. The program storage device of claim 43, wherein the method steps further comprise the step of converting the result into a format specified by the remote user at the agent.
53. The program storage device of claim 43, wherein the method steps further comprise the step of translating the request into a format adapted to the database management system.
54. The program storage device of claim 43, wherein the request comprises an access token, and the method steps further comprise:
receiving an access request message from the client computer at the agent;
transmitting the token from the agent to the client computer when the remote user is authorized to access the database management system;
receiving the token from the client computer at the agent; and
processing the token to verify that the remote user is authorized to access the database management system.
55. The program storage device of claim 54, wherein the method steps further comprise transmitting the token from the client computer to the agent with the request.
56. The program storage device of claim 43, wherein the method steps further comprise determining the lifetime of the token from the request.
57. The program storage device of claim 43, wherein the result comprises a first result and a second result, and the response message comprises a first response message and a second response message, and the method steps further comprise:
caching the first result in the agent; and
optimizing the second response message in the agent by including only information contained in the second result, but not present in the cache of the first result.
58. The program storage device of claim 43, wherein the method steps further comprise invoking a daemon at the client computer to communicate the request and response message between the client computer and the agent.
59. The program storage device of claim 58, wherein the method steps further comprise periodically querying the daemon to determine if any requests are present.
60. The program storage device of claim 43, wherein the client computer further comprises a first message queue associated with a trigger and a query browser to display the response message, the agent further comprises a second message queue, and the method steps further comprise sending a message to the client computer to activate the trigger to invoke the query browser at the client computer.
61. The program storage device of claim 43, wherein the method steps further comprise determining the lifetime of the token from a history of transactions with the client.
62. The program storage device of claim 43, wherein the method steps further comprise determining the lifetime of the token from characteristics of the communications channel.
63. The program storage device of claim 43, wherein the method steps further comprise selecting an optimal channel to use to re-open the communications channel.
US08/684,012 1996-07-23 1996-07-23 Generic SQL query agent Expired - Fee Related US5881232A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
US08/684,012 US5881232A (en) 1996-07-23 1996-07-23 Generic SQL query agent

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
US08/684,012 US5881232A (en) 1996-07-23 1996-07-23 Generic SQL query agent

Publications (1)

Publication Number Publication Date
US5881232A true US5881232A (en) 1999-03-09

Family

ID=24746362

Family Applications (1)

Application Number Title Priority Date Filing Date
US08/684,012 Expired - Fee Related US5881232A (en) 1996-07-23 1996-07-23 Generic SQL query agent

Country Status (1)

Country Link
US (1) US5881232A (en)

Cited By (60)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO1999022317A2 (en) * 1997-10-24 1999-05-06 Unifree, L.L.C. Message broadcast system
WO2000016206A1 (en) * 1998-09-10 2000-03-23 Sanctum Ltd. Method and system for protecting operations of trusted internal networks
US6065040A (en) * 1997-07-07 2000-05-16 International Business Machines Corporation Computer system having agent retracting method and agent returning method
US6070244A (en) * 1997-11-10 2000-05-30 The Chase Manhattan Bank Computer network security management system
WO2000077615A2 (en) * 1999-06-11 2000-12-21 Microsoft Corporation Network file system
US20010027467A1 (en) * 2000-03-30 2001-10-04 Anderson David P. Massively distributed database system and associated method
WO2001086854A2 (en) * 2000-05-11 2001-11-15 Telefonaktiebolaget L M Ericsson (Publ) Method and system for data file management within a telecommunication system
US6339773B1 (en) * 1999-10-12 2002-01-15 Naphtali Rishe Data extractor
US20020013832A1 (en) * 2000-03-30 2002-01-31 Hubbard Edward A. Software-based network attached storage services hosted on massively distributed parallel computing networks
US6370576B1 (en) * 1999-05-27 2002-04-09 Nadio.Com, Inc. System and method for obstacle-free network communication
WO2002039646A2 (en) * 2000-11-09 2002-05-16 Expand Beyond Corporation An improved method and system for wireless database management
US20020073189A1 (en) * 2000-12-07 2002-06-13 International Business Machines Corporation Remote systems management via DBMS stored procedures
US20020087883A1 (en) * 2000-11-06 2002-07-04 Curt Wohlgemuth Anti-piracy system for remotely served computer applications
US20020116643A1 (en) * 1998-09-09 2002-08-22 Gil Raanan Method and system for extracting application protocol characteristics
US20030004882A1 (en) * 2000-11-06 2003-01-02 Holler Anne Marie Optimized server for streamed applications
US6513047B1 (en) * 1997-09-04 2003-01-28 Sun Microsystems, Inc. Management of user-definable databases
US20030056112A1 (en) * 1997-06-16 2003-03-20 Jeffrey Vinson Method and apparatus to allow remotely located computer programs and/or data to be accessed on a local computer in a secure, time-limited manner, with persistent caching
EP1316899A2 (en) * 2001-11-27 2003-06-04 Toshiba Tec Kabushiki Kaisha Information storage input system, information storage input service and screen display system
US6584569B2 (en) 2000-03-03 2003-06-24 Sanctum Ltd. System for determining web application vulnerabilities
US20030126109A1 (en) * 2002-01-02 2003-07-03 Tanya Couch Method and system for converting message data into relational table format
US6594557B1 (en) 1999-09-27 2003-07-15 Visteon Global Technologies, Inc. Utilizing intelligent software agents in a mobile vehicle
US20030225918A1 (en) * 2002-05-31 2003-12-04 International Business Machines Corporation Method and system for off-loading user queries to a task manager
US6711560B2 (en) 2001-03-29 2004-03-23 Hewlett-Packard Development Company, L.P. Method of executing conflicting triggers in an active database
US20040068479A1 (en) * 2002-10-04 2004-04-08 International Business Machines Corporation Exploiting asynchronous access to database operations
US6721725B2 (en) 2001-03-29 2004-04-13 Hewlett-Packard Development Company, L.P. Method of parallel trigger execution in an active database
US20040103139A1 (en) * 2000-03-30 2004-05-27 United Devices, Inc. Distributed processing system having sensor based data collection and associated method
US6745174B2 (en) 2001-03-29 2004-06-01 Hewlett-Packard Development Company, L.P. Method of executing before-triggers in an active database
US6799196B1 (en) 2000-01-21 2004-09-28 Gateway, Inc. On-demand data streaming parceling
US20050080759A1 (en) * 2003-10-08 2005-04-14 International Business Machines Corporation Transparent interface to a messaging system from a database engine
US6889256B1 (en) 1999-06-11 2005-05-03 Microsoft Corporation System and method for converting and reconverting between file system requests and access requests of a remote transfer protocol
US6922729B1 (en) * 1999-07-30 2005-07-26 International Business Machines Corporation Multi-connection control system
US20050213743A1 (en) * 2004-03-26 2005-09-29 Conversagent, Inc. Methods and apparatus for use in computer-to-human escalation
US20050223021A1 (en) * 2004-03-30 2005-10-06 Alok Batra Providing enterprise information
US20060048161A1 (en) * 2004-08-26 2006-03-02 De Rose Cesar Resource allocation method and system
US20060048136A1 (en) * 2004-08-25 2006-03-02 Vries Jeff D Interception-based resource detection system
US20060075024A1 (en) * 2002-05-17 2006-04-06 Microsoft Corporation Method and apparatus for connecting a secure peer-to-peer collaboration system to an external system
US7031999B1 (en) * 1998-11-17 2006-04-18 International Business Machines Corporation Method of interconnecting computers and computer network
US20060123185A1 (en) * 2004-11-13 2006-06-08 De Vries Jeffrey Streaming from a media device
US20060136389A1 (en) * 2004-12-22 2006-06-22 Cover Clay H System and method for invocation of streaming application
US7072888B1 (en) 1999-06-16 2006-07-04 Triogo, Inc. Process for improving search engine efficiency using feedback
US20060218165A1 (en) * 2005-03-23 2006-09-28 Vries Jeffrey De Explicit overlay integration rules
US20060230175A1 (en) * 2005-03-23 2006-10-12 De Vries Jeffrey System and method for tracking changes to files in streaming applications
US7240162B2 (en) 2004-10-22 2007-07-03 Stream Theory, Inc. System and method for predictive streaming
US20070198729A1 (en) * 2006-02-07 2007-08-23 Yechuri Sitaramarao S SQL network gadget
US7301944B1 (en) 1997-10-24 2007-11-27 Tranz-Send Broadcasting Network, Inc. Media file distribution with adaptive transmission protocols
US20080109876A1 (en) * 2006-10-23 2008-05-08 Endeavors Technologies, Inc. Rule-based application access management
US20080178298A1 (en) * 2001-02-14 2008-07-24 Endeavors Technology, Inc. Intelligent network streaming and execution system for conventionally coded applications
US7451196B1 (en) 2000-12-15 2008-11-11 Stream Theory, Inc. Method and system for executing a software application in a virtual environment
US7506033B2 (en) * 1998-11-12 2009-03-17 International Business Machines Corporation System and method for remotely accessing a client in a client server environment
US20090119644A1 (en) * 2007-11-07 2009-05-07 Endeavors Technologies, Inc. Deriving component statistics for a stream enabled application
US20090119458A1 (en) * 2007-11-07 2009-05-07 Endeavors Technologies, Inc. Opportunistic block transmission with time constraints
US20090132649A1 (en) * 2000-03-30 2009-05-21 Niration Network Group, L.L.C. Method of Managing Workloads and Associated Distributed Processing System
US20090222508A1 (en) * 2000-03-30 2009-09-03 Hubbard Edward A Network Site Testing
USRE42153E1 (en) 2000-03-30 2011-02-15 Hubbard Edward A Dynamic coordination and control of network connected devices for large-scale network site testing and associated architectures
US8010703B2 (en) 2000-03-30 2011-08-30 Prashtama Wireless Llc Data conversion services and associated distributed processing system
USRE43247E1 (en) * 1998-05-29 2012-03-13 Access Co., Ltd. Method and apparatus for communicating information over low bandwidth communications networks
US20140040072A1 (en) * 2012-08-01 2014-02-06 Move, Inc. Real estate data exchange system
CN107870924A (en) * 2016-09-26 2018-04-03 华为技术有限公司 Inquire about the method and data query system of data
CN109995869A (en) * 2019-04-08 2019-07-09 苏州浪潮智能科技有限公司 A kind of method, apparatus, equipment and the storage medium of remote auto downloading file
US11025478B2 (en) 2015-05-27 2021-06-01 Telefonaktiebolaget Lm Ericsson (Publ) Method and apparatus for analysing performance of a network by managing network data relating to operation of the network

Citations (13)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US4422145A (en) * 1981-10-26 1983-12-20 International Business Machines Corporation Thrashing reduction in demand accessing of a data base through an LRU paging buffer pool
US4714996A (en) * 1985-11-26 1987-12-22 International Business Machines Corporation Impact calculation for version management in a distributed information service
US4714992A (en) * 1985-11-26 1987-12-22 International Business Machines Corporation Communication for version management in a distributed information service
US4751635A (en) * 1986-04-16 1988-06-14 Bell Communications Research, Inc. Distributed management support system for software managers
US4774655A (en) * 1984-10-24 1988-09-27 Telebase Systems, Inc. System for retrieving information from a plurality of remote databases having at least two different languages
US5317727A (en) * 1988-05-19 1994-05-31 Hitachi Software Engineering Co., Ltd. Method apparatus for determining prefetch operating for a data base
US5454105A (en) * 1989-06-14 1995-09-26 Hitachi, Ltd. Document information search method and system
US5542046A (en) * 1992-09-11 1996-07-30 International Business Machines Corporation Server entity that provides secure access to its resources through token validation
US5627979A (en) * 1994-07-18 1997-05-06 International Business Machines Corporation System and method for providing a graphical user interface for mapping and accessing objects in data stores
US5689697A (en) * 1994-06-27 1997-11-18 International Business Machines Corporation System and method for asynchronous database command processing
US5701451A (en) * 1995-06-07 1997-12-23 International Business Machines Corporation Method for fulfilling requests of a web browser
US5742905A (en) * 1994-09-19 1998-04-21 Bell Communications Research, Inc. Personal communications internetworking
US5774461A (en) * 1995-09-27 1998-06-30 Lucent Technologies Inc. Medium access control and air interface subsystem for an indoor wireless ATM network

Patent Citations (13)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US4422145A (en) * 1981-10-26 1983-12-20 International Business Machines Corporation Thrashing reduction in demand accessing of a data base through an LRU paging buffer pool
US4774655A (en) * 1984-10-24 1988-09-27 Telebase Systems, Inc. System for retrieving information from a plurality of remote databases having at least two different languages
US4714996A (en) * 1985-11-26 1987-12-22 International Business Machines Corporation Impact calculation for version management in a distributed information service
US4714992A (en) * 1985-11-26 1987-12-22 International Business Machines Corporation Communication for version management in a distributed information service
US4751635A (en) * 1986-04-16 1988-06-14 Bell Communications Research, Inc. Distributed management support system for software managers
US5317727A (en) * 1988-05-19 1994-05-31 Hitachi Software Engineering Co., Ltd. Method apparatus for determining prefetch operating for a data base
US5454105A (en) * 1989-06-14 1995-09-26 Hitachi, Ltd. Document information search method and system
US5542046A (en) * 1992-09-11 1996-07-30 International Business Machines Corporation Server entity that provides secure access to its resources through token validation
US5689697A (en) * 1994-06-27 1997-11-18 International Business Machines Corporation System and method for asynchronous database command processing
US5627979A (en) * 1994-07-18 1997-05-06 International Business Machines Corporation System and method for providing a graphical user interface for mapping and accessing objects in data stores
US5742905A (en) * 1994-09-19 1998-04-21 Bell Communications Research, Inc. Personal communications internetworking
US5701451A (en) * 1995-06-07 1997-12-23 International Business Machines Corporation Method for fulfilling requests of a web browser
US5774461A (en) * 1995-09-27 1998-06-30 Lucent Technologies Inc. Medium access control and air interface subsystem for an indoor wireless ATM network

Cited By (146)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20100023640A1 (en) * 1997-06-16 2010-01-28 Stream Theory, Inc. Software streaming system and method
US9094480B2 (en) 1997-06-16 2015-07-28 Numecent Holdings, Inc. Software streaming system and method
US8509230B2 (en) 1997-06-16 2013-08-13 Numecent Holdings, Inc. Software streaming system and method
US20030056112A1 (en) * 1997-06-16 2003-03-20 Jeffrey Vinson Method and apparatus to allow remotely located computer programs and/or data to be accessed on a local computer in a secure, time-limited manner, with persistent caching
US9578075B2 (en) 1997-06-16 2017-02-21 Numecent Holdings, Inc. Software streaming system and method
US20050193139A1 (en) * 1997-06-16 2005-09-01 Jeffrey Vinson Software streaming system and method
US7577751B2 (en) 1997-06-16 2009-08-18 Stream Theory, Inc./Endeavors Technologies, Inc. Software streaming system and method
US7096253B2 (en) * 1997-06-16 2006-08-22 Stream Theory, Inc. Method and apparatus for streaming software
US6065040A (en) * 1997-07-07 2000-05-16 International Business Machines Corporation Computer system having agent retracting method and agent returning method
US6513047B1 (en) * 1997-09-04 2003-01-28 Sun Microsystems, Inc. Management of user-definable databases
WO1999022317A2 (en) * 1997-10-24 1999-05-06 Unifree, L.L.C. Message broadcast system
US20080120430A1 (en) * 1997-10-24 2008-05-22 Redmond Scott D Peered Content Distribution
US6370139B2 (en) * 1997-10-24 2002-04-09 Tranz-Send Broadcasting Network, Inc. System and method for providing information dispersal in a networked computing environment
WO1999022317A3 (en) * 1997-10-24 1999-07-01 Unifree L L C Message broadcast system
US7301944B1 (en) 1997-10-24 2007-11-27 Tranz-Send Broadcasting Network, Inc. Media file distribution with adaptive transmission protocols
US6070244A (en) * 1997-11-10 2000-05-30 The Chase Manhattan Bank Computer network security management system
USRE43247E1 (en) * 1998-05-29 2012-03-13 Access Co., Ltd. Method and apparatus for communicating information over low bandwidth communications networks
US8805957B2 (en) 1998-05-29 2014-08-12 Access Co., Ltd. Method and apparatus for communications over low bandwidth communications networks
US20050044420A1 (en) * 1998-09-09 2005-02-24 Gil Raanan Method and system for extracting application protocol characteristics
US20020116643A1 (en) * 1998-09-09 2002-08-22 Gil Raanan Method and system for extracting application protocol characteristics
US7774835B2 (en) 1998-09-09 2010-08-10 F5 Networks, Inc. Method and system for extracting application protocol characteristics
WO2000016206A1 (en) * 1998-09-10 2000-03-23 Sanctum Ltd. Method and system for protecting operations of trusted internal networks
US7506033B2 (en) * 1998-11-12 2009-03-17 International Business Machines Corporation System and method for remotely accessing a client in a client server environment
US7031999B1 (en) * 1998-11-17 2006-04-18 International Business Machines Corporation Method of interconnecting computers and computer network
US6370576B1 (en) * 1999-05-27 2002-04-09 Nadio.Com, Inc. System and method for obstacle-free network communication
WO2000077615A3 (en) * 1999-06-11 2002-09-12 Microsoft Corp Network file system
US6889256B1 (en) 1999-06-11 2005-05-03 Microsoft Corporation System and method for converting and reconverting between file system requests and access requests of a remote transfer protocol
US7441012B2 (en) 1999-06-11 2008-10-21 Microsoft Corporation Network file system
WO2000077615A2 (en) * 1999-06-11 2000-12-21 Microsoft Corporation Network file system
US20060212539A1 (en) * 1999-06-11 2006-09-21 Microsoft Corporation Network file system
US7080131B2 (en) 1999-06-11 2006-07-18 Microsoft Corporation System and method for converting and reconverting between file system requests and access requests of a remote transfer protocol
US20050144325A1 (en) * 1999-06-11 2005-06-30 Microsoft Corporation Network file system
US7072888B1 (en) 1999-06-16 2006-07-04 Triogo, Inc. Process for improving search engine efficiency using feedback
US20050240622A1 (en) * 1999-07-30 2005-10-27 Ibm Corp Multi-connection control system
US6922729B1 (en) * 1999-07-30 2005-07-26 International Business Machines Corporation Multi-connection control system
US6594557B1 (en) 1999-09-27 2003-07-15 Visteon Global Technologies, Inc. Utilizing intelligent software agents in a mobile vehicle
US6339773B1 (en) * 1999-10-12 2002-01-15 Naphtali Rishe Data extractor
US6799196B1 (en) 2000-01-21 2004-09-28 Gateway, Inc. On-demand data streaming parceling
US20040193704A1 (en) * 2000-01-21 2004-09-30 Smith Kim C. On-demand data stream parceling
US20030233581A1 (en) * 2000-03-03 2003-12-18 Eran Reshef System for determining web application vulnerabilities
US7237265B2 (en) 2000-03-03 2007-06-26 Watchfire Corporation System for determining web application vulnerabilities
US6584569B2 (en) 2000-03-03 2003-06-24 Sanctum Ltd. System for determining web application vulnerabilities
US20090164533A1 (en) * 2000-03-30 2009-06-25 Niration Network Group, L.L.C. Method of Managing Workloads and Associated Distributed Processing System
US20090138551A1 (en) * 2000-03-30 2009-05-28 Niration Network Group, L.L.C. Method of Managing Workloads and Associated Distributed Processing System
US8249940B2 (en) 2000-03-30 2012-08-21 Niration Network Group, LLC Capability based distributed processing
US20010027467A1 (en) * 2000-03-30 2001-10-04 Anderson David P. Massively distributed database system and associated method
US8010703B2 (en) 2000-03-30 2011-08-30 Prashtama Wireless Llc Data conversion services and associated distributed processing system
USRE42153E1 (en) 2000-03-30 2011-02-15 Hubbard Edward A Dynamic coordination and control of network connected devices for large-scale network site testing and associated architectures
US20040103139A1 (en) * 2000-03-30 2004-05-27 United Devices, Inc. Distributed processing system having sensor based data collection and associated method
US20090132649A1 (en) * 2000-03-30 2009-05-21 Niration Network Group, L.L.C. Method of Managing Workloads and Associated Distributed Processing System
US10269025B2 (en) 2000-03-30 2019-04-23 Intellectual Ventures Ii Llc Monetizing network connected user bases utilizing distributed processing systems
US20100036723A1 (en) * 2000-03-30 2010-02-11 Hubbard Edward A Sweepstakes Incentive Model and Associated System
US8275827B2 (en) 2000-03-30 2012-09-25 Niration Network Group, L.L.C. Software-based network attached storage services hosted on massively distributed parallel computing networks
US20020013832A1 (en) * 2000-03-30 2002-01-31 Hubbard Edward A. Software-based network attached storage services hosted on massively distributed parallel computing networks
US20090222508A1 (en) * 2000-03-30 2009-09-03 Hubbard Edward A Network Site Testing
US20090216649A1 (en) * 2000-03-30 2009-08-27 Hubbard Edward A Capability Based Distributed Processing
WO2001086854A3 (en) * 2000-05-11 2002-07-04 Ericsson Telefon Ab L M Method and system for data file management within a telecommunication system
WO2001086854A2 (en) * 2000-05-11 2001-11-15 Telefonaktiebolaget L M Ericsson (Publ) Method and system for data file management within a telecommunication system
US9130953B2 (en) 2000-11-06 2015-09-08 Numecent Holdings, Inc. Intelligent network streaming and execution system for conventionally coded applications
US20020087883A1 (en) * 2000-11-06 2002-07-04 Curt Wohlgemuth Anti-piracy system for remotely served computer applications
US9654548B2 (en) 2000-11-06 2017-05-16 Numecent Holdings, Inc. Intelligent network streaming and execution system for conventionally coded applications
US20030004882A1 (en) * 2000-11-06 2003-01-02 Holler Anne Marie Optimized server for streamed applications
US8831995B2 (en) 2000-11-06 2014-09-09 Numecent Holdings, Inc. Optimized server for streamed applications
US20090150410A1 (en) * 2000-11-09 2009-06-11 Stavros Investments Llc Method and System for Wireless Database Management
USRE41902E1 (en) 2000-11-09 2010-10-26 Ari David Kaplan System, method and apparatus for wireless monitoring and management of computer systems
US8065284B2 (en) 2000-11-09 2011-11-22 Stavros Investments Llc Method and system for wireless database management
WO2002039646A2 (en) * 2000-11-09 2002-05-16 Expand Beyond Corporation An improved method and system for wireless database management
US7496554B2 (en) 2000-11-09 2009-02-24 Stavros Investments Llc Method and system for wireless database management
WO2002039646A3 (en) * 2000-11-09 2002-08-29 Expand Beyond Corp An improved method and system for wireless database management
US6845392B2 (en) * 2000-12-07 2005-01-18 International Business Machines Corporation Remote systems management via DBMS stored procedures and one communication line
US20020073189A1 (en) * 2000-12-07 2002-06-13 International Business Machines Corporation Remote systems management via DBMS stored procedures
US7451196B1 (en) 2000-12-15 2008-11-11 Stream Theory, Inc. Method and system for executing a software application in a virtual environment
US20080178298A1 (en) * 2001-02-14 2008-07-24 Endeavors Technology, Inc. Intelligent network streaming and execution system for conventionally coded applications
US8438298B2 (en) 2001-02-14 2013-05-07 Endeavors Technologies, Inc. Intelligent network streaming and execution system for conventionally coded applications
US8893249B2 (en) 2001-02-14 2014-11-18 Numecent Holdings, Inc. Intelligent network streaming and execution system for conventionally coded applications
US6711560B2 (en) 2001-03-29 2004-03-23 Hewlett-Packard Development Company, L.P. Method of executing conflicting triggers in an active database
US20040103094A1 (en) * 2001-03-29 2004-05-27 Eliezer Levy Method of parallel trigger execution in an active database
US6745174B2 (en) 2001-03-29 2004-06-01 Hewlett-Packard Development Company, L.P. Method of executing before-triggers in an active database
US6721725B2 (en) 2001-03-29 2004-04-13 Hewlett-Packard Development Company, L.P. Method of parallel trigger execution in an active database
EP1316899A2 (en) * 2001-11-27 2003-06-04 Toshiba Tec Kabushiki Kaisha Information storage input system, information storage input service and screen display system
US20030217103A1 (en) * 2001-11-27 2003-11-20 Toshiba Tec Kabushiki Kaisha Information storage input system, information storage input service and screen display system
EP1316899A3 (en) * 2001-11-27 2004-02-25 Toshiba Tec Kabushiki Kaisha Information storage input system, information storage input service and screen display system
US20090157596A1 (en) * 2002-01-02 2009-06-18 International Business Machines Corporation System for converting message data into relational table format
US20030126109A1 (en) * 2002-01-02 2003-07-03 Tanya Couch Method and system for converting message data into relational table format
US7562115B2 (en) * 2002-05-17 2009-07-14 Microsoft Corporation Method and apparatus for connecting a secure peer-to-peer collaboration system to an external system
US20060075024A1 (en) * 2002-05-17 2006-04-06 Microsoft Corporation Method and apparatus for connecting a secure peer-to-peer collaboration system to an external system
US8024744B2 (en) 2002-05-31 2011-09-20 International Business Machines Corporation Method and system for off-loading user queries to a task manager
US7467387B2 (en) 2002-05-31 2008-12-16 International Business Machines Corporation Method for off-loading user queries to a task manager
US20030225918A1 (en) * 2002-05-31 2003-12-04 International Business Machines Corporation Method and system for off-loading user queries to a task manager
US20040068479A1 (en) * 2002-10-04 2004-04-08 International Business Machines Corporation Exploiting asynchronous access to database operations
US20050080759A1 (en) * 2003-10-08 2005-04-14 International Business Machines Corporation Transparent interface to a messaging system from a database engine
US8275117B2 (en) 2004-03-26 2012-09-25 Microsoft Corporation Methods and apparatus for use in computer-to-human escalation
US7983411B2 (en) 2004-03-26 2011-07-19 Microsoft Corporation Methods and apparatus for use in computer-to-human escalation
US20110235797A1 (en) * 2004-03-26 2011-09-29 Microsoft Corporation Methods and apparatus for use in computer-to-human escalation
US20050213743A1 (en) * 2004-03-26 2005-09-29 Conversagent, Inc. Methods and apparatus for use in computer-to-human escalation
WO2005098652A2 (en) * 2004-03-30 2005-10-20 Cxo Systems, Inc. Providing enterprise information
US20050223021A1 (en) * 2004-03-30 2005-10-06 Alok Batra Providing enterprise information
US7702718B2 (en) 2004-03-30 2010-04-20 Cisco Technology, Inc. Providing enterprise information
WO2005098652A3 (en) * 2004-03-30 2006-11-16 Cxo Systems Inc Providing enterprise information
US20060048136A1 (en) * 2004-08-25 2006-03-02 Vries Jeff D Interception-based resource detection system
US20060048161A1 (en) * 2004-08-26 2006-03-02 De Rose Cesar Resource allocation method and system
US8046759B2 (en) * 2004-08-26 2011-10-25 Hewlett-Packard Development Company, L.P. Resource allocation method and system
US7240162B2 (en) 2004-10-22 2007-07-03 Stream Theory, Inc. System and method for predictive streaming
US20060168294A1 (en) * 2004-11-13 2006-07-27 De Vries Jeff Hybrid local/remote streaming
US8359591B2 (en) 2004-11-13 2013-01-22 Streamtheory, Inc. Streaming from a media device
US20060123185A1 (en) * 2004-11-13 2006-06-08 De Vries Jeffrey Streaming from a media device
US8949820B2 (en) 2004-11-13 2015-02-03 Numecent Holdings, Inc. Streaming from a media device
US20060136389A1 (en) * 2004-12-22 2006-06-22 Cover Clay H System and method for invocation of streaming application
US9300752B2 (en) 2005-03-23 2016-03-29 Numecent Holdings, Inc. Opportunistic block transmission with time constraints
US9716609B2 (en) 2005-03-23 2017-07-25 Numecent Holdings, Inc. System and method for tracking changes to files in streaming applications
US9781007B2 (en) 2005-03-23 2017-10-03 Numecent Holdings, Inc. Opportunistic block transmission with time constraints
US10587473B2 (en) 2005-03-23 2020-03-10 Numecent Holdings, Inc. Opportunistic block transmission with time constraints
US11121928B2 (en) 2005-03-23 2021-09-14 Numecent Holdings, Inc. Opportunistic block transmission with time constraints
US20060218165A1 (en) * 2005-03-23 2006-09-28 Vries Jeffrey De Explicit overlay integration rules
US20060230175A1 (en) * 2005-03-23 2006-10-12 De Vries Jeffrey System and method for tracking changes to files in streaming applications
US8898391B2 (en) 2005-03-23 2014-11-25 Numecent Holdings, Inc. Opportunistic block transmission with time constraints
US8527706B2 (en) 2005-03-23 2013-09-03 Numecent Holdings, Inc. Opportunistic block transmission with time constraints
US20070198729A1 (en) * 2006-02-07 2007-08-23 Yechuri Sitaramarao S SQL network gadget
US8782778B2 (en) 2006-10-23 2014-07-15 Numecent Holdings, Inc. Rule-based application access management
US9825957B2 (en) 2006-10-23 2017-11-21 Numecent Holdings, Inc. Rule-based application access management
US9054962B2 (en) 2006-10-23 2015-06-09 Numecent Holdings, Inc. Rule-based application access management
US12081548B2 (en) 2006-10-23 2024-09-03 Numecent Holdings, Inc. Rule-based application access management
US8752128B2 (en) 2006-10-23 2014-06-10 Numecent Holdings, Inc. Rule-based application access management
US9380063B2 (en) 2006-10-23 2016-06-28 Numecent Holdings, Inc. Rule-based application access management
US11451548B2 (en) 2006-10-23 2022-09-20 Numecent Holdings, Inc Rule-based application access management
US9571501B2 (en) 2006-10-23 2017-02-14 Numecent Holdings, Inc. Rule-based application access management
US8261345B2 (en) 2006-10-23 2012-09-04 Endeavors Technologies, Inc. Rule-based application access management
US10356100B2 (en) 2006-10-23 2019-07-16 Numecent Holdings, Inc. Rule-based application access management
US9699194B2 (en) 2006-10-23 2017-07-04 Numecent Holdings, Inc. Rule-based application access management
US20080109876A1 (en) * 2006-10-23 2008-05-08 Endeavors Technologies, Inc. Rule-based application access management
US10057268B2 (en) 2006-10-23 2018-08-21 Numecent Holdings, Inc. Rule-based application access management
US9054963B2 (en) 2006-10-23 2015-06-09 Numecent Holdings, Inc. Rule-based application access management
US20090119458A1 (en) * 2007-11-07 2009-05-07 Endeavors Technologies, Inc. Opportunistic block transmission with time constraints
US8892738B2 (en) 2007-11-07 2014-11-18 Numecent Holdings, Inc. Deriving component statistics for a stream enabled application
US8661197B2 (en) 2007-11-07 2014-02-25 Numecent Holdings, Inc. Opportunistic block transmission with time constraints
US12271285B2 (en) 2007-11-07 2025-04-08 Numecent Holdings, Inc. Deriving component statistics for a stream enabled application
US20090119644A1 (en) * 2007-11-07 2009-05-07 Endeavors Technologies, Inc. Deriving component statistics for a stream enabled application
US10445210B2 (en) 2007-11-07 2019-10-15 Numecent Holdings, Inc. Deriving component statistics for a stream enabled application
US11119884B2 (en) 2007-11-07 2021-09-14 Numecent Holdings, Inc. Deriving component statistics for a stream enabled application
US8024523B2 (en) 2007-11-07 2011-09-20 Endeavors Technologies, Inc. Opportunistic block transmission with time constraints
US11740992B2 (en) 2007-11-07 2023-08-29 Numecent Holdings, Inc. Deriving component statistics for a stream enabled application
US9436578B2 (en) 2007-11-07 2016-09-06 Numecent Holdings, Inc. Deriving component statistics for a stream enabled application
US20140040072A1 (en) * 2012-08-01 2014-02-06 Move, Inc. Real estate data exchange system
US11025478B2 (en) 2015-05-27 2021-06-01 Telefonaktiebolaget Lm Ericsson (Publ) Method and apparatus for analysing performance of a network by managing network data relating to operation of the network
CN107870924A (en) * 2016-09-26 2018-04-03 华为技术有限公司 Inquire about the method and data query system of data
CN109995869A (en) * 2019-04-08 2019-07-09 苏州浪潮智能科技有限公司 A kind of method, apparatus, equipment and the storage medium of remote auto downloading file

Similar Documents

Publication Publication Date Title
US5881232A (en) Generic SQL query agent
US5884324A (en) Agent for replicating data based on a client defined replication period
CN102104632B (en) Systems and methods for performing caching of dynamically generated objects in a network
US8788675B2 (en) Multi-modal communication using a session specific proxy server
US6292835B1 (en) Network bandwidth and object obsolescence sensitive scheduling method and apparatus for objects distributed broadcasting
US7243136B2 (en) Approach for managing and providing content to users
JP4081017B2 (en) System and method for pushing data to a mobile device
US7433956B2 (en) Method, device and system for sharing application session information across multiple-channels
US8848710B2 (en) System and method for performing flash caching of dynamically generated objects in a data communication network
US20100268772A1 (en) System and method for determining effective policy profiles in a client-server architecture
US20020147849A1 (en) Delta encoding using canonical reference files
US20070156852A1 (en) System and method for performing flash crowd caching of dynamically generated objects in a data communication network
US20030204562A1 (en) System and process for roaming thin clients in a wide area network with transparent working environment
US20070156966A1 (en) System and method for performing granular invalidation of cached dynamically generated objects in a data communication network
KR20040010677A (en) System and method for a caching mechanism for a central synchronization server
WO1991003024A1 (en) Method and system for opportunistic locking in a networked computer system
CN113806655A (en) Data processing method, device, electronic device and storage medium
KR20000063802A (en) Apparatus and Method for connecting and serving a data using wireless terminal
US5652913A (en) System for providing intercommunication of I/O access factors stored in a shared data structure, accessed and maintained by both file system and device driver
US20020188698A1 (en) Method and apparatus to retrieve information in a network
US7464070B2 (en) Database query operations using storage networks
US20020103877A1 (en) Method and system for wireless access to a user's computer
JPH05143435A (en) Data base system
EP1265141A2 (en) System, method and computer program for data-management
US9219706B2 (en) Just-in-time wrapper synchronization

Legal Events

Date Code Title Description
AS Assignment

Owner name: INTERNATIONAL BUSINESS MACHINES CORPORATION, NEW Y

Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNORS:CHENG, JOSEPHINE M.;SHEN, HONGHAI;WATTS, STEVEN JOHN;REEL/FRAME:008116/0367;SIGNING DATES FROM 19960718 TO 19960722

CC Certificate of correction
FPAY Fee payment

Year of fee payment: 4

REMI Maintenance fee reminder mailed
LAPS Lapse for failure to pay maintenance fees
STCH Information on status: patent discontinuation

Free format text: PATENT EXPIRED DUE TO NONPAYMENT OF MAINTENANCE FEES UNDER 37 CFR 1.362

FP Lapsed due to failure to pay maintenance fee

Effective date: 20070309

OSZAR »