CS2032 Data Warehousing And Data Mining Important questions Nov Dec 2013

CS2032 Data Warehousing And Data Mining Important questions Nov Dec 2013 - Anna University CS2032 Important Questions Nov Dec 2013

Unit 1

1. Give the Architecture of Data warehouse and explain its usage.
2. State the difference between OLTP and OLAP in detail.
3. Explain the operations performed on data warehouse with examples.
4. Write short notes on data warehouse Meta data.
5. Explain the Conceptual Modeling of Data Warehouses.

Unit 2

1. Explain major tasks in Data Preprocessing.
2. What is data cleaning? List and explain various techniques used for data cleaning?
3. How is Attribute –Oriented Induction implemented? Explain with an example
4. Why do we preprocess the data? Explain how data preprocessing techniques can improve the quality of the data.
5. List out and describe the primitives for specifying a data mining task.

Unit 3

1. Discuss the following in detail:
             a. Association Mining
             b. Support
             c. Confidence
             d. Rule measures
2. Explain how mining will be done in frequent item sets with an example.
3. Describe join and prune steps in Apriori Algorithm.
4. Discuss the approaches for mining databases multi dimensional association rule from transactional databases. Give suitable examples.
5. (i) Explain the methods to improve the Apriori’s Efficiency.  
      (ii) Construct the FP tree for given transaction DB