RTMNU · Final Year B.Tech Information Technology · CBCS
Data Warehousing & Mining
BTIT701T · Semester VII · 4 credits · College 30 + university 70
3 lecture hours and 1 tutorial hour a week, 4 credits (the scheme's semester total of 17 needs them). Its unit hours are not printed.
Unit 1: Introduction to Data Warehousing
What data warehousing is, operational versus decision-support systems, data warehouse architecture and models, the metadata repository, data marts and how warehouses differ from data marts.
Examined in the 70-mark end-semester paper
- Data warehouse architecture
- Data warehouse components and metadata
- Enterprise warehouses and data marts
- Decision support systems
Unit 2: Data Preprocessing
Why data is preprocessed and its major tasks; descriptive data summarisation; data cleaning, integration, reduction, transformation and discretisation.
Examined in the 70-mark end-semester paper
- Data cleaning and transformation
- Data reduction: PCA and binning
- Measures of central tendency and dispersion
Unit 3: OLAP Analytical Processing
The data cube and the multidimensional data model, its schemas, concept hierarchies and measures; OLAP operations, data cube computation and OLAP servers — ROLAP, MOLAP and HOLAP.
Examined in the 70-mark end-semester paper
- Data cube and OLAP operations
- Star, snowflake and fact constellation schemas
- OLAP: ROLAP, MOLAP and HOLAP
Unit 4: Introduction to Data Mining
Why and what data mining is, its functionalities and interesting patterns, techniques drawn from many domains, the architecture and classification of data mining systems, applications and major issues.
Examined in the 70-mark end-semester paper
- Active databases and the KDD process
- Data mining functionalities and system classification
Unit 5: Mining Frequent Patterns and Association Rules
Market basket analysis, frequent and closed itemsets and association rules; the Apriori algorithm, generating rules from frequent itemsets and making Apriori efficient; FP-growth and mining with the vertical data format.
Examined in the 70-mark end-semester paper
- Association rule mining
- Association rules and the Apriori algorithm
- FP-growth algorithm
Unit contents are summarised from the official RTMNU syllabus . AiCanCode.org is not affiliated with Rashtrasant Tukadoji Maharaj Nagpur University (RTMNU).