Tous les livres

Professionnel

Applis À propos Coach Connexion Commencer la lecture

Quantitative Finance · Glossaire

Qu'est-ce que « Online transaction processing, online analytical processing » ?

Aussi appelé : online transaction processing · online analytical processing

Definition 25.7 Research, Data and Risk Platforms · Chapitre 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.

Lire dans le chapitre →