Selective data compression in a database system

A method of data compression in a database system, the method comprising:

• retrieving, with a processor, a data object from a storage device, wherein content of the data object comprises information associated with usage of at least a subset of the database tables in database related tasks, wherein the information includes respective specific usage times for each of a plurality of database tables in a database in response to a database task, wherein each database table comprises organized data records of the database;
• determine the respective specific usage times of the plurality of database tables from the data object;
• determine the presence of at least one condition associated with the database system;
• selecting, with the processor, a database table from the plurality of database tables for data compression based on the presence of the at least one condition associated with the database system and the respective specific usage times of the database table as indicated in the information in the data object;
• and
• generating, with the processor, a schedule to compress and decompress at least a portion of the database table.

A non-transitory computer-readable medium encoded with computer-executable instructions, the computer-executable instructions executable with a processor, the computer-readable medium comprising:

• instructions to retrieve, from a data object, database-table-usage patterns for a plurality of database tables of a database, wherein the database table-usage patterns include respective specific usage times for each database table in a database-related task;
• instructions to identify at least one database table from a plurality of database tables of a database as a candidate for data compression based on at least one respective specific usage time of the database table, wherein each database table comprises a data object of organized data records in the database;
• instructions to determine presence of at least one condition associated with the database table;
• and
• instructions to generate a schedule to compress and decompress at least a portion of the database table in response to the determination of the presence of the at least one condition associated with the database table.

A method of data compression in a database system, the method comprising:

• selecting, with a processor, a database table from a plurality of database tables of a database for compression, wherein each database table comprises a data object of organized data records in the database;
• determining, with the processor, in a predetermined order, that a respective condition associated with one of a plurality of compression routines is present in the database table;
• and
• in the predetermined order, for each compression routine having the presence of the associated condition, compressing, with the processor, the database table according to the compression routine in response to presence of the respective condition.