IT

CCS341: Data Warehousing syllabus for IT 2021 regulation (Professional Elective-III)

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.

Data Warehousing

Course Objectives:

Download the iStudy App for all syllabus and other updates.
Get it on Google Play

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.
Get it on Google Play

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.
Get it on Google Play

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.
Get it on Google Play

Course Outcomes:

At the end of the course the students should be able to

  1. Design data warehouse architecture for various Problems
  2. Apply the OLAP Technology
  3. Analyse the partitioning strategy
  4. Critically analyze the differentiation of various schema for given problem
  5. Frame roles of process manager & system manager

Text Books:

  1. Alex Berson and Stephen J. Smith Data Warehousing, Data Mining & OLAP, Tata McGraw – Hill Edition, Thirteenth Reprint 2008.
  2. 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.
Get it on Google Play

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.

Leave a Reply

Your email address will not be published. Required fields are marked *

*