Patent ID: 6834290
Filing Date: 2004-12-21
Classification: G06F,Y10S

Abstract:
A method of developing a plan to reorganize a tablespace that increases the benefit derived from the reorganization while decreasing the cost associated with the reorganization, the method comprising:determining an object benefit for each of multiple objects of a tablespace, each object benefit being based at least in Dart upon a free space distribution within the tablespace associated with the reorganization of one of the multiple objects, wherein the object benefit for each of the multiple objects comprises a measurement of the reorganization need associated with each object, wherein the reorganization need includes a measurement of wasted space, and wherein the measurement of wasted space includes a measurement of the actual data within each object that is calculated according to DS1-PF100;determining an object cost for each of the multiple objects, each object cost being based at least in part upon the size of one of the multiple objects; for each object, generating a benefit-cost indicator which accounts for the object benefit and the object cost associated with the reorganization of the object; and developing a plan for reorganizing the tablespace based on at least the benefit-cost indicator.