首页>
外国专利>
SELECTING VARIOUS ALGORITHMS TO COMPRESS COLUMNS OF ANALYTIC DATA IN A READ-ONLY RELATIONAL DATABASE IN A MANNER THAT ALLOWS DECOMPRESSION OF THE COMPRESSED DATA USING MINIMAL SYSTEM RESOURCES
SELECTING VARIOUS ALGORITHMS TO COMPRESS COLUMNS OF ANALYTIC DATA IN A READ-ONLY RELATIONAL DATABASE IN A MANNER THAT ALLOWS DECOMPRESSION OF THE COMPRESSED DATA USING MINIMAL SYSTEM RESOURCES
展开▼
机译:选择各种算法来压缩只读关系数据库中的分析数据列,以允许使用最小系统资源对压缩数据进行解压缩
展开▼
页面导航
摘要
著录项
相似文献
摘要
A method, computer program product and system for balancing compression efficiency against access performance. Source data is read from a database row by row and column by column within each row. Algorithm(s) are selected to compress the data read for each column. Algorithms are selected in a manner that closely maximizes the amount of data stored in a given amount of disk space but requires minimal system resources to decompress the compressed data. These algorithms are stored in a control block. Further, parameters that allow the read data to be stored in a compressed manner efficiently are stored in the control block. Upon a second reading of the source data, data is compressed column by column using the appropriate algorithms and parameters. The compressed data may then be decompressed using the appropriate algorithms and parameters. In this manner, a better balance may be realized between compression efficiency and access performance.
展开▼