OLAP

Question 1

OLAP

Answer 1

Online Analytical Processing

Question 2

OLAP software

Answer 2

Enables multi-dimensional analysis of data.

Question 3

Multi-dimensional analysis?

Answer 3

Users can look at data from many different dimensions at the same time
And can request which dimensions they wish to look at the data across

Question 4

Relational OLAP

Answer 4

Data is stored in a relational database.
Can store or calculate data summaries
Can create a star schema to view data across dimensions

Question 5

MOLAP (multidimensional)

Answer 5

Data is stored in a multidimensional database.

Each cell in the DB is a in a hypercube array at the intersection of all dimensions

Limited space - some cells can be empty

Question 6

HOLAP (hybrid)

Answer 6

High level data is stored in multidimensional database and underlying is in original tables

Needs a robust link between multidimensional DB part and underlying base data

Question 7

Slice and dice

Answer 7

Data is understood in 2D
So we constrain other dimensions (by picking values or summarising) and display only the slide of data we want (the dimension we want)

Question 8

Drill across

Answer 8

To take a different slice of the data