Patent ID: 8024357

Claim:
A computer readable storage medium containing program instructions for managing an external routine in a computer implemented database management system, the program instructions, when executed by a computer, causing the computer to execute the steps of: creating a first table in a data store coupled to the database management system, the first table for storing external routine having an identifier and a body portion comprising an implementation of the external routine, wherein the implementation of the external routine includes program code in a language environment associated with the external routine; storing the external routine in the first table by storing the identifier in a first column and storing the body portion in a second column as a database object; automatically and directly managing any modification to the database related to the external routine; controlling access to the external routine, wherein storing the body portion in the second column includes compiling the program code prior to storing the body portion in the second column and storing the compiled program code in the second column such that the external routine can be executed directly; providing a plurality of external compilation modules, wherein each external compilation module is associated with a language environment; creating a mapping in the database management system that maps each language environment to the associated external compilation module; using the mapping to invoke the external compilation module associated with the language environment of the external routine; and utilizing the invoked external compilation module to compile the program code.