Data Warehousing detailed syllabus for Information Technology (IT) for 2021 regulation curriculum has been taken from the Anna Universities official website and presented for the IT 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 Information Technology 6th Sem scheme and its subjects, do visit IT 6th Sem 2021 regulation scheme. For Professional Elective-III scheme and its subjects refer to IT 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 Information Technology 6th Sem, visit IT 6th Sem subject syllabuses for 2021 regulation.
For all Information Technology results, visit Anna University IT all semester results direct link.