Enabling scripting language commands to backup/restore databases
AssigneeEMC IP Holding Company LLC
InventorsKrishnendu Bagchi, Manjesh Chikkanayakanahally, Sunil Yadav, Elango Chockalingam, Amarendra Behera
Life of this patent
Estimating the term…
Abstract
Enabling scripting language commands to backup/restore databases is described. A system outputs, to a user interface, a backup/restore option for a database. The system generates scripting language commands based on a selection of the backup/restore option received from the user interface. The system outputs, to the user interface, the scripting language commands based on the selection of the backup/restore option. The system enables a scripting language system to execute the scripting language commands based on the selection of the backup/restore option.
Claims20
A system for enabling scripting language commands to backup/restore databases, the system comprising:
- one or more processors;
- and
- a processor-based backup/restore application having backup/restore commands that trigger backup or restore functionality supported by the backup/restore application, which when executed, will cause the one or more processors to:
- output, by the backup/restore application, backup/restore options for a database to a user interface associated with the backup/restore application, the backup/restore options including selectable backup/restore parameters for at least one of recovery model for a database backup or a destination for the database backup;
- generate, by the backup/restore application, scripting language commands by:
- parsing custom native script commands of a relational database management system, the custom native script commands being of a database-specific language that are different from the backup/restore commands used by the backup/restore application, which does not support script commands of the relational database management system,
- mapping the custom native script commands to the backup or restore functionality supported by the backup/restore application, and
- modifying the custom native script commands to include at least one of the backup/restore parameters, the at least one of the backup/restore parameters being selected from the user interface associated with the backup/restore application,
- output, by the backup/restore application, the modified custom native script commands including the at least one backup/restore parameter generated by the backup/restore application to the user interface associated with the backup/restore application;
- execute, by the backup/restore application, the backup or restore functionality by:
- receiving, by a plug-in provided by the backup/restore application, the at least one backup/restore parameter from the relational database management system in response to the relational database management system executing the modified custom native script commands including the at least one backup/restore parameter, the execution of the generated scripting language commands causing back up of the database by parsing the modified custom native scripts to identify the backup/restore parameters, and mapping the backup/restore parameters to the backup or restore functionality supported by the backup/restore application;
- and
- receiving, by the backup/restore application, data via the plug-in when the relational database management system subsequently re-executes the modified custom native script commands including the at least one backup/restore parameter.
A computer-implemented method for enabling scripting language commands to backup/restore databases, the method comprising:
- outputting, by the backup/restore application, backup/restore options for a database to a user interface associated with the backup/restore application, the backup/restore application having backup/restore commands that trigger backup or restore functionality supported by the backup/restore application, the backup/restore options including selectable backup/restore parameters for at least one of recovery model for a database backup or a destination for the database backup;
- generating, by the backup/restore application, scripting language commands by:
- parsing custom native script commands of a relational database management system, the custom native script commands being of a database-specific language that are different from the backup/restore commands used by the backup/restore application, which does not support script commands of the relational database management system,
- mapping the custom native script commands to the backup or restore functionality supported by the backup/restore application, and
- modifying the custom native script commands to include at least one of the backup/restore parameters, the at least one of the backup/restore parameters being selected from the user interface associated with the backup/restore application,
- outputting, by the backup/restore application, the modified custom native script commands including the at least one backup/restore parameter generated by the backup/restore application to the user interface associated with the backup/restore application;
- executing, by the backup/restore application, the backup or restore functionality by:
- receiving, by a plug-in provided by the backup/restore application, the at least one backup/restore parameter from the relational database management system in response to the relational database management system executing the modified custom native script commands including the at least one backup/restore parameter, the execution of the generated scripting language commands causing back up of the database by parsing the modified custom native scripts to identify the backup/restore parameters, and mapping the backup/restore parameters to the backup or restore functionality supported by the backup/restore application;
- and
- receiving, by the backup/restore application, data via the plug-in when the relational database management system subsequently re-executes the modified custom native script commands including the at least one backup/restore parameter.
A computer program product, comprising a non-transitory computer-readable medium having a computer-readable program code embodied therein to be executed by one or more processors, the program code including instructions to:
- output, by the backup/restore application, backup/restore options for a database to a user interface associated with the backup/restore application, the backup/restore application having backup/restore commands that trigger backup or restore functionality supported by the backup/restore application, the backup/restore options including selectable backup/restore parameters for at least one of recovery model for a database backup or a destination for the database backup;
- generate, by the backup/restore application, scripting language commands by:
- parsing custom native script commands of a relational database management system, the custom native script commands being of a database-specific language that are different from the backup/restore commands used by the backup/restore application, which does not support script commands of the relational database management system;
- mapping the custom native script commands to the backup or restore functionality supported by the backup/restore application;
- and
- modifying the custom native script commands to include at least one of the backup/restore parameters, the at least one of the backup/restore parameters being selected from the user interface associated with the backup/restore application;
- output, by the backup/restore application, the modified custom native script commands including the at least one backup/restore parameter generated by the backup/restore application to the user interface associated with the backup/restore application;
- execute, by the backup/restore application, the backup or restore functionality by:
- receiving, by a plug-in provided by the backup/restore application, the at least one backup/restore parameter from the relational database management system in response to the relational database management system executing the modified custom native script commands including the at least one backup/restore parameter, the execution of the generated scripting language commands causing back up of the database by parsing the modified custom native scripts to identify the backup/restore parameters, and mapping the backup/restore parameters to the backup or restore functionality supported by the backup/restore application;
- and
- receiving, by the backup/restore application, data via the plug-in when the relational database management system subsequently re-executes the modified custom native script commands including the at least one backup/restore parameter.
Dependencies are inferred from the claim text.