Method and apparatus for providing shared data to a requesting client

• US 5,930,786 A
• Filed: 10/20/1995
• Issued: 07/27/1999
• Est. Priority Date: 10/20/1995
• Status: Expired due to Term

• Current Assignee: NCR Corporation
• Original Assignee: NCR Corporation
• Inventors: Rollins, Anthony L., Carino, Felipe Jr.
• Primary Examiner(s): Lintz, Paul R.
• Assistant Examiner(s): Corrielus, Jean M.
• Application Number:
  US08/546,466
• Time in Patent Office: 1,376 Days
• Field of Search: 395/601, 395/800, 707/4, 707/102, 707/100, 707/101, 707/10, 370/395, 380/24
• US Class Current: 1/1
• CPC Class Codes: G06F 16/256 in federated or virtual databases
• CPC Class Codes: G06F 16/40 of multimedia data, e.g. slideshows comprising image and additional audio data retrieval of still image data G06F16/50; retrieval of audio data G06F16/60; retrieval of video data G06F16/70
• CPC Class Codes: G06F 16/48 Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation
• CPC Class Codes: Y10S 707/99939 Privileged access
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing
• CPC Class Codes: Y10S 707/99948 Application of database or data structure, e.g. distributed, multimedia, or image

Abstract

A method and apparatus for providing object data stored in a database management system to a receiving client. The method comprises the steps of receiving a database query from the 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, the response comprising an object locator identifying data responsive to the database query, compiling an answer set comprising the database management system response, transmitting the answer set to the client on the first communications path, receiving a data request from the client comprising the media object locator, establishing a transport session with the client on a second communication path, and transmitting data identified by the media object locator to the client on the second communication path.

Claims

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

receiving a database query from the 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, the response comprising an object locator identifying object data responsive to the database query;

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

transmitting the answer set to the client on the first communications path;

receiving a data request from the client comprising the object locator;

establishing a transport session with the client on a second communication path; and

transmitting data identified by the object locator to the client on the second communication path.

2. The method of claim 1 further comprising the step of encrypting the answer set before transmitting the answer set to the client on the first communications path.

3. The method of claim 2 further comprising the step of decrypting the answer set to confirm that the client is authorized to receive the object data before transmitting the data identified by the object locator to the client on the second communication path.

4. The method of claim 1 wherein the database management system comprises a federated coordinator coupled to a relational database management system and an object server and:

the transforming step comprises the step of transforming the database query into relational database management system commands and object server commands;

the step of transmitting the database management system commands comprises the steps of transmitting the relational database management system commands to a relational database management system and transmitting the object server commands to an object server comprising an object processor and an object data storage device for storing and retrieving the object data;

the step of receiving a response from the database management system comprises the steps of receiving a response table from the relational database management system; and

the answer set is compiled from the response table and comprises an object locator identifying object data stored in the object server and responsive to the database query.

5. The method of claim 1, wherein the second communication path is of higher bandwidth than the first communication path.

6. The method of claim 1, wherein the second communication path is selected according to a quality of service parameter.

7. The method of claim 1, wherein the second communication path is more secure than the first communication path.

8. The method of claim 1, wherein the step of establishing a transport session with the client on a second communication path comprises the steps of:

receiving a request to open a transport connection from the client in a federated coordinator;

obtaining an address for a transport agent process on the object server;

transmitting the transport agent address to an object server connectivity module communicatively coupled to the federated coordinator;

opening a transport connection on the second communication path to the transport agent process using the transport agent address; and

reading the data identified by the object locator from the transport agent.

9. The method of claim 1, wherein the database query comprises a user defined function and the step of establishing a transport session with the client on a second communication path comprises the steps of:

receiving a request to open a transport connection from the client in a federated coordinator;

obtaining an address for a transport agent process on the object server;

transmitting the transport agent address to an object server connectivity module communicatively coupled to the federated coordinator;

opening a transport connection on the second communication path to the transport agent process using the transport agent address;

reading the data identified by the object locator from the transport agent; and

executing the user-defined function in the object server to generate object data responsive to the user-defined function.

10. The method of claim 1, wherein the database query comprises a user defined function and the means for establishing a transport session with the client on a second communication path comprises:

means, performed by the computer, for receiving a request to open a transport connection from the client in a federated coordinator;

means, performed by the computer, for obtaining an address for a transport agent process on the object server;

means, performed by the computer, for transmitting the transport agent address to an object server connectivity module communicatively coupled to the federated coordinator;

means, performed by the computer, for opening a transport connection on the second communication path to the transport agent process using the transport agent address;

means, performed by the computer, for reading the data identified by the object locator from the transport agent; and

