International Business Machines Corporation

Thomas James Schreiber

Mark John Anderson

Robert J Bestgen

Scott Forstie

James Michael Flanagan

Brian Robert Muras

Robert Douglas Driesch, Jr

Craig Stephen Aldrich

Lynnette Elaine Carston

An index advice record engine generates and stores index advice records. An index advice policy mechanism allows a user to define an index advice policy that specifies criteria for autonomic index creation. An autonomic index creation mechanism reads the index advice records, compares this information with the criteria in the user-defined index advice policies, and determines whether an index should be created based on the information in the index advice records and the index advice policies. By automating the process of creating indexes according to user-defined policies, the preferred embodiments alleviate human users from most of the work of manually creating indexes.

Autonomic index creation

An index advice record engine generates and stores index advice records. An index advice policy mechanism allows a user to define an index advice policy that specifies criteria for autonomic index creation, modification and deletion. An autonomic index mechanism reads the index advice records, compares this information with the criteria in the user-defined index advice policies, and determines whether an index should be created, modified or deleted based on the information in the index advice records and the index advice policies. By automating the process of creating, modifying and deleting indexes according to user-defined policies, the preferred embodiments alleviate human users from most of the work of manually creating, modifying and deleting indexes.

Autonomic index creation, modification and deletion

Disclosed is an apparatus, method, and program product for performing efficient database access plan caching. Unlike prior art mechanism that automatically discard stored access plans whenever the need for a different access plans is detected, stored plans are intelligently retained despite the handling of one or more infrequent queries that call for the use of a different plan.

Data management system that provides intelligent access plan caching

Methods, systems and articles of manufacture for selectively maintaining query implementation information. A user is able to set a Predictive Query Threshold which will be honored by a database system to determine for which queries information will be collected. In one embodiment, the decision about whether to collect information for a query is made before the query starts to run (i.e., before the plan is executed) by comparing the Predictive Query Threshold to some cost factor (e.g. estimated runtime). In another embodiment, each query may be monitored but the query implementation information is only selectively logged. Specifically, the determination as to whether query implementation information for a query should be logged is made after the query implementation information is collected.

Growing community of inventors

Rochester, MN, United States of America

Thomas James Schreiber