I have a reasonable understanding of relational databases. I am not so sure about NoSQL databases. Though I have used mongodb in the past.
Can someone point me to resources to get a deeper understanding? How do I go about learning the trade-offs of choosing say a document store over a key value store. Also CAP theorem and related trade-offs. When is NoSQL better suited than relational etc.
The Little MongoDB Book might help. It doesn't answer all your questions but it gave me enough background (albeit MongoDB specific) to learn more. It's also a fairy short read. <a href="http://openmymind.net/mongodb.pdf" rel="nofollow">http://openmymind.net/mongodb.pdf</a>
This goes a bit in a different direction, but it should help.<p>"SQL and NoSQL are two sides of the same coin, mathematically"<p><a href="https://news.ycombinator.com/item?id=3313234" rel="nofollow">https://news.ycombinator.com/item?id=3313234</a>
I can't recommend enough the book <i>Seven Databases in Seven Weeks</i> by Eric Redmond & Jim Wilson. It covers the whole range of different types of databases, with just a little bit of theory (the CAP theorem).
I would recommend Martin Fowler's NoSQL Distilled : <a href="http://martinfowler.com/books/nosql.html" rel="nofollow">http://martinfowler.com/books/nosql.html</a>