RTMNU · Final Year B.Tech Computer Science & Engineering (Data Science) · CBCS
Data Warehousing
Elective V · Semester VII · 3 credits · College 30 + university 70
One of the Elective V options.
Unit 1: Data Warehouse Fundamentals
8 hoursWhat a data warehouse is; OLTP systems and how a warehouse differs; its characteristics, functionality, advantages and applications; top-down and bottom-up development, tools and types of data warehouse.
Examined in the 70-mark end-semester paper
- Data warehouse architecture
- OLTP versus the data warehouse
- Top-down and bottom-up data warehouse development
Unit 2: Planning and Requirements
7 hoursPlanning a data warehouse and its key issues, project management, the development life cycle and the Kimball lifecycle; approaches to gathering requirements, team organisation, roles and responsibilities.
Examined in the 70-mark end-semester paper
- Data warehouse planning and the Kimball lifecycle
- Data engineering lifecycle
Unit 3: Data Warehouse Architecture
7 hoursThe components of a data-warehouse architecture, technical architectures, tool selection and federated data-warehouse architecture.
Examined in the 70-mark end-semester paper
- Data lakes and lakehouses
- ETL and ELT
Unit 4: Dimensional Modelling and OLAP
7 hoursE-R versus dimensional modelling; star, snowflake and fact-constellation schemas, dimension and fact tables, factless facts, granularity and keys; OLAP, its characteristics and creation, multidimensional data and OLAP architectures (MOLAP).
Examined in the 70-mark end-semester paper
- Star and snowflake schemas
- Fact and dimension tables, factless facts and granularity
- OLAP operations
- ROLAP, MOLAP and HOLAP
Unit 5: Metadata Management
7 hoursCategorising metadata, metadata management in practice — gathering requirements, classification and collection strategies; metadata management in Oracle and SAS and its tools.
Examined in the 70-mark end-semester paper
- Metadata management
- Data lineage and catalogues
Unit contents are summarised from the official RTMNU syllabus . AiCanCode.org is not affiliated with Rashtrasant Tukadoji Maharaj Nagpur University (RTMNU).