Patent ID: 6985911
Filing Date: 2006-01-10
Classification: G06F,Y10S

Abstract:
1. A computer implemented method for the execution of a set of invokable user-defined routines in a database management system, the method comprising: (a) receiving a request from an application to invoke a user-defined routine in the set of user-defined routines, (b) determining whether the user-defined routine is threadsafe, (c) in the case that the user-defined routine is determined not to be threadsafe, spawning a fenced-mode process to execute the user-defined routine, (d) in the case that the user-defined routine is determined to be threadsafe, where an existing process is available to the database system for execution of threadsafe routines, executing the user-defined routine in a thread in the existing process, and where there is no such existing process, spawning a new, multi-threaded, fenced-mode process and executing the user-defined routine in a thread in the said new process.