Zu dieser Karteikarte gibt es einen kompletten Satz an Karteikarten. Kostenlos!
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 |
Karteninfo:
Autor: TiRoX
Oberthema: Business Intelligence
Thema: Definitionen allgemein
Schule / Uni: FU Berlin
Veröffentlicht: 27.07.2018