I was taking some courses to understand better the way Cassandra works (at academy.datastax.com) and by what I gathered it came to me that it is a Key Value Database because of the way it stores data based on a hash of the key and distributes to nodes accordingly. But everywhere I look people say Cassandra is a Column-Based Database and I can't see why.

  • From wiki.apache.org --> Cassandra is a partitioned row store, where rows are organized into tables with a required primary key. The first component of a table's primary key is the partition key; within a partition, rows are clustered by the remaining columns of the PK. Other columns may be indexed independent of the PK. This allows pervasive renormalization to "pre-build" result sets at update time, rather than doing expensive joins across the cluster. – Kin Shah Jun 23 '15 at 23:24
  • " a partitioned row store" a.k.a. a column-oriented data store. Note it is not a true "Column-store". It is column-oriented or a column-family store. The terminology of partitioned row store versus column-oriented is less important than understanding what Kin shared though. If you walk into Cassandra thinking it is a true column store, you'll be surprised. – SDillon Jun 24 '15 at 11:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.