SNSCT/IQAC/ F 1.
SNS COLLEGE OF TECHNOLOGY
COIMBATORE-35
DEPARTMENT OF INFORMATION TECHNOLOGY
Staff InCharge : Dr.J.Shanthini
Semester : III
Academic Year : 2014-2015
- Odd Semester
Course : Data warehousing &Data Mining
Class : II Year M.Tech.IT
LESSON PLAN
Method of
No. of
Instruction
Periods
UNIT I Data Warehousing and Business Analysis
Data warehousing Components Building
Black board
1
a Data warehouse
Mapping the Data Warehouse to a
PPT , Black
1
board
Multiprocessor Architecture
Black board
1
DBMS Schemas for Decision Support
Data Extraction, Cleanup
Black board
R1
Transformation Tools
Metadata, Query reporting tools and
Applications
Black board
R1
Black board
PPT
Black board
Black board
Black board
Group
Discussion
Black board
R2
R2
Black board
Black board
PPT
Black board
Black board
Black board
R2
R7
Sl.No.
1
2
6
7
8
9
Topic
Online Analytical Processing (OLAP)
OLAP and Multidimensional Data
Analysis.
Revision & University QP Discussion
Unit I
UNIT II
Data Mining Functionalities
Data Preprocessing Data Cleaning
Data Integration and Transformation
Data Reduction Data Discretization and
Concept Hierarchy Generation.
Association Rule Mining
Efficient and Scalable Frequent Item set
Mining Methods
Mining Various Kinds of Association
Rules
Association Mining to Correlation
Analysis
Constraint-Based Association Mining.
10
Revision & University QP Discussion
5
6
7
8
R1
R1
R1
R1
R1
R1
10
Data Mining
Book to be
referred
Unit II
1
1
R2
R2
R2
R2
R2
R2
10
Classification and Prediction
Issues Regarding Classification and
Black board
Prediction
Classification
Black board
by Decision Tree Introduction
Bayesian Classification- Rule Based
OHP
Classification
UNIT III
1
2
3
1
1
R7
R7
SNSCT/IQAC/ F 1.1
Classification by Back propagation
Support Vector Machines
Associative Classification Lazy
Learners
Other Classification Methods
Prediction- Accuracy and Error Measures
Evaluating the Accuracy of a Classifier or
Predictor
Ensemble Methods Model Section
Revision & University QP Discussion
4
5
6
7
PPT
PPT
Black board
Black board
R7
R6
R6
Unit III
UNIT IV
R7
OHP
R7
R7
R7
10
Cluster Analysis
Black board
Black board
PPT
OHP
Types of Data in Cluster Analysis
A Categorization of Major Clustering
Methods
Partitioning Methods Hierarchical
methods
Density-Based Methods Grid-Based
Methods
Model-Based Clustering Methods
Black board
R6
Clustering High Dimensional Data
Black board
R6
Clustering with constraints
PPT
R6
Outlier Analysis and detection methods.
PPT
R6
Revision & University QP Discussion
1
2
3
4
Unit IV
R6
R6
10
R3
UNIT V Mining Object, Spatial, Multimedia, Text and Web Data
Multidimensional Analysis and
Black board
1
Descriptive Mining of Complex Data
Objects
Black board
1
Spatial Data Mining
Multimedia Data Mining
R2
Black board
R2
Text Mining
OHP
R2& R3
Applications and trends in data mining
LCD
R2
Black board
R3
Black board
R3
Data Mining tools: WEKA
Data Mining tools: Rapid
Miner
Big Data.
Black board
R4
Revision & University QP Discussion
Unit V
10
Total Hours : 45[Lecture]+5[Revision]=50
REFERENCES:
R1
Alex Berson and Stephen J. Smith Data Warehousing, Data Mining & OLAP, Tata
McGraw Hill Edition, Thirteenth Reprint 2008.
R2
Jiawei Han and Micheline Kamber Data Mining Concepts and Techniques Elsevier,
Third Edition, print 2011
R3
Ian H. Witten, Eibe Frank, Mark A. Hall Data Mining: Practical Machine Learning
Tools and Techniques Elsevier 2011.
R4
Pete Warden, Big Data Glossary,OReilly , 2011
R5
M.Golfarelli, S.Rizzi, Data warehouse Design: Modern Principles and Methodologies,
SNSCT/IQAC/ F 1.1
R6
R7
R8
McGraw-Hill, 2009.
Margaret H.Dunham,Data Mining: Introductotry and Advanced Topics, Prentice Hall,
2003.
Pang-Ning Tna, Michael Stunbach and Vipin Kumar, Introduction to Data mining
Pearson Addison Wesley, 2005.
Viktor Mayer-Schonberger, Kenneth Cukier, Big Data: A Revolution That Will
Transform How We Live, Work, and Think, 2013.
Staff In Charge
HOD
Principal
