User interface for restoring databases

• US 9,489,271 B1
• Filed: 03/29/2012
• Issued: 11/08/2016
• Est. Priority Date: 03/29/2012
• Status: Active Grant

• Current Assignee: Veritas Technologies, LLC (Whitehouse Group Ltd.)
• Original Assignee: Veritas Technologies, LLC (Whitehouse Group Ltd.)
• Inventors: Surroca, Francisco, Wang, Ping, Tsaur, Ynn-Pyng Anker, Abraham, Lijo J., Payne, Michael A., Dowers, Gregory R. II, Doucette, Lee M.
• Primary Examiner(s): Corrielus, Jean M
• Application Number:
  US13/433,709
• Time in Patent Office: 1,685 Days
• Field of Search: 707/640, 707/679, 707/752, 707/661, 707/660, 707/654, 707/653
• US Class Current: 1/1
• CPC Class Codes: G06F 11/00 Error detection; Error correction; Monitoring error detection, correction or monitoring in information storage based on relative movement between record carrier and transducer G11B20/18; monitoring, i.e. supervising the progress of recording or reproducing G11B27/36; in static stores G11C29/00
• CPC Class Codes: G06F 11/1469 Backup restoration techniques
• CPC Class Codes: G06F 16/213 with details for schema evolution support
• CPC Class Codes: G06F 16/22 Indexing; Data structures therefor; Storage structures
• CPC Class Codes: G06F 16/2365 Ensuring data consistency and integrity
• CPC Class Codes: G06F 2201/80 Database-specific techniques

Abstract

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.

Claims

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.