Method for restoring data from a monolithic backup

• US 8,386,438 B2
• Filed: 03/19/2009
• Issued: 02/26/2013
• Est. Priority Date: 03/19/2009
• Status: Active Grant

• Current Assignee: Veritas Technologies, LLC (Whitehouse Group Ltd.)
• Original Assignee: Symantec Corporation (NortonLifeLock Inc.)
• Inventors: Beatty, Louis, DeVos, Steven R., Saraf, Deepak
• Primary Examiner(s): Breene, John E
• Assistant Examiner(s): Bullock, Joshua
• Application Number:
  US12/407,630
• Publication Number:
  US 20100241618A1
• Time in Patent Office: 1,440 Days
• Field of Search: 707/679, 707/667, 707/803
• US Class Current: 707/667
• CPC Class Codes: G06F 11/1464 for networked environments
• CPC Class Codes: G06F 11/1469 Backup restoration techniques

Abstract

A computer system and methods for restoring data from a copy of a database file. The method includes receiving a request to restore an item from the copy of the database file. The item includes a file and associated context information describing the file in a first intranet portal application environment. The method further includes retrieving a schema including the item from the copy of the database file and generating an item file comprising a copy of the file. The item file is independent of the context information. The method further includes generating a metadata file based on the context information, associating the metadata file with the item file, storing the item file and associated metadata file in a file system, and restoring the item to a second intranet portal application or to a third application via the file system.

Claims

1. A method for restoring data from an archived copy of a database file, the method comprising:

receiving a request to restore an item from the archived copy of the database file, the database file being a single monolithic database file, wherein the item comprises a file and associated context information describing the file in a first intranet portal application environment;

retrieving a schema from the archived copy of the database file, wherein the schema represents a data structure of the database file that includes the item and allows access or restoration of selected items of the archived copy of the database file without use of a database;

generating an item file and associated metadata file from the retrieved schema, wherein the item file comprises a copy of the file and is independent of the context information, and wherein the metadata file is based on the context information;

storing the item file and the associated metadata file in a file system; and

restoring the item to a second intranet portal application via the file system.

2. The method of claim 1, wherein the database file is a single monolithic archived copy, and wherein the first and second intranet portal applications are a same intranet portal application.

3. The method of claim 1, further comprising redirecting the file to a third application directly through the file system without accessing the context information, wherein the third application is different from the first and the second intranet portal applications.

4. The method of claim 1, wherein the context information comprises one or more file attributes and wherein for each of the one or more file attributes, the metadata file includes a corresponding tagged element.

5. The method of claim 4, wherein generating the associated metadata file from the retrieved schema comprises generating Collaborative Application Markup Language, and wherein elements in the metadata file are tagged with tags conforming to the Collaborative Application Markup Language.

6. The method of claim 1, further comprising:

receiving a request to restore a list comprising two or more items from the archived copy of the database file, wherein each item in the list comprises a file of a same file type and associated context information describing the file in a first intranet portal application environment;

retrieving a list schema from the archived copy of the database file, wherein the list schema includes the two or more items;

for each item in the list;

generating an item file and associated metadata file from the retrieved list schema, wherein the item file comprises a copy of the file and is independent of the context information, and wherein the metadata file is based on the context information; and

storing the item file and the associated metadata file in a file system; and

restoring the list to a second intranet portal application via the file system.

7. The method of claim 1, wherein the schema comprises information describing a plurality of tables in a row and column arrangement and indexes within the database file, wherein each table comprises one or more associated records within the database file, and wherein one or more records include an index that points to another record in another table.

8. A computer system comprising

a processor;

and

a memory storing program instructions for restoring data from an archived copy of a database file, the database file being a single monolithic database file, including program instructions executable by the processor to;

receive a request to restore an item from the archived copy of the database file, wherein the item comprises a file and associated context information describing the file in a first intranet portal application environment;

retrieve a schema from the archived copy of the database file, wherein the schema represents a data structure of the database file that includes the item and allows access or restoration of selected items of the archived copy of the database file without use of a database;

