Patent ID: 9424286
Filing Date: 2016-08-23
CPC Classification: G06F

Claim Text:
1. In a computing environment, a method of managing database recovery time, the method comprising: receiving user input specifying a target recovery time for a database; determining a number of dirty pages that presently would be read in recovery if a database failure occurred, the number of dirty pages reflecting a count of each dirty page that presently would be read in recovery, wherein each data page is identified by a pageID, an indication of whether or not it is a dirty page, and a page log sequence number (pageLSN) corresponding to a log entry corresponding to a most recent change to the each data page; determining a number of log records that would be processed in recovery if a database failure occurred; adjusting at least one of the number of dirty pages that presently would be read in recovery or the number of log records that would be processed in recovery according to the specified target recovery time; and wherein adjusting at least one of the number of dirty pages that presently would be read in recovery or the number of log records that would be processed in recovery according to the specified target recovery time is based on a contiguity factor, wherein the contiguity factor is based on database growth size which determines a quantity of data pages that can be read from persistent storage in a sequential read fashion.