Relaxation-based approach to automatic physical database tuning
AssigneeMicrosoft Corporation
InventorsNicolas Bruno, Surajit Chaudhuri
Life of this patent
Estimating the term…
Abstract
A system that facilitates automatic selection of a physical configuration of a database comprises an optimizer component that determines simulated physical structures and creates a hypothetical configuration based thereon. A reduction component progressively reduces size of the configuration until the hypothetical configuration is associated with a size below a threshold. For example, the simulated physical structures can be based at least in part upon a workload.
Claims20
A system that facilitates automatic selection of a physical configuration of a database, comprising:
- an optimizer component that determines simulated physical structures and creates a hypothetical configuration based thereon;
- and
- a reduction component that progressively reduces size of the hypothetical configuration until the hypothetical configuration is associated with a size below a threshold.
A method for automatically tuning a database, comprising:
- generating a configuration based upon a received workload;
- and
- selectively relaxing the configuration until size of the configuration is below a threshold size.
A computer-implemented database tuning system, comprising:
- means for generating an optimal configuration with respect to a workload;
- and
- means for relaxing the configuration to cause a resulting configuration to be within a space constraint.
Dependencies are inferred from the claim text.