Essbase - Data block

Essbase Overview

About

A data block is a multidimensional array structure that contains the data.

Article Related

How is it created ?

Essbase creates a data block for each unique combination of sparse standard dimension members (providing that at least one data value exists for the sparse dimension member combination). The data block represents all the dense dimension members for its combination of sparse dimension members.

A data block is created if at least one data value exists in the block.

Compression

Essbase compresses data blocks with missing values on disk, expanding each block fully as it brings the block into memory. Data compression is optional but is enabled by default. See Data Compression.

Cell

Each data block is a multidimensional array that contains a fixed, ordered location for each possible combination of dense dimension members. Accessing a Essbase - Cell in the block does not involve sequential or Essbase - Index searches. The search is almost instantaneous, resulting in optimal retrieval and calculation speed.

Essbase orders the cells in a data block according to the order of the members in the dense dimensions of the database outline.

Example of block creation

A (Dense)
   a1
   a2
B (Dense)
   b1
       b11
       b12
   b2
       b21
       b22
C (Dense)
   c1
   c2
   c3
D (Sparse)
   d1
   d2
       d21
       d22
E (Sparse)
   e1
   e2
   e3

The block below represent the three dense dimensions from within the combination of the sparse members d22 and e3.

Essbase Data Block For D22 E3

By carefully selecting dense and sparse standard dimensions, you can ensure that data blocks do not contain many empty cells, minimizing disk storage requirements and improving performance. More …

In Essbase, member combinations are denoted by the cross-dimensional operator. The symbol for the cross-dimensional operator is →, so d22 → e3 denotes the block for d22 and e3. The intersection of A, b21, and c3 is written A → b21 → c3.





Discover More
Essbase Overview
Essbase - ASO/BSO Storage

Essbase support two storage type : block storage (BSO) and aggregate storage (ASO) as a persistence mechanism for multidimensional databases. How the data are internally stored is determined by...
Essbase Overview
Essbase - BSO Access Path

Essbase BSO uses two types of internal structures to store and access data: data block and index Accessing a cell in the data block does not involve sequential or index searches. The search...
Essbase Overview
Essbase - Block storage

Block Storage databases are optimized for data set that are partially denses. Data is stored in dense data blocks which are indexed along sparse dimension for retrieval. This storage paradigm enables...
Essbase Overview
Essbase - Cell

A cell is a part of a data block and represent a combination of the dense dimension members. Essbase orders the cells in a data block according to the order of the members in the dense dimensions of the...
Cube Combination
Essbase - Combinations/Intersections

Combination is also known as : intersection, dimension intersection. In Essbase, combinations are denoted by the cross-dimensional operator “->” So : July -> Product A denotes the data...
Essbase Database With All Sparse Standard Dimensions
Essbase - Dense and Sparse Selection Effect on the data storage (performance)

The choice between sparse and dense dimension have a great influence on the storage and therefore on the performance of Essbase. data blockeach unique combinationsparse standard dimension membersdense...
Essbase Overview
Essbase - Index

Essbase creates an index entry for each . The index represents the combinations of sparse standard dimension members. It contains an entry for each unique combination of sparse standard dimension members...
Essbase Overview
Essbase - Locking and unlocking artifacts

Essbase uses a checkout facility for database to ensure that only one user modifies an at one time. This section describes how to lock and unlock artifacts, with the exception of . See . By default,...
Essbase Overview
Essbase - Selection of Dense and Sparse Dimensions

The setting of the dimension as sparse or dense have a lot of influence on the storage. See this article to understand how : . If you match patterns correctly, you can store the existing data in a reasonable...
Card Puncher Data Processing
IO - Block (Batch on device)

A block is a unit of storage representing a fix number of bytes called the block size. It's also known as the minimum unit of transfer. It implements the concept of batch where data is organized into...



Share this page:
Follow us:
Task Runner