Selective data compression in a database system

摘要

A database system may implement compression management of tables in the database system. The compression management may include determination of a pattern of usage of various database tables in the database system. Based on this pattern of usage, the database tables may be selected as candidates for compression or decompression at the appropriate time. In one example, the pattern of usage may be based on the contents of a query log of the database system. The compression management may also include evaluation of various compression strategies to apply to a candidate database table. Each compression strategy may be evaluated to determine if application to a database table or a portion of the database table would be beneficial based on various conditions. The compression management may also include consideration of each available compression strategy to be applied solely or in combination with one another.

主权项

1. A database system comprising:
at least one storage device configured to store a database and a query log, wherein the database comprises data organized into a plurality of database tables, and wherein the query log is a data object comprising 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 the plurality of database tables in database-related tasks; a processor in communication with the at least one storage device; and a compression management module executable by the processor to: retrieve the query log; determine the respective specific usage times of the plurality of database tables from the query log; determine the presence of at least one condition associated with the database system; select 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 based on the information in the query log; and generate a schedule to compress and decompress at least a portion of the database table.