User interface for restoring databases
Various systems and methods for restoring data in distributed storage systems. For example, one method involves receiving a first selection, where the first selection identifies data abstraction. The data abstraction represents a data source that can be restored. The method also involves receiving a second selection, where the second selection identifies a restore operation, and where the restore operation is associated with the data abstraction. The method also involves determining data to be restored, where this determination is based on the data source(s) (as can be determined from the data abstraction) and on the second selection. Data can then be restored based on the determined data.
1. A method comprising:
receiving a first selection, wherein
the first selection identifies a data abstraction, and
the data abstraction represents a data source;
receiving a second selection, wherein
the second selection identifies a restore operation,
the restore operation is associated with the data abstraction, and
the second selection is chosen from a list of one or more restore operations, wherein
each restore operation from the list is customized for the data abstraction,
any restore operation that cannot be performed for the data abstraction is not made available in the list, and
the list is automatically generated based on the data abstraction identified by the first selection;
automatically determining one or more data sources of a plurality of data sources, wherein
the determining is based on the first selection, and
the restore operation is configured to restore data of the one or more data sources;
automatically determining one or more first backup sets, wherein
the one or more first backup sets comprise at least a portion of a backup of the one or more data sources, and
the one or more first backup sets are selected based on the second selection; and
generating one or more SQL commands, wherein
the one or more SQL commands are configured to cause restoration of the one or more first backup sets.
2. The method of claim 1 , further comprising:
determining the data to be restored, wherein
the determining is based on
the data source(s), and
the second selection, and
the determining generates determined data.
3. The method of claim 2 ,
restoring the data, wherein
the restoring is based on the determined data, and
the restoring generates restored data.
4. The method of claim 1 , wherein
restoring accesses a backup subsystem,
the backup subsystem comprises a plurality of backups,
the plurality of backups comprises the one or more first backup sets, and
the restoring generates restored data by accessing the one or more first backup sets.
5. The method of claim 1 , further comprising
generating a restore plan, wherein
the restore plan is generated based on
the data source(s), and
the second selection, and
restoring the data, wherein
the restoring generates restored data, and
the restoring is based on the restore plan.
6. The method of claim 5 , wherein
the generating the restore plan comprises
the automatically determining the one or more first backup sets, wherein
the automatically determining the one or more first backup sets is further based on the data source(s), and
a type of the restore operation, and
the restore plan comprises a selection of the one or more first backup sets.
7. The method of claim 6 , wherein
the type of the restore operation indicates restoring the data to a latest backup.
8. The method of claim 6 , wherein
the type of the restore operation indicates restoring the data to a first time.
9. The method of claim 6 , wherein
the type of the restore operation indicates a restore to a first time in a transaction log.
10. The method of claim 6 , wherein
the type of the restore operation indicates a restore to a first transaction of a plurality of transactions.
11. The method of claim 1 , further comprising:
displaying a plurality of data representations, wherein
the plurality of data representations comprises a first data representation,
the plurality of data representations comprises additional data representations, and
the first selection is indicative of
the first data representation being selected, and
the other data representations not being selected.
12. The method of claim 1 , further comprising:
displaying a plurality of restore operations, wherein
the plurality of restore operations comprises the restore operation,
the plurality of restore operations comprises one or more additional restore operations, and
the second selection is indicative of
the first restore operation being selected, and
the other one or more additional restore operations not being selected.
13. The method of claim 1 , further comprising:
displaying a plurality of icons, wherein
each of the plurality of icons indicates one of a plurality of data representations,
the first selection is indicative of a selection of a first icon of the plurality of icons.
14. The method of claim 1 , further comprising:
displaying a plurality of icons, wherein
each of the plurality of icons indicates one of a plurality of restore operations, and
the second selection is indicative of a selection of a first icon of the plurality of icons.
15. The method of claim 1 , wherein
the determining the data source(s) comprises
mapping the data abstraction to the data source.
16. The method of claim 1 , wherein:
the first selection is comprised in a first user input,
the second selection is comprised in a second user input, and
the list comprises one or more restore operations that are configured to be performed for the data abstraction identified by the first selection.
17. A system comprising:
a processor;
a display module, wherein
the display module is configured to
display a plurality of data, and
display a plurality of restore operations;
a selection module, wherein
the selection module is configured to
receive a first selection, wherein
the first selection identifies a data abstraction, and
the data abstraction represents a data source, and
receive a second selection, wherein
the second selection indicates a restore operation of the plurality of restore operations,
the restore operation is related to the data, and
the second selection is chosen from a list of one or more restore operations, wherein
each restore operation from the list is customized for the data abstraction,
any restore operation that cannot be performed for the data abstraction is not made available in the list, and
the list is automatically generated based on the data abstraction identified by the first selection;
a source determination module, configured to be executed using the processor, wherein
the source determination module is configured to automatically determine one or more data sources of a plurality of data sources,
the restore operation is configured to restore data of the one or more data sources,
the determination is based on the first selection,
the source determination module is further configured to automatically determine one or more first backup sets,
the one or more first backup sets comprise at least a portion of a backup of the one or more data sources, and
the one or more first backup sets are selected based on the second selection; and
a plan generation module, configured to be executed using the processor, and further configured to
generate one or more SQL commands, wherein
the one or more SQL commands are configured to cause a restoration of the one or more first backup sets.
18. The system of claim 17 , further comprising:
a restore module, wherein
the restore module is configured to
restore the data, and
the restoration is based on
the one or more SQL commands,
the one or more data sources, and
the second selection.
19. A computer program product for restoring data in a distributed storage system, the computer program product comprising a non-transitory computer-readable storage medium having a plurality of instructions embodied therein, wherein said plurality of instructions comprises: a first set of instructions, executable on a computer system, configured to
receive a first selection, wherein
the first selection identifies data abstraction, and
the data abstraction represents a data source;
a second set of instructions, executable on the computer system, configured to
receive a second selection, wherein
the second selection identifies a restore operation,
the restore operation is associated with the data abstraction, and
the second selection is configured to be chosen from a list of one or more restore operations, wherein
each restore operation from the list is customized for the data abstraction,
any restore operation that cannot be performed for the data abstraction is not made available in the list, and
the list is configured to be automatically generated based on the data abstraction identified by the first selection;
a third set of instructions, executable on the computer system, configured to
automatically determine one or more data sources of a plurality of data sources based on the first selection, wherein
the restore operation is configured to restore data of the one or more data sources, and
the determining is based on the first selection;
a fourth set of instructions, executable on the computer system, configured to
automatically determine one or more first backup sets, wherein
the one or more first backup sets comprise at least a portion of a backup of the one or more data sources, and
the one or more first backup sets are selected based on the second selection; and
a fifth set of instructions, executable on the computer system, configured to
generate one or more SQL commands, wherein
the one or more SQL commands are configured to cause a restoration of the one or more first backup sets.
20. The computer program product of claim 19 , wherein the instructions further comprise:
a sixth set of instructions, executable on the computer system, configured to
determine the data to be restored, wherein
the determining is based on
the data source(s), and
the second selection, and
the determining generates determined data.