Method and apparatus for restoring a portion of a database

A computer program product comprising a computer useable medium having computer readable program code embodied therein for recovering at least a portion of a database comprising at least one table, the computer program product comprising:

• computer readable program code devices configured to cause a computer to receive at least one identifier corresponding to at the least one table;
• computer readable program code devices configured to cause a computer to identify at least one first file having an identifier and corresponding to the at least one identifier received;
• computer readable program code devices configured to cause a computer to add less than all of at least one of the first files identified into a second file;
• and
• computer readable program code devices configured to cause a computer to copy at least one the at least one file identifiers into a third file.

An apparatus for recovering at least one table of a database, the apparatus comprising:

• a related files identifier module, having an first input operatively coupled to receive a name of the at least one table, the related files identifier module for identifying and providing at an output at least one name of at least one file, at least one of the at least one file comprising at least one of the at least one table;
• a working storage;
• a file restorer module coupled to the working storage and having a first input coupled to the related files identifier module output for receiving the at least one name, the file restorer module for restoring into the working storage coupled to an output at least one file corresponding to the name received at the file restorer module input and at least one first data dictionary;
• a data dictionary splicer module having an input operatively coupled to receive a portion comprising less than all of a second data dictionary corresponding to the at least one table, the data dictionary splicer for replacing less than all of the first data dictionary with the portion received at the data dictionary splicer output.