Patent ID: 7447681
Filing Date: 2008-11-04
Classification: G06F,Y10S

Abstract:
1. A method of configuring a database based on a database workload having a performance metric, the method comprising: selecting a plurality of different database characteristics based upon the database workload, each of the different database characteristics having an associated estimated performance metric for the database workload, wherein the selecting the plurality of different data base characteristics includes determining degrees of interdependencies between the different database characteristics, and determining, based on the degrees of interdependencies, the different database characteristics are searched in an integrated manner in groups with other different database characteristics, and the different database characteristics are searched in groups of one database characteristic separately from the other different database characteristics, and including defining different ones of the degrees of interdependencies as strong dependencies and weak dependencies, wherein the database characteristics that have the strong dependencies are provided in the groups having searching performed in an integrated manner, and the database characteristics that have the weak dependencies are provided in the groups having searching performed separately; selecting a set of candidate database characteristics from the plurality of different database characteristics for which the associated estimated performance metric is lower than the database workload performance metric, wherein the set of candidate database characteristics is selected by searching each of the groups of database characteristics in an order such that groups are searched taking into consideration candidate database characteristics selected in groups searched previously in the order; and configuring the database using the selected set of candidate database characteristics.