I am used to seeing data in tables and their relationship via foreign keys. I would like to move on to noSQL (key-value) store. A challenge to me is how to stop thinking about foreign keys and tables and think everything in a single key-value store. Does anyone point to guide/links how to move away from RDBMS mindset to key-value store mindset. Real life examples of moving rdbms schemas to noSQL would be great.
I dont understand the constant desire to replace the relational model. It works great to store most types of data in it, and its very flexible to do ad hoc reports if you have a good understanding of SQL.<p>I &#10084; ORDER BY, GROUP BY, DISTINCT, SUM(), COUNT(1) etc <i>ducks</i>
You may check this presentation from MIX10 "Using Storage in the Windows Azure Platform" <a href="http://live.visitmix.com/MIX10/Sessions/EX11" rel="nofollow">http://live.visitmix.com/MIX10/Sessions/EX11</a>
Why do you want to move to a KV store? Don't just move for the sake of it. If you have a real problem that requires a KV store then sure, but it sounds like you're just doing it cause everyone else is. Don't optimise for a problem you don't have (yet).