Section B: Online Analytical Processing and Data Mining $[74]$

The focus of this question is to guide you towards an understanding of online analytical processing $($OLAP$)$ and

data mining. To answer these questions, it is expected that you will google to find answers to the questions.

$1.$ Provide a definition of OLAP. $(3)$

$2.$ What is an OLAP cube? $(3)$

$3.$ The OLAP cube enables four basic types of multidimensional data analysis, namely drill$-$down, roll up$,$

slice and dice, and pivot. Describe each of these, and provide an example for each. $(12)$

$4.$ What are the main differences between OLAP and online transaction processing $($OLTP$)?(4)$

$5.$ What is data mining? $(2)$

$6.$ What are the differences between OLAP and data mining? Illustrate the differences with examples. $(6)$

$7.$ What are the main steps within a data mining process? Describe each of these steps. $(12)$

$8.$ Discuss $($shortly$)$ whether or not each of the following activities is a data mining task:

$($a$)$ Dividing the customers of a company according to their profitability. $(2)$

$($b$)$ Predicting the outcomes of tossing a $($fair$)$ pair of dice. $(2)$

$($c$)$ Understanding the profile of customers who default their loan within the first year of the loan. $(2)$

$9.$ Describe the following two terms to make the differences between these two terms clear: Exploratory data

analysis and data mining $($or knowledge discovery from data$).(6)$

$10.$ Discuss an application where data mining has been used successfully in any industry. In your discussion,

name the industry, discuss the tools used and the data, the objectives, and the main findings. $(8)$

$11.$ Discuss the role that feature selection plays within knowledge extraction approaches. $(6)$

$12.$ The following questions refer to text mining:

$($a$)$ What is text mining? $(2)$

$($b$)$ Discuss the difficulties encountered in text mining compared to mining tabular data. $(4)$