BITM Data Warehousing and Data Mining

Is KDD and Data mining same?

List any two example of categorical data.

What do you understand by “nonvolatile” property of data warehouse?

Define frequent pattern.

What do you mean by training during classification process?

What are the two parameters of DBSCAN?

Is outlier always harmful?

List any two applications of data mining

What do you understand by concept hierarchy?

How do you evaluate a classifier?

Given following dataset, compute information gain of attribute “age” using ID3.

Define lazy learners. List some limitation of k-means.

Given the following dataset: 34, 41, 55, 62, 38, 69, 36, 43, 54, 63, 39, 68. Perform smoothing using bin mean. Use 3 bins.

Explain fact constellation schema with a simple example.

Explain “no materialization” of a data cube. What are its advantage and disadvantage?

How do you detect outlier? Explain any two approaches.

Explain DBSCAN algorithm and its working.

What is OLTP? Differentiate between ROLAP and MOLAP.

Describe the architecture of data warehouse.

How do you measure similarity among data? Explain with example.

What do you understand by association analysis and where can it be used in real life? How do you measure strength of association rules? Given following transaction, construct a FP-Tree.:

(a) Discuss the works performed by load manager, warehouse manager and query manager in a data warehouse.

(b) Write short notes on: (any two)

i. Proximity based outlier detection.

ii. K-fold Cross Validation

iii. Confusion matrix