Chapter 11

Question 1

What is HOLAP

Answer 1

OLAP implemented as a hybrid of MOLAP and ROLAP. The goal is to get the best of both MOLAP and ROLAP

Question 2

What is DOLAP

Answer 2

DOLAP allows download of “cube” structures to a desktop platform.

Question 3

Does MOLAP build cubes

Answer 3

Yes, MOLAP physically builds “cubes” for direct access

Question 4

What is MDD

Answer 4

Multi-dimensional databases. Multi-dimensional databases use proprietary file formats

Question 5

What are MOLAP cubes

Answer 5

MOLAP cubes are built around dimensions, as corresponding to each dimension is the index of the multi-dimensional array data structure. Meaning, if there are four dimensions, then the data will be stored in a four dimensional array i.e. with four indexes i, j, k and l.

Question 6

What is O(1) in MOLAP

Answer 6

The performance in a MOLAP cube comes from the O(1) look-up time for the array data structure

Question 7

Are there tables in MOLAP

Answer 7

NO. there are cubes

Question 8

Which language is used for MOLAP

Answer 8

MDX by microsoft