AI-Powered Learning Platform

Subject Syllabus

CSIT-802 (A) - Data Warehousing & Mining

CSIT · Semester 8

Course Modules

Learn topic-wise with Hyper AI and revise using mapped PYQs.

Introduction Delivery process Data warehouse architecture Data preprocessing: data cleaning, data integration and transformation, and data reduction Data warehouse design: data warehouse schema and partitioning strategy Data warehouse implementation Data marts Meta data Example of a multidimensional data model Introduction to pattern warehousing

Basic concepts OLAP queries Types of OLAP servers OLAP operations Data warehouse hardware and operational design: security, backup and recovery

Data types Quality of data Data preprocessing Similarity measures Summary statistics Data distributions Basic data mining tasks Data mining vs knowledge discovery in databases Issues in data mining Introduction to fuzzy sets and fuzzy logic

Statistical-based algorithms Distance-based algorithms Decision tree-based algorithms Neural network-based algorithms Rule-based algorithms Probabilistic classifiers

Hierarchical algorithms Partitional algorithms Clustering large databases: BIRCH, DBSCAN and CURE algorithms Association rules Parallel and distributed algorithms such as Apriori and FP growth algorithms