OLTP

9 items tagged with "oltp"

Filter by type:

Reference Architectures1

HTAP OLTP and OLAP Platform

A hybrid transactional and analytical platform that serves OLTP and OLAP on one distributed SQL store with columnar replicas.

Benchmarks7

Benchmark

TPC-C

The classic OLTP benchmark simulating an order-entry warehouse workload, measuring transactions per minute (tpmC) and price/performance.

Benchmark

TPC-E

An OLTP benchmark modeling a brokerage firm with realistic data and read-heavy transactions, reporting tpsE as a more representative successor to TPC-C.

Benchmark

sysbench

A scriptable, multi-threaded benchmark tool widely used for MySQL/PostgreSQL OLTP tests as well as CPU, memory, and file I/O microbenchmarks.

Benchmark

pgbench

PostgreSQL's built-in benchmarking tool that runs a TPC-B-like transaction load and custom scripts to measure transactions per second and latency.

Benchmark

HammerDB

An open-source database load-testing tool implementing TPROC-C and TPROC-H (TPC-C/TPC-H-derived) workloads across many relational engines.

Benchmark

BenchBase

An extensible Java framework (successor to OLTPBench) for benchmarking relational databases with many built-in workloads via a common JDBC harness.

Benchmark

OLTP vs OLAP Latency Benchmark

A comparative benchmark category contrasting transactional (OLTP) point-operation latency with analytical (OLAP) scan-and-aggregate latency to evaluate HTAP systems.

FAQs1

FAQ

What is the difference between OLTP and OLAP?

OLTP (Online Transaction Processing) handles many short, concurrent transactions like orders, payments, and updates, optimized for fast writes and row...