Backup and recovery of integrated linked databases
First Claim
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.
9 Assignments
0 Petitions
Accused Products
Abstract
A programmatic method for automatically backing up and restoring an integrated database system including a Lotus Notes/Domino loosely structured database and a linked DB2 relational database that stores data mapped from the Domino database. The method includes integrated first and second client application programs running on server hosts for backup and recovery of the Domino and DB2 databases that communicate with the database managers for the databases using client application APIs. Backup and recovery of the integrated linked databases is controlled by the client application associated with the Domino database.
-
Citations
19 Claims
-
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. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12)
-
-
13. A system for the automatic backup and recovery of an integrated database that comprises 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 identifying the same data that was stored in the second database, and a catalog mapping information indicating where the same data stored in the first database is stored in the second database, comprising first and second client application programs which are executable by a processor on one or more host computers associated with the first and second databases, and a server application program running on a backup server, said first client application program comprising a plurality of processes that, upon initiation, control said one or more host computers to
identify a selected set of data stored in the first database in the first database structure to be backed up; -
confirm 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 as said same data; determine from the catalog mapping information to storage locations of said selected set of data in the second database; and automatically back up to backup media the selected set of data in said first and second databases at the same time, and to automatically backup said link file and said catalog, and wherein said second client application program comprises other processes responsive to said first client application program processes that control said one or more host computers to automatically restore said selected set of data to said first and second databases in said first and second database structures, respectively, from said backup media, and to update the catalog with storage locations of the restored set of data, wherein said back up comprises backing up of logs of said second database, and wherein said restore comprises employing said logs to update the restored second database data in order to make said second database consistent. - View Dependent Claims (14, 15, 16)
-
-
17. Computer readable non-transitory storage media storing instructions executable by a computer system for performing a method of 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 that was stored in the second database, and a catalog having 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 the first database structure to be backed up; -
automatically confirming from said link file that said selected set of data stored in the first database is also stored in the second database in said second database structure; automatically 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 and second databases at the same time, and automatically backing up said link file, and said catalog; and upon initiation of a recovery to restore data, restoring the selected set of data from the backup media to said 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. - View Dependent Claims (18, 19)
-
Specification