2 ms·
What's the advantage of a "column-oriented" data store/database?
by mrweasel 11y ago
What's the advantage of a "column-oriented" data store/database?
- gglanzani 11y agoAnalytics like sum(column) are much faster if data is saved column-oriented. Also every time you don't do select *, but select a, b, it's much easier on disk because you're not even touching some columns.
- scott_s 11y agoWikipedia is a good start: https://en.wikipedia.org/wiki/Column-oriented_DBMS https://en.wikipedia.org/wiki/Column-oriented_DBMS The references section has good primary sources.