公开(公告)号：CA2365687A1

公开(公告)日：2003-06-19

申请号：CA2365687

申请日：2001-12-19

Applicant: IBM CANADA

Inventor： VINCENT TIMOTHY J ,  DOOLE DOUGLAS J ,  MCKEOUGH SEAN W ,  WILSON GEORGE M

IPC: G06F9/48 ,  G06F9/06 ,  G06F17/30

Abstract: A database management system provides for the execution of invokable user- defined routines. Applications specify user-defined routines as being threadsafe or not threadsafe and specify the language of user-defined routines. Execution of routines will be carried out dependent on the threadsafe characteristic of the routines and on the language of the routines. Routines are assigned to processes based on their language to have any given process execute routines of the same language. Routines that are specified to be threadsafe are executed in threa ds in a potentially multi- threaded process. Each routine that is specified to be not threadsafe is executed in a fenced-mode processes in which no other routine is being executed.

公开(公告)号：CA2366338A1

公开(公告)日：2003-06-21

申请号：CA2366338

申请日：2001-12-21

Applicant: IBM CANADA

Inventor： WILSON GEORGE M ,  BOUSFIELD MELISSA ,  DOOLE DOUGLAS J ,  VINCENT TIMOTHY J ,  MCKEOUGH SEAN W

IPC: G06F9/40 ,  G06F9/445 ,  G06F17/30

Abstract: Library management for libraries of user-defined routines in a database system. Libraries are stored in a long-term storage device and loaded into working memory in t he database system when routines in the libraries are to be executed. An unload thread is defin ed to carry out the process of unloading libraries from the working memory when such libraries are inactive. The unload thread becomes active on a defined timing interval. The unload thread accesses a ha sh table and a most recently used list to determine which of the loaded libraries is inactive an d which of the libraries ought to be unloaded. The hash table maintains information as to which libraries have been accessed in the most recent past defined timing interval. The size of the most recent ly used list can be defined such that all libraries associated with the list are retained in working memory.

公开(公告)号：CA2366338C

公开(公告)日：2006-08-08

申请号：CA2366338

申请日：2001-12-21

Applicant: IBM CANADA

Inventor： DOOLE DOUGLAS J ,  VINCENT TIMOTHY J ,  WILSON GEORGE M ,  BOUSFIELD MELISSA ,  MCKEOUGH SEAN W

IPC: G06F17/30 ,  G06F9/40 ,  G06F9/445

Abstract: Library management for libraries of user-defined routines in a database system. Libraries are stored in a long-term storage device and loaded into working memory in t he database system when routines in the libraries are to be executed. An unload thread is defin ed to carry out the process of unloading libraries from the working memory when such libraries are inactive. The unload thread becomes active on a defined timing interval. The unload thread accesses a ha sh table and a most recently used list to determine which of the loaded libraries is inactive an d which of the libraries ought to be unloaded. The hash table maintains information as to which libraries have been accessed in the most recent past defined timing interval. The size of the most recent ly used list can be defined such that all libraries associated with the list are retained in working memory.