Index Value Pair Compression

Index Value Pair addresses compression on databases with larger block sizes, where the blocks are highly sparse. This compression algorithm is not selectable but is automatically used whenever appropriate by the database. The user must still choose between the compression types None, bitmap, RLE, and zlib through Administration Services.

Table 155 lists the available compression types the user can choose and the compression types that Essbase evaluates and then applies.

Table 155. Index Value Pair Compression

Chosen Compression Type

Evaluated Compression Type

None

None

Bitmap

Bitmap, Index Value Pair

RLE

RLE, Bitmap, Index Value Pair

zlib

zlib

For example, if the user selects RLE, Essbase reviews each block and evaluates the following compression types for highest compression: RLE, bitmap, or Index Value Pair. If the user chooses zlib, zlib is the only compression type applied.