Patent ID: 9239871
Filing Date: 2016-01-19
CPC Classification: G06F

Claim Text:
1. A computer-implemented method of determining sequential access efficiency for a database table, the method executed by a processor to perform a plurality of operations, the operations comprising: determining a sequential access of a plurality of rows of a database table, wherein the plurality of rows are stored using a plurality of data blocks, and wherein the sequential access occurs when a portion of the database table is accessed; determining a number of data block changes that occur during the sequential access of the plurality of rows in the database table, 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, different from the first data block, such that accessing the next row after accessing the current row results in the data block change; and calculating a sequential access efficiency based on the determined number of data block changes, wherein calculating the sequential access efficiency is performed using the following equation: wherein N