Differences between revisions 32 and 33
Revision 32 as of 2013-07-11 16:04:16
Size: 1139
Comment: Rip out obsolete material in favor of DS docs and Patrick's presentations
Revision 33 as of 2013-08-30 02:25:37
Size: 1005
Comment: fix link
Deletions are marked like this. Additions are marked like this.
Line 8: Line 8:
DataStax has a good introduction to data modeling in Cassandra here:

 * [[http://www.datastax.com/documentation/cassandra/1.2/index.html#cassandra/ddl/ddl_anatomy_table_c.html#concept_ds_qqw_1dy_zj|http://www.datastax.com/documentation/cassandra/1.2/index.html#cassandra/ddl/ddl_anatomy_table_c.html]]
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]].

Introduction

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 three-part series:

  1. The Data Model is Dead; Long live the Data Model

  2. Become a Super Modeler

  3. The World's Next Top Data Model

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