US5987463A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Apparatus and method for calling external routines in a database system
Assignee: Oracle International Corp
•
Filing: 1997-06-23
•
Granted: 1999-11-16
•
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 a heterogeneous services module to selectively send requests to the foreign processes based on their respective capabilities. A client application sending a statement to the local database server is checked by the local server process to determine if the statement includes a reference for a registered external routine executable by an agent process in an address space separate from the local server process. The heterogeneous services module selectively initiates a network connection with an external agent process, and the external agent process executes the external routine by accessing a dynamically linked library. If necessary, the local database server and the agent process exchange callback queries and callback results via the heterogeneous services module to complete intermediate queries within the same user instance. The local database server then completes the client statement based on the results received from the agent process. Use of a link to an external agent process executing in a separate address space enables the local server process to use enhanced external routines written in third generation languages, without risking the local server process to failures in the external routines.
Inventors
- 👤 Jacco Draaijer
- 👤 Roger Bodamer
- 👤 Eric Voss
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-07 19:29
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/24; G06F16/245; G06F16/2455; G06F16/24553
Claims Analysis
Total Claims: 25
Claim 1
Independent Claim
109 words
A method for processing a request from a client, comprising the steps of: receiving the request by a database server that is executing in a first address space, the request specifying an operation to be executed by an external routine, wherein execution of said operation is necessary to execute the request; in response to the request, initiating a connection between the database server and an agent executing in a second address space separate from the first address space; causing the agent to execute the external routine to perform the operation; and processing the request by the database server based on results received from the agent executing the external routine.
Claim 2
Independent Claim
109 words
A method for processing a request from a client, comprising the steps of: receiving the request by a database server that is executing in a first address space, the request specifying an operation to be executed by an external routine, wherein execution of said operation is necessary to execute the request; in response to the request, initiating a connection between the database server and an agent executing in a second address space separate from the first address space; causing the agent to execute the external routine to perform the operation; and processing the request by the database server based on results received from the agent executing the external routine.
Claim 3
Dependent Claim
52 words
The method of claim 1, further comprising registering the external routine with the database server by: describing at least one argument of the external routine; creating a new procedure that specifies the at least one argument and a path to the external routine; and storing in a database table the new procedure.
Claim 4
Dependent Claim
42 words
The method of claim 2, wherein the step of registering an external routine with a database server further includes: creating a library for storing paths to locate respective stored external routines; and storing said path to the external routine in the library.
Claim 5
Dependent Claim
64 words
The method of claim 1, wherein the step of initiating a connection between the database server and an agent includes the steps of establishing a link with a listener agent external to the database server; causing the listener agent to transfer the link between the database server and the listener agent to the agent executing in the second address space to form said connection.
Claim 6
Dependent Claim
17 words
The method of claim 4, further comprising the step of initiating a new instance of said agent.
Claim 7
Dependent Claim
42 words
The method of claim 5, further comprising initiating another new instance of said agent in response to reception by the database server of a second request from a second client including an operation to be performed by one of the external processes.
Claim 8
Dependent Claim
32 words
The method of claim 5, further comprising initiating another new instance of said agent in response to the request including another operation to be processed by another one of said external processes.
Claim 9
Dependent Claim
81 words
The method of claim 1, wherein the step of causing the agent to execute the external routine includes: passing arguments corresponding to the operation to the agent for processing by the agent; receiving a first SQL statement from the agent during execution of the external routine; processing the first SQL statement within a same database instance executing the step of processing the request; and returning results from processing the first SQL statement back to the agent for processing of the operation.
Claim 10
Dependent Claim
25 words
The method of claim 8, wherein the step of receiving an SQL statement comprises receiving the first SQL statement from the agent via said connection.
Claim 11
Dependent Claim
21 words
The method of claim 8, further comprising suspending processing of the request in response to receipt of the first SQL statement.
Claim 12
Dependent Claim
25 words
The method of claim 10, further comprising sending a second invocation of an external routine to the agent for processing of the first SQL statement.
Claim 13
Dependent Claim
54 words
The method of claim 8, further comprising: receiving a plurality of recursive invocations of external routines from the agent during execution of the external routine; and recursively processing the plurality of SQL statements from the agent within the same database instance, each recursive processing performed within a common connection and within a common transaction.
Claim 14
Dependent Claim
15 words
The method of claim 1, further comprising registering the external routine with the database server.
Claim 15
Dependent Claim
131 words
A computer readable medium having stored thereon sequences of instructions for responding to a request for performance of an operation received by a server, the sequences of instructions including instructions for performing the steps of: receiving the request by a database server that is executing in a first address space, the request specifying an operation to be executed by an external routine, wherein execution of said operation is necessary to execute the request; in response to the request initiating a connection between the database server and an agent executing in a second address space separate from the first address space; causing the agent to execute the external routine to perform the operation; and processing the request by the database server based on results received from the agent executing the external routine.
Claim 16
Dependent Claim
131 words
A computer readable medium having stored thereon sequences of instructions for responding to a request for performance of an operation received by a server, the sequences of instructions including instructions for performing the steps of: receiving the request by a database server that is executing in a first address space, the request specifying an operation to be executed by an external routine, wherein execution of said operation is necessary to execute the request; in response to the request initiating a connection between the database server and an agent executing in a second address space separate from the first address space; causing the agent to execute the external routine to perform the operation; and processing the request by the database server based on results received from the agent executing the external routine.
Claim 17
Dependent Claim
88 words
A database system configured to respond to a statement, comprising: a local server process receiving the statement from the client and configured for identifying routines necessary for execution of the statement, the local server process including an interface configured for sending a request to execute an identified one of the routines; and an agent process configured for executing the identified routine in an address space separate from the local server process, the local server process completing execution of the statement based on results received from the agent process.
Claim 18
Dependent Claim
88 words
A database system configured to respond to a statement, comprising: a local server process receiving the statement from the client and configured for identifying routines necessary for execution of the statement, the local server process including an interface configured for sending a request to execute an identified one of the routines; and an agent process configured for executing the identified routine in an address space separate from the local server process, the local server process completing execution of the statement based on results received from the agent process.
Claim 19
Dependent Claim
40 words
The database system of claim 15, further comprising a dynamically-linked library storing a plurality of foreign routines executable by the agent process, the agent process selectively executing the identified one of the routines in response to reception of the request.
Claim 20
Dependent Claim
32 words
The database system of claim 16, wherein the dynamically-linked library is a dynamically linked library (DLL), the agent process selectively receiving arguments necessary for execution of the identified one of the routines.
Claim 21
Dependent Claim
61 words
The database server of claim 16, further comprising a listener agent configured for initiating execution of the agent process, wherein: the interface is configured for establishing a connection to the listener agent to send the request, and the listener agent is configured for selectively transferring the connection with the interface to the agent process for execution of the identified one routine.
Claim 22
Dependent Claim
19 words
The database system of claim 16, further comprising a database table for storing identifiers specifying the foreign routines, respectively.
Claim 23
Dependent Claim
42 words
The database system of claim 19, wherein the local server process identifies the identified one of the routines as a foreign routine executable by the agent process in response to accessing the database table, wherein the statement includes the corresponding stored identifier.
Claim 24
Dependent Claim
79 words
The database system of claim 15, wherein: the interface is configured to receive a second recursive invocation of an external routine from the agent process necessary for execution of the identified one routine by the agent process; and the local server process is configured for executing the second recursive invocation of an external routine within a same database instance executing the statement and returning second results for the second recursive invocation of an external routine to the agent process.
Claim 25
Dependent Claim
46 words
The database server of claim 21, wherein: the agent process is configured to store a context stack for executing external routines recursively; and the local server is configured to store a context stack for processing multiple statements from the agent process within the same database instance.
References Cited (Backward Citations)
US4736321A
Cited
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
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) | 2002-11-15 | 2003-05-17 | 2003-11-16 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2006-11-15 | 2007-05-17 | 2007-11-16 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2010-11-15 | 2011-05-17 | 2011-11-16 | $7700.00 | Window Closed / Lapsed |