US 2020/0004638 A1 · SYSTEM AND METHOD FOR SELECTIVE COMPRESSION IN A DATABASE BACKUP OPERATION

Abstract

Differential or selective elective data transformation, which can include compression and/or encryption, is applied to selected data subsets, such as selected table spaces, of a database during a single database operation. In response to a received backup command, a backup utility of a database management system obtains data from a number of data subsets of a source database that are specified for inclusion in a backup image. At least one of the data subsets is specified for data transformation while subsets are not. The data from the specified data subsets is identified in the obtained data, and transformed prior to writing a single backup image to archive media. The backup image therefore contains both transformed and untransformed data. The selection of data subsets for transformation can be made automatically without requiring user specification according to predefined data characteristics including subset size, data type, compressibility, or encryption.

Claims20

Dependent claims

A method of selectively transforming data during a database backup, the method comprising:

receiving, by one or more computer processors, backup command for a database;
obtaining, by one or more computer processors, data from a plurality of data subsets of the database, wherein the plurality of data subsets are specified for inclusion in a backup image and at least one of the plurality of data subsets are specified for transformation;
identifying, by one or more computer processors, the data from the specified at least one data subset;
transforming, by one or more computer processors, the identified data;
and
outputting, by one or more computer processors, both the transformed data and untransformed data obtained from at least another one of the plurality of data subsets to a single backup image, wherein the transformed data comprising encrypted data and the untransformed data comprising unencrypted data.

3 more elements

A computer program product for a database management system, the computer program product comprising:

one or more computer readable storage media and program instructions stored on the one or more computer readable storage media, the program instructions comprising:
program instructions to receive backup command for a database;
program instructions to obtain data from a plurality of data subsets of the database, wherein the plurality of data subsets are specified for inclusion in a backup image and at least one of the plurality of data subsets are specified for transformation;
program instructions to identify the data from the specified at least one data subset;
program instructions to transform the identified data;
and
program instructions to output both the transformed data and untransformed data obtained from at least another one of the plurality of data subsets to a single backup image, wherein the transformed data comprising encrypted data and the untransformed data comprising unencrypted data.

4 more elements

A computer system for a database management system, the computer system comprising:

one or more computer processors;
one or more computer readable storage media;
program instructions stored on the computer readable storage media for execution by at least one of the one or more computer processors, the program instructions comprising:
program instructions to receive backup command for a database;
program instructions to obtain data from a plurality of data subsets of the database, wherein the plurality of data subsets are specified for inclusion in a backup image and at least one of the plurality of data subsets are specified for transformation;
program instructions to identify the data from the specified at least one data subset;
program instructions to transform the identified data;
and
program instructions to output both the transformed data and untransformed data obtained from at least another one of the plurality of data subsets to a single backup image, wherein the transformed data comprising encrypted data and the untransformed data comprising unencrypted data.

6 more elements

Dependencies are inferred from the claim text.

System and method for selective compression in a database backup operation

Life of this patent

System and method for selective compression in a database backup operation

Life of this patent

Abstract

Claims20