×

System to automate schema creation for table restore

  • US 7,200,621 B2
  • Filed: 12/17/2003
  • Issued: 04/03/2007
  • Est. Priority Date: 12/17/2003
  • Status: Expired due to Fees
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.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×