Table level database restore in a data storage system

• US 9,846,620 B2
• Filed: 09/30/2013
• Issued: 12/19/2017
• Est. Priority Date: 01/11/2013
• Status: Active Grant

• Current Assignee: CommVault Systems Incorporated
• Original Assignee: CommVault Systems Incorporated
• Inventors: Kumarasamy, Paramasivam, Vallabhaneni, Brahmaiah
• Primary Examiner(s): Pham, Khanh
• Application Number:
  US14/041,498
• Publication Number:
  US 20140201159A1
• Time in Patent Office: 1,541 Days
• CPC Class Codes: G06F 11/1448 Management of the data involved in backup or backup restore
• CPC Class Codes: G06F 11/1469 Backup restoration techniques
• CPC Class Codes: G06F 2201/80 Database-specific techniques

Abstract

The data storage system according to certain aspects can implement table level database restore. Table level database restore may refer to restoring a database table and its related data without restoring the entire database. The data storage system may use table metadata index to implement table level restore. A table metadata index may be created for each table, e.g., during a backup of the database. The table metadata index for a table can include any type of information for restoring the table and its related data. Some examples of the type of information included in the table metadata index include the following: container for the table, table backup location, system data, table index, table relationships, etc. Table metadata index can make the restoring of tables fast and efficient by packaging information that can be used to restore a table and its related data in an easily accessible manner.

Claims

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;

providing a user interface on a display device;

displaying a list of a plurality of database tables associated with a database application in the user interface, data associated with the plurality of database tables being stored in a secondary storage subsystem as a part of a secondary copy of data associated with the database application, the database application installed on one or more client computing devices comprising computer hardware;

receiving an indication of a first table from the list of the plurality of database tables to restore;

accessing a first table metadata index stored separately from the secondary copy of the data associated with the database application in response to receiving the indication of the first table, wherein the first table metadata index is specific to the first table; and

restoring the first table and a second table from the list of the plurality of database tables that includes a value referenced by a record in the first table from the secondary storage subsystem to a primary storage subsystem using the first table metadata index without restoring all of the secondary copy of the data associated with the database application,

wherein the first table metadata index comprises information for restoring the first table and the second table that includes the value referenced by the record in the first table, the first table metadata index comprising a location of the first table in the secondary copy, and a location of the second table that includes the value referenced by the record in the first table in the secondary copy or information for obtaining the location of the second table that includes the value referenced by the record in the first table in the secondary copy, wherein the first table metadata index was created during a secondary storage operation that created the secondary copy of the data associated with the database application.

2. The method of claim 1, wherein the first table metadata index comprises information relating to one or more of:

a container for the first table, system data, a table index, or a relationship between the first table and the second table that includes the value referenced by the record in the first table.

3. The method of claim 2, wherein the system data comprises one or more of:

a system object, a database object, a database schema associated with the database application, and a data structure used by the database application.

4. The method of claim 2, wherein said restoring the first table and the second table that includes the value referenced by the record in the first table comprises:

restoring data of the first table by accessing the location of the first table in the secondary copy from the first table metadata index;

restoring one or more system objects or one or more database objects referenced by the first table by accessing the information relating to the system data from the first table metadata index; and

restoring data of the second table that includes the value referenced by the record in the first table by accessing the information relating to the relationship between the first table and the second table that includes the value referenced by the record in the first table from the first table metadata index.

5. The method of claim 4, wherein the information relating to the system data comprises information relating to system objects or database objects referenced by the first table.

6. The method of claim 4, wherein subsequent to said restoring the first table and the second table that includes the value referenced by the record in the first table, the restored first table in the primary storage subsystem can be browsed or queried and the data of the second table that includes the value referenced by the record in the first table is available in the primary storage subsystem.

7. The method of claim 2, wherein the user interface displays an option for using an auxiliary database for restoring, and wherein said restoring the first table and the second table that includes the value referenced by the record in the first table comprises:

copying system data associated with the database application from the secondary storage subsystem to the auxiliary database;

copying data of the container that includes the first table from the secondary storage subsystem to the auxiliary database by accessing the first table metadata index;

extracting from the auxiliary database the data of the first table and at least a portion of the system data referenced by the first table; and

copying the extracted data to the primary storage subsystem.

8. The method of claim 7, further comprising:

copying data of one or more containers that include the second table that includes the value referenced by the record in the first table from the secondary storage subsystem to the auxiliary database by accessing the first table metadata index;

