IT6702 Data warehousing and Data Mining, Final year, Department of Electrical & Electronics Engineering, First and second Units Questions.

Answers All the Questions
Part – A[10x2=20 marks]
1.      What is data warehousing?
2.      What are the purposes of data warehousing?
3.      What arethe advantages and disadvantages of data warehouses?
4.      What is metadata repository?
5.      What is multidimensional data model (MDDM)?
6.      Explain clustering analysis.
7.      What are the requirements of clustering in data mining?
8.      Explain outlier analysis and approaches of outlier analysis?
9.      What are the types of data in cluster analysis?
10.  What are the methods of clustering High-Dimensional data?
Part – B[16x5=80 marks]
11.  a. i. What is difference between operational database systems and data warehouses?          (8)
 ii. Explain about building a data warehouse?                                                                        (8)

12.  a. i. Briefly explain about mapping the data warehouse to a multiprocessor architecture?    (8)
 ii. Explain components of data warehousing?                                                           (8)
       13.a .i. Briefly explain about the data extraction, cleanup and transformation tools?                (8)        ii. Explain about the major clustering methods?                                                  (8)
 14.a.Explain the types of variables in Data analysis?                                                            (16)

15.a. Explain about outlier analysis?                                                                           (16)