September 2010 BE 412706-511707-CSE01 Data warehousing and Data Mining Sathyabama University

Register Number

                               

SATHYABAMA UNIVERSITY

(Established under section 3 of UGC Act, 1956)

Course & Branch: B.E/B. Tech - CSE/DCS/IT

Title of the Paper: Data warehousing and Data Mining

Max. Marks: 80

Sub. Code: 412706-511707-CSE01                       Time: 3 Hours

Date: 06/09/2010                                                    Session: FN

______________________________________________________________________________________________________________________

                                       PART - A                    (10 x 2 = 20)

                        Answer ALL the Questions

1.     Describe a self learning computer system.     

2.     Define Concept Hierarchy.

3.     What is Metadata?

4.     Define a Data warehouse.

5.     Define Datamining.

6.     What is a Datamart?

7.     Describe a Canned Query.

8.     List the OLAP operations.

9.     What is Cold backup?

10.   Distinguish Function Shipping and Data Shipping.

PART – B                       (5 x 12 = 60)

Answer All the Questions

11.   (a) Describe in detail the partitioning strategies practiced in databases of a Data Warehouse.

(b) Explain the various data warehouse design schemas.

(or)

12.   State in detail the role and responsibilities of the Data Warehouse Process Manager.   

13.   (a) Describe the hardware architecture of a Data warehouse.

(b) Explain the working of a parallel query.

(or)

14.   Detail about the security issues in maintaining a data warehouse.

15.   Explain how the size of a database is estimated, to support the growing needs of a data warehouse.

(or)

16.   Explain the various strategies followed in testing a data warehouse.

17.   (a) Explain in detail the types of learning in computer systems (8)

(b) Illustrate how to build a concept hierarchy for the concept TIME.                                                                                         (4)

(or)

18.   Explain the concept of data mining and illustrate how it is different from query tools and datawarehousing.

19.   (a) Explain the six stages of the Knowledge Discovery process.

(8)

(b) Write a short note on data cleaning.                                         (4)

(or)

20.   Explain the construction and working of a back propagation network. 

Share This