BAMU · Final Year B.E. Information Technology · CBCS (2019)
Data Warehousing and Data Mining
CSE401 · Semester VII · 4 credits · CT 20 + theory 80
Unit 1: Data Warehousing
6 hoursData warehouse basics, the multitiered architecture, enterprise warehouses and data marts, ETL and the metadata repository.
Examined in the 80-mark end-semester paper
- Data warehouse architecture
- Data warehouse components and metadata
- ETL
Unit 2: Data Warehouse Modeling and Implementation
8 hoursThe data cube and star, snowflake and fact-constellation schemas; concept hierarchies and measures; OLAP operations; data objects, attribute types, statistical descriptions and similarity measures.
Examined in the 80-mark end-semester paper
- Star, snowflake and fact constellation schemas
- Data cube and OLAP operations
- OLAP: ROLAP, MOLAP and HOLAP
- Measuring data similarity and dissimilarity
Unit 3: Data Mining
6 hoursKinds of data, data mining functionalities and interestingness of patterns, classification of systems, task primitives, integration with a warehouse, issues and preprocessing.
Examined in the 80-mark end-semester paper
- Active databases and the KDD process
- Data mining functionalities and system classification
- Data cleaning and transformation
Unit 4: Association Rule Mining and Classification
8 hoursFrequent patterns, association and correlation mining, constraint-based mining; decision trees, Bayesian and rule-based classification, SVMs and regression models.
Examined in the 80-mark end-semester paper
- Association rules and the Apriori algorithm
- Decision tree and Bayesian classification
- Support vector machines and regression models
Unit 5: Clustering
6 hoursCluster analysis; k-means, hierarchical, agglomerative and divisive clustering; web content, structure and usage mining.
Examined in the 80-mark end-semester paper
- Clustering: partitioning, hierarchical and density-based methods
- Web content, structure and usage mining
Unit 6: Business Intelligence
6 hoursBusiness intelligence, its tools, infrastructure and applications; BI versus data warehousing and data mining; the future of BI.
Examined in the 80-mark end-semester paper
- Business intelligence tools and applications
Unit contents are summarised from the official BAMU syllabus . AiCanCode.org is not affiliated with Dr. Babasaheb Ambedkar Marathwada University (BAMU).