TABLE LEVEL DATABASE RESTORE IN A DATA STORAGE SYSTEM
2 Assignments
0 Petitions
Accused Products
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.
-
Citations
21 Claims
-
1. (canceled)
-
2. A method of storing database tables in secondary storage of a data storage system, comprising:
using one or more computing devices comprising computer hardware; copying data associated with a plurality of database tables from one or more primary storage devices in a primary storage subsystem to one or more secondary storage devices in a secondary storage subsystem, wherein said copying comprises at least; identifying a first set of database tables referenced by a first database table from the plurality of database tables; and packaging (i) information for restoring the first database table and (ii) information for restoring the first set of database tables referenced by the first database table, together in a first table metadata index specific to the first database table for use in restoring the first database table such that the first database table can be restored without restoring at least one other table of the plurality of database tables. - View Dependent Claims (3, 4, 5, 6, 7, 8, 9, 10, 11, 12)
-
13. A system for storing database tables, comprising:
one or more computing devices comprising computer hardware and configured to; copy data associated with a plurality of database tables from one or more primary storage devices in a primary storage subsystem to one or more secondary storage devices in a secondary storage subsystem, wherein the one or more computing devices are configured to copy the data at least by; identifying a first set of database tables referenced by a first database table from the plurality of database tables; and packaging (i) information for restoring the first database table and (ii) information for restoring the first set of database tables referenced by the first database table, together in a first table metadata index specific to the first database table for use in restoring the first database table such that the first database table can be restored without restoring at least one other table of the plurality of database tables. - View Dependent Claims (14, 15, 16, 17, 18, 19, 20, 21)
Specification