Apparatus and method for calling external routines in a database

Details Apparatus and method for calling external routines in a database Apparatus and method for calling external routines in a database

1997-06-23

1999-11-16

Amsbury, Wayne

Data processing: database and file management or data structures

Database design

Data structure types

707100, 707103, G06F 1730

Patent

active

059874635

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.

REFERENCES:
patent: 4736321 (1988-04-01), Brown et al.
patent: 4949255 (1990-08-01), Gerth et al.
patent: 5257366 (1993-10-01), Adair et al.
patent: 5416917 (1995-05-01), Adair et al.
patent: 5452450 (1995-09-01), Delory
patent: 5455948 (1995-10-01), Poole et al.
patent: 5524253 (1996-06-01), Pham et al.
patent: 5539886 (1996-07-01), Aldred et al.
patent: 5542078 (1996-07-01), Martel et al.
patent: 5596744 (1997-01-01), Dao et al.
patent: 5608874 (1997-03-01), Ogawa et al.
patent: 5617533 (1997-04-01), Wu et al.
patent: 5627972 (1997-05-01), Shear
patent: 5651111 (1997-07-01), McKeeman et al.
patent: 5655116 (1997-08-01), Kirk et al.
patent: 5706499 (1998-01-01), Kleewein et al.
patent: 5710918 (1998-01-01), Lagarde et al.
patent: 5713014 (1998-01-01), Durflinger et al.
patent: 5721904 (1998-02-01), Ito et al.
patent: 5745754 (1998-04-01), Lagarde et al.
patent: 5764949 (1998-06-01), Huang et al.
patent: 5768577 (1998-06-01), Kleewein et al.
patent: 5768589 (1998-06-01), Bradley et al.
patent: 5787452 (1998-07-01), McKenna
patent: 5794234 (1998-08-01), Church et al.
patent: 5806066 (1998-09-01), Golshani et al.
patent: 5859972 (1999-01-01), Subramaniam et al.

Affiliated with

Also associated with

Rating

Apparatus and method for calling external routines in a database does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Apparatus and method for calling external routines in a database, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Apparatus and method for calling external routines in a database will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-1337536