'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 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. Thanks in advance!
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|