User restoration of workflow objects and elements from an archived database

• US 8,818,961 B1
• Filed: 10/30/2009
• Issued: 08/26/2014
• Est. Priority Date: 10/30/2009
• Status: Active Grant

• Current Assignee: Veritas Technologies, LLC (Whitehouse Group Ltd.)
• Original Assignee: Symantec Corporation (NortonLifeLock Inc.)
• Inventors: Beatty, Louis, DeVos, Steven R.
• Primary Examiner(s): GEBRESENBET, DINKU W
• Application Number:
  US12/610,246
• Time in Patent Office: 1,761 Days
• US Class Current: 707/685
• CPC Class Codes: G06F 16/211 Schema design and management

Abstract

A system and method for restoring data including a workflow from an archived copy of a database file. The method includes receiving a request to restore a workflow from an archived copy. The workflow comprises attributes describing a sequence of conditions and actions corresponding to an item and comprises a history log. The item may comprise an electronic document and associated context information describing the document in an intranet portal application environment. The associated context information includes an identifier corresponding to the workflow. The method includes retrieving records comprising the workflow attributes from the archived copy. The method further includes generating from the retrieved records a workflow metadata file comprising tagged elements corresponding to the workflow attributes and history log. Then the method stores the workflow metadata file in a file system. The method further includes restoring the workflow to the intranet portal application via the file system.

Claims

1. A computer implemented method comprising:

performing a backup of a database file by generating a schema of table and index information along with backup contents of the database file and storing the generated schema in association with a backup copy of the database file;

receiving a request to restore a workflow from an unmounted backup copy of a database file, wherein the backup copy of the database file is a single monolithic database file;

responsive to receiving the request to restore the workflow from the unmounted backup copy of the database file;

locating a workflow attributes table;

retrieving one or more records comprising attributes of the workflow from the backup copy of the database file, wherein the one or more records are retrieved without mounting the backup copy of the database file and wherein the schema is used to identify and retrieve the workflow without accessing a mounted database file; and

restoring the workflow to a file system without restoring the backup copy of the database file.

2. The method as recited in claim 1, wherein the backup copy of the database file comprises a plurality of tables, and wherein the plurality of tables includes a workflow attributes table and a workflow history table.

3. The method as recited in claim 2, further comprising:

generating a first key to identify the workflow of the restore request;

locating a first value in a first record stored in a first table, wherein the first value matches the first key;

using the first value to query the workflow attributes table to locate one or more second records corresponding to the workflow; and

using the first value to query the workflow history table to locate one or more third records corresponding to the workflow.

4. The method as recited in claim 1, further comprising:

using the one or more second records and one or more third records to generate a workflow metadata file; and

using the workflow metadata file to update one or more files corresponding to the workflow.

5. The method as recited in claim 3, wherein the first table is a document table.

6. A computer system comprising:

a processor; and

a memory storing program instructions executable by the processor to;

perform a backup of a database file by generating a schema of table and index information along with backup contents of the database file and storing the generated schema in association with the backup copy of the database file;

receive a request to restore a workflow from an unmounted backup copy of a database file, wherein the backup copy of the database file is a single monolithic database file;

responsive to receiving the request to restore the workflow from the unmounted backup copy of the database file;

locate a workflow attributes table;

retrieve one or more records comprising attributes of the workflow from the backup copy of the database file, wherein the one or more records are retrieved without mounting the backup copy of the database file and wherein the schema is used to identify and retrieve the workflow without accessing a mounted database file; and

restore the workflow to a file system without restoring the backup copy of the database file.

7. The computer system of claim 6, wherein the backup copy of the database file comprises a plurality of tables, and wherein the plurality of tables includes a workflow attributes table and a workflow history table.

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

generate a first key to identify the workflow of the restore request;

locate a first value in a first record stored in a first table, wherein the first value matches the first key;

use the first value to query the workflow attributes table to locate one or more second records corresponding to the workflow; and

use the first value to query the workflow history table to locate one or more third records corresponding to the workflow.

9. The computer system of claim 6, wherein the program instructions are further executable to:

use the one or more second records and one or more third records to generate a workflow metadata file; and

use the workflow metadata file to update one or more files corresponding to the workflow.

10. The computer system of claim 8, wherein the first table is a document table.

11. A non-transitory computer-readable storage medium storing program instructions that are executable to:

perform a backup of a database file by generating a schema of table and index information along with backup contents of a database file and storing the generated schema in association with the backup copy of the database file;

receive a request to restore a workflow from an unmounted backup copy of a database file, wherein the backup copy of the database file is a single monolithic database file;

responsive to receiving the request to restore the workflow from the unmounted backup copy of the database file;

locate a workflow attributes table;

retrieve one or more records comprising attributes of the workflow from the backup copy of the database file, wherein the one or more records are retrieved without mounting the backup copy of the database file and wherein the schema is used to identify and retrieve the workflow without accessing a mounted database file; and

restore the workflow to a file system without restoring the backup copy of the database file.

12. The non-transitory computer-readable storage medium of claim 11, wherein the backup copy of the database file comprises a plurality of tables, and wherein the plurality of tables includes a workflow attributes table and a workflow history table.