JNTU B.Tech Examinations, DATA WAREHOUSING AND DATA MINING, Aug/Sep 2008

JNTU B.Tech Examinations, DATA WAREHOUSING AND DATA MINING,

Aug/Sep 2008

DATA WAREHOUSING AND DATA MINING

(Information Technology)

Time: 3 hours Max Marks: 80

Answer any FIVE Questions

All Questions carry equal marks

SET-II

1. (a) Explain data mining as a step in the process of knowledge discovery.

(b) Differentiate operational database systems and data warehousing. [8+8]

 

2. Explain various data reduction techniques. [16]

 

3. (a) Briefly discuss the various forms of Presenting and visualizing the discovered

patterns.

(b) Discuss about the objective measures of pattern interestingness. [8+8]

 

4. (a) What are the differences between concept description in large data bases and

OLAP?

(b) Explain about the graph displays of basic statistical class description. [8+8]

 

5. (a) Which algorithm is an influential algorithm for mining frequent item sets for

Boolean association rules? Explain.

(b) What are additional rule constraints to guide mining? Explain. [8+8]

 

6. The following table consists of training data from an employee database. The data

have been generalized. For a given row entry, count represents the number of data

tuples having the values for department, status, age, and salary given in that below:

Department status age salary count

Sales Senior 31…35 46K….50K 30

Sales Junior 26…30 26K…30K 40

Sales Junior 31…35 31K…35K 40

Systems Junior 21…25 46K…50K 20

Systems Senior 31…35 66K…70K 5

Systems Junior 26…30 46K…50K 3

Systems Senior 41…45 66K…70K 3

Marketing Senior 36…40 46K…50K 10

Marketing Junior 31…35 41K…45K 4

Secretary Senior 46…50 36K…40K 4

Secretary Junior 26…30 26K…30K 6

Let salary be the class label attribute.

Design a multilayer feed-forward neural network for the given data. Label the nodes

in the input and output layers. [16]

 

7. (a) Define mean absolute deviation, z-score, city block distance, and minkowski

distance.

(b) What are different types of hierarchical methods? Explain. [2+2+2+2+8]

 

8. (a) Define spatial database, multimedia database, time-series database, sequence

database, and text database.

(b) What is web usage mining? Explain with suitable example. [10+6]

Leave a Comment