Patent ID: 8112396
Filing Date: 2012-02-07
Classification: G06F,Y10S

Abstract:
1. A computer-implemented method of automatic backup and recovery of an integrated database system comprising first and second linked databases having different first and second database structures that store data of the first database in the second database as same data, a link file indicating the same data stored in the first database that was stored in the second database, and a catalog mapping information identifying where the same data stored in the first database is stored in the second database, the method comprising: identifying a selected set of data stored in the first database in said first database structure to be backed up; confirming from said link file that said selected set of data stored in said first database in said first database structure is also stored in the second database in said second database structure; determining from the catalog mapping information to storage locations of said selected set of data in the second database; automatically backing up to backup media said selected set of data from said first database and from said second database at the same time, and automatically backing up said link file and said catalog; upon initiation of a recovery to restore said selected set of data, restoring the selected set of data from the backup media to said first and second databases in said first and second database structures, respectively; and updating said catalog with storage locations of the restored set of data, wherein said backing up comprises backing of logs of said second database, and wherein said restoring comprises employing said logs to update the restored second database data in order to make said second database consistent.