← Advanced DBMS learning pathAdvanced DBMS · Module 9 of 10
Data warehousing and OLAP
Analyse large historical data.
📖 Key ideas
- OLTP handles daily transactions; OLAP handles analysis.
- Data warehouses integrate data from many sources via ETL.
- Star and snowflake schemas organise facts and dimensions.
- OLAP operations: roll-up, drill-down, slice, dice, pivot.
- Columnar storage speeds analytics.
💡 Real-life example: OLTP is the shop billing counter; OLAP is the owner's monthly sales analysis.
OLTPOnline Transaction Processing
OLAPOnline Analytical Processing
Star schemaFact table with dimension tables
Drill-downMoving to more detailed data