公开(公告)号：CA2447458A1

公开(公告)日：2005-04-29

申请号：CA2447458

申请日：2003-10-29

Applicant: IBM CANADA

Inventor： DANTRESSANGLE PATRICK ,  COTNER CURT L ,  BIRD PAUL M

IPC: G06F16/17 ,  G06F16/2455 ,  G06F21/62 ,  G06F17/30

Abstract: A system and method for supporting named memory variables in an information retrieval system comprising a relational database. PUBLIC and PRIVATE named memory variables can be created, referenced, modified or deleted using SQL statements. The informati on retrieval system allocates a memory area as a named variable storage space for storing named memory variables. System catalogs may be used for storing information about PUBLIC, SECURE PUBLIC, SECURE PRIVATE, and pre-defined named memory variables. PUBLIC and PRIVATE named memory variables can be used for transferring information between SQL statements of one or more sessions, or for retrieving system information from the relational database. Both PUBLIC and PRIVATE types can be defined as SECURE named memory variables requiring specific authorization privileges to read or write to the variable.