Here are some useful links that will help you learn how to create a data model:
WTF is a SuperColumn? An Intro to the Cassandra Data Model - http://arin.me/blog/wtf-is-a-supercolumn-cassandra-data-model A Java Implementation of the Blog Data Model created by Arin Sarkissian in his blog post "WTF is a SuperColumn?" - http://sleeplessinslc.blogspot.com/2010/11/apache-cassandra-with-hector-example.html Cassandra’s data model cheat sheet - http://www.javageneration.com/?p=70 A Quick Introduction to the Cassandra Data Model - http://maxgrinev.com/2010/07/09/a-quick-introduction-to-the-cassandra-data-model/ Installing and using Apache Cassandra With Java Part 2 (Data model) - http://www.sodeso.nl/?p=108 http://www.rackspace.com/cloud/blog/2010/05/12/cassandra-by-example/ http://www.coraltreemedia.com/resources/cassandra-data-model.php http://www.juhonkoti.net/2010/09/25/example-how-to-model-your-data-into-nosql-with-cassandra http://wiki.apache.org/cassandra/ArticlesAndPresentations Sample Blog Data Model - http://code.google.com/p/nosql-blog-example/ Sample Data Insert Example - http://blog.maescool.be/2010/05/12/what-i-have-learned-about-cassandra-nosql-db/ http://blog.maescool.be/2010/05/12/what-i-have-learned-about-cassandra-nosql-db/ John Haigh On Thu, Jun 23, 2011 at 12:43 PM, mcasandra <mohitanch...@gmail.com> wrote: > How should one go about creating a data model from RDBMS ER into Big Table > Data model? For eg: RDBMS has many indexes required for queries and I think > this is the most important aspect when desiging the data model in Big Table. > > I was initially planning to denormalize into one CF and use secondary > indexes. However I also read that creating secondary indexes have > performance impact. So other option is to create inverted index. But it also > seems to be bad to have too many CFs. We have requirements to support high > volume min of 500 writes + 500 reads per sec. > > What would you advise? > > -- > View this message in context: > http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/How-to-create-data-model-from-RDBMS-ERD-tp6509041p6509041.html > Sent from the cassandra-u...@incubator.apache.org mailing list archive at > Nabble.com. >
