Database Flashcards
1
Q
What is the difference between OLTP and OLAP?
A
OLTP
- Online Transaction Processing
- Large transactions
- INSERT/ UPDATE/ DELETE
- Fast Query, multi-access environments for data integrity
OLAP
- Online Analytical Processing
- Low volume transactions
- Complex Queries/ Aggregation
- Used by Data Mining
- Purpose: Historical/Archival
