Patent ID: 9230008
Filing Date: 2016-01-05
CPC Classification: G06F

Claim Text:
1. A computer-implemented method for reorganizing data records of a database, comprising: receiving, by a processor of a server, 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, determining, by the server, a number of data block changes that occur during a sequential access of the group of rows; determining, by the server, 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, wherein the efficiency is calculated based on a number of buffers used while sequentially accessing the database table, and wherein the data block change is not counted in determining the efficiency if the second data block being accessed is already present in one of the number of buffers; comparing, by the server, the determined efficiency and the efficiency parameter; determining, by the server, whether the determined efficiency is satisfactory based on the comparison; and generating, by the server, 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.