Patent ID: 8019784
Filing Date: 2011-09-13
Classification: G06F

Abstract:
1. A computer-implemented method, in a database server having a file system and a database management system, for managing an external routine in a data store interoperably coupled with the database management system, the method comprising: creating, by the database management system, a first table for storing the external routine having an identifier and a body portion comprising an implementation of the external routine, in the data store, wherein the implementation of the external routine includes program code in a language environment associated with the external routine; storing, by a routine manager in the database management system, 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, by the database management system, any modification in relation to the external routine; controlling, by the database management system, access to the external routine, wherein storing the body portion in the second column includes compiling, by the database server, 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, by the database management system, a plurality of external compilation modules, wherein each external compilation module is associated with a language environment; creating, by the database server, a mapping in the database management system that maps each language environment to the associated external compilation module; using, by the database management system, the mapping to invoke the external compilation module associated with the language environment of the external routine; and utilizing, by the database server, the invoked external compilation module to compile the program code.