GTU Information Technology (Semester 7)
Data Warehousing And Data Mining
December 2015
Total marks: --
Total time: --
INSTRUCTIONS
(1) Assume appropriate data and state your reasons
(2) Marks are given to the right of every question
(3) Draw neat diagrams wherever necessary


1(a) Draw and explain the data warehouse architecture.
7 M
1(b) What is OLAP? Give the difference between OLAP and OLTP.
7 M

2(a) What do you mean by data mart? What are the different types of data mart?
7 M
Solve any one question from Q.2(b) & Q.2(c)
2(b) List out the different schema of data warehouse and explain one of the data warehouse schemas in detail with suitable diagram.
7 M
2(c) Explain detail about OLAP servers.
7 M

Solve any one question from Q.3 & Q.4
3(a) Draw and explain the data mining architecture.
7 M
3(b) What is data cleaning? Describe the different methods of handling missing values during data cleaning.
7 M

4(a) Explain the major issues in data mining.
7 M
4(b) What is data transformation? Explain the different data transformation approaches for transforming data.
7 M

Solve any one question from Q.5 & Q.6
5(a) Describe the various criteria for the classification of frequent pattern mining.
7 M
5(b) Explain the following as attribute selection measure:
(i) Information Gain
(ii) Gain Ratio
7 M

6(a) Write and explain the algorithm for mining frequent itemsets without candidate itemsets generation with suitable example.
7 M
6(b) Explain the various methods which evaluate the accuracy of a classifier or a predictor.
7 M

Solve any one question from Q.7 & Q.8
7(a) Explain the typical requirements of clustering in data mining.
7 M
7(b) Write a short note on Web mining.
7 M

8(a) Describe and explain the different types of clustering methods.
7 M
8(b) Write a short note on text mining.
7 M



More question papers from Data Warehousing And Data Mining
SPONSORED ADVERTISEMENTS