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

公开(公告)号：CA2384174A1

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

申请号：CA2384174

申请日：2002-04-29

Applicant: IBM CANADA

Inventor： ZHU BIAO ,  PIRAHESH HAMID ,  SIDLE RICHARD S ,  LAPIS GEORGE ,  COCHRANE ROBERTA J ,  RIELAU SERGE P

IPC: G06F16/16 ,  G06F17/30 ,  G06F12/02

Abstract: Records of information are classified for delivery to different targets or destinations even though it is not predictable as to which target a given unit of data (such a s a record) should be routed. Classification allows database updating through an insert command. Generally, it cannot be predicted into which table a given record should be inserted when there a re multiple tables or destinations from which to choose.