The data block density for a particular BSO database is between 10% and 90%, and data values within the block do not consecutively repeat. Which type of compression would be most appropriate to use?

The correct answer is A. Bitmap. Bitmap is good for non-repeating data. It will use Bitmap or IVP (Index Value Pair). Note: Bitmap compression, the default. Essbase stores only non-missing values anduses a bitmapping scheme. A bitmap uses one bit for each cell in the data block, whether the cell value is…

Performance Tuning

Question

Options

ABitmap
BRLE
CZLIB
DNo compression required

How the community answered

(33 responses)

A
82% (27)
B
3% (1)
C
9% (3)
D
6% (2)

Explanation

Bitmap is good for non-repeating data. It will use Bitmap or IVP (Index Value Pair). Note: Bitmap compression, the default. Essbase stores only non-missing values anduses a bitmapping scheme. A bitmap uses one bit for each cell in the data block, whether the cell value is missing or non-missing. When a data block is not compressed, Essbase uses 8 bytes to store every non-missing cell. In most cases, bitmap compression conserves disk space more efficiently. However, much depends on the configuration of the data.

Topics

#BSO compression#bitmap compression#block density#data compression

Community Discussion

No community discussion yet for this question.

Full 1Z0-531 Practice