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

Code No: RR410509 Set No. 4
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. discuss the role of extract and load process with an exphasis on the subsequent
topics.
(a) Controlling the process
(b) Snapshot and initiating the extract.
(c) Loading the data. [16]
2. (a) discuss horizontal partitioning.
(b) discuss vertical partitioning. [10+6]
3. define the role and importance of hardware architecture of a data warehouse.
discuss with the help of an example situation. [16]
4. (a) define the role access hierarchy of a data warehouse.
(b) The tighter the security the more person oriented. Do you accept the state-
ment? Offer your remarks with justification. [8+8]
5. (a) what are estimation of CPU band width for the various phases involved in
loading data warehouse.
(b) How do you estimate the memory requirement for a data warehouse. [10+6]
6. (a) define the ID3 algorithm of the DECISION TREE construction. Why is it
unsuitable for DATA MINING applications? [4+4]
(b) discuss about CHAID algorithms. [8]
7. (a) What is concept hierarchy? How is it related to web mining? [3+5]
(b) Which frequent itemset mining is suitable for text mining and why. Explain?
[8]
8. (a) How do you handle spatial and non-spatial data, while carrying out any mining
task?
(b) Propose various neighborhood relationships that can be used for density-
based clustering of spatial data. [8+8]

Earning:   Approval pending.