CCS341 Data Warehousing
Stuff Sector
Prepared by
S.Santhosh (Admin)
Important questions
share it a link alone
Don't waste my hardwork and valuable time
Don't share as screenshot kind request
UNIT -1
1. operational database Vs data warehouse
2. Autonomous Data Warehouse Vs Snowflake Modern Data Warehouse
3. Data warehouse architecture**
UNIT-21. ETL Vs ELT-Types of Data warehouses
2. Data warehouse Design and Modeling
3. Delivery Process Online Analytical Processing (OLAP) Characteristics of OLAP
4. Online Transaction Processing (OLTP) Vs OLAP -
Don't share it as screenshot
share as link
UNIT-3
1. Categories , Role of Metadata 2. Challenges for Meta Management
3. Cost Effective ,Designing Data Marts, cost of partioning **UNIT-4
UNIT-5
1. System Configuration, System Scheduling, Event Manager
1. Multi-Dimensional Data Modeling Star Schema
2. Schema Definition Process Architecture
3. Types of Data Base Parallelism
2.Recovery Manager
3. Query Manager
4. Tuning ,Testing.
**Very important questions are bolded and may be asked based on this topic
PART-C
1.Compulsory Questions {a case study where the student will have to read and analyse the subject }
mostly asked from unit 4,5(OR)Algorithm may be asked
Snowflake schema Star Vs Snowflake schema Fact constellation Schema
don't waste my hardwork and valuable time
As Engineer i think you know how to respect another
Share it as link alone . don't share it as screenshot or any text material if u found this anywhere kindly report me . #Admin WhatsAppContact uS
*These questions are expected for the exams This may or may not be asked for exams All the best.... from admin Santhosh
Thanks for your love and support guys keep supporting and share let the Engineers know about Us and leave a comment below for better improvements If there is any doubt feel free to ask me I will clear if I can or-else I will say some solutions ..get me through WhatsApp for instant updates ~$tuff$£ctorSYllabuSUNITI INTRODUCTION TO DATA WAREHOUSE
Data warehouse Introduction Data warehouse components operational database Va data warehousa-Data warehouse Architecture-Three-fer Data Warehouse Architecture-Autonomous Data Warehouse Autonomous Data Warehouse Vs Snowflake Modern Data Warehouse
UNIT II ETL AND OLAP TECHNOLOGY
What is ETL-ETL Vs ELT-Types of Data warehouses Duta warehouser Design and Modeling- Delivery Process Online Analytical Processing (OLAP) Charactenstics of OLAP Online Transaction Processing (OLTP) Vs OLAP OLAP operations- Types of OLAP-ROLAP VS MOLAP VHOLAP
UNIT III META DATA, DATA MART AND PARTITION STRATEGY
Meta Data-Categories of Metadata Role of Metadata Metadata Repository Chalenges for Merta Management Data Mart Need of Data Mart Cost Effective Data Mart- Designing Data Marts- Cost of Data Marts- Partitioning Strategy-Vertical partition-Normalization-Row Spitting -Horizontal Partition
UNIT IV DIMENSIONAL MODELING AND SCHEMA Dimensional Modeling- Multi-Cimensional Data Modeling Data Cube- Star Schema- Snowflake schema- Star Vs Snowflake schema- Fact constellation Schema- Schema Definition-Process Architecture-Types of Data Base Paraleliam-Datawarehouse Tools
UNIT V SYSTEM & PROCESS MANAGERS
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
Contact uS
*These questions are expected for the exams This may or may not be asked for exams
All the best.... from admin Santhosh
Thanks for your love and support guys keep supporting and share let the Engineers know about Us and leave a comment below for better improvements
If there is any doubt feel free to ask me I will clear if I can or-else I will say some solutions ..get me through WhatsApp for instant updates ~$tuff$£ctor