🗄️Row-Oriented Storage
Also known as Row Storage, Row Store, Row-Based Storage
Each row is kept together on disk. It is quick for one record at a time.
Think of it like
It is like a stack of cards, one per person. Each card holds all about that one person.
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.
Definition
Common mistake
Key takeaways
- 1Rows together. A record's values sit side by side.
- 2Fast for one record. Read or write a row in one go.
- 3Slow for one column. Sums must read every full row.