Method and means for backup and restoration of a database system linked to a system for filing data

• US 6,453,325 B1
• Filed: 02/03/1997
• Issued: 09/17/2002
• Est. Priority Date: 05/24/1995
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Cabrera, Luis Felipe, Narang, Inderpal Singh, Mohan, Chandrasekaran
• Primary Examiner(s): Coby, Frantz
• Application Number:
  US08/794,691
• Time in Patent Office: 2,052 Days
• Field of Search: 707/204, 707/200, 707/201, 707/202, 707/203, 395/182.13, 395/575, 395/400, 395/425, 395/404, 364/200, 364/900, 379/265
• US Class Current: 1/1
• CPC Class Codes: G06F 11/1461 Backup scheduling policy
• CPC Class Codes: G06F 2201/80 Database-specific techniques
• CPC Class Codes: Y10S 707/99952 Coherency, e.g. same view to multiple users
• CPC Class Codes: Y10S 707/99953 Recoverability
• CPC Class Codes: Y10S 707/99955 Archiving or backup

Abstract

In a database system with linkage between data in the database system and files in a system for filing data which is external to the database system (“the filing system”), backup and restoration of the database are coordinated with the filing system. Backup of a referenced file is initiated when the file is linked to the database system. The file backup is asynchronous to the linking process. When database backup occurs, all unfinished file backups are accelerated and completed before the database backup is declared successful. When a database is restored to a state with reference to files in a file manager, the database system causes the file manager to ensure that referenced files are linked to the database system.

Claims

1. A method of restoring a database system having references to files stored in at least one file system external to the database system, comprising the steps of:

placing in the database a reference to a file in the file system;

making a record in the file system of the reference, the record initially indicating the existence of the reference, the records being changed to indicate deletion of the reference if the reference is deleted from the database system;

initiating a restoration of database contents that existed at a time of database system operation (restore time); and

(a) if the reference is placed in the database system prior to the restore time and the record indicates that the reference was deleted, changing the reference to indicate that the reference exists;

or

(b) if the reference was placed in the database system subsequent to the restore time and the record indicates that the reference exists, changing the record to indicate that the reference is deleted.

2. The method of claim 1, the record including a recovery time having a value corresponding to a time when the reference was placed in the database system, step 10(a) being performed if the recovery time is earlier than the restoration time.

3. The method of claim 2, step 10(b) being performed if the recovery time is later than, or equal to, the restored time.

4. The method of claim 1, wherein the step of initiating includes providing to the file system a list of references to files in the file system that exist in the restored database contents and step 10(a) is performed if a reference to the file is in the list.

5. The method of claim 4, wherein step 10(b) is performed if no reference to the file is in the list.

6. The method of claim 1, further including the steps of:

determining that either step 10(a) or 10(b) cannot be performed;

providing to the database system an indication that either step 10(a) or step 10(b) cannot be performed; and

removing the references from the restored database contents.

7. A method performed in a file system to reconcile file data indicating references made in the contents of a database system to files in the file system, the method comprising the steps of:

making a record in the file system of a reference made in the contents of a database system to a file in the file system, the record initially indicating the existence of the reference in the database system, the record being changed to indicate deletion of the reference if the reference is deleted from the database system;

receiving an indication from the database system of the restoration of a database system with database contents that existed at a time of database system operation (restore time); and

(a) if the reference was placed in the database system prior to the restore time and the record indicates that the reference was deleted, changing the reference to indicate that the reference exists;

or

(b) if the reference was placed in the database system subsequent to the restore time and the record indicates that the reference exists, changing the reference to indicate that the reference is deleted.

8. The method of claim 7, the record including a recovery time having a value corresponding to a time when the reference was placed in the database system, step 16(a) being performed if the recovery time is earlier than the restore time.

9. The method of claim 8, step 16(b) being performed if the recovery time is later than, or equal to, the restore time.

10. The method claim 7, wherein the step of receiving an indication includes receiving from the database system a list of references to files in the file system that exist in the restored database contents, and step 16(a) is performed if a reference to the file is in the list.

11. The method of claim 10, wherein step 16(b) is performed if no reference to the file is in the list.