公开(公告)号：JP2001357063A

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

申请号：JP2001127376

申请日：2001-04-25

Applicant: IBM

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

IPC: G06F12/00 ,  G06F17/30

Abstract: PROBLEM TO BE SOLVED: To provide a query processor capable of executing a query including filtering so as to decrease the number of times of fixing a page required for executing the query. SOLUTION: The query processing system has the query processor and a data manager. The query processor calls the data manager and executes data access for performing the query including a filtering operation. The data manager accesses data in the set of data and, before returning these data, call-back is started to the query processor. Then, it is judged whether the found data satisfy a filtering reference or not. When the data do not satisfy the filtering reference, the data manager seeks additional data in the set of data and it is not necessary to return the first found data to the query processor.

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

公开(公告)号：GB2366039B

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

申请号：GB0103345

申请日：2001-02-12

Applicant: IBM

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

IPC: G06F12/00 ,  G06F17/30

公开(公告)号：GB2356950B

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

申请号：GB0018310

申请日：2000-07-27

Applicant: IBM

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

IPC: G06F17/30

公开(公告)号：GB2366039A

公开(公告)日：2002-02-27

申请号：GB0103345

申请日：2001-02-12

Applicant: IBM

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

IPC: G06F12/00 ,  G06F17/30

Abstract: A query processor (14) calls a data manager (16) to carry out data access for a query including a filtering operation. The data manager (16) accesses the data in a set of data (18) and, before returning the data, initiates a callback to the query processor (14) to determine if the located data meets the filtering criteria. Where the data does not satisfy the filtering criteria, the data manager (16) seeks additional data in the set of data (18), without having to return the first located data to the query processor (14).

公开(公告)号：GB2356950A

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

申请号：GB0018310

申请日：2000-07-27

Applicant: IBM

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

IPC: G06F17/30

Abstract: A lock control data structure for a 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 the 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.