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

Claim 2

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.

Claim 3

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.

Claim 4

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.

Claim 5

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.

Claim 6

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.

Claim 7

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.

Claim 8

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

Claim 9

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.

Claim 10

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.

Claim 11

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.

Claim 12

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.

Claim 13

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.

Claim 14

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.

Claim 15

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.

Claim 16

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

Claim 19

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.