For each of the following items, explain the underlying concepts, typical applications and any additional technical or implementation points if appropriate. Support your discussion with suitable diagrams and/or examples.
(i) OLAP For example, discuss different implementations of OLAP, SQL and OLAP, aggregation
(ii) Multi-Dimensional Data For example, discuss roll-up, pivoting and what each dimension could represent,
(iii) Data Mining For example, discuss patterns in data, techniques to identify these, data preparation, tools and predictions.

(Advanced Database Systems Course)