3 ms·
It's also a bit odd they don't mention column-oriented databases at all.
by hedgehog 6mo ago
It's also a bit odd they don't mention column-oriented databases at all.
- zffr 6mo agoWhy would column-oriented databases be mentioned? My understanding is that these are typically used for OLAP, but the article seems to talk only about OLTP.
- SigmundA 6mo agoBecause there is a whole section that describes column based storage without mentioning that some databases have column based storage as an option.
- goalieca 6mo agoThis is one of the main problems I have with LLMs. It finds patterns in words but not content. I see this in code reviews and eventually outages. Something looks reasonable at the micro scale but clearly didn’t understand something important (because they don’t understand) and it causes a major issue.
- jandrewrogers 6mo agoModern database engines tend to use PAX-style storage layouts, which are column structured, regardless of use case. There is a new type of row-oriented analytic storage layout that would be even better for OLTP but it is not widely known yet so I wouldn't expect to see it mentioned.
- dpe82 6mo agoYeah that was my second thought. ECS' favoring of structs-of-arrays over traditional arrays-of-structs for game entities boils down to the same motivations and resulting physical layout as column-stores vs row-stores.