Apparatus, system, and method for maintaining metadata for offline repositories in online databases for efficient access

• US 20070208780A1
• Filed: 03/02/2006
• Published: 09/06/2007
• Est. Priority Date: 03/02/2006
• Status: Abandoned Application

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Hannigan, Kenneth, Anglin, Matthew, Haye, Mark
• Application Number:
  US11/366,343
• Publication Number:
  US 20070208780A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 11/1448 Management of the data involved in backup or backup restore
• CPC Class Codes: G06F 11/1461 Backup scheduling policy
• CPC Class Codes: G06F 11/1469 Backup restoration techniques
• CPC Class Codes: G06F 2201/80 Database-specific techniques

Abstract

An apparatus, system, and method are disclosed for maintaining metadata for offline repositories in online databases for efficient access. In one embodiment the apparatus includes a metadata module configured to maintain metadata pertaining to one or more data record copies of a data record. At least one of the one or more data record copies is stored in an offline storage medium. The apparatus further comprises a query processor module configured to retrieve metadata pertaining to the one or more data record copies in accordance with the metadata stored in the metadata module.

Claims

1. An apparatus to manage metadata pertaining to copies of files, the apparatus comprising:

one or more copies of a data record wherein at least one of the data record copies is stored on an offline storage medium;

a metadata module configured to maintain metadata pertaining to the one or more data record copies; and

a query processor module configured to retrieve metadata pertaining to the one or more data record copies in accordance with the metadata stored in the metadata module.

2. The apparatus of claim 1, the apparatus further comprising:

a record creation module configured to notify the metadata module of record creation events; and

a record deletion module configured to notify the metadata module of record deletion events.

3. The apparatus of claim 2, wherein the metadata module is further configured to maintain metadata pertaining to one or more data records by:

incrementing a count of the number of copies of the data record in response to receiving a record creation event for a data record;

decrementing the count in response to receiving a record deletion event for the data record; and

deleting the metadata for the data record in response to decrementing the count to zero.

4. The apparatus of claim 1, wherein the metadata module is further configured to maintain metadata pertaining to one or more data records by:

tracking the one or more copies of the data record; and

deleting the metadata pertaining to the one or more data record copies in response to the deletion of the last copy of the data record.

5. The apparatus of claim 1, wherein the metadata module is further configured to prevent the deletion of the metadata pertaining to the one or more data record copies in response to the deletion of a copy of the data record that is not the last copy of the data record.

6. The apparatus of claim 1, wherein the offline storage medium is selected from the group consisting of a computer tape accessible from an automated tape library, a computer tape inaccessible from an automated tape library, a compact disc (CD), a digital video disc (DVD), an optical drive, a removable hard disk, a floppy disk, and a universal serial bus storage device.

7. The apparatus of claim 1, wherein, for each of the one or more copies of the data record, the metadata comprises:

a filename;

a creation date;

an expiration date;

a volume identifier; and

a volume location.

8. The apparatus of claim 7, further comprising a restore module configured to selectively restore the data record in response to a restoration request.

9. The apparatus of claim 8, wherein the restore module is further configured to selectively restore the data record in accordance with a specified date value.

10. A signal bearing medium tangibly embodying a program of machine-readable instructions executable by a digital processing apparatus to perform operations to retrieve data from a plurality of data repositories, the operations comprising:

maintaining an online repository of data records maintaining an offline repository of data records;

maintaining an online metadata entry associating one or more copies of a data record, wherein at least one of the one or more copies is maintained in the offline repository;

retrieving a copy of the data record in accordance with the metadata entry.

11. The signal bearing medium of claim 10, wherein the operation further comprises deleting a copy of the data record in response to a deletion request;

updating the online metadata entry to reflect the deletion of the copy; and

deleting the metadata entry in response to the deletion of the last copy of the data record.

12. The signal bearing medium of claim 10, wherein the offline repository comprises computer tape volumes.

13. The signal bearing medium of claim 10, wherein the online metadata entry for each copy of the data record comprises:

a filename;

a creation date;

an expiration date;

a volume identifier;

a volume location; and

a backup set name.

14. The signal bearing medium of claim 11, wherein the online metadata entry is stored in a metadata database.

15. A system for managing metadata pertaining to copies of files the system comprising:

a computer network;

an online storage repository connected to the computer network and configured to store an online copy of a file;

an offline storage repository configured to store storage volumes;

a storage device connected to the computer network and configured to store an offline copy of the file on a storage volume in the offline storage repository;

an online metadata database;

a metadata module configured to maintain in the online metadata database metadata pertaining to the online copy and metadata pertaining to the offline copy;

a query processor module configured to retrieve metadata from the online metadata database pertaining to the online copy and the offline copy; and

a metadata preservation module configured to prevent the deletion of metadata pertaining to the file prior to the deletion of the online copy and the offline copy.

16. The system of claim 15, the system further comprising:

a record creation module configured to notify the metadata module of record creation events; and

a record deletion module configured to notify the metadata module of record deletion events.

17. The system of claim 15, wherein the metadata module is further configured to maintain metadata pertaining to one or more data records by:

incrementing a count of the number of copies of the data record in response to receiving a record creation event for a data record;

decrementing the count in response to receiving a record deletion event for the data record; and

deleting the metadata for the data record in response to decrementing the count to zero.

18. The system of claim 15, wherein the metadata module is further configured to maintain metadata pertaining to one or more data records by:

tracking the one or more copies of the data record; and

deleting the metadata pertaining to the one or more data record copies in response to the deletion of the last copy of the data record.

19. A method for managing metadata pertaining to copies of files, the method comprising:

maintaining an online repository of data records

maintaining an offline repository of data records;

maintaining an online metadata entry associating one or more copies of a data record, wherein at least one of the one or more copies is maintained in the offline repository;

retrieving a copy of the offline data record in accordance with the online metadata entry.

20. The method of claim 19, the method further comprising preventing the deletion of the online metadata entry pertaining to the one or more data record copies in response to the deletion of a copy of the data record that is not the last copy of the data record.