Patent ID: 8315987

Claim:
A computer-readable non-transitory medium having recorded thereon a database management program for causing a computer to execute: a setting process of receiving a snapshot request requesting that a record in a database on a recording medium at a designated point in time be extracted and saved to another area, and recording information indicating an extraction range of data to be extracted in the recording medium to a memory; an extraction process of sequentially extracting records inside the extraction range, and recording the extracted records to the other area; a monitoring process of recording information indicating an extraction-completed area with respect to which record extraction in the extraction range in the extraction process has been completed and an extraction-remaining area with respect to which record extraction in the extraction range has yet to be performed to the memory on a timely basis; a subsequent update process of judging, in a case where an instruction to update a record inside the extraction range by a subsequent transaction started after the designated point in time is received during the extraction process, whether the record targeted by the update instruction is in the extraction-completed area or in the extraction-remaining area with reference to the memory, and, if the update target record is in the extraction-completed area, updating the update target record in the extraction-completed area, and, if the update target record is in the extraction-remaining area, recording a map of the update target record in the extraction-remaining area to an area outside the extraction range and updating the map; and a restore process of updating the update target record inside the extraction range to be the same as the map recorded and updated outside the extraction range, after the update target record inside the extraction range has been extracted in the extraction process.