DATA WAREHOUSING AND DATA MINING

Paper Code: 
MCS 425C
Credits: 
04
Periods/week: 
04
Max. Marks: 
100.00
Objective: 

This Course Focuses on The Study of Basic Concepts of Data Warehousing And Data Mining.

 

12.00
Unit I: 

Introduction To Data Warehousing -Concept And Characteristics of Data Warehouse, Distributed V/S Centralized Data Warehouses, Design Consideration of Data Warehouse ,Tools For Data Warehousing ,Data Warehouse Models ,Architecture Of Data Warehouse And Organizational Issues ,Managing Security In Data Warehouse Environment.

12.00
Unit II: 

OLTP And OLAP Systems And Their Applications, Steps Involved In Project Planning, Management, Project Estimation, Introduction To ROLAP AND MOLAP Application Of Data Warehouse - National Data Warehouses, Census Data, Prices Of Essential Commodities.

                                                   

12.00
Unit III: 

Data Mining:   Introduction, Definition, KDD Vs. DM, DBMS Vs. DM, DM Techniques, Issues And challenges In DM, DM Applications. Association Rules: A Prior Algorithm, Partition, Search, Incremental, Border, FP-Tree Growth Algorithms.          

Classification: Parametric And Non-Parametric Technology: Bayesian Classification, Two Class And Generalized Class Classification, Classification Error, Decision Boundary, Discriminate Functions.

12.00
Unit IV: 

Non-Parametric Methods for Classification. Clustering: Hierarchical And Non-Hierarchical Techniques, K-Medoid Algorithm, Partitioning, Clara, Clarans. Advanced Hierarchical Algorithms.   

                                                                         

12.00
Unit V: 

Decision Trees: Decision Tree Induction, Tree Pruning, Extracting Classification Rules From Decision Trees, Decision Tree Construction Algorithms, Decision Tree Construction With Presorting. Other Techniques For Data Mining: Introduction, Learning, Neural Networks, Data    Mining Using Neural Networks, Genetic Algorithms. Web Mining: Web Mining, Text Mining, Data Mining Tasks.

ESSENTIAL READINGS: 

1. C.S.R Prabhu, “Data Warehousing “, PHI.

REFERENCES: 

1. Trevor Hastic, Robert Tibshirani and Jerome Friedman,”Data mining inference and prediction,” 2009.

2. Ralfh Kimball, Laura Reeves, Margy Ross, ”The Data Warehouse Life Style Toolkit “Wiley Computer Publishing, 2008.

3. David Mand , Heikki  Manniles, Padhraic Smyth, ”Principles Of Data Mining” ,Eastern Economy

Academic Year: