×

Table level database restore in a data storage system

  • US 9,720,787 B2
  • Filed: 09/30/2013
  • Issued: 08/01/2017
  • Est. Priority Date: 01/11/2013
  • Status: Active Grant
First Claim
Patent Images

1. A method of restoring a database table from secondary storage in a data storage system, comprising:

  • using one or more computing devices comprising computer hardware;

    receiving instructions to perform a table level restore for a first table of a plurality of database tables to restore the first table from a secondary storage subsystem to a primary storage subsystem,wherein the plurality of database tables is associated with a database application installed on one or more client computing devices comprising computer hardware, and wherein a first secondary copy of data corresponding to a first subset of database tables belonging to a first tablespace is stored in the secondary storage subsystem and comprises data relating to the first subset of database tables, and a second secondary copy of data corresponding to a second subset of database tables belonging to a second tablespace different than the first tablespace is stored in the secondary storage subsystem and comprises data relating to the second subset of database tables, the first table belonging to the first tablespace;

    accessing a first table metadata index for the first table, the first table metadata index comprising information specific to the first table, the first table metadata index further comprising information for restoring (i) the first table, (ii) a second table referenced by the first table and belonging to the first tablespace, and (iii) a third table referenced by the first table and belonging to the second tablespace, the first table metadata index further comprising (i) a first location within the first secondary copy that contains data corresponding to the first table, a second location within the first secondary copy that contains data corresponding to the second table, and a third location within the second secondary copy that contains data corresponding to the third table or (ii) information sufficient to locate data corresponding to the first and second tables in the first secondary copy and to locate data corresponding to the third table in the second secondary copy, wherein the first table metadata index was created prior to the receipt of the instructions to restore the first table; and

    restoring the first table and the second table referenced by the first table from the secondary storage subsystem to the primary storage subsystem without restoring the entire first secondary copy, and restoring the third table referenced by the first table from the secondary storage subsystem to the primary storage subsystem without restoring the entire second secondary copy.

View all claims
  • 4 Assignments
Timeline View
Assignment View
    ×
    ×