What are types of storage modes in OLAP?

OLAP storage modes
There are three standard storage modes in OLAP they are
1.MOLAP — the data and aggregations are stored in a multidimensional format
2.ROLAP — data and aggregations are kept in the relational database instead of on the OLAP server
3.HOLAP — HOLAP is a combination of MOLAP and ROLAP HOLAP stores the detail data in the relational database but stores the aggregations in multidimensional format

What are types of storage modes in OLAP? was last modified: October 1st, 2017 by Justin Antony

About Justin Antony

https://forum.sqlpublic.com

Leave a Reply