System and Method for Automated Online Reorganization of Sequential Access Databases

A computer-implemented system for reorganizing data records of a database, comprising:

• a server comprising a processor configured to:
• receive an efficiency parameter that indicates a satisfactory level of organizational efficiency of at least a portion of a database table having a group of rows stored using a plurality of data blocks,
• wherein a level of organizational efficiency is based on a number of data block changes that occur while sequentially accessing the database table, and
• wherein a data block change occurs when a current row is stored in a first data block and a next row is stored in a second data block that is different from the first data block such that accessing the next row after accessing the current row results in the data block change;
• determine a number of data block changes that occur during a sequential access of the group of rows;
• determine an efficiency associated with the group of rows based on the determined number of data block changes that occur during the sequential access of the group of rows;
• compare the determined efficiency and the efficiency parameter;
• determine whether the determined efficiency is satisfactory based on the comparison;
• and
• generate a control card to reorganize the group of rows when the efficiency is not satisfactory, the control card causing a reorganization of the group of rows.

A non-transitory computer-readable storage medium having one or more computer-readable instructions thereon which when executed by a processor cause the processor to:

• receive an efficiency parameter that indicates a satisfactory level of organizational efficiency of at least a portion of a database table having a group of rows stored using a plurality of data blocks,
• wherein a level of organizational efficiency is based on a number of data block changes that occur while sequentially accessing the database table, and wherein a data block change occurs when a current row is stored in a first data block and a next row is stored in a second data block that is different from the first data block such that accessing the next row after accessing the current row results in the data block change;
• determine a number of data block changes that occur during a sequential access of the group of rows;
• determine an efficiency associated with the group of rows based on the determined number of data block changes that occur during the sequential access of the group of rows;
• compare the determined efficiency and the efficiency parameter;
• determine whether the determined efficiency is satisfactory based on the comparison;
• and
• generate a control card to reorganize the group of rows when the efficiency is not satisfactory, the control card causing a reorganization of the group of rows.