SGBAU · Third Year B.E. Computer Science and Engineering · NEP 2020
Data Warehousing and Mining
6CS235PE1 · Elective III · Semester VI · 3 credits · IE 40 + ESE 60
One of the Elective III options.
Unit 1: Introduction to Data Mining
6 hoursWhy data mining, what it is, the kinds of data and patterns that can be mined, the technologies used, target applications, and the major issues and challenges.
Examined in the 60-mark end-semester paper
- Data mining and the KDD process
- Data mining functionalities and task primitives
Unit 2: Getting to Know Your Data
6 hoursData objects and attribute types, basic statistical descriptions, visualisation techniques, and measuring similarity and dissimilarity.
Examined in the 60-mark end-semester paper
- Attribute and data types
- Normalisation and distance measures
- Descriptive statistics
Unit 3: Data Preprocessing
6 hoursAn overview of preprocessing, cleaning, integration, reduction, transformation and discretisation.
Examined in the 60-mark end-semester paper
- Data cleaning and integration
- Data reduction and discretisation
- Principal component analysis for data reduction
Unit 4: Data Warehousing and OLAP
6 hoursData-warehouse concepts and modelling, the data cube and OLAP operations, design, usage and implementation, and data lakes and data oceans.
Examined in the 60-mark end-semester paper
- Data warehouse concepts and architecture
- Star, snowflake and fact constellation schemas
- Data cubes and OLAP
- OLAP operations
- Enterprise warehouses and data marts
Unit 5: Data Cube Technology
6 hoursData-cube computation and its methods, processing advanced queries with cube technology, and multidimensional analysis in cube space.
Examined in the 60-mark end-semester paper
- Data cube computation and multidimensional analysis
Unit 6: Mining Frequent Patterns, Associations and Correlations
6 hoursFrequent-pattern mining, frequent-itemset methods, generating association rules, and pattern evaluation and interestingness measures.
Examined in the 60-mark end-semester paper
- Frequent itemsets and association rules
- Apriori algorithm
- FP-growth algorithm
- Correlation analysis and constraint-based association mining
Unit contents are summarised from the official SGBAU syllabus . AiCanCode.org is not affiliated with Sant Gadge Baba Amravati University (SGBAU).