Method for restoring documents from a database file
View Patent ↗Various embodiments of a method and system for accessing an instance of a database file previously created by a secured RDBMS are disclosed. The secured RDBMS is not used to reconstruct tables and records from an unmounted backed up copy of a database file. During backup, a schema file including table and index information is stored along with the database file. During a subsequent restore operation, the schema file may be read for efficiently reconstructing objects from the database file, without having to reload or reinstall the secured RDBMS. For restoring or comparing objects from the backed up database file, a stored procedure in the secured RDBMS may be called.
1. A method for restoring data, said method comprising:
a computer system receiving a request to restore one or more data objects from an unmounted relational database file that is a backup copy of a mounted relational database file of a secured relation database management system (RDBMS);
the computer system retrieving a previously stored schema corresponding to a data structure of said unmounted relational database file;
the computer system using said schema to retrieve said one or more data objects from said unmounted relational database file, wherein said one or more data objects are retrieved without mounting the unmounted relational database file, and wherein said using includes:
the computer system using said schema to access said unmounted relational database file, wherein said schema includes information describing a user-defined table stored in said unmounted relational database file;
the computer system reconstructing the user-defined table including one or more records associated with the user-defined table, wherein said one or more reconstructed records respectively correspond to data objects stored in said unmounted relational database file;
the computer system selecting one or more reconstructed records from said reconstructed user-defined table wherein said selected one or more reconstructed records correspond to said one or more data objects to be retrieved from said unmounted relational database file;
the computer system initiating retrieval of said one or more data objects to be retrieved from said unmounted relational database file; and
the computer system providing said retrieved one or more data objects to said secured RDBMS.
2. The method of claim 1 , i further comprising:
the computer system creating the backup copy of the mounted relational database file prior to receiving the request to restore said one or more data objects, wherein said creating includes:
the computer system querying a data structure of said mounted relational database file from said secured RDBMS;
the computer system backing up said mounted relational database file to said unmounted relational database file; and
the computer system storing said data structure of said mounted relational database file in said schema.
3. The method of claim 1 , wherein said providing said retrieved one or more data objects to said secured RDBMS includes:
the computer system transferring said retrieved one or more data objects to said secured RDBMS, wherein said retrieved one or more data objects are added to said mounted relational database file.
4. The method of claim 3 , wherein said transferring is performed as a continuous buffered operation, wherein said retrieved one or more data objects are reconstructed at the secured RDBMS.
5. The method of claim 1 , wherein said providing said retrieved one or more data objects to said secured RDBMS includes:
the computer system transferring said retrieved one or more data objects to said secured RDBMS, wherein said retrieved one or more data objects are compared to corresponding data objects in said mounted relational database file.
6. The method of claim 1 , wherein at least one of said one or more data objects corresponds to an electronic document.
7. The method of claim 6 , wherein said secured RDBMS is configured as a document management system.
8. The method of claim 7 , wherein said document management system includes an intranet portal for accessing documents.
9. A computer-readable memory medium including program instructions executable by a computer system to:
receive a request to restore one or more data objects from an unmounted relational database file that is a backup copy of a mounted relational database file of a secured relation database management system (RDBMS);
retrieve a previously stored schema corresponding to a data structure of said unmounted relational database file;
use said schema to retrieve said one or more data objects from said unmounted relational database file without mounting the unmounted relational database file, wherein using said schema includes:
using said schema to access said unmounted relational database file, wherein said schema includes information describing a user-defined table stored in said unmounted relational database file;
reconstructing the user-defined table including one or more records associated with the user-defined table wherein said one or more reconstructed records respectively correspond to data objects stored in said unmounted relational database file;
selecting one or more reconstructed records from said reconstructed user-defined table wherein said one or more selected reconstructed records correspond to said one or more data objects to be retrieved from said unmounted relational database file; and
initiating retrieval of said one or more data objects to be retrieved from said unmounted relational database file; and
provide said retrieved one or more data objects to said secured RDBMS.
10. The memory medium of claim 9 , including program instructions executable to:
create the backup copy of the mounted relational database file prior to receiving the request to restore said one or more data objects, wherein the program instructions executable to create the backup copy are executable to:
query a data structure of said mounted relational database file from said secured RDBMS;
backup said mounted relational database file to said unmounted relational database file; and
store said data structure of said mounted relational database file in said schema.
11. The memory medium of claim 9 , wherein said program instructions executable to provide said retrieved one or more data objects to said secured RDBMS include program instructions executable to:
transfer said retrieved one or more data objects to said secured RDBMS, wherein said retrieved one or more data objects are added to said mounted relational database file.
12. The memory medium of claim 11 , wherein transferring said retrieved one or more data objects is performed as a continuous buffered operation, wherein said retrieved one or more data objects are reconstructed at the secured RDBMS.
13. The memory medium of claim 9 , wherein said program instructions executable to provide said retrieved one or more data objects to said secured RDBMS include program instructions executable to:
transfer said retrieved one or more data objects to said secured RDBMS, wherein said retrieved one or more data objects are compared to corresponding data objects in said mounted relational database file.
14. The memory medium of claim 9 , wherein at least one of said one or more data objects corresponds to an electronic document, wherein said secured RDBMS is configured as a document management system.
15. The memory medium of claim 14 , wherein said document management system includes an intranet portal for accessing documents.
16. A computer system comprising
a processor; and
a memory storing program instructions executable by the computer system to:
receive a request to restore one or more data objects from an unmounted relational database file that is a backup copy of a mounted relational database file of a secured relation database management system (RDBMS);
retrieve a previously stored schema corresponding to a data structure of said unmounted relational database file;
use said schema to retrieve said one or more data objects from said unmounted relational database file, wherein said one or more data objects are retrieved without mounting the unmounted relational database file, and wherein using said schema includes:
using said schema to access said unmounted relational database file, wherein said schema includes information describing a user-defined table stored in said unmounted relational database file;
reconstructing the user-defined table including one or more records associated with the user-defined table wherein said one or more reconstructed records respectively correspond to data objects stored in said unmounted relational database file;
selecting one or more reconstructed records from said reconstructed user-defined table, wherein said selected one or more reconstructed records correspond to said one or more data objects to be retrieved from said unmounted relational database file;
initiating retrieval of said one or more data objects to be retrieved from said unmounted relational database file; and
provide said retrieved one or more data objects to said secured RDBMS.