On Fri, Jan 29, 2010 at 9:09 AM, Mehar Chaitanya <meharchaita...@gmail.com> wrote: > 1. This would lead to enourmous amount of duplication of data, in short > if I now want to view the data from IS_PUBLISHED dimenstion then my database > size would scale up tremendously.
Yes. But disk space is so cheap it's worth using a lot of it to make other things fast. > 2. Above way of reprensting the data would suffice if I want to retrieve > something like, get me all the articles whose category is WORLDNEWS. But > what if I want to find out something like: Get me all the articles whose > Section is BASEBALL and Category is WORLDNEWS. For addressing queries taht > depend on multiple parameter how do we do it? Hope I am clear with my > problem statement :( You have to do the intersection client-side (or use something like http://github.com/tjake/Lucandra to do it for you). -Jonathan