3 ms·
My understanding has always been: 1. No indexes or primary keys 2. Insert and delete only, no updates 3. Automatically normalized behind the scenes leading t
by brightball 3y ago
My understanding has always been:
1. No indexes or primary keys
2. Insert and delete only, no updates
3. Automatically normalized behind the scenes leading to data compression in the 10x-100x range
4. Very fast analytical queries
BigQuery, RedShift, etc are columnar databases (for example).
- jiggawatts 3y agoMicrosoft SQL Server ColumnStore and SAP HANA both support indexes, point updates, etc... You can convert a table in SQL Server to "Clustered ColumnStore" storage, it'll become compressed, but everything will mostly work the same. The implementation in SQL Server uses a row "delta store" to keep recent changes. Once a certain threshold is reached, the delta store is converted to columnar format and merged with the underlying table.