User restoration of workflow objects and elements from an archived database

摘要

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.

主权项

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; andrestoring the workflow to a file system without restoring the backup copy of the database file.