Generic SQL query agent
First Claim
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.
1 Assignment
0 Petitions
Accused Products
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.
-
Citations
63 Claims
-
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. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21)
-
-
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. - View Dependent Claims (23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42)
-
-
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. - View Dependent Claims (44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63)
-
Specification