Oracle Database

How can databases handle millions of transactions per second?

Imagine a busy online marketplace where millions of buyers and sellers are constantly adding, updating, and removing items. The system must quickly process these changes without slowing down.

To keep the marketplace running smoothly, a special type of database uses fast memory and smart ways to find information quickly. This helps it handle lots of changes at once.

Example

A database with 1 million transactions per second uses in-memory processing and optimized indexing to efficiently manage updates and queries.

Remember this

In-memory processing and optimized indexing enable databases to handle high read-write workloads efficiently.

Text adapted from Wikipedia, licensed under CC BY-SA 4.0.

Related concepts

LSM trees optimize: write-heavy workloads by buffering writes in memory

Ever wondered how your favorite social media app handles millions of new posts every minute?

database sharding does: splits data across machines by a partition key

Why can't you just split a huge library into smaller ones?

SQL vs NoSQL: SQL enforces schema and ACID, NoSQL offers flexibility and horizontal scaling

Ever wondered how databases handle massive data across the globe?

Distributed hash table

Ever wondered how your favorite streaming service instantly starts playing a movie?

paged attention (vLLM) improves serving throughput

Paged attention (vLLM) improves serving throughput by reducing latency through non-contiguous KV-cache pages, enabling faster data retrieval

B-trees optimize: disk-based sorted data with O(log n) reads per query

How can we quickly find your favorite song in a massive music library?

Swipe through 100 ML concepts daily

Open Pocket Polymath