compressionsap-data-dictionary

Data compression algorithm in SAP clusters


I'm interested in data decompression in SAP systems.

Which algorithm is used for compression/decompression in clustered tables? For example, in RFBLG table. I read something about the LZ algorithm but I'm not sure how it exactly works.

Is there a detailed document describing how it works in SAP?


Solution

  • The compression mechanisms would be highly dependent on the DB backend behind the Netweaver.

    You can view compression method in Database Utility (SE14) by Go To->Storage Parameters.

    enter image description here

    Generally SAP uses three compression types for clustered (as well) data:

    However, their implementation by DB vendors may differ significantly.

    SAP and MS created MSSCOMPRESS report for performing table compression. Look at these articles too, where MS mentions about UCS-2 compression for SAP systems:

    Oracle involves its own compression mechanisms which are described, for example, in note 1436352, called Oracle Database 11g Advanced Compression for SAP Systems (S-LOGIN required).

    DB2 uses LZ2 (Lempel-Z) algorithm as your correctly stated. Here is detailed manual.