Skip to content
SmartFigureEdu

Anna University · Regulation 2021

CCS 341 Data Warehousing question papers

CCS341 Data Warehousing previous year question papers from Anna University (Regulation 2021), with the full syllabus. Read online or download the PDF.

Fifth/Sixth semester · Professional Elective (Vertical 3: Cloud Computing and Data Center Technologies) · L T P C: 2 0 2 3

Question papers

Syllabus

  1. Unit 1: Introduction to Data Warehouse5 hours

    Data warehouse Introduction · Data warehouse components · operational database Vs data warehouse · Data warehouse Architecture · Three-tier Data Warehouse Architecture · Autonomous Data Warehouse · Autonomous Data Warehouse Vs Snowflake · Modern Data Warehouse

  2. Unit 2: ETL and OLAP Technology6 hours

    What is ETL · ETL Vs ELT · Types of Data warehouses · Data warehouse Design and Modeling · Delivery Process · Online Analytical Processing (OLAP) · Characteristics of OLAP · Online Transaction Processing (OLTP) Vs OLAP · OLAP operations · Types of OLAP · ROLAP Vs MOLAP Vs HOLAP

  3. Unit 3: Meta Data, Data Mart and Partition Strategy7 hours

    Meta Data · Categories of Metadata · Role of Metadata · Metadata Repository · Challenges for Meta Management · Data Mart · Need of Data Mart · Cost Effective Data Mart · Designing Data Marts · Cost of Data Marts · Partitioning Strategy · Vertical partition · Normalization · Row Splitting · Horizontal Partition

  4. Unit 4: Dimensional Modeling and Schema6 hours

    Dimensional Modeling · Multi-Dimensional Data Modeling · Data Cube · Star Schema · Snowflake schema · Star Vs Snowflake schema · Fact constellation Schema · Schema Definition · Process Architecture · Types of Data Base Parallelism · Datawarehouse Tools

  5. Unit 5: System & Process Managers6 hours

    Data Warehousing System Managers: System Configuration Manager · System Scheduling Manager · System Event Manager · System Database Manager · System Backup Recovery Manager · Data Warehousing Process Managers: Load Manager · Warehouse Manager · Query Manager · Tuning · Testing