Anna University – CCS341 Data Warehousing Regulation 2021 Syllabus , Notes Book , Important Questions, Question Paper with Answers Previous Year Question Paper.
UNIT I INTRODUCTION TO DATA WAREHOUSE CCS341 Data Warehousing
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 CCS341 Data Warehousing
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 CCS341 Data Warehousing notes
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
| Syllabus | Click Here |
| Notes | Click Here |
| Important Questions | Click Here |
| Previous Year Question Paper | Click Here |
| Question Bank | Click Here |
TEXT BOOKS CCS341 Data Warehousing important questions
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