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

公开(公告)号：CA2419904A1

公开(公告)日：2004-08-26

申请号：CA2419904

申请日：2003-02-26

Applicant: IBM CANADA

Inventor： XU THERESA ,  LIPFORD GORDON D ,  TASSI BELAI A ,  CHEUNG KIT MAN ,  KOHLMANN PETER W ,  SIROIS ERIC A ,  MEZOFENYI MARK

IPC: G06F9/44 ,  G06F17/30 ,  G06F17/00

Abstract: A method for serializing and deserializing program objects that is versionin g sensitive. A program object is serialized into a persistent object by saving only those data fields that contain non-default data. The persistent object is deserialized to be used b y a deserializing application by first creating a blank program object of the sa me version as the deserializing application and then populating it with the non-default da ta stored in the persistent object. The version of the deserializing application need not he the same as the version of the serializing application.