System and method for archiving data
View Patent ↗Systems, methods, apparatus and software can utilize a markup language to import and export data that is archived using a backup and restore system. An export utility extracts data produced or processed by an application program, converts it into a markup language format, and provides it to a backup and restore system. An import utility extracts data in a markup language format, converts it to another format, and provides the data for use by the application program. In one example, the application program is a database management system.
1. A system comprising:
a query processor for constructing a command to extract data of some but not all rows in a database table in accordance with information from a parameter file, wherein the parameter file comprises a list of tables entered via a command line user interface to restrict data that is selected for export;
a data base management system for executing the command;
in response to executing the command, receiving the data of some but not all rows in the table;
a backup and restore module configured to generate a first data stream to be backed up and transmit the first data stream to a backup and restore server for further direction to a storage device;
a markup language module configured to receive the data of some but not all rows in the table, translate the data into a markup language version and pass the markup language version to the backup and restore module.
2. The system of claim 1 wherein the markup language module uses extensible markup language (XML).
3. A computer-implemented method comprising:
receiving a backup request;
constructing a command to extract data of some but not all rows in a database table using information from a parameter file, wherein the parameter file comprises a list of tables entered via a command line user interface to restrict data that is selected for export;
executing the command;
in response to executing the command, receiving the data of some but not all rows in the table;
translating the data into a markup language version; and
transmitting the markup language version to at least one of a backup and restore module or an archive file.
4. The method of claim 3 further comprising:
transmitting the markup language version from the backup and restore module to a backup and restore server.
5. The method of claim 3 wherein:
the parameter file comprises at least one parameter for identifying the some but not all rows of the table.
6. The method of claim 3 wherein the markup language is extensible markup language (XML).
7. The method of claim 3 wherein the application program is a database management system.
8. A computer readable storage medium comprising:
program instructions executable on a processor, encoded on the computer readable storage medium, and operable to implement each of:
receiving a backup request constructing a command to extract data of some but not all rows in a database table using information from a parameter file, wherein the parameter file comprises a list of tables entered via a command line user interface to restrict data that is selected for export;
executing the command;
in response to executing the command, receiving the data of some but not all rows in the table;
translating the data into a markup language version; and
transmitting the markup language version to at least one of a backup and restore module or an archive file.