Alibaba Group Holding Limited
METHOD AND SYSTEM TO COMPRESS DECIMAL AND NUMERIC DATA IN DATABASE

Abstract:

The present disclosure provides a method for compressing numeric data. The method comprises receiving a data set having a plurality of numeric values; for each numeric value of the plurality of numeric values of the data set, dividing a numeric value into a plurality of arrays arranged according to a specific location of the numeric value, wherein the plurality of arrays include a first array and a second array; grouping, across the plurality of numeric values, first arrays; grouping, across the plurality of numeric values, second arrays; and compressing the group of first arrays and the group of second arrays. The present disclosure also provides a method for decompressing numeric data. The method comprises receiving a data buffer comprising compressed numeric values; decompressing the compressed numeric values into groups of arrays; aligning the groups of arrays according to their relative positions from decimal points; and reconstructing numeric values according to the aligned groups of arrays. In addition, the present disclosure provides database systems and non-transitory computer-readable media for compressing and decompressing numeric data.