Data Warehousing, Mining and Business Intelligence - May 2013

Information Technology (Semester 7)

TOTAL MARKS: 100
TOTAL TIME: 3 HOURS (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 :-

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)