Differences between revisions 37 and 38
Revision 37 as of 2013-11-14 23:26:29
Size: 1513
Editor: jeremyhanna
Comment: Adding the fourth part in the series
Revision 38 as of 2014-07-22 16:34:28
Size: 1486
Comment: 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:

  1. The Data Model is Dead; Long live the Data Model: Video, Slides

  2. Become a Super Modeler: Video, Slides

  3. The World's Next Top Data Model: Video, Slides

  4. Apache Cassandra 2.0: Data Model on Fire: Video, Slides


DataModel (last edited 2014-07-22 16:34:28 by JonathanEllis)