MCA-501 Data
Warehousing and Mining:
UNIT – I
Motivation, importance, Data type
for Data Mining : relation Databases, Data Warehouses, Transactional databases, advanced database
system and its applications, Data mining Functionalities: Concept/Class description, Association Analysis
classification & Prediction, Cluster Analysis, Outlier Analysis,Evolution Analysis, Classification
of Data Mining Systems, Major Issues in Data Mining.
UNIT – II
Data Warehouse and OLAP Technology
for Data Mining: Differences between Operational Database Systems and Data Warehouses, a
multidimensional Data Model, Data Warehouse Architecture, Data Warehouse Architecture, Data
Warehouse Implementation, Data Cube Technology.
UNIT- III
Data Preprocessing: Data Cleaning,
Data Integration and Transformation, Data Reduction, Discretization and Concept Hierarchy Generation.
Data Mining Primitives, Languages, and System Architectures,Concept Description:
Characterization and Comparison, Analytical Characterization.
UNIT – IV
Mining Association Rules in Large
Databases: Association Rule Mining: Market Basket Analysis, Basic Concepts, Mining
Single-Dimensional Boolean Association Rules from Transactional Databases: the Apriori algorithm, Generating
Association rules from Frequent items, Improving the efficiency of Apriory, Mining Multilevel
Association Rules, multidimensional Association Rules, Constraint-Based Association Mining.
UNIT – V
Classification & Prediction
and Cluster Analysis: Issues regarding classification & prediction,
Different Classification Methods,
Prediction, Cluster Analysis, Major Clustering Methods, Applications &
Trends in Data Mining: Data Mining
Applications, currently available tools.
BOOKS:
1. J. Han and M. Kamber, “Data
Mining: Concepts and Techniques”, Morgan Kaufmann Pub.
2. Berson “Dataware housing, Data
Mining & DLAP, @004, TMH.
3. W.H. Inmon “ Building the
Datawarehouse, 3ed, Wiley India.
4. Anahory, “Data Warehousing in
Real World”, Pearson Education.
5. Adriaans, “Data Mining”,
Pearson Education.
6. S.K. Pujari, “Data Mining
Techniques”, University Press, Hyderabad.
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
