Todos los libros

Profesional

Apps Acerca de Coach Iniciar sesión Empezar a leer

Quantitative Finance · Glosario

¿Qué es Online transaction processing, online analytical processing?

También llamado: online transaction processing · online analytical processing

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

Leer en el capítulo →