Stephen Downes

Knowledge, Learning, Community

This is the sort of thing that keeps me wondering. Storing data in rows is importantly different from storing it in columns. It's not just a conceptual difference; it is a difference in where the bits are physically placed in a storage medium, and that has an impact on how efficient it is to make one sort of query rather than another. Suppose I am storing information about bicycle rentals. If I want to know about a particular rental (in order to, say, invoice a customer) then a row is more efficient. But if I'm doing analytics (in order to, say, assess demand in a certain region) then a column is more efficient. Anyhow, this article explores the implications of that, describes the different types of databases, and dips into more advanced topics like 'vectorized execution'.

Today: Total: [Direct link] [Share]


Stephen Downes Stephen Downes, Casselman, Canada
stephen@downes.ca

Copyright 2026
Last Updated: Nov 20, 2026 1:23 p.m.

Canadian Flag Creative Commons License.