Data compression techniques in sap hana

For applying any type of compression on a data table, we must calculate a compression value first using appropriate factors.
Thus, the compression value is calculated using a compression factor.
The compression factor is the ratio of the size of uncompressed data to the size of compressed data in SAP HANA.
Technology is evolving rapidly! .

Data compression techniques primarily store data and avoid data redundancy.
The compression techniques are automatically optimized and calculated during the delta merge operation.
If an empty column is stored in the HANA memory, compression is not applied at that time.

The column store allows for the efficient compression of data.
This makes it less costly for the SAP HANA database to keep data in main memory.
It also speeds up searches and calculations.
This default method of compression is applied to all columns.

Dictionary Compression Dictionary compression is a standard compression method to reduce data volume in the main memory.
It is a default compression method which compulsorily applies on all columns of a data table in HANA database.
In this technique, we map distinct column values to consecutive numbers (value ID).

Data compression techniques primarily store data and avoid data redundancy

The compression techniques are automatically optimized and calculated during the delta merge operation

If an empty column is stored in the HANA memory, compression is not applied at that time

The column store allows for the efficient compression of data

This makes it less costly for the SAP HANA database to keep data in main memory

It also speeds up searches and calculations

This default method of compression is applied to all columns

Data Compression : SAP HANA provide series of data compression technique that can be used for data in the column store

To store contents of a column , the HANA database creates minimum two data structures

A dictionary vector and an attribute vector

See below table 2 and the corresponding column store