Method and apparatus for invoking a stored procedure or a user defined interpreted language function in a database management system

• US 6,006,235 A
• Filed: 11/26/1997
• Issued: 12/21/1999
• Est. Priority Date: 11/26/1997
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Macdonald, Patrick E., Eigler, Frank C.
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): TRINH, WILLIAM B
• Application Number:
  US08/978,588
• Time in Patent Office: 755 Days
• Field of Search: 707/103, 707/104, 707/206
• US Class Current: 707/702
• CPC Class Codes: G06F 16/2443 Stored procedures
• CPC Class Codes: Y10S 707/922 Communications
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing
• CPC Class Codes: Y10S 707/99953 Recoverability

Abstract

The invention herein provides method, means and programming for invoking a stored procedure or user defined function in an interpreted language such as Java in a database management system capable of operating on a data processing system. The invention includes a database server associated with invocation means adapted to receive a request for invokation of a stored procedure or user defined function in a specified interpreted language, such as Java. The invocation means is adapted to: load an interpreter for the specified language if the server is not already loaded, and setup an interprocess communication between the interpreter and the data the database server. The invocation means is adapted to return an error message to an application calling for invocation of the stored procedure or user defined function, without otherwise impeding operation of the database server.

Claims

1. Means for invoking a stored procedure or user defined function in a database management system capable of operating on a data processing system comprising:

a database server being associated with invocation means adapted to receive a request for invocation of a stored procedure or user defined function in a specified interpreted language;

said invocation means being adapted to;

load an interpreter for said specified language if said server is not already loaded, and setup an interprocess communication between said interpreter and said database server;

said invocation means being adapted to return an error message to an application calling for invocation of said stored procedure or user defined function, without otherwise impeding operation of said database server;

wherein said invocation means is adapted to load a stored procedure library as if it were a library in a default programming language and run said stored procedure if it were found in said library, and otherwise read the stored procedure system catalogue of the database management system to determine the language of said stored procedure, and load the appropriate interpreter for the specified interpreted language of the stored procedure if said interpreter was not already loaded;

and if said interpreter fails to load properly, returning a predefined error code to the application calling for said stored procedure;

and when said interpreter is loaded, setup interprocess communication between said interpreter and said database server.

2. The means of claim 1 wherein said interpreter is loaded by means of a stub dynamic link library which returns a predefined error code to the application calling for said stored procedure.

3. The means of claim 2 wherein said interprocess communication between said interpreter and said database server is accomplished by:

thread scheduling means adapted for;

scheduling an appropriate worker thread for said interpreted language;

if no threads exist creating an immortal thread;

if one or more threads exist locating an idle thread from a pool of threads;

if unable to locate an idle thread in a predetermined length of time then creating a mortal thread;

and, processing means adapted to use said thread to determine the appropriate method function to call based on predefined attributes such as class, method name, or signature.

4. The means of claim 3 wherein said method function to call is identified by traversing the interpreter to find the best match for said method.

5. The means of claim 4 wherein said method function to call is identified by traversing the object tree of said interpreter to locate the best matching method function based on said predefined attributes, and;

if not found returns an error code to said application;

and if found invokes the appropriate stored procedure of user defined procedure.

6. The means of claim 5 wherein for the case wherein said method function comprises a user defined function with a scratchpad option declared providing means for linking said user defined function to a suitable Hash table to prevent premature garbage collection.

7. The means of claim 1 wherein said interpreted language is Java and said interpreter is a Java interpreter.

8. A computer program product comprising:

a computer usable medium having computer readable program code means embodied therein for invoking a stored procedure or user defined function in a database management system capable of operating on a data processing system said computer readable program code means in said computer program product comprising;

computer readable program code means for causing a computer to effect a database server associated with invocation means adapted to receive a request for invocation of a stored procedure or user defined function in a specified interpreted language;

said invocation means being adapted to;

load an interpreter for said specified language if said server is not already loaded, and setup an interprocess communication between said interpreter and said database server;

said invocation means being adapted to return an error message to an application calling for invocation of said stored procedure or user defined function, without otherwise impeding operation of said database server; and

wherein said invocation means is adapted to load a stored procedure library as if it were a library in a default programming language and run said stored procedure if it were found in said library, and otherwise read the stored procedure system catalogue of the database management system to determine the language of said stored procedure, and load the appropriate interpreter for the specified interpreted language of the stored procedure if said interpreter was not already loaded;

and if said interpreter fails to load properly, returning a predefined error code to the application calling for said stored procedure;

and when said interpreter is loaded, setup interprocess communication between said interpreter and said database server.

9. The computer program product of claim 8 wherein said interpreter is loaded by means of a stub dynamic link library which returns a predefined error code to the application calling for said stored procedure.

10. The computer program product of claim 9 wherein said interprocess communication between said interpreter and said database server is accomplished by:

thread scheduling means adapted for;

scheduling an appropriate worker thread for said interpreted language;

if no threads exist creating an immortal thread;

if one or more threads exist locating an idle thread from a pool of threads;

if unable to locate an idle thread in a predetermined length of time then creating a mortal thread;

and, processing means adapted to use said thread to determine the appropriate method function to call based on predefined attributes such as class, method name, or signature.

11. The computer program product of claim 10 wherein said method function to call is identified by traversing the interpreter to find the best match for said method.

12. The computer program product of claim 11 wherein said method function to call is identified by traversing the object tree of said interpreter to locate the best matching method function based on said predefined attributes, and;

if not found returns an error code to said application;

and if found invokes the appropriate stored procedure of user defined procedure.

13. The computer program product of claim 12 wherein for the case wherein said method function comprises a user defined function with a scratchpad option declared providing means for linking said user defined function to a suitable Hash table to prevent premature garbage collection.

14. The computer program product of claim 8 wherein said interpreted language is Java and said interpreter is a Java interpreter.

15. A method for invoking a stored procedure or user defined function in a database management system capable of operating on a data processing system comprising:

associating a database server with invocation means adapted to receive a request for invocation of a stored procedure or user defined function in a specified interpreted language;

said invocation means being adapted to;

load an interpreter for said specified language if said server is not already loaded, and setup an interprocess communication between said interpreter and said database server;

said invocation means being adapted to return an error message to an application calling for invocation of said stored procedure or user defined function, without otherwise impeding operation of said database server; and

wherein said invocation means is adapted to load a stored procedure library as if it were a library in a default programming language and run said stored procedure if it were found in said library, and otherwise read the stored procedure system catalogue of the database management system to determine the language of said stored procedure, and load the appropriate interpreter for the specified interpreted language of the stored procedure if said interpreter was not already loaded;

and if said interpreter fails to load properly, returning a predefined error code to the application calling for said stored procedure;

and when said interpreter is loaded, setup interprocess communication between said interpreter and said database server.

16. The method of claim 15 wherein said interpreter is loaded by means of a stub dynamic link library which returns a predefined error code to the application calling for said stored procedure.