generate an item file and associated metadata file from the retrieved schema, wherein the item file comprises a copy of the file and is independent of the context information, and wherein the metadata file is based on the context information;

store the item file and the associated metadata file in a file system;

and

restore the item to a second intranet portal application via the file system.

9. The computer system of claim 8, wherein the database file is a single monolithic archived copy, and wherein the first and second intranet portal applications are a same intranet portal application.

10. The computer system of claim 8, wherein the program instructions are further executable by the processor to redirect the file to a third application directly through the file system without accessing the context information, wherein the third application is different from the first and the second intranet portal applications.

11. The computer system of claim 8, wherein the context information comprises one or more file attributes and wherein for each of the one or more file attributes, the metadata file includes a corresponding tagged element.

12. The computer system of claim 11, wherein generating the associated metadata file from the retrieved schema comprises generating Collaborative Application Markup Language, and wherein elements in the metadata file are tagged with tags conforming to the Collaborative Application Markup Language (CAML).

13. The computer system of claim 8, wherein the program instructions are further executable by the processor to:

receive a request to restore a list comprising two or more items from the archived copy of the database file, wherein each item in the list comprises a file of a same file type and associated context information describing the file in a firsts intranet portal application environment;

retrieve a list schema from the archived copy of the database file, wherein the list schema includes the two or more items;

for each item in the list;

generate an item file and associated metadata file from the retrieved list schema, wherein the item file comprises a copy of the file and is independent of the context information, and wherein the metadata file is based on the context information;

and

store the item file and the associated metadata file in a file system;

and

restore the list to a second intranet portal application via the file system.

14. The computer system of claim 8, wherein the item comprises an electronic document.

15. A non-transitory computer-readable storage medium storing program instructions for restoring data from an archived copy of a database file, the storage medium including program instructions executable by a processor to:

receive a request to restore an item from the archived copy of the database file, the database file being a single monolithic database file, wherein the item comprises a file and associated context information describing the file in a first intranet portal application environment;

retrieve a schema from the archived copy of the database file, wherein the schema represents a data structure of the database file that includes the item and allows access or restoration of selected items of the archived copy of the database file without use of a database;

generate an item file and associated metadata file from the retrieved schema, wherein the item file comprises a copy of the file and is independent of the context information, and wherein the metadata file is based on the context information;

store the item file and the associated metadata file in a file system;

and

restore the item to a second intranet portal application via the file system.

16. The non-transitory computer-readable storage medium of claim 15, wherein the database file is a single monolithic archived copy, and wherein the first and second intranet portal applications are a same intranet portal application.

17. The non-transitory computer-readable storage medium of claim 15, wherein the program instructions are further executable by the processor to redirect the file to a third application directly through the file system without accessing the context information, wherein the third application is different from the first and the second intranet portal applications.

18. The non-transitory computer-readable storage medium of claim 15, wherein the context information comprises one or more file attributes and wherein for each of the one or more file attributes, the metadata file includes a corresponding tagged element.

19. The non-transitory computer-readable storage medium of claim 18, wherein generating the associated metadata file from the retrieved schema comprises generating Collaborative Application Markup Language, and wherein elements in the metadata file are tagged with tags conforming to the Collaborative Application Markup Language (CAML).

20. The non-transitory computer-readable storage medium of claim 15, wherein the program instructions are further executable by the processor to:

receive a request to restore a list comprising two or more items from the archived copy of the database file, wherein each item in the list comprises a file of a same file type and associated context information describing the file in a firsts intranet portal application environment;

retrieve a list schema from the archived copy of the database file, wherein the list schema includes the two or more items;

for each item in the list;

generate an item file and associated metadata file from the retrieved list schema, wherein the item file comprises a copy of the file and is independent of the context information, and wherein the metadata file is based on the context information;

and

store the item file and the associated metadata file in a file system;

and

restore the list to a second intranet portal application via the file system.