row
One entry in a table, holding one value for each of the table's columns.
In more detail
In a well designed table one row is one fact, such as one customer or one line of an order. A query's answer is also a set of rows, and a primary key gives each row an identity no other row shares.
Related terms
- table — A named set of rows that all have the same columns, where each row records one fact about one thing.
- column — A named, typed field that every row of a database table has, such as name or price.
- primary key — The column, or columns, whose value uniquely identifies each row of a table and can never be NULL.
- relational database — A database that stores data in tables and links rows in one table to rows in another through shared key values.
- blob — A large chunk of raw bytes, such as a photo, video or backup file, stored as one object.
- row lock — A database lock on one row that makes other transactions wait before changing it.
Taught in
- Why Tables And Relations Beat Files — PostgreSQL, Indexing & Relational Data Modeling
- What A Design Is For, And How To Run A Design Discussion — Scalable System Design & Distributed Architecture
- Back Of The Envelope Estimation: Storage And Bandwidth — Scalable System Design & Distributed Architecture
- The Storage Decision: Relational Versus Document — Scalable System Design & Distributed Architecture
- The Storage Decision: Key Value, Search And Blob — Scalable System Design & Distributed Architecture
- Cache Invalidation And The Three Hard Cases — Scalable System Design & Distributed Architecture
- Queues, Events And Asynchronous Work — Scalable System Design & Distributed Architecture
- The Difference Between A Queue And A Log — Scalable System Design & Distributed Architecture
- Idempotency, And Exactly Once As A Fiction — Scalable System Design & Distributed Architecture
- Worked Design One: Ticket Booking, Correctness First — Scalable System Design & Distributed Architecture
- Worked Design One: Scaling The Ticket Booking System — Scalable System Design & Distributed Architecture
- Worked Design Two: A Global Chat System — Scalable System Design & Distributed Architecture
- Worked Design Two: Scaling Chat Fan Out — Scalable System Design & Distributed Architecture