CODEWITHSUNDEEP
cassandracolumn-familycolumn-orientedwide-column-store
Stan
Stan

Reputation: 872

Columnar/Column-oriented database vs wide-column/column family database

I got really confused about Cassandra recently because most online material even AWS and Google describe it as columnar database. But actually it is row-based, partitioned, column-family database. Now everything makes sense to me:
Then are all characteristics such as

  1. being optimised for foreign join
  2. aggregating many rows and a few columns/ single column aggregation
  3. Scanning only column by column as opposed to row-based database

still valid or true for Cassandra AKA wide-column/column-family database.
If not, what are their real characteristics? Write Performance?

IN addition, I really need a true columnar database example to study on?(as opposed to Cassandra and data are store in different column blocks)

Can anyone help? It troubles me for a long time. enter image description here

Upvotes: 3

Views: 427

Answers (0)

Related Questions