Apparatus and method for passing statements to foreign databases by using a virtual package

• US 6,041,344 A
• Filed: 06/23/1997
• Issued: 03/21/2000
• Est. Priority Date: 06/23/1997
• Status: Expired due to Term

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle Corporation
• Inventors: Draaijer, Jacco, Mani, Raghu, Voss, Eric, Bodamer, Roger
• Primary Examiner(s): Geckil, Mehmet B.
• Application Number:
  US08/880,325
• Time in Patent Office: 1,002 Days
• Field of Search: 395/200.31, 395/500, 395/200.32, 395/200.37, 395/200.76, 395/200.75, 707/10, 707/103, 707/109, 707/1, 707/2, 707/3, 707/202, 707/203, 707/207, 707/246, 707/245, 707/217, 709/201, 709/203, 709/207, 709/246, 709/245, 709/217
• US Class Current: 709/203
• CPC Class Codes: G06F 16/256 in federated or virtual databases

Abstract

An apparatus and method for accessing foreign processes in a heterogeneous database environment includes a local database server having heterogeneous services to selectively send foreign operations to the appropriate foreign processes in a controllable manner. A client application sending a statement to the local database server is checked by the local server to determine if the statement includes a reference to a foreign database system. The heterogeneous services selectively outputs a the foreign request to an agent process in communication with the foreign database system via an Application Programming Interface (API), where a foreign database driver corresponding to the foreign database maps the request from the API to the format of the foreign database. The local database server selectively allocates memory space for expected results from the foreign database, and completes execution of the statement upon receiving the expected results from the agent process. Hence, the agent process efficiently manages client statements having expressions to be processed by a foreign database system.

Claims

1. A method for processing a plurality of requests, comprising the steps of:

receiving the requests by a database server, each of the requests including a respective statement that can be performed by a foreign database server and a reference to the foreign database server, each respective statement including at least one operation necessary for execution that cannot be performed by the database server;

collecting the statements included in the requests into a single call request for the foreign database server;

sending the single call request to the foreign database server; and

receiving results from the foreign database server generated in response to the single call request.

2. The method of claim 1, further comprising the steps of:

establishing a connection with an agent process external to the database server; and

sending to the agent the statements formatted according to a syntax of the foreign database server;

wherein the steps of collecting the statements and sending the single call request are performed by the agent process.

3. The method of claim 2, further comprising the steps of:

accessing a table in the database server based on the reference to the foreign database server, the table identifying the syntax mapping information for the foreign database server; and

mapping the at least one operation from a syntax of the database server to the syntax of the foreign database server based on the syntax mapping information for the foreign database server.

4. The method of claim 2, further comprising:

identifying the at least one operation necessary for execution of said statement that cannot be performed by the database server, and

processing in the database server operations of the statement that can be performed by the database server.

5. The method of claim 2, wherein the step of establishing a connection with an agent process includes initiating the connection in response to reception of the reference to the foreign database server.

6. The method of claim 2, further comprising:

storing in the database server a plurality of links for respective references to foreign database servers; and

selectively establishing a connection with the agent process using a corresponding link in response to reception of the corresponding reference.

7. The method of claim 1, further comprising:

estimating expected results from the foreign database server based on the statements corresponding to the at least one operation; and

establishing a memory space in the database server for the results received based on the expected results from the foreign database server.

8. The method of claim 1, wherein the step of collecting the statements includes collecting a plurality of bind variable statements.

9. The method of claim 1, wherein the step of collecting the statements includes collecting a plurality of query statements to fetch respective rows from a table served by the foreign database server.

10. The method of claim 1, further comprising the step of completing processing of the statements based on the results received from the foreign database server from processing the single call request.

11. A computer readable medium having stored thereon sequences of instructions for responding to a plurality of requests, the sequences of instructions including instructions for performing the steps of:

receiving the requests by a database server, each of the requests including a respective statement that can be performed by a foreign database server and a reference to the foreign database server, each respective statement includes at least one operation necessary for execution that cannot be performed by the local database server;

collecting the statements included in the requests into a single call request for the foreign database server; and

sending the single call request to the foreign database server

receiving results from the foreign database server generated in response to the single call request.

12. The medium of claim 11, wherein the step of collecting the statements includes collecting a plurality of bind variable statements.

13. The medium of claim 11, wherein the step of collecting the statements includes collecting a plurality of query statements to fetch respective rows from a table served by the foreign database server.

14. A computer system configured to respond to a plurality of requests, comprising:

a local server process configured for;

receiving the requests, each of the requests including a respective statement that can be performed by a foreign database server and a reference to the database server, each respective statement including at least one operation necessary for execution that cannot be performed by the local server process; and

determining the operations necessary for execution of the respective statements; and

an agent process configured for;

collecting the statements included in the requests into a single call request for the foreign database server; and

sending the single call request to the foreign database server based on the corresponding reference in the statement;

wherein the local server process is further configured for receiving results from the foreign process generated in response to the single call request.

15. The system of claim 14, wherein the agent process is executing in an address space separate from the local server process.

16. The system of claim 15, further comprising a plurality of agent processes executing in respective address spaces separate from the local server process, for:

establishing connections with respective foreign processes in response to a respective operations sent, and

sending the respective operations according to respective syntax.

17. The system of claim 15, further comprising a table storing the reference and the corresponding syntax,

wherein the agent process is further configured for:

mapping the identified one operation from said syntax of the foreign process onto an Application Programming Interface (API), and

mapping the identified one operation from the API back to the syntax of the foreign process before sending the identified one operation to the foreign process.

18. The medium of claim 17, wherein said instructions are further arranged to cause the one or more processors to perform the step of completing processing of the statements based on the results received from the foreign database server from processing the single call request.

19. The system of claim 14, wherein the statements include a plurality of bind variable statements.

20. The system of claim 14, wherein the statements include a plurality of query statements to fetch respective rows from a table served by the foreign database server.