Wide column stores and column-oriented database systems store their data differently:
Column-oriented database systems store the data using a column-oriented data layout. Values for the same column are stored contiguously on disk.
Wide column stores group columns into column families (which usually have data of the same data type). According to Wikipedia:
Within a given column family, all data is stored in a row-by-row
fashion, such that the columns for a given row are stored together,
rather than each column being stored separately.
Data belonging to the same key is stored together. It uses multi-dimensional mapping to reference data by column, row and timestamp. (Timestamp, because new versions of the value in the cell/field are added rather than overwriting the previous value.)
Columnar databases (AWS Redshift, Azure Synapse, GCP Bigquery, Snowflake) are warehouses
Maybe it is more correct to say that columnar database systems are well suited for data warehouses.
ScyllaDB is another wide column store worth mentioning in addition to the ones you already listed.
See also:
