What difference between columnar and wide column databases?

What difference between columnar database (AWS Redshift, Azure Synapse, GCP Bigquery, Snowflake) and wide column database (AWS Keyspaces, Azure CosmosDB, GCP Bigtable, Hbase, Cassandra)?

What I understand so far:

  1. Columnar databases are SQL (ACID transactions compliant) and wide column databases are NoSQL (Scalability, etc)
  2. Columnar databases (AWS Redshift, Azure Synapse, GCP Bigquery, Snowflake) are warehouses and wide column databases (AWS Keyspaces, Azure CosmosDB, GCP Bigtable, Hbase, Cassandra) are just "pure" databases

Leave a Reply

Your email address will not be published.