Database table compression

A system comprising a table compression module for table compression in a database, the database organized in tables comprising rows and columns, the table compression module comprising:

• a partition definition unit configured to define a range partition of a table of the database according to a first attribute of the table;
• a range definition unit configured to define internal ranges according to a second attribute of the table;
• a range determination unit configured to determine a target internal range out of the internal ranges for a row to be inserted as a new entry into the table;
• and
• a creation unit configured to create the internal range compression directory for the target internal range in case no internal range compression directory exists for the target internal range and a predefined threshold value of a number of rows is exceeded in the target internal range.

A computer program product for table compression in a database, the database organized in tables comprising rows and columns, the computer program product comprising:

• a computer readable storage medium having computer readable program code configured to:
• define a range partition of a table of the database according to a first attribute of the table;
• define internal ranges of the table of the database according to a second attribute of the table;
• determine a target internal range of the internal ranges to insert a row as a new entry into the table;
• determine whether an internal range compression directory exists for the target internal range;
• and
• based on determining that no internal range compression directory exists for the target internal range and a predefined threshold value of a number of rows is exceeded in the target internal range, create the internal range compression directory for the target internal range.