Database Flashcards Preview

Software Engineer > Database > Flashcards

Flashcards in Database Deck (1)
Loading flashcards...
1

What is the difference between OLTP and OLAP?

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