Loading patent…
AssigneeInternational Business Machines Corporation
InventorsRobert Bestgen, James Flanagan, Michale Pfeifer
Estimating the term…
A database management system maintains a record of queries which can be executed against the database. For a given auxiliary database structure, an advisory function automatically reviews the query record and identifies those queries which might execute with greater efficiency using the auxiliary database structure, presenting analytical information to the user. Preferably, the auxiliary database structure is an index, and the information is used for determining whether to include the index in the database definition. Preferably, a query optimizer records potentially useful indexes when considering multiple alternative database optimizations, and this information is later retrieved to identify queries which would benefit from an index.
A method for managing a database in at least one computer system, comprising the computer-executed steps of:
A computer program product for managing a database in at least one computer system, said at least one computer system including a record of a set of queries which can be executed against said database, said program product comprising:
The computer program product 14, wherein said step of identifying any queries for which the corresponding record of a set of hypothetical auxiliary database structures contains a hypothetical auxiliary database structure matching said auxiliary database structure specified by said specifying step comprises matching said auxiliary database structure according to at least one user-specified matching criterion.
A computer system, comprising:
Dependencies are inferred from the claim text.