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
- being optimised for foreign join
- aggregating many rows and a few columns/ single column aggregation
- 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.
