Method for reorganizing a set of database partitions

A method for reorganizing a set of database partitions for a client, the method comprising:

• providing a reorganization utility comprising;
• an evaluation module that determines a fragmentation indicator for each database partition within a set of database partitions;
• a ranking module that ranks the database partitions according to a rank criteria comprising at least the fragmentation indicator;
• a presentation module that presents the ranked set of database partitions to a user for evaluation, the presentation module displaying by way of a user interface one or more indicators representing database partitions that are members of a recalculated subset of database partitions, in response to the user adjusting a threshold indicator by way of the user interface, the user interface displaying updated resource requirements based on the recalculated subset of database partitions;
• an input module that prompts the user for a dynamic reorganization threshold in response to the evaluation, the dynamic reorganization threshold defining a subset of database partitions, the subset of database partitions dynamically recalculated in response to a user changing the dynamic reorganization threshold, the dynamic reorganization threshold changed in response to a user adjusting the threshold indicator by way of the user interface;
• a reorganization module that reorganizes a subset of database partitions in the ranked set of database partitions that satisfy the dynamic reorganization threshold;
• executing the reorganization utility against a set of database partitions;
• evaluating a ranked set of database partitions provided by the reorganization utility;
• and
• providing the dynamic reorganization threshold to the reorganization utility in response to the evaluation, such that the reorganization utility reorganizes the subset of database partitions of the ranked set of database partitions.