-
公开(公告)号：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
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.
-
公开(公告)号：CA2366196A1
公开(公告)日：2003-06-21
申请号：CA2366196
申请日：2001-12-21
Applicant: IBM CANADA
Inventor： VINCENT TIMOTHY J , BIRD PAUL M , COTNER CURT L
IPC: G06F17/30
Abstract: A cursor query identifier is defined to uniquely identify cursors in a relational database system that supports nested routine invocation. The identifier includes a cursor nesting level value that corresponds to the nested level at which the cursor is opened. The identifier also includes a invocation identifier that corresponds to the routine within which a cursor is opened. The third part of the identifier is a unique cursor counter. The definition of the cursor query identifier permits cursors to be opened within nested levels of the same relational database context and to be uniquely identified for reference by database system and by applications accessing th e system.
-
3.发明专利
公开(公告)号：CA2365687A1
公开(公告)日：2003-06-19
申请号：CA2365687
申请日：2001-12-19
Applicant: IBM CANADA
Inventor： VINCENT TIMOTHY J , DOOLE DOUGLAS J , MCKEOUGH SEAN W , WILSON GEORGE M
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.
-
公开(公告)号：CA2419982A1
公开(公告)日：2004-08-26
申请号：CA2419982
申请日：2003-02-26
Applicant: IBM CANADA
Inventor： COTNER CURT L , OSTLER PAUL A , BEGG ROBERT A , VINCENT TIMOTHY J , GROSS BRENT P
Abstract: A database server helps to streamline retrieval of lob values by making the decision of sending a locator in replacement of the lob value, or the lob value itself, depending upon the specific lob value being retrieved. A threshold value is determined in a fetch query, and lob sizes below that threshold are sent as values in a corresponding fetch response, and lengths above are sent as locators in the fetch response. Indicators are inserted in a fetch parameter of the response to inform the receiving client about which form of retrieval was used for each requested lob value being returned. The use of the indicators provides for sending lob values to the client when the lob value is considered small, and sending the locator when the lob values a re considered large in comparison to the threshold value. Therefore, the use of distinct indicators in the parameter of the response provides for the server system making a dynamic decision of sending either the LOB locator or an inline LOB value in the response, depending upon the specific value of the LOB in comparison to the threshold value. For example, the LOB values below the threshold are sent as values in columns or fetch answers of the response, while the LO B values above the threshold are sent as locators in place of the LOB values. The fetch paramet er uses the distinct indicator values to help inform the client of the form of retrieval present in the response as a result of the query.
-
公开(公告)号：CA2366192A1
公开(公告)日：2003-06-21
申请号：CA2366192
申请日：2001-12-21
Applicant: IBM CANADA
Inventor： VINCENT TIMOTHY J , BIRD PAUL M
IPC: G06F17/30
Abstract: Working memory in an SQL database system is organized in workspaces. Age nt workspaces are defined into which working copies of SQL executable logic information are loaded. Application workspaces are also defined for the loading of working copies of SQL executable logic information. Reference copies of the SQL information are available in a global SQL cache. An application SQL context data structure is as an entry point to access working copies of SQL information in the agent or application workspaces. An application workspace is associated with an application and is maintained until the last applicati on in the set is not active. An agent workspace is associated with an agent in the database syste m and is maintained until the agent is no longer active.
-
Patent Agency Ranking
公开(公告)号：CA2365731A1
公开(公告)日：2003-06-20
申请号：CA2365731
申请日：2001-12-20
Applicant: IBM CANADA
Inventor： VINCENT TIMOTHY J , BIRD PAUL M
IPC: G06F17/30
Abstract: An SQL database management system for executing SQL requests from applications. The SQL database management system includes a hierarchical arrangement of data structures comprising packages, section entries, sibling control blocks and sections, for representing SQL context information and SQL statement information. Each package represents SQL conte xt information on an application component-level basis. Each section entry is associated with a package and corresponds to a set of SQL actions. Each section entry is potentially associated with one or more sibling control blocks. Each sibling control block is associated with one section and represents context information relating to a unique SQL request. Each section includes logic for a specific SQL statement.
-
公开(公告)号：CA2322604A1
公开(公告)日：2002-04-06
申请号：CA2322604
申请日：2000-10-06
Applicant: IBM CANADA
Inventor： XUE XUN , MCKEOUGH SEAN W , VINCENT TIMOTHY J , HURAS MATTHEW A , ZHENG ROGER L
Abstract: A deadlock management system for a demultiplexed database system having work er agents and applications associated with and disassociated from the worker agents. Applications holding locks on database resources and capable of retaining locks when disassociated from worker agents. Providing each application with a flag set in accordance with the existing value of the application flag and in accordance with the state of applications holding and requesting locks. The deadlock management system providing for applications to be placed on a wait queue, a priority queue, or provided worker agents or overflow worker agents depending on the flag value for the application. Declaring deadlocks based on the flag value of applications and on the state of the lock wait graph showing applications holding and requesting locks.
-
公开(公告)号：CA2365731C
公开(公告)日：2008-09-23
申请号：CA2365731
申请日：2001-12-20
Applicant: IBM CANADA
Inventor： BIRD PAUL M , VINCENT TIMOTHY J
Abstract: An SQL database management system for executing SQL requests from applications. The SQL database management system includes a hierarchical arrangement of data structures comprising packages, section entries, sibling control blocks and sections, for representing SQL context information and SQL statement information. Each package represents SQL context information on an application component-level basis. Each section entry is associated with a package and corresponds to a set of SQL actions. Each section entry is potentially associated with one or more sibling control blocks. Each sibling control block is associated with one section and represents context information relating to a unique SQL request. Each section includes logic for a specific SQL statement.
-
公开(公告)号：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
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.
-
公开(公告)号：CA2322604C
公开(公告)日：2005-06-28
申请号：CA2322604
申请日：2000-10-06
Applicant: IBM CANADA
Inventor： XUE XUN , ZHENG ROGER L , VINCENT TIMOTHY J , MCKEOUGH SEAN W , HURAS MATTHEW A
Abstract: A deadlock management system for a demultiplexed database system having work er agents and applications associated with and disassociated from the worker agents. Applications holding locks on database resources and capable of retaining locks when disassociated from worker agents. Providing each application with a flag set in accordance with the existing value of the application flag and in accordance with the state of applications holding and requesting locks. The deadlock management system providing for applications to be placed on a wait queue, a priority queue, or provided worker agents or overflow worker agents depending on the flag value for the application. Declaring deadlocks based on the flag value of applications and on the state of the lock wait graph showing applications holding and requesting locks.
-
-
-
-
-
-
-
-
-
Search Results
12
records
(took 0.02 seconds)
