BAMU · Final Year B.E. Computer Science and Engineering · CBCS (2019)
Data Warehousing and Data Mining
CSE401 · Semester VII · 4 credits · CT 20 + theory 80
Unit 1: Data Warehousing
6 hoursData warehouse basic concepts and multitiered architecture; enterprise warehouses and data marts; extraction, transformation and loading; the metadata repository.
Examined in the 80-mark end-semester paper
- Data warehouse concepts and architecture
- Enterprise warehouses and data marts
- ETL and the metadata repository
Unit 2: Data Warehouse Modelling and Implementation
8 hoursData cubes and the multidimensional model; 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
Unit 3: Data Mining
6 hoursData and its types; data mining functionalities and interestingness of patterns; classification of data mining systems and task primitives; integration with a warehouse; issues and preprocessing.
Examined in the 80-mark end-semester paper
- Data mining and the KDD process
- Data mining functionalities and task primitives
- Data cleaning and integration
- Data reduction and discretisation
Unit 4: Association Rule Mining and Classification
8 hoursFrequent patterns, associations and correlations; mining methods and kinds of association rules; correlation and constraint-based mining; decision trees, Bayesian and rule-based classification, SVMs and regression models.
Examined in the 80-mark end-semester paper
- Frequent itemsets and association rules
- Apriori algorithm
- Correlation analysis and constraint-based association mining
- Decision tree induction
- Bayes and naive Bayes classification
- Rule-based classification
- Support vector machines and regression models for prediction
Unit 5: Clustering
6 hoursCluster analysis and clustering methods: k-means, hierarchical, agglomerative and divisive clustering; web content, structure and usage mining.
Examined in the 80-mark end-semester paper
- Cluster analysis: K-means and K-medoids
- Hierarchical and density-based clustering
- Web mining and recommender systems
Unit 6: Business Intelligence
6 hoursBusiness intelligence, its tools, infrastructure and applications; BI versus data warehouse and data mining; the future of BI.
Examined in the 80-mark end-semester paper
- Business intelligence: tools, infrastructure and applications
- BI versus data warehousing and data mining
Unit contents are summarised from the official BAMU syllabus . AiCanCode.org is not affiliated with Dr. Babasaheb Ambedkar Marathwada University (BAMU).