OLAP - AshokBhat/notes GitHub Wiki
About
- Online Analytical Processing
OLAP vs OLTP
| Feature | OLAP | OLTP |
|---|---|---|
| Purpose | Complex data analysis and reporting | Transactional processing and real-time updates |
| Data | Aggregated data | Transactional data |
| Performance | Optimized for complex queries | Optimized for fast updates |
| Data structure | Multidimensional | Relational |
| Typical use cases | Reporting, analysis, decision-making | Order processing, inventory management, customer management |