COMPUTER APPLICATIONS 2022
DATA WAREHOUSING AND DATA MINING
Course Code: 22CA3118 LTPC
3 0 0 3
COURSE OUTCOMES:
At the end of the course student will be able to
CO1: Interpret the problem in real time applications, and apply the appropriate data mining technique
for effective results.(L2)
CO2: Apply different conceptions of data mining and compute OLAP operations.(L3)
CO3: List associations and correlations in the given Information domain.(L1)
CO4: Apply basic techniques of classification for various applications like banks, health organizations
etc.(L3)
CO5: Analyze the real time data using various clustering techniques.(L4)
UNIT-I (10 Lectures)
Introduction: Fundamentals of data mining, Data Mining Functionalities, Classification of Data Mining
systems, Major issues in Data Mining, Data Warehouse and OLAP Technology for Data Mining Data
Warehouse, Multidimensional Data Model, Data Warehouse Architecture, Data Warehouse
Implementation, Further Development of Data Cube Technology, From Data Warehousing to Data
Mining,
Learning Outcomes:
At the end of the module, students will be able to
Describe concepts of data mining and its functionalities. (L2)
Classify OLAP technology, warehouse architecture and its implementation. (L4)
Develop the data cube technology. (L3)
UNIT-II (10 Lectures)
Data Preprocessing: Needs Preprocessing the Data, Data Cleaning, Data Integration and Transformation,
Data Reduction, Discrimination and Concept Hierarchy Generation, Online Data Storage.
Data Mining Primitives, Languages, and System Architectures: Data Mining Primitives, Data Mining
Query Languages, Designing Graphical User Interfaces Based on a Data Mining Query Language
Architectures of Data Mining Systems,
Learning Outcomes:
At the end of the module, students will be able to
Demonstrate data preprocessing. (L3)
Explain the primitives and query languages of data mining. (L2)
Build GUI based data mining query language. (L3)
COMPUTER APPLICATIONS 2022
UNIT-III (10 Lectures)
Concepts Description: Characterization and Comparison: Data Generalization and Summarization-Based
Characterization, Analytical Characterization: Analysis of Attribute Relevance, Mining Class
Comparisons: Discriminating between Different Classes, Mining Descriptive Statistical Measures in
Large Databases.
Mining Association Rules in Large Databases: Association Rule Mining, Mining Single-Dimensional
Boolean Association Rules from Transactional Databases, Mining Multilevel Association Rules from
Transaction Databases, Mining Multidimensional Association Rules
from Relational Databases and Data Warehouses, From Association Mining to Correlation Analysis,
Constraint-Based Association Mining.
Learning Outcomes:
At the end of the module, students will be able to
Explain characterization and comparison. (L3)
Illustrate the analytical characterization and mining class comparisons. (L4)
Categorize different levels of mining association rules in large databases. (L4)
UNIT-IV (10 Lectures)
Classification and Prediction-1: Issues Regarding Classification and Prediction, Classification by
Decision Tree Induction, Bayesian Classification, Rule-Based Classification, Classification by Back
propagation.
Classification and Prediction-2: Support Vector Machines, Association Classification, Other
Classification Methods, Prediction, Accuracy and Error Measures, Evaluating the Accuracy of a
Classifier or Predictor.
Learning Outcomes:
At the end of the module, students will be able to
Explain issues regarding classification and prediction. (L2)
Apply basic techniques of classification like Decision tree, Bayesian, rule –based and
back propagation. (L3)
Illustrate support vector machines and other association classifications. (L4)
Compare accuracy of a classifier and predictor. (L4)
UNIT- V (10 Lectures)
Cluster Analysis Introduction: Types of Data in Cluster Analysis, A Categorization of Major Clustering
Methods, Partitioning Methods: K-Means Clustering Algorithm, Hierarchical Methods: BIRCH
Multiphase Hierarchical Clustering using Clustering Features Trees, Density-Based Methods: DBSCAN
Density-Based clustering based on connected Regions with High Density, Grid-Based Methods: STING-
STatistical INformation Grid, Introduction to Outlier Analysis- What are Outliers?, Types of Outliers
and Challenges.
.
COMPUTER APPLICATIONS 2022
Learning Outcomes:
At the end of the module, students will be able to
Describe different types of clustering analysis. (L2)
Categorize various clustering methods. (L4)
Summarize outlier Analysis. (L2)
TEXT BOOKS:
1. Jiawei Han & Micheline Kamber, “Data Mining – Concepts and Techniques”, 3rd Edition, Morgan
Kaufmann Publishers, 2008.
2. Margaret H Dunham, “Data Mining Introductory and advanced topics”, 6th Edition, Pearson
Education, 2009.
REFERENCES:
1. Arun K Pujari, “Data Mining Techniques”,1st Edition, University Press, 2005.
2. Pang- Ning Tan, Michael Steinbach, Vipin Kumar, “Introduction to Data Mining”, 1st Edition,
Pearson Education,2012.
3. Sam Aanhory& Dennis Murray, “Data Warehousing in the Real World”, 1st Edition, Pearson
Edition, Asia,2008.
4. PaulrajPonnaiah, “Data Warehousing Fundamentals”, 1st Edition, Wiley student Edition,2007.
5. Ralph Kimball, “The Data Warehouse Life Cycle Tool Kit”, 2nd Edition, Wiley student Edition,
2005.
