G - Physics – 06 – F
Patent
G - Physics
06
F
G06F 17/30 (2006.01) G06F 17/60 (2000.01)
Patent
CA 2365692
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 the database; evaluating the data processing system characteristics; evaluating the database 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 number of rows, row size, and column statistics; generating a plurality of potential index candidates by evaluating the workload, data processing system characteristics, database characteristics and 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.
Beyer Kevin S.
Cheung Kit Man
Cochrane Roberta J.
Leung Ting Y.
Lightstone Sam S.
International Business Machines Corporation
Rosen Arnold
LandOfFree
Method for recommending indexes and materialized views for a... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Method for recommending indexes and materialized views for a..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method for recommending indexes and materialized views for a... will most certainly appreciate the feedback.
Profile ID: LFCA-PAI-O-1980555