extracting from the auxiliary database the data of the second table that includes the value referenced by the record in the first table and at least a portion of the system data referenced by the second table that includes the value referenced by the record in the first table; and

copying the extracted data of the second table that includes the value referenced by the record in the first table and the at least a portion of the system data to the primary storage subsystem.

9. The method of claim 2, wherein the first table metadata index is available in an index that is not stored in the secondary storage subsystem.

10. The method of claim 2, wherein the relationship between the first table and the second table that includes the value referenced by the record in the first table comprises one or more of:

a list that includes the second table that includes the value referenced by the record in the first table and a list of one or more tables that reference the first table.

11. The method of claim 2, wherein the relationship between the first table and the second table that includes the value referenced by the record in the first table comprises metadata relating to the second table that includes the value referenced by the record in the first table, the metadata comprising same type of information as type of information in the first table metadata index for the first table.

12. The method of claim 2, wherein the first table is stored in a secondary storage copy of the container, and wherein the location of the first table in the secondary copy indicates a location of the first table within the secondary storage copy of the container.

13. A data storage system for restoring a database table from secondary storage, comprising:

a first computing device comprising one or more first computer processors configured to;

provide a user interface on a display device; and

display a list of a plurality of database tables associated with a database application in the user interface, data associated with the plurality of database tables being stored in a secondary storage subsystem as a part of a secondary copy of data associated with the database application, the database application installed on one or more client computing devices; and

a second computing device comprising one or more second computer processors, the second computing device configured to execute a table level restore module, the table level restore module configured to;

receive an indication of a first table from the list of the plurality of database tables to restore;

access a first table metadata index stored separately from the secondary copy of the data associated with the database application in response to receiving the indication of the first table; and

restore the first table and a second table from the list of the plurality of database tables that includes a value referenced by a record in the first table from the secondary storage subsystem to a primary storage subsystem using the first table metadata index without restoring all of data associated with the database application,

wherein the first table metadata index comprises information for restoring the first table and the second table that includes the value referenced by the record in the first table, the first table metadata index comprising a location of the first table in the secondary copy, and a location of the second table that includes the value referenced by the record in the first table in the secondary copy or information for obtaining the location of the second table that includes the value referenced by the record in the first table in the secondary copy, wherein the first table metadata index was created during a secondary storage operation that created the secondary copy of the data associated with the database application.

14. The system of claim 13, wherein the first table metadata index comprises information relating to one or more of:

a container for the first table, system data, a table index, or a relationship between the first table and the second table that includes the value referenced by the record in the first table.

15. The system of claim 14, wherein the table level restore module performs said restore of the first table and the second table that includes the value referenced by the record in the first table at least partly by:

restoring data of the first table by accessing the location of the first table in the secondary copy from the first table metadata index;

restoring one or more system objects or one or more database objects referenced by the first table by accessing the information relating to the system data from the first table metadata index; and

restoring data of the second table that includes the value referenced by the record in the first table by accessing the information relating to the relationship between the first table and the second table that includes the value referenced by the record in the first table from the first table metadata index.

16. The system of claim 15, wherein the information relating to the system data comprises information relating to system objects or database objects referenced by the first table.

17. The system of claim 15, wherein subsequent to said restoring of the first table the first table and the second table that includes the value referenced by the record in the first table by the table level restore module, the restored first table in the primary storage subsystem can be browsed or queried and the data of the second table that includes the value referenced by the record in the first table is available in the primary storage subsystem.

18. The system of claim 14, wherein the first computing device is further configured to display in the user interface an option for using an auxiliary database for restore, and wherein the table level restore module is configured to perform said restore of the first table and second table that includes the value referenced by the record in the first table at least partly by:

copying system data associated with the database application from the secondary storage subsystem to the auxiliary database;

copying data of the container that includes the first table from the secondary storage subsystem to the auxiliary database by accessing the first table metadata index;

extracting from the auxiliary database the data of the first table and at least a portion of the system data referenced by the first table; and

copying the extracted data to the primary storage subsystem.

19. The system of claim 18, wherein the table level restore module is further configured to perform said restore of the first table and one or more tables referenced by the first table at least partly by:

copying data of one or more containers that include the second table that includes the value referenced by the record in the first table from the secondary storage subsystem to the auxiliary database by accessing the first table metadata index;

extracting from the auxiliary database the data of the second table that includes the value referenced by the record in the first table and at least a portion of the system data referenced by the second table that includes the value referenced by the record in the first table; and

copying the extracted data of the second table that includes the value referenced by the record in the first table and the at least a portion of the system data to the primary storage subsystem.