Question Paper: Data Warehousing, Mining and Business Intelligence : Question Paper May 2013 - Information Technology (Semester 7) | Mumbai University (MU)

Data Warehousing, Mining and Business Intelligence - May 2013

Information Technology (Semester 7)

(1) Question 1 is compulsory.
(2) Attempt any four from the remaining questions.
(3) Assume data wherever required.
(4) Figures to the right indicate full marks.
1 (a) Give different between OLTP and OLAP(5 marks) 1 (b) Explain DBSCAN.(5 marks) 1 (c) Give difference between Classification and Clustering.(5 marks) 1 (d) Explain constraint based association rule mining.(5 marks) 1 (e) Explain Regression.(5 marks) 2 (a) List the dimension and facts for hospital management system and also draw star schema and snowfalke schema.(10 marks) 2 (b) Why preprocessing is required?(5 marks) 2 (c) Explain multidimention association rule.(5 marks) 3 (a) What is web structure mining? Explain Technique of web structure mining.(10 marks) 3 (b) Explain data descritization and summarization with example.(10 marks) 4 (a) Define the following terms with example-
(i) Item set (ii) frequency item set (iii) closed item set.
(10 marks)
4 (b) What is Market basket analysis? Explain its use.(10 marks) 5 (a) Following table gives fat and proteins content of items. Apply single linkage clustering and construct dendrogram :-

Food Item Protein Fat
1 1.1 60
2 8.2 20
3 4.2 35
4 1.5 21
5 7.6 15
6 2.0 55
7 3.9 39
(10 marks) 5 (b) Explain spatial data mining (SDM). Also explain a model of spatial data warehouse.(10 marks) 6 (a) Use k-mean Algorithm to create three cluster for given set of values :-
(10 marks)
6 (b) Explain Hoeffding tree algorithm with example.(10 marks)

Write short notes on any three :-

7 (a) Spatial data cube construction(7 marks) 7 (b) Bayesian classification(7 marks) 7 (c) Text mining approaches (7 marks) 7 (d) Issue in data mining(7 marks)

Please log in to add an answer.