Todos os livros

Profissional

Apps Sobre Coach Entrar Começar a ler

Quantitative Finance · Glossário

O que é Online transaction processing, online analytical processing?

Também chamado de: 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.

Ler no capítulo →