System to automate schema creation for table restore

Details System to automate schema creation for table restore System to automate schema creation for table restore

2007-04-03

2007-04-03

Cottingham, John (Department: 2167)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000

Reexamination Certificate

active

10738294

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.

REFERENCES:
patent: 5991772 (1999-11-01), Doherty et al.
patent: 6269381 (2001-07-01), St. Pierre et al.
patent: 6366987 (2002-04-01), Tzelnic et al.
patent: 6415300 (2002-07-01), Liu
patent: 6434682 (2002-08-01), Ashton et al.
patent: 6453325 (2002-09-01), Cabrera et al.
patent: 6505216 (2003-01-01), Schutzman et al.
patent: 6728711 (2004-04-01), Richard
patent: 2002/0059505 (2002-05-01), St. Pierre et al.
Rama Velpuri: Oracle Backup & Recovery Handbook, Osborne McGraw-Hill, 1995 (pp. 54, 70-74, 188-199 and 220-221).
Oracle7™ Server Utilities, Release 7.3, Feb. 1996, Oracleâ (pp. 1-1 to 1-32).
Lightstone et al., “Toward Autonomic Computing With DB2 Universal Database”, Sep. 2002, SIGMOD Record, vol. 31, No. 3, pp. 55-61.
Elie et al., Informed Dynamic Shared Path Protection, 2002, Optical Fiber Communication Conference—Postconference Technical Digest, Pt. 1, vol. 1, pp. 492-493.
Hohndel et al., “Automated Installation of Linux Systems Using YaST”, Nov. 1999, 13thSystems Administration Conference, pp. 261-266.
Mitton et al., “Migrated Data Backup Utility”, IBM Technical Disclosure Bulletin, vol. 37, No. 6B, pp. 505-508, Jun. 1994.

Affiliated with

Also associated with

Rating

System to automate schema creation for table restore does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with System to automate schema creation for table restore, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System to automate schema creation for table restore will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3770164