Adding the fourth part in the series
update link to 2.0 docs
|Deletions are marked like this.||Additions are marked like this.|
|Line 8:||Line 8:|
|!DataStax has a [[http://www.datastax.com/documentation/cql/3.0/webhelp/index.html#cql/ddl/ddl_anatomy_table_c.html|good introduction to data modeling in Cassandra here]].||!DataStax has a [[http://www.datastax.com/documentation/cql/3.1/cql/ddl/ddl_intro_c.html|good introduction to data modeling in Cassandra here]].|
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 denormalization to "pre-build" resultsets at update time, rather than doing expensive joins across the cluster.
DataStax has a good introduction to data modeling in Cassandra here.
For more detail, see Patrick McFadin's data modeling series: