RTMNU Final CSE (DS) syllabus

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.

  1. Unit 1: Data Warehouse Fundamentals

    8 hours

    What 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
  2. Unit 2: Planning and Requirements

    7 hours

    Planning 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
  3. Unit 3: Data Warehouse Architecture

    7 hours

    The 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
  4. Unit 4: Dimensional Modelling and OLAP

    7 hours

    E-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
  5. Unit 5: Metadata Management

    7 hours

    Categorising 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).