Data Warehousing detailed syllabus for Computer Science & Engineering (CSE) for 2021 regulation curriculum has been taken from the Anna Universities official website and presented for the CSE students. For course code, course name, number of credits for a course and other scheme related information, do visit full semester subjects post given below.
For Computer Science & Engineering 6th Sem scheme and its subjects, do visit CSE 6th Sem 2021 regulation scheme. For Professional Elective-III scheme and its subjects refer to CSE Professional Elective-III syllabus scheme. The detailed syllabus of data warehousing is as follows.
Course Objectives:
Download the iStudy App for all syllabus and other updates.
Unit I
INTRODUCTION TO DATA WAREHOUSE 5 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
Unit II
Download the iStudy App for all syllabus and other updates.
Unit III
META DATA, DATA MART AND PARTITION STRATEGY 7 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
Unit IV
Download the iStudy App for all syllabus and other updates.
Unit V
SYSTEM & PROCESS MANAGERS 6 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
Practical Exercises:
Download the iStudy App for all syllabus and other updates.
Course Outcomes:
At the end of the course the students should be able to
- Design data warehouse architecture for various Problems
- Apply the OLAP Technology
- Analyse the partitioning strategy
- Critically analyze the differentiation of various schema for given problem
- Frame roles of process manager & system manager
Text Books:
- Alex Berson and Stephen J. Smith Data Warehousing, Data Mining & OLAP, Tata McGraw – Hill Edition, Thirteenth Reprint 2008.
- Ralph Kimball, The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling, Third edition, 2013.
Reference Books:
Download the iStudy App for all syllabus and other updates.
For detailed syllabus of all the other subjects of Computer Science & Engineering 6th Sem, visit CSE 6th Sem subject syllabuses for 2021 regulation.
For all Computer Science & Engineering results, visit Anna University CSE all semester results direct link.