Method and apparatus for providing database information to non-requesting clients

• US 6,085,223 A
• Filed: 10/20/1995
• Issued: 07/04/2000
• Est. Priority Date: 10/20/1995
• Status: Expired due to Term

• Current Assignee: NCR Corporation
• Original Assignee: NCR Corporation
• Inventors: Carino, Felipe Jr., Rollins, Anthony L.
• Primary Examiner(s): Rinehart, Mark H.
• Application Number:
  US08/546,070
• Time in Patent Office: 1,719 Days
• Field of Search: 395/200.02, 395/200.09, 395/200.05, 395/605, 395/610, 709/201, 709/203, 709/217, 709/218, 707/9, 707/10, 707/102, 707/103, 707/104
• US Class Current: 709/203
• CPC Class Codes: G06F 16/2452 Query translation
• CPC Class Codes: G06F 16/256 in federated or virtual databases
• CPC Class Codes: G06F 16/43 Querying

Abstract

A method and apparatus for providing access to object data stored in a database management system to a receiver client. The method comprises the steps of receiving a database query from a submitting client on a first communication path, transforming the database query into database management system commands, transmitting the database management system commands to a database management system, receiving a response from the database management system comprising a media object locator, compiling an answer set comprising the database management system response, and transmitting the media object locator to the receiver client on the first communication path.

Claims

1. A method of providing access to data stored in a database management system to a receiver client, comprising the steps of:

receiving a database query from a submitting client on a first communication path;

transforming the database query into database management system commands;

transmitting the database management system commands to the database management system;

receiving a response from the database management system;

compiling an answer set comprising the database management system response; and

transmitting the database management system response to the receiver client.

2. The method of claim 1 wherein the database management system response comprises object data responsive to the database query and the response is transmitted to the receiver client via the first communications path.

3. The method of claim 1 wherein the database management system response comprises object data responsive to the database query and the response is transmitted to the receiver client over a second communications path.

4. The method of claim 1 wherein the database management system response comprises a media object locator identifying object data responsive to the database query and the response is transmitted to the receiver client via the first communications path.

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

receiving a transport request from the receiver client, the transport request comprising the media object locator;

establishing a transport session between the receiver client and the object server on a second communications path; and

closing the transport session when the data defined by the media object locator has been transmitted to the receiver client.

6. The method of claim 5 wherein:

the step of transmitting the media object locator to a receiver client comprises the steps of building service tickets for the objects identified by the answer set object locators, modifying the answer set by embedding the service tickets within the answer set object locators, and transmitting the modified answer set to the receiver client; and

the step of establishing a transport session between the receiver client and the object server comprises the step of decrypting the modified answer set to verify that the receiver client is authorized to access the object data.

7. The method of claim 5 wherein the transport request further comprises a parameter defining second communication path quality, and the step of establishing a transport session further comprises the step of selecting a communication path in accord with the parameter.

8. The method of claim 1 wherein:

the step of transforming the database query into at least one database management command comprises the step of transforming the database query into at least one relational database command and at least one object server command, the object server command comprising an object surrogate;

the step of transmitting the database management system commands to the data management system comprises the steps of transmitting the relational database command to a relational database management system and the object server command to the object server; and

the response further comprises a response table received from the relational database management system.

9. An apparatus for providing access to data stored in a database management system to a receiver client, comprising:

a computer having a processor, the computer coupled to a data storage device;

means, performed by the computer for receiving a database query from a submitting client on a first communication path;

means, performed by the computer for transforming the database query into database management system commands;

means, performed by the computer for transmitting the database management system commands to the database management system;

means, performed by the computer for receiving a response from the database management system;

means, performed by the computer for compiling an answer set comprising the database management system response; and

means, performed by the computer for transmitting the database management system response to the receiver client.

10. The apparatus of claim 9 wherein the database management system response comprises a media object locator identifying object data responsive to the database query and the response is transmitted to the receiver client via the first communications path.

11. The apparatus of claim 10, further comprising:

means, performed by the computer for receiving a transport request from the receiver client, the transport request comprising a media object locator;

means, performed by the computer for establishing a transport session between the receiver client and the object server; and

means, performed by the computer for closing the transport session when the data defined by the media object locator has been transmitted to the receiver client.

12. The apparatus of claim 10, wherein:

the means for transmitting the media object locator to the receiver client comprises means, performed by the computer for building service tickets for the objects identified by the media object locator, means, performed by the computer for modifying the answer set by embedding the service tickets within the answer set object locators, and means, performed by the computer for transmitting the modified media object locator to the receiver client on the first communication path, and

the means for establishing a transport session between the receiver client and the object server comprises means, performed by the computer, for decrypting the modified answer set to verify that the receiver client is authorized to access the object data.

13. The apparatus of claim 10 wherein the transport request further comprises a parameter defining second communication path quality, and the means for establishing a transport session further comprises means, performed by the computer, for selecting a communication path in accord with the parameter.

14. The apparatus of claim 9 wherein:

the means for transforming the database query into database management system commands comprises means, performed by the computer for transforming the database query into at least one relational database command and at least one object server command, the object server command comprising an object surrogate;

the means for transmitting the database management system commands to the database management system comprises means, performed by the computer for transmitting the relational database command to a relational database management system and the object server command to the object server; and

the response further comprises a response table received from the relational database management system.

15. A program storage device, readable by a computer having a processor and coupled to a data storage device, tangibly embodying one or more programs of instructions executable by the computer to perform method steps of providing access to data stored in a database management system to a receiver client, the method comprising the steps of:

receiving a database query from a submitting client on a first communication path;

transforming the database query into database management system commands;

transmitting the database management system commands to the database management system;

receiving a response from the database management system;

compiling an answer set comprising the database management system response; and

transmitting the database management system response to the receiver client.

16. The program storage device of claim 15 wherein the database management system response comprises a media object locator identifying object data responsive to the database query and the response is transmitted to the receiver client via the first communications path.

17. The program storage device of claim 16 wherein the method steps further comprise the steps of:

receiving a transport request from the receiver client, the transport request comprising the media object locator;

establishing a transport session between the receiver client and the object server; and

closing the transport session when the data defined by the media object locator has been transmitted to the receiver client.

18. The program storage device of claim 16 wherein:

the method step of transmitting the media object locator to a receiver client comprises the steps of building service tickets for the objects identified by the answer set object locators, modifying the answer set by embedding the service tickets within the answer set object locators, and transmitting the modified answer set to the receiver client; and

the method step of establishing a transport session between the receiver client and the object server comprises the step of decrypting the modified answer set to verify that the receiver client is authorized to access the object data.

19. The program storage device of claim 16 wherein the transport request further comprises a parameter defining second communications path quality, and the method step of establishing a transport session further comprises the method step of selecting a communication path in accord with the parameter.

20. The program storage device of claim 16 wherein:

the method step of transforming the database query into database management system commands comprises the method step of transforming the database query into at least one relational database command and at least one object server command, the object server command comprising an object surrogate;

the method step of transmitting the database management system commands to the data management system comprises the method steps of transmitting the relational database command to a relational database management system and the object server command to the object server; and

the response further comprises a response table received from the relational database management system.