Skip to content
CampusPrep
CY-604 (C) · Dataware Housing & Mining/Official Syllabus

Dataware Housing & Mining (CY-604 (C)) - Official Syllabus

1
Unit 1

Data Warehousing

  • Need for data warehousing, Basic elements of data warehousing, Data Mart
  • Data Warehouse Architecture, extract and load Process, Clean and Transform data
  • Star, Snowflake and Galaxy Schemas for Multidimensional databases, Fact and dimension data
  • Partitioning Strategy-Horizontal and Vertical Partitioning
2
Unit 2

Data Warehouse and OLAP technology

  • Multidimensional data models and different OLAP Operations
  • OLAP Server: ROLAP, MOLAP, Data Warehouse implementation
  • Efficient Computation of Data Cubes, Processing of OLAP queries, Indexing data
3
Unit 3

Data Mining

  • Data Preprocessing, Data Integration and Transformation, Data Reduction, Discretizaion and Concept Hierarchy Generation
  • Basics of data mining, Data mining techniques, KDP (Knowledge Discovery Process)
  • Application and Challenges of Data Mining, Introduction of Web Structure Mining, Web Usage Mining, Spatial Mining, Text Mining
  • Security Issue, Privacy Issue, Ethical Issue
4
Unit 4

Mining Association Rules in Large Databases

  • Association Rule Mining, Single-Dimensional Boolean Association Rules, Multi-Level Association Rule
  • Apriori Algorithm, Fp-Growth Algorithm
  • Time series mining association rules, latest trends in association rules mining
5
Unit 5

Classification and Clustering

  • Distance Measures, Types of Clustering, K-Means Algorithm
  • Decision Tree Induction, Bayesian Classification, Association Rule Based, Other Classification Methods
  • Prediction, Classifier Accuracy
  • Categorization of methods, Partitioning methods, Outlier Analysis

Reference Books

  • Data Warehousing Fundamentals
  • Data Mining Concepts & Techniques
  • Data Mining Introductory & Advanced Topics
  • The Data Warehouse Lifecycle Tool Kit
  • Master in Data Mining
  • Building the Data Ware houses
  • The Decision Support & Data Warehouse Systems
Go to where you left off?

Quick Add to Notes

Save questions, your own notes and screenshots into notes filed by unit. It takes a free account.

Create free account

Have an account? Log in