Invention Grant
- Patent Title: System and method for selective compression in a database backup operation
-
Application No.: US16564274Application Date: 2019-09-09
-
Publication No.: US11221922B2Publication Date: 2022-01-11
- Inventor: Prashant Dagar , Neeraj Gaurav , Kelly D. Rodger , Tapas Saha
- Applicant: International Business Machines Corporation
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agent Stephanie L. Carusillo
- Priority: CACA2876468 20141229
- Main IPC: G06F11/14
- IPC: G06F11/14 ; G06F16/22

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.
Public/Granted literature
- US20200004638A1 SYSTEM AND METHOD FOR SELECTIVE COMPRESSION IN A DATABASE BACKUP OPERATION Public/Granted day:2020-01-02
Information query