Chapter 10

Question 1

What is OLAP

Answer 1

OLAP is Online Analytical Processing. It is also NOT a physical database design or implementation technique, but a framework.

Question 2

What is OLTP

Answer 2

Online Transaction Processing

Question 3

What is the difference between OLAP and OLTP

Answer 3

OLAP implementations are either highly de-normalized or completely de-normalized, while OLTP implementations are fully normalized. OLAP use by DWH and OLTP use by traditional database applications

Question 4

What is field of dreams scenario

Answer 4

Dataware house developers sometimes refer to the importance of intuitiveness to the users as the “field of dreams scenario”

Question 5

Does Analytical processing uses multi-level aggregates, instead of record level access.

Answer 5

Yes

Question 6

Does OLAP a characterization of applications or database design technique

Answer 6

Characterization of applications

Question 7

What is MOLAP

Answer 7

Multidimensional OLAP. In MOLAP, the results are displayed as tables, along with different types of charts, such as histogram, pie etc.

Question 8

What is minimum number of dimensions that must be handled in MOLAP

Answer 8

No limit