alt Hacker NewsWhy 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.
Replies
SigmundA • yesterday at 7:11 PM
Because there is a whole section that describes column based storage without mentioning that some databases have column based storage as an option.
➕ show 1 reply
Modern 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.