公开(公告)号：CA2307155A1

公开(公告)日：2001-10-28

申请号：CA2307155

申请日：2000-04-28

Applicant: IBM CANADA

Inventor： MCKNIGHT KATHY A ,  HUFFMAN PAUL C ,  ZILIO DANIEL C ,  SHARPE DAVID C

IPC: G06F12/00 ,  G06F17/30

Abstract: A query processing system has a query processor and a data manager. The quer y processor calls the data manager to carry out data access for a query including a filtering operation, The date manager accesses the data in a set of data and before returning the data, initiates a callback to the query processor to determine if the located data meets the filtering criteria. Whe re the data does not satisfy the filtering criteria, the data manager seeks additional data in the set of data, without having to return the first located data to the query processor.

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

公开(公告)号：CA2279051C

公开(公告)日：2004-12-28

申请号：CA2279051

申请日：1999-07-29

Applicant: IBM CANADA

Inventor： WINER MICHAEL J ,  ZHENG ROGER LUO Q ,  WONG CATHARINA K ,  MCKNIGHT KATHY A

IPC: G06F17/30 ,  G06F17/60

Abstract: A lock control data structure for an unit of work of an application program. The unit of work has a set of threads of access for opening a set of objects accessible to th e application program. The lock control data structure has a set of object-specific lock models corresponding to the set of objects, and a lock controller for locking each object in the set of objects . Information regarding the lock requirements for each object are stored in the corresponding object- specific lock model. The lock controller locks and unlocks each object in the set of objects based on the information stored in the corresponding object-specific lock model.

公开(公告)号：CA2279051A1

公开(公告)日：2001-01-29

申请号：CA2279051

申请日：1999-07-29

Applicant: IBM CANADA

Inventor： WONG CATHARINA K ,  WINER MICHAEL J ,  ZHENG ROGER LUO Q ,  MCKNIGHT KATHY A

IPC: G06F17/30 ,  G06F17/60

Abstract: A lock control data structure for an unit of work of an application program. The unit of work has a set of threads of access for opening a set of objects accessible to th e application program. The lock control data structure has a set of object-specific lock models corresponding to the set of objects, and a lock controller for locking each object in the set of objects . Information regarding the lock requirements for each object are stored in the corresponding object- specific lock model. The lock controller locks and unlocks each object in the set of objects based on the information stored in the corresponding object-specific lock model.

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