Columnar Storage is Normalization (opens in new tab)

Something I didn't understand for a while is that the process of turning row-oriented data into column-oriented data isn't a totally bespoke, foreign concept in the realm of databases. It's still of the relational abstraction. Or can be. As an example, say we have this data: data = [ { "name": "Smudge", "colour": "black" }, { "name": "Sissel", "colour": "grey" }, { "name": "Hamlet", "colour": "black" } ] This represents a table in a relational database. Let's assume this was a table in a rela...