Alle boeken

Professioneel

Apps Over Coach Inloggen Begin met lezen

Quantitative Finance · Begrippenlijst

Wat is Online transaction processing, online analytical processing?

Ook bekend als: online transaction processing · online analytical processing

Definition 25.7 Research, Data and Risk Platforms · Hoofdstuk 25 — Databases and SQL

Online transaction processing (OLTP) is a workload of many small transactions that read and write a few rows each by key — booking trades, updating positions. Online analytical processing (OLAP) is a workload of few large queries that read many rows and few columns to aggregate them — traded value by instrument, P&L by desk over a year.

Lees in het hoofdstuk →