http://www.datastax.com/support-forums/topic/denormalize-to-optimize-data-model-document Software, Support, and Training for Apache Cassandra en-US Mon, 20 May 2013 07:07:50 +0000 http://bbpress.org/?v=1.0.3 q http://www.datastax.com/support-forums/search.php http://www.datastax.com/support-forums/topic/denormalize-to-optimize-data-model-document#post-1114 Thu, 09 Feb 2012 18:51:24 +0000 Anonymous 1114@http://www.datastax.com/support-forums/ <p>Howdy,</p> <p>I have some concerns about Denormalize to Optimize.<br /> <a href="http://www.datastax.com/docs/1.0/ddl/data_model_planning#denormalize-to-optimize" rel="nofollow">http://www.datastax.com/docs/1.0/ddl/data_model_planning#denormalize-to-optimize</a></p> <p>"a single column family are used to answer each query. This sacrifices disk space (one of the cheapest resources for a server) in order to reduce the number of disk seeks and the amount of network traffic."</p> <p>First, it will NOT reduce the amount of network traffic, compared with Normalized data when you get same number of columns and rows.<br /> 2nd, for the number of disk seeks, it depends. some times Normalized data increase the cache hit ratio with smaller memory footprint and reduce the number of disk seeks.</p> <p>And last, could you add some data model examples to explain how to Denormalize to Optimize? it help us to learn and understand the data modeling in Cassandra.</p> <p>Thanks,<br /> Charlie | DBA </p>