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

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

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

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

公开(公告)号：CA2382712A1

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

申请号：CA2382712

申请日：2002-04-19

Applicant: IBM CANADA

Inventor： DOOLE DOUGLAS J ,  BIRD PAUL M

IPC: G06F17/30 ,  G06F9/45

Abstract: Conflict checking for writing operations in an SQL database system is carrie d out for nested statements invoked by a parent statement. Each statement has an associated table access data structure defined at compile-time indicating the tables in the database that the statement accesses and the mode of access. At execution-time the table access data structure for ea ch nested statement is accessed and the information is compared with a list of tables maintained fo r the parent statement to determine if there is a read/write or write/write conflict possible if th e nested statement is executed. Where there is no conflict detected, the information from the tabl e access data structure is copied to the list of tables.

公开(公告)号：CA2382718C

公开(公告)日：2007-02-13

申请号：CA2382718

申请日：2002-04-12

Applicant: IBM CANADA

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

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

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.

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

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

公开(公告)号：CA2249066C

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

申请号：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 al l 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.

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