The design and implementation of modern column-oriented database systems
Modern column-oriented databases are rather incredible at what they do, and I&#x27;m surprised by how little they are used or known about. Redshift, BigQuery, Snowflake, Azure SQL DW, SQL Server, MonetDB, Vertica, Greenplum, MemSQL, kdb+, Clickhouse, even Druid are all column-stores that can do sub-second queries on massive amounts of data.<p>I also want to note that time-series databases are basically obsolete at this point because time-series data is very well handled by these OLAP column-stores. Create a table with time as a primary or sort key and you&#x27;ll get fast queries with full SQL and joins.