US6041344A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Apparatus and method for passing statements to foreign databases by using a virtual package
Assignee: Oracle International Corp
•
Filing: 1997-06-23
•
Granted: 2000-03-21
•
Expires: 2017-06-23
Abstract
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.
Inventors
- 👤 Roger Bodamer
- 👤 Jacco Draaijer
- 👤 Eric Voss
- 👤 Raghu Mani
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-02 16:55
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/25; G06F16/256
Claims Analysis
Total Claims: 23
Claim 1
Independent Claim
106 words
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.
Claim 2
Independent Claim
106 words
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.
Claim 3
Dependent Claim
58 words
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.
Claim 4
Dependent Claim
71 words
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.
Claim 5
Dependent Claim
45 words
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.
Claim 6
Dependent Claim
32 words
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.
Claim 7
Dependent Claim
44 words
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.
Claim 8
Dependent Claim
49 words
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.
Claim 9
Dependent Claim
20 words
The method of claim 1, wherein the step of collecting the statements includes collecting a plurality of bind variable statements.
Claim 10
Dependent Claim
32 words
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.
Claim 11
Dependent Claim
31 words
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.
Claim 12
Dependent Claim
123 words
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.
Claim 13
Dependent Claim
123 words
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.
Claim 14
Dependent Claim
20 words
The medium of claim 11, wherein the step of collecting the statements includes collecting a plurality of bind variable statements.
Claim 15
Dependent Claim
32 words
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.
Claim 16
Dependent Claim
141 words
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.
Claim 17
Dependent Claim
141 words
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.
Claim 18
Dependent Claim
21 words
The system of claim 14, wherein the agent process is executing in an address space separate from the local server process.
Claim 19
Dependent Claim
46 words
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.
Claim 20
Dependent Claim
69 words
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.
Claim 21
Dependent Claim
44 words
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.
Claim 22
Dependent Claim
15 words
The system of claim 14, wherein the statements include a plurality of bind variable statements.
Claim 23
Dependent Claim
27 words
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.
References Cited (Backward Citations)
US4949255A
Cited
US5257366A
Cited
US5416917A
Cited
US5524253A
Cited
US5452450A
Cited
US5455948A
Cited
US5627972A
Cited
US5539886A
Cited
US5596744A
Cited
US5721904A
Cited
US5655116A
Cited
US5651111A
Cited
US5713014A
Cited
US5764949A
Cited
US5706499A
Cited
US5542078A
Cited
US5768577A
Cited
US5617533A
Cited
US5736321A
Cited
US5608874A
Cited
US5710918A
Cited
US5745754A
Cited
US5806066A
Cited
US5859972A
Cited
US5787452A
Cited
US5768589A
Cited
US5794234A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2003-03-21 | 2003-09-20 | 2004-03-21 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2007-03-21 | 2007-09-20 | 2008-03-21 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2011-03-21 | 2011-09-20 | 2012-03-21 | $7700.00 | Window Closed / Lapsed |