Jawaharlal Nehru Technological University Hyderabad 2005-1st Sem B.E Computer Science DATA MINING AND WAREHOUSING IV B.TechRegular s, emr set 2 - Question Paper

Code No: RR410509 Set No. 2
IV B.Tech I Semester Regular Examinations, November 2005
DATA MINING AND WAREHOUSING
( Common to Computer Science & Engineering and info
Technology)
Time: three hours Max Marks: 80
ans any 5 ques.
All ques. carry equal marks
? ? ? ? ?
1. provide an introduction of Delivery process in Data Warehouse. [16]
2. (a) discuss difference ranging from designing a DataWarehouse and an OLTP system.
(b) discuss fact table identification process. [8+8]
3. define the role and importance of hardware architecture of a data warehouse.
discuss with the help of an example situation. [16]
4. (a) Why is it important to get all the security and audit requirements clearly
documented ?
(b) “Data movement is an expensive process“ Justify [8+8]
5. (a) What is the significance of performance assessment before tuning the ware-
house.
(b) discuss the AD hoc query tuning mechanism in a data warehouse. [10+6]
6. (a) What is a Decision Tree? elaborate the advantages and disadvantages of
DECISION TREE classifications? [3+5]
(b) For the provided data set create a Decision Tree? And discuss about the knowl-
edge found from it. [4+4]
OUTLOOK TEMP(F) HUMIDITY(%) WINDY CLASS
sunny 79 90 actual play
sunny 56 70 Flase play
sunny 79 75 actual no play
sunny 60 90 actual no play
overcast 88 88 False no play
overcast 63 75 actual play
overcast 88 95 False play
Rain 78 60 False play
Rain 66 70 False no play
Rain 68 60 actual p lay
7. (a) What is concept hierarchy? How is it related to web mining? [3+5]
(b) What is page Rank, and How is it computed? How it is related to web mining?
[3+2+3]
8. (a) What is spatial trend? discuss about the spatial pattern detection algorithm.
[3+5]
(b) What is spatial clustering? Write about spatial characterization. [3+5]

Earning:   Approval pending.