In the original: "Bi thing" cube storage
Relational OLAP (ROLAP)
The basic data and aggregated data of ROLAP are stored in the relational database;
The ROLAP storage mode enables the aggregation of the partitions to be stored in the tables of the relational database (specified in the partitioned data source). However, you can use the ROLAP storage mode for partitioned data instead of creating aggregations in the relational database.
The data that uses the ROLAP dimension is actually stored in the table that defines the dimension. Low relative query performance.
Multidimensional OLAP (MOLAP)
The basic data and aggregated data of Mloap are stored in multidimensional database;
MOLAP storage mode enables the aggregation of partitions and copies of their source data to be stored on the Analysis server computer in a multidimensional structure. The MOLAP storage mode provides the potential to achieve the fastest query response time, based on the percentage and design of the partition aggregation. In summary, MOLAP is more suitable for partitioning in frequently used cubes and for fast query response needs.
Data for dimensions that use MOLAP is stored in a multidimensional structure in an analysis Services instance. High relative query performance.
Mixed OLAP (HOLAP)
HOLAP basic data is stored in a relational database and aggregated data is stored in a multidimensional database.
The HOLAP storage mode combines the characteristics of both MOLAP and ROLAP.
A combination of ROLAP and MOLAP storage methods.
Comparison of different storage modes
Mode |
Query time |
Delay |
Processing time |
Storage size |
MOLAP |
Fast |
High |
Fast |
Medium |
ROLAP |
Slow |
Low |
Slow |
Big |
HOLAP |
Medium |
Medium |
Fast |
Small |
"Bi thing" cube storage