Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2006-02-28
2006-02-28
Alam, Hosain (Department: 2161)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000
Reexamination Certificate
active
07007006
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 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.
REFERENCES:
patent: 6356890 (2002-03-01), Agrawal et al.
patent: 6356891 (2002-03-01), Agrawal et al.
patent: 6366903 (2002-04-01), Agrawal et al.
patent: 6513029 (2003-01-01), Agrawal et al.
Beyer Kevin S.
Cheung Kit Man
Cochrane Roberta J.
Leung Ting Y.
Lightstone Samuel S.
Alam Hosain
Goldman Richard M.
McSwain Mark D.
Nguyen Cam-Linh
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: LFUS-PAI-O-3662065