means, performed by the computer, for executing the user-defined function in the object server to generate object data responsive to the user-defined function.

11. An apparatus for providing object data stored in a database management system to a requesting 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 the client on a first communications 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, the response comprising an object locator identifying object data responsive to the database query;

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 answer set to the client on the first communications path;

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

means, performed by the computer for establishing a transport session with the client on a second communications path; and

means, performed by the computer for transmitting data identified by the object locator to the client on the second communications path.

12. The apparatus of claim 11, further comprising means, performed by the computer, for encrypting the answer set before transmitting the answer set to the client on the first communication path.

13. The apparatus of claim 12, further comprising means, performed by the computer, for decrypting the answer set to confirm that the client is authorized to receive the object data before transmitting the data identified by the object locator to the client on the second communication path.

14. The apparatus of claim 11 wherein the database management system comprises a federated coordinator coupled to a relational database management system and an object server, and:

the transforming means further comprises a means for transforming the database query into a relational database management system command and an object server command;

the means for transforming the database management system commands further comprises means for transmitting the relational database management system commands to a relational database management system and means for transmitting the object server commands to an object server comprising an object processor and an object storage device for storing and retrieving the object data;

the means for receiving a response from the database management system comprises a means for receiving a response table from the relational database management system; and

the answer set is compiled from the response table and comprises an object locator identifying object data stored in the object server and responsive to the database query.

15. The apparatus of claim 11, wherein the second communication path is of higher bandwidth than the first communication path.

16. The apparatus of claim 11, wherein the second communication path is selected according to a quality of service parameter.

17. The apparatus of claim 11, wherein the second communication path is more secure than the first communication path.

18. The apparatus of claim 11, wherein the means for establishing a transport session with the client on a second communication path comprises:

means, performed by the computer, for receiving a request to open a transport connection from the client in a federated coordinator;

means, performed by the computer, for obtaining an address for a transport agent process on the object server;

means, performed by the computer, for transmitting the transport agent address to an object server connectivity module communicatively coupled to the federated coordinator;

means, performed by the computer, for opening a transport connection on the second communication path to the transport agent process using the transport agent address; and

means, performed by the computer, for reading the data identified by the object locator from the transport agent.

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

receiving a database query from the 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, the response comprising an object locator identifying object data responsive to the database query;

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

transmitting the answer set to the client on the first communications path;

receiving a data request from the client comprising the object locator;

establishing a transport session with the client on a second communication pathl; and

transmitting data identified by the object locator to the client on the second communication path.

20. The program storage device of claim 19, wherein the method steps further comprise the step of encrypting the answer set before transmitting the answer set to the client on the first communications path.

21. The program storage device of claim 20, wherein the method steps further comprise the step of decrypting the answer set to confirm that the client is authorized to receive the object data before transmitting the data identified by the object locator to the client on the second communication path.

22. The program storage device of claim 19, wherein the database management system further comprises a federated coordinator coupled to a relational database management system and an object server and:

the transforming step comprises the step of transforming the database query into relational database management system commands and object server commands;

the step of transmitting the database management system commands comprises the steps of transmitting the relational database management system commands to a relational database management system and transmitting the object server commands to an object server comprising an object processor and an object data storage device for storing and retrieving the object data;

the step of receiving a response from the database management system comprises the steps of receiving a response table from the relational database management system; and

the answer set is compiled from the response table and comprises an object locator identifying object data stored in the object server and responsive to the database query.

23. The program storage device of claim 19, wherein the second communication path is of higher bandwidth than the first communication path.

24. The program storage device of claim 19, wherein the second communication path is selected according to a quality of service parameter.

25. The program storage device of claim 19, wherein the second communication path is more secure than the first communication path.

26. The program storage device of claim 19, wherein the method step of establishing a transport session with the client on a second communication path comprises the method steps of:

receiving a request to open a transport connection from the client in a federated coordinator;

obtaining an address for a transport agent process on the object server;

transmitting the transport agent address to an object server connectivity module communicatively coupled to the federated coordinator;

opening a transport connection on the second communication path to the transport agent process using the transport agent address; and

reading the data identified by the object locator from the transport agent.

27. The program storage device of claim 19, wherein the database query comprises a user defined function and the method step of establishing a transport session with the client on a second communication path comprises the method steps of:

receiving a request to open a transport connection from the client in a federated coordinator;

obtaining an address for a transport agent process on the object server;

transmitting the transport agent address to an object server connectivity module communicatively coupled to the federated coordinator;

opening a transport connection on the second communication path to the transport agent process using the transport agent address;

reading the data identified by the object locator from the transport agent; and

executing the user-defined function in the object server to generate object data responsive to the user-defined function.