This flashcard is just one of a free flashcard set. See all flashcards!
21
(online transaction processing) OLTP vs OLAP (online analytical processing)
| X | OLTP | OLAP |
| data | operational transactions | management analysis data |
| user friendliness | low | high |
| granularity | microscopic | macroscopic |
| up to date? | current | historic snapshots |
| main operations | update read/write | query & calculate (read only) |
| storage effieciency | high | lower |
| tools | sql | tools |
Flashcard info:
Author: TiRoX
Main topic: Business Intelligence
Topic: Definitionen allgemein
School / Univ.: FU Berlin
Published: 27.07.2018