Patent ID: 9564919
Date: 2017-02-07
CPC Classifications: G06F,H03M

Claim:
1. A computer program product for managing data records in a relational database, the computer program product comprising a computer readable storage medium having program instructions embodied therewith, wherein the computer readable storage medium is not a transitory signal per se, the program instructions executable by a processor to cause the processor to perform a method comprising: monitoring, by the processor, a record length for a first data record of the relational database stored in a first page of memory, a first amount of free space in the first page of memory, and a first page length of the first page of memory, wherein, for each respective page of memory, a respective amount of free space includes reserved space and unused space; receiving an update structured query language (SQL) command to replace the first data record with a second data record in the relational database; determining, by the processor, based upon receiving the update SQL command, whether an estimated record length of a compressed second data record is larger than the first amount of free space in the first page of memory; in response to determining that the estimated record length of the compressed second data record is larger than the first amount of free space, determining whether an estimated length of a compressed page that includes the second data record is larger than the first page length; in response to determining the estimated length of the compressed page is larger than the first page length, creating an overflow record for the second data record, wherein creating an overflow record comprises storing the second data record in a second page of memory; and in response to determining that the estimated length of the compressed page is within the first page length, compressing the page using adaptive dictionary-based compression, and replacing the page with a compressed page.