Bachelors Level/Fourth Year/Seventh Semester/Science csit/seventh semester/data warehousing and data mining/syllabus wise questions

B.Sc Computer Science and Information Technology

Institute of Science and Technology, TU

Data Warehousing and Data Mining (CSC420)

Year Asked: 2075, syllabus wise question

Cluster Analysis
1.
What is the purpose of cluster analysis in data mining? Explain. [5]
Data Cube Technology
1.
Describe how bitmap and join indexing are used to represent OLAP data. Explain the different components of data warehouse. [10]
2.
Explain OLAP operations with examples. [5]
3.
Describe the significances of pre-computation of data cube. [5]
Introduction to Data Mining
1.
How does KDD differ with data mining? Describe the stages of data mining. [5]
Introduction to Data Warehousing
1.
How different schema are used to model data warehouse? Explain. [5]
Mining Frequent Patterns
1.
Give any two types of association rules with example. Trace the results of using the Apriori algorithm on the grocery store example with support threshold 2 and confidence threshold 60%. Show the candidate and frequent itemsets for each database scan. Enumerate all the final frequent itemsets. Also indicate the association rules that are generated.

$\begin{array}{|c|l|}\hline \text{Transaction\_ID} & \text{Items} \\ \hline \text{T1} & \text{HotDogs, Buns, Ketchup} \\ \text{T2} & \text{HotDogs, Buns} \\ \text{T3} & \text{HotDogs, Coke, Chips} \\ \text{T4} & \text{Chips, Coke} \\ \text{T5} & \text{Chips, Ketchup} \\ \text{T6} & \text{HotDogs, Coke, Chips} \\ \hline \end{array}$
[10]
2.
Explain the primitives of data mining query language. [5]
Mining Spatial, Multimedia, Text and Web Data
1.
List some issues of multimedia mining. Describe how back propagation is used in classification. [10]