Scribd
Upload
524 views

Data Warehousing & Data Mining

The document outlines the topics and proposed lecture hours for a course on data warehousing and data mining. It is divided into 5 units that cover: 1) an introduction to data warehousing components and models; 2) data warehouse processes, technologies, and infrastructure; 3) an overview of data mining techniques for preprocessing, reduction, and modeling; 4) classification and clustering algorithms; and 5) data visualization, OLAP, applications, and trends. The course aims to provide students with 08 lecture hours per unit on key concepts and methods in data warehousing and mining.

Uploaded by

Anmol
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
524 views

Data Warehousing & Data Mining

The document outlines the topics and proposed lecture hours for a course on data warehousing and data mining. It is divided into 5 units that cover: 1) an introduction to data warehousing components and models; 2) data warehouse processes, technologies, and infrastructure; 3) an overview of data mining techniques for preprocessing, reduction, and modeling; 4) classification and clustering algorithms; and 5) data visualization, OLAP, applications, and trends. The course aims to provide students with 08 lecture hours per unit on key concepts and methods in data warehousing and mining.

Uploaded by

Anmol
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

KOE093: DATA WAREHOUSING & DATA MINING

DETAILED SYLLABUS 3-1-0


Unit Topic Proposed
Lecture
I Data Warehousing: Overview, Definition, Data Warehousing 08
Components, Building a Data Warehouse, Warehouse Database, Mapping
the Data Warehouse to a Multiprocessor Architecture, Difference between
Database System and Data Warehouse, Multi Dimensional Data Model,
Data Cubes, Stars, Snow Flakes, Fact Constellations, Concept.
II Data Warehouse Process and Technology: Warehousing Strategy, 08
Warehouse /management and Support Processes, Warehouse Planning and
Implementation, Hardware and Operating Systems for Data Warehousing,
Client/Server Computing Model & Data Warehousing. Parallel Processors
& Cluster Systems, Distributed DBMS implementations, Warehousing
Software, Warehouse Schema Design
III Data Mining: Overview, Motivation, Definition & Functionalities, Data 08
Processing, Form of Data Pre-processing, Data Cleaning: Missing Values,
Noisy Data, (Binning, Clustering, Regression, Computer and Human
inspection), Inconsistent Data, Data Integration and Transformation. Data
Reduction:-Data Cube Aggregation, Dimensionality reduction, Data
Compression, Numerosity Reduction, Discretization and Concept
hierarchy generation, Decision Tree
IV Classification: Definition, Data Generalization, Analytical 08
Characterization, Analysis of attribute relevance, Mining Class
comparisons, Statistical measures in large Databases, Statistical-Based
Algorithms, Distance-Based Algorithms, Decision Tree-Based
Algorithms.
Clustering: Introduction, Similarity and Distance Measures, Hierarchical
and Partitional Algorithms. Hierarchical Clustering- CURE and
Chameleon. Density Based Methods DBSCAN, OPTICS. Grid Based
Methods- STING, CLIQUE. Model Based Method – Statistical Approach,
Association rules: Introduction, Large Item sets, Basic Algorithms,
Parallel and Distributed Algorithms, Neural Network approach.
V Data Visualization and Overall Perspective: Aggregation, Historical 08
information, Query Facility, OLAP function and Tools. OLAP Servers,
ROLAP, MOLAP, HOLAP, Data Mining interface, Security, Backup and
Recovery, Tuning Data Warehouse, Testing Data Warehouse.
Warehousing applications and Recent Trends: Types of Warehousing
Applications, Web Mining, Spatial Mining and Temporal Mining.

Suggested Readings:
1. Alex Berson, Stephen J. Smith “Data Warehousing, Data-Mining & OLAP”, McGrawHil.
2. Mark Humphries, Michael W. Hawkins, Michelle C. Dy, “Data Warehousing: Architecture and
Implementation”, Pearson Education..
3. I. Singh, “Data Mining and Warehousing”, Khanna Publishing House.
4. Margaret H. Dunham, S. Sridhar,”Data Mining:Introductory and Advanced Topics” Pearson
Education.

Open Elective List (VIII Semester) 2021-22 Page 17

You might also like