# Row-Oriented Storage

> Each row is kept together on disk. It is quick for one record at a time.

**Field:** Data Engineering  
**Category:** Storage & Warehousing  
**Also known as:** Row Storage, Row Store, Row-Based Storage

## Think of it like

It is like a stack of cards, one per person. Each card holds all about that one person.

## Definition

Row-oriented storage keeps all the values of one row next to each other on disk. Reading or writing one whole record is quick, because it sits in one place. Reading one column from many rows is slow, because every full row must be read. Most databases that run apps store data this way. Warehouses tend to use columnar storage instead.

## Example

When Jack places an order, the shop's database writes his whole order row in one place. Showing his order later reads that one spot.

## Why it matters

It is why app databases handle many small writes fast. It is also why big reports on them are slow.

## Common mistake

Running big reports on the app's own database. Each report reads every row in full, and the app slows down for its users.

## Three principles

- **Rows together.** A record's values sit side by side.
- **Fast for one record.** Read or write a row in one go.
- **Slow for one column.** Sums must read every full row.

## Related terms

- [Columnar Storage](https://learn.benibix.com/term/data/columnar-storage)
- [Online Transaction Processing (OLTP)](https://learn.benibix.com/term/data/oltp)
- [Online Analytical Processing (OLAP)](https://learn.benibix.com/term/data/olap)
- [Apache Avro](https://learn.benibix.com/term/data/apache-avro)
- [Relational Database](https://learn.benibix.com/term/development/relational-database)

## Told apart from

- [Row-Oriented vs Columnar Storage](https://learn.benibix.com/compare/row-oriented-vs-columnar-storage): People think row storage and column storage hold different data. They hold the very same table, just laid out two ways on disk. Row storage keeps each record together, so writing one order is fast. Column storage keeps each column together, so adding up one column is fast. Apps use rows. Warehouses use columns.

![The same three-row table stored two ways. In row storage each row's id, city and total sit side by side on disk. In column storage all the ids sit together, then all the cities, then all the totals, so a query for totals reads one block.](https://learn.benibix.com/diagrams/row-vs-column-storage.svg)

---

Source: https://learn.benibix.com/term/data/row-oriented-storage
Author: Behnia Zarei (a developer in Vienna, Austria, who builds and teaches data, AI and business intelligence at BENIBIX)
Publisher: BENIBIX Learn (https://learn.benibix.com/)
Last updated: 2026-11-16
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
