Generic SQL query agent

• US 5,881,232 A
• Filed: 07/23/1996
• Issued: 03/09/1999
• Est. Priority Date: 07/23/1996
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Watts, Steven John, Shen, HongHai, Cheng, Josephine M.
• Primary Examiner(s): Geckil, Mehmet B.
• Application Number:
  US08/684,012
• Time in Patent Office: 959 Days
• Field of Search: 395/200.31, 395/200.32, 395/200.33, 395/200.49, 395/200.47, 395/200.59, 707/10, 707/2-5, 707/104
• US Class Current: 709/217
• CPC Class Codes: G06F 16/10 File systems; File servers
• CPC Class Codes: H04L 67/01 Protocols
• CPC Class Codes: H04L 67/02 based on web technology, e.g. hypertext transfer protocol [HTTP]
• CPC Class Codes: H04L 69/329 in the application layer [OSI layer 7]
• CPC Class Codes: H04L 9/40 Network security protocols

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.

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.

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.