公开(公告)号：CA2427273A1

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

申请号：CA2427273

申请日：2003-04-30

Applicant: IBM CANADA

Inventor： FINLAY IAN R ,  LOHMAN GUY M

IPC: G06F16/2455 ,  G06F17/30

Abstract: For an information retrieval system adapted to process a query having an associated plan, the associated plan includes applying predicates, including local predicates and a join predicate, to at least two tables, method and system of applying the predicates is provided. Index ANDing is used to construct a filter for filtering a first of the tabl es in accordance with the local predicates. The join predicate is applied to the tables for determining row identifiers of rows satisfying the join predicate. The row identifiers are used to probe the filter for determining whether the rows satisfying the join predicate also satisfy the local predicates. The rows that satisfy both the join and local predicates are fetched and the join predicate is completed. Results of the join predicate are then returned .

公开(公告)号：CA2249096C

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

申请号：CA2249096

申请日：1998-09-30

Applicant: IBM CANADA

Inventor： VALENTIN GARY ,  LOHMAN GUY M

IPC: G06F17/30

Abstract: A method for determining optimal database materializations utilizing a query optimizer in a database management system. The method takes one or more queries as inputs and using the query optimizer in the database management system generates a series of virtual materializations by materializing some subsets of the database. The virtual materializations are used to consider the relative performance benefits, i.e. cost-benefits, for the queries based on the various virtual materializations. If the query optimizer decides to use any of the materializations in its plan, then those materializations are recommended to the user, or created automatically for the user.

公开(公告)号：CA2306946C

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

申请号：CA2306946

申请日：2000-04-28

Applicant: IBM CANADA

Inventor： FINLAY IAN R ,  LOHMAN GUY M ,  SHARPE DAVID C ,  LINDSAY BRUCE G ,  ZILIO DANIEL C

IPC: G06F17/30

Abstract: A query processing system having a data manager, and a query manager also includes a buffer. The query manager calls the data manager to access data based on a query. Where there is no predicate check or consumption operation on the record accessed, the data manager will notionally return the record to the query manager. However, the data manager accomplishes the retu rn by writing the relevant portions of the record to a buffer. The data manager maintains stabilization of the page containing the record while the buffer is being written to. The data manager continues to access records on the stabilized page and to write such records to the buffer where appropriate. The query manager retrieves the records from the buffer after the data manager has completed its operation resulting from the query manager call.

公开(公告)号：CA2306946A1

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

申请号：CA2306946

申请日：2000-04-28

Applicant: IBM CANADA

Inventor： ZILIO DANIEL C ,  FINLAY IAN R ,  LOHMAN GUY M ,  SHARPE DAVID C ,  LINDSAY BRUCE G

IPC: G06F17/30

Abstract: A query processing system having a data manager, and a query manager also includes a buffer. The query manager calls the data manager to access data based on a query. Where there is no predicate check or consumption operation on the record accessed, the data manager will notionally return the record to the query manager. However, the data manager accomplishes the retu rn by writing the relevant portions of the record to a buffer. The data manager maintains stabilization of the page containing the record while the buffer is being written to. The data manager continues to access records on the stabilized page and to write such records to the buffer where appropriate. The query manager retrieves the records from the buffer after the data manager has completed its operation resulting from the query manager call.

公开(公告)号：CA2249096A1

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

申请号：CA2249096

申请日：1998-09-30

Applicant: IBM CANADA

Inventor： VALENTIN GARY ,  LOHMAN GUY M

IPC: G06F17/30

Abstract: A method for determining optimal database materializations utilizing a query optimizer in a database management system. The method takes one or more queries as inputs and using the query optimizer in the database management system generates a series of virtual materializations by materializing some subsets of the database. The virtual materializations are used to consider the relative performance benefits, i.e. cost-benefits, for the queries based on the various virtual materializations. If the query optimizer decides to use any of the materializations in its plan, then those materializations are recommended to the user, or created automatically for the user.