4 ms·
The document completely overlooks Columnar databases, which are focused on analytics and are much faster than (most, not all) general-purpose DBMSes. See: http
by einpoklum 7y ago
The document completely overlooks Columnar databases, which are focused on analytics and are much faster than (most, not all) general-purpose DBMSes. See:
https://en.wikipedia.org/wiki/Column-oriented_DBMS https://en.wikipedia.org/wiki/Column-oriented_DBMS
and
https://www.slideshare.net/arangodb/introduction-to-column-oriented-databases https://www.slideshare.net/arangodb/introduction-to-column-o...
or get:
http://www.nowpublishers.com/article/Details/DBS-024 http://www.nowpublishers.com/article/Details/DBS-024
Examples:
* MonetDB
* SAP Hana
* Actian Vector (formerly Vectorwise)
* Oracle In-Memory
- kthejoker2 7y agoAlso 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
- takeda 7y agoThey are much faster for analytical queries, not for transactional ones. If they were overall faster they would be the default relational databases.
- einpoklum 7y agoYes, I did say "focused on Analytics" but I didn't clarify that they're only/mostly fast for analytic workloads.
- cptnapalm 7y agoI know very, very little about any of this, but would this be akin to entity component systems in video games? Forgive me if I'm way off.
- ralusek 7y agoA database being columnar is more of an implementation detail regarding the underlying storage mechanism than it is a type of database. It has to do with how the data is physically stored, i.e. by putting values across rows of a single column adjacent to one another on disc/in memory.