Database_Wide_Column

Wide Column Database

• aka Column family database
• column families is introduced by Google Bigtable
• Each column family is like a table
• flexible schema, each row can have different columns, hence called wide column
• They do not use column compression like column oriented database
• Benefits
  • Handles massive scale (petabytes)
  • High write throughput
  • Schema flexibility without complex migrations
• Uses
  • good for time-series, logs, sensor data (High write throughput)
  • Social Media interactions (High volume/write throughput)
• Examples
  • Apache Cassandra
  • Apache HBase
  • ScyllaDB
  • Google Bigtable
• https://stackoverflow.com/questions/62010368/what-exactly-is-a-wide-column-store
• https://discuss.google.dev/t/when-to-use-cloud-bigtable-instead-of-cloud-spanner/169930/2
• https://stackoverflow.com/questions/13010225/why-many-refer-to-cassandra-as-a-column-oriented-database