TABLE LEVEL DATABASE RESTORE IN A DATA STORAGE SYSTEM

摘要

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.

主权项

1. A method of storing database tables in secondary storage of a data storage system, comprising:
initiating copying of data associated with a database application in primary storage to secondary storage, the database application executing on one or more client computing devices in communication with the primary storage, wherein the data associated with the database application comprises data of a plurality of database tables; determining a relationship among the plurality of database tables; creating a table metadata index associated with a first table of the plurality of database tables, wherein the table metadata index comprises information for restoring the first table and its associated data; and copying data relating to the first table to the secondary storage.