Compression determination for column store

    公开(公告)号:US11681676B2

    公开(公告)日:2023-06-20

    申请号:US17357097

    申请日:2021-06-24

    Applicant: SAP SE

    CPC classification number: G06F16/221 G06F16/2282 H03M7/6064

    Abstract: A system includes application of respective compression types to first data associated with each of a plurality of columns to generate compressed column data, determination of a first compression ratio for each of the plurality of columns based on the compressed column data, storage of the determined first compression ratios, application, for each of the plurality of columns, of the determined compression type to second data associated with the column to generate second compressed column data, determination of a second compression ratio for each of the plurality of columns based on the second compressed column data, determination of a value for each column based on the stored first compression ratio and the second compression ratio determined for the column, determination of a representative value of the determined values, and determination, based on the representative value, whether to re-determine a compression type for each of the plurality of columns.

    Consistency checks for compressed data

    公开(公告)号:US12197419B2

    公开(公告)日:2025-01-14

    申请号:US17974209

    申请日:2022-10-26

    Applicant: SAP SE

    Abstract: Systems and methods include reception of an instruction to perform a consistency check on compressed column data. In response to the instruction, a compression algorithm applied to uncompressed column data to generate the compressed column data is determined, one or more consistency checks associated with the compression algorithm are determined, wherein a first one or more consistency checks associated with a first compression algorithm are different from a second one or more consistency checks associated with a second compression algorithm, the one or more consistency checks are executed on the compressed column data, and, if the one or more consistency checks are not satisfied, a notification is transmitted to a user.

Patent Agency Ranking