Re: Human readable Cassandra limitations

2010-05-12 Thread Paul Prescod
On Wed, May 12, 2010 at 2:02 AM, David Vanderfeesten wrote: >... > > My concern with the denormalization approach is that it shouldn't be managed > by the client side because this has big impact on your throughput.  Is the > map-reduce in that respect any better? > Wouldn't it be nice to support a

Re: Human readable Cassandra limitations

2010-05-12 Thread David Vanderfeesten
On the scaleability and performance side, I found Yahoo's paper about the YCSB project interesting (benchmarking some NoSQL solutions with MySQL). See research.yahoo.com/files/*ycsb*.*pdf. *My concern with the denormalization approach is that it shouldn't be managed by the client side because this

Re: Human readable Cassandra limitations

2010-05-10 Thread Paul Prescod
On Mon, May 10, 2010 at 1:23 PM, Peter Hsu wrote: > Thanks for the response, Paul. > ... > > * Cassandra and its siblings are weak at ad hoc queries on tables > that you did not think to index in advance > > What is the normal way of dealing with this in Cassandra?  Would you just > create a new "

Re: Human readable Cassandra limitations

2010-05-10 Thread Peter Hsu
Thanks for the response, Paul. Very helpful, but very general at the same time. I'm still having trouble translating these into actual use cases.Let me think of some better questions before I continue the thread, but I'd like to address one of the weaknesses you brought up: > * Cassandra

Re: Human readable Cassandra limitations

2010-05-10 Thread Paul Prescod
Also: * you should Google "eventual consistency" to learn about the strengths and weaknesses of that. On Mon, May 10, 2010 at 11:22 AM, Paul Prescod wrote: > This is a very, very big topic. For the most part, the issues are > covered in the various SQL versus NoSQL debates all over the Internet

Re: Human readable Cassandra limitations

2010-05-10 Thread Paul Prescod
This is a very, very big topic. For the most part, the issues are covered in the various SQL versus NoSQL debates all over the Internet. For example: * Cassandra and its NoSQL siblings have no concept of an in-database "join" * Cassandra and its NoSQL siblings do not allow you to update multipl

Human readable Cassandra limitations

2010-05-10 Thread Peter Hsu
I've seen a lot of threads and posts about why Cassandra is great. I'm fairly sold on the features, and the few big deployments on Cassandra give it a lot of credibility. However, I don't believe in magic bullets, so I really want to understand the potential downsides of Cassandra. Right now,