5 ms·
Also Druid, HBase, Vertipaq (engine behind PowerBI), Redshift, Azure SQL DW, etc Columnar compression is a really interesting engineering problem
by kthejoker2 7y ago
Also Druid, HBase, Vertipaq (engine behind PowerBI), Redshift, Azure SQL DW, etc
Columnar compression is a really interesting engineering problem
- shrumm 7y agoClickHouse is another favourite
- einpoklum 7y agoClickhouse is a columnar system, yes, but is not a full-fledged DBMS. Specifically, I don't think it can join tables.
- NotSammyHagar 7y agomemsql (which was in there for new sql).
- einpoklum 7y agoEh... not quite. It's in-memory representation is row-based. It seems it uses columnar secondary storage. At least - that's what it says here: https://en.wikipedia.org/wiki/MemSQL https://en.wikipedia.org/wiki/MemSQL
- nicoburns 7y agoAlso notable is the Postgres column store extension. Not as fancy / performant as the dedicated columns store databases, but it allows you mix and match row-tables with column-tables which is pretty nice.
- einpoklum 7y agoYes it is, and I've written academically about this. For example: https://is.gd/9wwjjf https://is.gd/9wwjjf