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

公开(公告)号：CA2365692A1

公开(公告)日：2002-12-21

申请号：CA2365692

申请日：2001-12-19

Applicant: IBM

Inventor： ZILIO DANIEL C ,  CHEUNG KIT MAN ,  LIGHTSTONE SAM S ,  ZUZARTE CALISTO P ,  BEYER KEVIN S ,  VALENTIN GARY ,  ZAHARIOUDAKIS MARKOS ,  LEUNG TING Y ,  LOHMAN GUY M ,  SIMMEN DAVID E ,  PIRAHESH MIR HAMID ,  COCHRANE ROBERTA J

IPC: G06F17/30 ,  G06F17/60

Abstract: The invention herein provides method and apparatus, including software for determining a set of materialized views or indices of the contents or a subset of the contents of a database in a data processing system to be created for one or more users of the database. The method and apparatus provide method and means for evaluating a workload presented by a user to th e database; evaluating the data processing system characteristics; evaluating the databa se characteristics; and, using the above evaluations for recommending a set of suitable materialized views or indices to the user. Another aspect of the invention, which may be used for a workload presented by a user of a database in a data processing system, provides method and apparatus, including software for determining a set of materialized views or indices of the contents or a subset of the contents of the database, by: generating a plurality of materialized view candidates from evaluation of the workload, data processing system characteristics and database characteristics; estimating statistics for the materialized view candidates such as the numbe r of rows, row size, and column statistics; generating a plurality of potential index candidates by evaluating the workload, data processing system characteristics, database characteristics a nd the materialized view candidates; and, from the materialized view candidates and index candidates selecting a set of suitable materialized views and/or indices for submission to the user.

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

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

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

公开(公告)号：CA2353015A1

公开(公告)日：2003-01-12

申请号：CA2353015

申请日：2001-07-12

Applicant: IBM CANADA

Inventor： FINLAY IAN R ,  LAI TONY WEN HSUN ,  ZUZARTE CALISTO P ,  ZILIO DANIEL C

IPC: G06F17/30

Abstract: The retrieval of distinct tuples in a relational database management system. In response to a request from a consumer process for distinct tuples in a relational database table matching a defined criteria, a distinct operator component sequentially requests tuples from a source component. The source component access the database table and returns a tuple in the sequence to the distinct operator component. The distinct operator component passes each tuple in the sequence to an auxiliary logger. The auxiliary component receives a tuples from the distinct component and determines if it is distinct from other previously received tuples in the sequence to verify its uniqueness to the distinct operator. Tuples that are verified as unique by the auxiliary logger are returned to the consumer process by the distinct operator upon verification.

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