APPARATUS AND SYSTEM FOR REORGANIZING A SET OF DATABASE PARTITIONS
First Claim
1. An apparatus for reorganizing a set of database partitions for a client, the apparatus 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; and
a reorganization module that reorganizes a subset of database partitions in the ranked set of database partitions that satisfy the dynamic reorganization threshold wherein the subset is defined at least in part by a rank order for the ranked set of database partitions.
0 Assignments
0 Petitions
Accused Products
Abstract
An apparatus and system are disclosed for reorganizing a set of database partitions based on a ranked set of database partitions. The apparatus includes an evaluation module to determine a fragmentation indicator for each database partition within a set of database partitions. A ranking module ranks the set of database partitions according to a rank criteria. The rank criteria includes, at a minimum, the fragmentation indicator. A reorganization module reorganizes a subset of the database partitions in the ranked set of database partitions. The subset is selected, at least in part, by a rank order for the ranked set of database partitions. The subset may be selected such that ranked database partitions satisfying a dynamic reorganization threshold are included in the subset.
27 Citations
20 Claims
-
1. An apparatus for reorganizing a set of database partitions for a client, the apparatus 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; and a reorganization module that reorganizes a subset of database partitions in the ranked set of database partitions that satisfy the dynamic reorganization threshold wherein the subset is defined at least in part by a rank order for the ranked set of database partitions. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9)
-
-
10. A system for reorganizing a set of database partitions for a client, the system comprising:
-
a processor; one or more storage devices storing a database comprising a set of database partitions; one or more Input/Output (I/O) devices; a memory; 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; and a reorganization module that reorganizes a subset of database partitions in the ranked set of database partitions that satisfy the dynamic reorganization threshold; and a communication bus, the communication bus operatively coupling the processor, the one or more storage devices, the one or more I/O devices, and memory. - View Dependent Claims (11, 12, 13)
-
-
14. A computer program product tangibly embodying a program of machine-readable instructions executable by a digital processing apparatus to perform operations to reorganize a set of Data Entry Data Base (DEDB) Units of Work (UOWs), the operations comprising:
-
determining a fragmentation indicator for each DEDB UOW within a set of DEDB UOWs and to evaluate a fragmentation function for each DEDB UOW within the set of DEDB UOWs; ranking the DEDB UOWs according to a rank criteria comprising at least the fragmentation indicator; defining a subset of DEDB UOWs, the DEDB UOWs satisfying a dynamic reorganization threshold; recalculating the subset of DEDB UOWs in response to a user changing the dynamic reorganization threshold, the dynamic reorganization threshold changed in response to a user adjusting a threshold indicator by way of a user interface; displaying by way of a user interface one or more indicators representing DEDB UOWs that are members of the recalculated subset of DEDB UOWs in response to the user adjusting the threshold indicator by way of the user interface, and displaying updated resource requirements based on the recalculated subset of DEDB UOWs; and reorganizing the subset of the DEDB UOWs in the ranked set of DEDB UOWs wherein the subset is defined at least in part by a rank order for the ranked set of DEDB UOWs. - View Dependent Claims (15, 16, 17, 18, 19, 20)
-
Specification