System to automate schema creation for table restore
First Claim
Patent Images
1. A method comprising:
- copying all table metadata, including table name and table identifier data, to a header of a backup storage media during a backup process of a database;
restoring a select base table from said backup storage media, comprising;
creating an empty copy of a catalog table associated with a select base table;
creating an empty copy of said select base table; and
reading said header from said storage media housing said backup of said database, including extracting table identifier metadata from said header;
identifying said select base table and all associated base tables;
reading said backup of said database from said storage media in physical order, includingextracting an extent list of physical page numbers for said specified base table and associated catalog tables; and
populating said empty copy of said select base table and associated catalog tables with backup data extracted from said storage media.
1 Assignment
0 Petitions
Accused Products
Abstract
A method and system are provided to enable restoration of a base table and associated catalog table from a database. Table names and table identifiers are copied to a header of a storage media during a backup of the database. When a restore of a designated table is requested, table identifier data is extracted from the header of the storage media housing the backup of the database. Accordingly, the designated base table and associated catalog table(s) are restored from the storage media based upon data stored in the header of the storage media during the backup of the database.
-
Citations
12 Claims
-
1. A method comprising:
-
copying all table metadata, including table name and table identifier data, to a header of a backup storage media during a backup process of a database; restoring a select base table from said backup storage media, comprising; creating an empty copy of a catalog table associated with a select base table; creating an empty copy of said select base table; and reading said header from said storage media housing said backup of said database, including extracting table identifier metadata from said header; identifying said select base table and all associated base tables; reading said backup of said database from said storage media in physical order, including extracting an extent list of physical page numbers for said specified base table and associated catalog tables; and populating said empty copy of said select base table and associated catalog tables with backup data extracted from said storage media. - View Dependent Claims (2, 3, 4)
-
-
5. A computer system comprising:
-
a processor; a backup manager in communication with said processor and adapted to copy table name metadata, including table identifier data, to a header of a storage media during a backup process of a database; a restore manager in communication with said processor and adapted to restore a select base table from said backup storage media through creation of an empty copy of a catalog table associated with a select base table, creation of an empty copy of said select base table, and read said header from said storage media housing said backup of said database, wherein the read of said header includes an extraction of table identifier metadata; and
said restore managerto identify said select base table and all associated base tables, to read said backup of said database from said storage media in physical order, including extraction of an extent list of physical page numbers for said specified base table and associated catalog tables, and to populate said empty copy of said select base table and associated catalog tables with backup data extracted from said storage media. - View Dependent Claims (6, 7, 8)
-
-
9. An article comprising:
-
a computer-readable data storage medium; means in the medium for copying metadata, including table name and table identifier data, to a header of a storage media during a backup process of a database; means in the medium for restoring a select base table from said backup storage media, comprising; creating an empty copy of a catalog table associated with a select base table; creating an empty copy of said select base table; and reading said header from said storage media housing said backup of said database, including extracting table identifier metadata from said header; means in the medium for identifying said select base table and all associated base tables; means in the medium for reading said backup of said database from said storage media in physical order, including extracting an extent list of physical page numbers for said specified base table and associated catalog tables; and means in the medium for populating said empty copy of said select base table and associated catalog tables with backup data extracted from said storage media. - View Dependent Claims (10, 11, 12)
-
Specification