公开(公告)号：CA2459004A1

公开(公告)日：2005-08-20

申请号：CA2459004

申请日：2004-02-20

Applicant: IBM CANADA

Inventor： RJAIBI WALID ,  BIRD PAUL M

IPC: G06F12/14

Abstract: For a data processing system having memory for storing data elements, a meth od for directing the data processing system to control user access to the store d data elements. Each stored data element is associated with a set of data security label components. Each user is associated with a set of user security label components. The method includes receiving a user request to access the stored data elements, comparing the s et of user security label components against the set of data security label components associated with the users, and determining whether to permit access to the stored data responsive to the received user request based on results of the comparison. There is an access control system and a computer program product which implements the method.

公开(公告)号：CA2384259A1

公开(公告)日：2003-10-29

申请号：CA2384259

申请日：2002-04-29

Applicant: IBM CANADA

Inventor： STUY MICHAEL A F ,  BIRD PAUL M

IPC: G06F21/30 ,  G06F16/21 ,  G06F12/14 ,  G06F12/02 ,  G06F17/30

Abstract: A method and system for permitting concurrent access to cached authorization information for an SQL database system. The authorization information is cached as consolidated bitmaps. A first, authorization, bitmap in the cache represents committed authorization information for a grantee and type of grantee. A second, cumulative delta, bitmap in each cache entry represents authorization information not yet committed. A cache entry state is recorded for each cach e entry. Access to the cumulative delta bitmap is provided where the database agent requesting acce ss is the agent carrying out a modification to the cached authorization information. Access to the authorization bitmap information is permitted, amongst other conditions, where a grant statement is uncommitted and the database agent requesting access is not seeking to modify the authorization

公开(公告)号：CA2382718A1

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

申请号：CA2382718

申请日：2002-04-12

Applicant: IBM CANADA

Inventor： BIRD PAUL M ,  VALENTIN GARY ,  HURAS MATTHEW A ,  XUE XUN

IPC: G06F9/50 ,  G06F12/00 ,  G06F12/02

Abstract: Memory balancing and optimization services (MBOS) control a size of a plurality of memory heaps, and a memory optimizer for allocating and de-allocating memory for a plurality of respective memory consumers. The MBOS may be instantiated within an application program such as a database management system providing services to memory consumers within the application. Alternatively, the MBOS may be instantiated within an operating system for providing services to memory consumers that are applications such as databas e management systems, e-commerce engines, operating systems, customer relationship management (CRM), enterprise resource planning (ERP), or supply chain management (SCM). Alternatively, an MBOS is instantiated within the operating system to provide services to applications and an MBOS is instantiated within each application to provide services to memory consumers within the application.

公开(公告)号：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.

公开(公告)号：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.

公开(公告)号：CA2249066A1

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

申请号：CA2249066

申请日：1998-09-29

Applicant: IBM CANADA

Inventor： BIRD PAUL M ,  MCKNIGHT KATHY A

IPC: G06F17/30

Abstract: A global cache for SQL sections and methods of accessing the cache. The global cache being at the database level and being accessible to all agents of all applications. The global cache having a static and a dynamic portion. The static portion containing section entries having both section information and section data. The dynamic portion having two sub-portions, a statement portion and a dependency portion. The dependency portion containing multiple SQL statements, multiple compilation environments for each SQL statement and multiple variations within each compilation environment. The dependency portion of the dynamic portion containing a plurality of lists of object types. Each object type having its own list, the list containing data on which variations are dependant on each object.