Scribd
Upload
246 views2 pages

CCS341 Data Warehousing Syllabus

The document outlines the course objectives and structure for a Data Warehousing course at Paavai Institutions, focusing on data warehouse architecture, OLAP technology, and partitioning strategies. It includes five units covering topics such as ETL processes, metadata, dimensional modeling, and system management. The course aims to equip students with the skills to design data warehouses and apply various technologies and strategies effectively.

Uploaded by

Divya
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
246 views2 pages

CCS341 Data Warehousing Syllabus

The document outlines the course objectives and structure for a Data Warehousing course at Paavai Institutions, focusing on data warehouse architecture, OLAP technology, and partitioning strategies. It includes five units covering topics such as ETL processes, metadata, dimensional modeling, and system management. The course aims to equip students with the skills to design data warehouses and apply various technologies and strategies effectively.

Uploaded by

Divya
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

Paavai Institutions Department of CSE

CCS341 DATA WAREHOUSING LT PC


2023
COURSE OBJECTIVES:
 To know the details of data warehouse Architecture
 To understand the OLAP Technology
 To understand the partitioning strategy
 To differentiate various schema
 To understand the roles of process manager & system manager

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 ETL AND OLAP TECHNOLOGY 6
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.
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 DIMENSIONAL MODELING AND SCHEMA 6


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

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
TOTAL: 30 PERIODS

1
Paavai Institutions Department of CSE

COURSE OUTCOMES:
CO1: Design data warehouse architecture for various Problems
CO2: Apply the OLAP Technology
CO3: Analyse the partitioning strategy
CO4: Critically analyze the differentiation of various schema for given problem
CO5: 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.

REFERENCES
1. Paul Raj Ponniah, “Data warehousing fundamentals for IT Professionals”, 2012.
2. K.P. Soman, ShyamDiwakar and V. Ajay “Insight into Data mining Theory and Practice”,
Easter Economy Edition, Prentice Hall of India, 2006.

You might also like