公开(公告)号：CA2249059A1

公开(公告)日：2000-03-29

申请号：CA2249059

申请日：1998-09-29

Applicant: IBM CANADA

Inventor： SNOWBELL MICHAEL J ,  BIRD PAUL M

IPC: G06F17/30

Abstract: A method and system for caching dynamic SQL statements and their sections at different nodes in a multiple node Relational Database Management System (RDBMS) while maintaining cache and application integrity across all nodes. Each node in the RDBMS having a global cache shared by all applications on that node. One of the nodes in the RDBMS being a catalogue node which controls access to a database. The catalogue node maintaining a list of participating nodes that have requested access to the database controlled by the catalogue node. The list of participating nodes being used to notify each participating node of any changes to the database that may affect the validity of a dynamic SQL statement stored in the global cache of the node.

公开(公告)号：CA2425046A1

公开(公告)日：2004-10-08

申请号：CA2425046

申请日：2003-04-08

Applicant: IBM CANADA

Inventor： SNOWBELL MICHAEL J ,  BIRD PAUL M

IPC: G06F16/172 ,  G06F16/2455 ,  G06F21/00 ,  G06F17/30 ,  G06F12/02

Abstract: In a database system that supports object name overloading, database query statements are compiled and cached as data structures, so that object level privileges are correctly resolved. Database query statements stored in the cached data structures are utilized when appropriate, and a new compilation is performed when an incorrect resolution would result. The data structures are stored in a predefined orde r to ensure that a deterministic search of the cache is efficiently performed.

公开(公告)号：CA2293059A1

公开(公告)日：2001-06-22

申请号：CA2293059

申请日：1999-12-22

Applicant: IBM CANADA

Inventor： CHAN YUK-KUEN ,  BIRD PAUL MILLER ,  SNOWBELL MICHAEL J

IPC: G06F16/2455 ,  G06F9/45 ,  G06F16/172 ,  G06F17/30 ,  G11B23/00

Abstract: An SQL relational database management system which determines the shareable status of an executable object (section) in an SQL cache. The shareable status is defined for a section in an SQL cache by the system maintaining an identification list which has reference t o database entities which are affected by a DDL statement in the current unit of work. When an SQL statement is compiled, the compiler generates a list of dependencies, which list is compared with t he identification list. If the SQL statement data dependencies are on the identification list, the SQL statement will be treated as non-shareable until the completion of the current unit of work.

公开(公告)号：CA2310578A1

公开(公告)日：2001-12-02

申请号：CA2310578

申请日：2000-06-02

Applicant: IBM CANADA

Inventor： LEE JESSE ,  SEE YEUNG-KUEN ,  SNOWBELL MICHAEL J ,  PEREYRA HEBERT W ,  WONG CATHARINA K ,  BIRD PAUL M ,  CHAN YUK KUEN

IPC: G06F17/30

Abstract: The invention herein provides a mufti-node relational database management system that can be embodied in software for managing a database having declared temporar y tables associated with respective software application programs, comprising: a plurality of nodes, including: a catalog node for maintaining a list of identification for declared temporary tables associated with any application; a coordinator node for an application; at least one subordinate node for the application, the subordinate node having at least one partition of the declared temporary tables of the application; and a declared temporary table manager for causing the coordinator node to maintain for the application a list of declared temporar y tables.

公开(公告)号：CA2249059C

公开(公告)日：2001-08-21

申请号：CA2249059

申请日：1998-09-29

Applicant: IBM CANADA

Inventor： SNOWBELL MICHAEL J ,  BIRD PAUL M

IPC: G06F17/30

Abstract: A method and system for caching dynamic SQL statements and their sections at different nodes in a multiple node Relational Database Management System (RDBMS) while maintaining cache and application integrity across all nodes. Each node in the RDBMS having a global cache shared by all applications on that node. One of the nodes in the RDBMS being a catalogue node which controls access to a database. The catalogue node maintaining a list of participating nodes that have requested access to the database controlled by the catalogue node. The list of participating nodes being used to notify each participating node of any changes to the database that may affect the validity of a dynamic SQL statement stored in the global cache of the node.

公开(公告)号：CA2425046C

公开(公告)日：2009-10-06

申请号：CA2425046

申请日：2003-04-08

Applicant: IBM CANADA

Inventor： SNOWBELL MICHAEL J ,  BIRD PAUL M

IPC: G06F16/172 ,  G06F16/2455 ,  G06F21/00

Abstract: In a database system that supports object name overloading, database query statements are compiled and cached as data structures, so that object level privileges are correctly resolved. Database query statements stored in the cached data structures are utilized when appropriate, and a new compilation is performed when an incorrect resolution would result. The data structures are stored in a predefined orde r to ensure that a deterministic search of the cache is efficiently performed.

公开(公告)号：CA2293059C

公开(公告)日：2004-06-08

申请号：CA2293059

申请日：1999-12-22

Applicant: IBM CANADA

Inventor： CHAN YUK-KUEN ,  BIRD PAUL MILLER ,  SNOWBELL MICHAEL J

IPC: G06F16/2455 ,  G06F9/45 ,  G06F16/172 ,  G06F17/30 ,  G11B23/00

Abstract: An SQL relational database management system which determines the shareable status of an executable object (section) in an SQL cache. The shareable status is defined for a section in an SQL cache by the system maintaining an identification list which has reference t o database entities which are affected by a DDL statement in the current unit of work. When an SQL statement is compiled, the compiler generates a list of dependencies, which list is compared with t he identification list. If the SQL statement data dependencies are on the identification list, the SQL statement will be treated as non-shareable until the completion of the current unit of work.