Database recovery and index rebuilds

• US 10,146,643 B2
• Filed: 05/27/2016
• Issued: 12/04/2018
• Est. Priority Date: 04/28/2015
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Fang, Min, Jin, Di, Shi, Zhen Yu, Slinger, Nigel G., Wang, Shu, Zheng, Li Fei, Zhu, Wen Jie
• Primary Examiner(s): Featherstone, Mark D
• Assistant Examiner(s): Forouharnejad, Faezeh
• Application Number:
  US15/166,390
• Publication Number:
  US 20160321145A1
• Time in Patent Office: 921 Days
• CPC Class Codes: G06F 11/1446 Point-in-time backing up or restoration of persistent data
• CPC Class Codes: G06F 11/1451 by selection of backup contents
• CPC Class Codes: G06F 11/1469 Backup restoration techniques
• CPC Class Codes: G06F 11/1471 involving logging of persistent data for recovery
• CPC Class Codes: G06F 11/1474 in transactions G06F16/20 takes precedence
• CPC Class Codes: G06F 16/2272 Management thereof
• CPC Class Codes: G06F 16/2358 Change logging, detection, and notification replication G06F16/27
• CPC Class Codes: G06F 2201/80 Database-specific techniques
• CPC Class Codes: G06F 2201/84 Using snapshots, i.e. a logical point-in-time copy of the data

Abstract

A computer-implemented method for recovering data and concurrently rebuilding indexes for the recovered data in a database for a system configured to store fewer than all indexes in backup files may include copying data from one or more database files and storing the copied data to one or more backup files. A recovery manager executing on a processor may read the copied data from the one or more backup files and write the copied data to the one or more database files, wherein the data is recovered to the one or more database files. In response to the reading, an index manager executing on the processor may initiate a rebuilding of one or more indexes for the copied data at substantially the same time as the reading of the copied data.

Claims

1. A system for recovering data and concurrently rebuilding indexes for the recovered data in a database for a system configured to store fewer than all indexes in backup files, the system comprising:

a computing device having a processor and a memory;

wherein the memory stores program instructions, the program instructions executable by the processor cause the system to;

copy data from one or more database files and store the copied data to one or more backup files;

read the copied data from the one or more backup files and write the copied data to the one or more database files, wherein the data is recovered to the one or more database files; and

initiate, in response to and at substantially the same time as the reading, a rebuilding of one or more indexes for the copied data.

2. The system of claim 1, wherein the program instructions executable by the processor to cause the system to store the copied data to one or more backup files includes storing an image copy of the data to a sparse backup file, and storing a log record of the data to a transaction log.

3. The system of claim 1, wherein the program instructions executable by the processor to cause the system to initiate, in response to the reading, a rebuilding of one or more indexes includes receiving one or more sorted index keys, and rebuilding the one or more indexes in response to the receiving of the one or more sorted index keys.

4. The system of claim 1, wherein the rebuilding of the one or more indexes finishes at substantially the same time as the writing of the copied data.

5. The system of claim 1, wherein the program instructions executable by the processor to cause the system to read the copied data from the one or more backup files includes:

reading an image copy of one or more data pages of the copied data from a sparse backup file, the reading of the image copy further comprising;

parsing the one or more data pages from the image copy into one or more database records, extracting one or more index keys from the one or more database records, and sorting the one or more index keys in preparation for initiating of the rebuilding of one or more indexes; and

reading one or more log records from a transaction log, wherein the one or more log records specify a particular point in time for recovery.

6. The system of claim 5, wherein the program instructions executable by the processor to cause the system to write the copied data to the one or more database files includes writing the image copy from the sparse backup file to the one or more database files and applying the one or more log records from the transaction log to the one or more database files.

7. The system of claim 6, wherein the reading of the image copy and the reading of the one or more log records is initiated at a first time, initiating of the rebuilding of one or more indexes occurs at a second time, and the applying of one or more log records is initiated at a third time, the third time being subsequent to the second time and the second time being subsequent to the first time.