Free Business Intelligence Practice Tests - Online Analytical Processing
OLAP Models | Business Intelligence Tutorials
A very important point to cover is here OLAP models Cube. An OLAP Cube is simply an array of data and start from 0 and range upto any dimension. In OLAP, a cube is stored data in data warehouse, and can be analyzed in any of three forms ROLAP, MOLAP or HOLAP.
MOLAP
MOLAP is the traditional model of OLAP system. In MOLAP a multi-dimensional database is used (but not a Relational Database) and data is stored in multi-dimensional cubes. The advantage of this technique is to make database provide quick information, and result in excellent query performance.
ROLAP
In ROLAP model, a relational database is used. Since the data is stored in database, ROLAP model uses the traditional OLAP functions i.e. Slicing and Dicing.
