Patent ID: 8639657

Claim:
A method for reorganizing table-based data objects, comprising: identifying a set of database tables containing data objects; accessing a set of scripts; and performing the reorganization operation on the set of tables on-line and in parallel using the set of scripts, the reorganization operation comprising: reading and interpreting the set of scripts and collecting information pertaining to status of said reading and interpreting; defragmenting the data objects to reclaim free space and collecting information pertaining to status of said defragmenting; sorting the data objects according to an index and collecting information pertaining to status of said sorting; eliminating overflow rows in order to improve data objects access performance and collecting information pertaining to status of said eliminating; performing runstat maintenance immediately following the performing of the reorganization operation against data objects affected by said reorganization operation; and using said collected information pertaining to status of said reading and interpreting, status of said defragmenting, status of said sorting and status of said eliminating to drive, control, manage and track the reorganization operation.