Database replication using adaptive compression

A computer program product comprising a computer readable storage medium, excluding a transitory signal per se, having stored thereon:

• program instructions programmed to, in a data replication environment, analyze a database workload to generate a knowledge base of information related to compression;
• program instructions programmed to divide a transfer data stream into different segments based, at least in part, on the knowledge base;
• program instructions programmed to obtain candidate compression types for the transfer data stream based, at least in part, on the knowledge base;
• program instructions programmed to assign respective compression types of the candidate compression types to the different segments;
• program instructions programmed to generate compressed segments based, at least in part, on the respective compression types assigned to the different segments;
• and program instructions programmed to provide the compressed segments to a replication target, wherein providing the compressed segments to the replication target includes providing a compression sequence table along with the compressed segments to the replication target and decompressing the compressed segments such that the transfer data stream can be replicated at the replication target.

A computer system comprising:

• a processor set;
• and
• a computer readable storage medium;
• wherein:
• the processor set is structured, located, connected, and programmed to run program instructions stored on the computer readable storage medium;
• and
• the stored program instructions include:
• program instructions programmed to, in a data replication environment, analyze a database workload to generate a knowledge base of information related to compression;
• program instructions programmed to divide a transfer data stream into different segments based, at least in part, on the knowledge base;
• program instructions programmed to obtain candidate compression types for the transfer data stream based, at least in part, on the knowledge base;
• program instructions programmed to assign respective compression types of the candidate compression types to the different segments;
• program instructions programmed to generate compressed segments based, at least in part, on the respective compression types assigned to the different segments;
• and
• program instructions programmed to provide the compressed segments to a replication target, wherein providing the compressed segments to the replication target includes providing a compression sequence table along with the compressed segments to the replication target and decompressing the compressed segments such that the transfer data stream can be replicated at the replication target.