DWDM Unitwise Qns

B.Tech.
(CSE) Seventh Semester

DATA WAREHOUSING AND DATA MINING
Code : EURCS 702
Credits: 3 Hours : 3 per week
Category : CE
Department: CSE
Unit wise important questions

UNIT-I
1. a) Explain the steps in knowledge Data Discovery Process in detail
b) How will you integrate Data Mining System with a Database or Data warehouse
System?
2. a) Explain major issues in data mining
b) Explain Discretization and concept Hierarchy Generation?
3. a) What is Data Mining? What kind of patterns can be mined?
b) Define data stream. Explain different advanced database applications
4. a) What is preprocessing the data? How you will preprocess the data?
b) Explain the architecture of data mining system
5. Answer the following questions:
a) How Operational Data Store differs from Information Data Store?
b) What are the different types of Data Marts?
c) Define the term Data Mining. List any five Data Mining applications
d) Briefly discuss about Data cleaning
6. Explain various Data reduction techniques
UNIT II
1. a) Explain spatial data cube construction and spatial OLAP
b) Briefly discuss about Multidimensional data model
2. a) Write the differences between operational database and data warehouse
b) Briefly describe 3-tier Data warehouse architecture
3. a) What is data warehouse? Explain the differences between operational database system
and data
warehouses
b) How you will construct a multi-dimensional data model? Explain with a suitable
example
4. a) Define data mart. Explain the architecture of data warehousing system
b) How do you lead data warehousing OLAP relate to data mining? Explain
5. a) What are different schemas for multidimensional databases? How will you construct the
schemas? Explain with suitable example?
b) Explain the comparison between OLAP & OLTP technologies
6. a) Explain the implementation of data warehouse

b) Explain the architecture of On-Line Analytical Mining (OLAM)
UNIT III
1. a) Explain Data Generalization and summarization with example
b) Explain different methods for analysis of attribute relevance
2. a) Explain the discrimination between different classes
b) Explain Mining descriptive statistical measures in large databases
3. a) What is data characterization? Explain with example
b) Explain Data Generalization and Summarization with an example
4. a) Explain AOI algorithm with example
b) Explain different methods for analysis of attribute relevance
5. a) What is Concept description? Explain
b) Discuss Mining Class comparisons and Discriminating between different classes
6. a) Discuss about the methods of attribute relevance analysis
b) Discuss about mining Descriptive Statistical Measures in large databases
UNIT IV
1. a) Explain Apriori algorithm with suitable example
b) Explain FP growth algorithm with an example
2. a) Explain various kinds of association rules with an example
b) Explain Constraint-Based association Mining. Explain with an example
3. a) What is mining multi level association rule and explain briefly?
b) Explain the concept of Frequent Itemsets, closed Itemsets and Association Rules?
4. a) Which algorithm is an influential algorithm for mining frequent item sets for Boolean
association rules. Explain
b) Discuss about association mining using correlation rules
5. Write the Apriori algorithm for discovering frequent item sets for mining single
Dimensional Boolean Association Rule and discuss various approaches to improve its
efficiency
6. A Database has five transactions. Let min- sup=60% and min-cont=80%

TID
T100
T200
T300
T400
T500
Items-bought
{M, O, N, K, E, Y}
{D, O, N, K, E, Y}
{M, A, K, E}
{M, U, C, K, Y}
{C, O, O, K, I,
E}
a) Find all frequent item sets using Appriori and FP-Growth respectively. Compare the
efficiency of the two mining processes.
b) List all of the strong association rules (with support s and confidence c) matching the
following metarule, where X is a variable representing customers, and item; denotes variables
representing items: transaction, buys x (X, item1)^ buys (X, item2) => buys (X, item3) [S,C]
UNIT V
1. a) Define classification? Explain Bayesian classification with an example
b) Define Clustering. What are different types of data in cluster analysis?
2. a) Explain classification by Back propagation, with an example
b) Explain the following classification methods
i) Genetic algorithms ii) Roughset Approach iii) Fuzzyset Approach
3. a) Define classification? Explain decision tree Induction algorithm with an example
b) Explain various partitioning clustering methods
4. Explain the categorization of major clustering methods
5. a) What is classification and Predication? What are the different issues between them
b) Explain in detail Bayesian Classification
6. Explain in detail classification by Decision Tree Induction

DWDM Unitwise Qns

Uploaded by

Copyright:

Available Formats

DWDM Unitwise Qns

Uploaded by

Document Information

Original Description:

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

DWDM Unitwise Qns

Uploaded by

Copyright:

Available Formats

B.Tech.

(CSE) Seventh Semester

Unit wise important questions

6. a) Explain the implementation of data warehouse

6. A Database has five transactions. Let min- sup=60% and min-cont=80%

You might also like