Comparing MapReduce in CouchDB with SQL in a RDBMS
Using NoSQL data stores makes you change the way you design and query data, so you have to learn new tools and methods to get the full power of your NoSQL DB. In this session we will focus on how to stop thinking ‘SQL and relations’ and start thinking ‘views and MapReduce’ with CouchDB. Our first challenge will be to query our documents with flexibility to get the data we need. To handle this, we will show how we can translate our good old SQL SELECT queries into Map and/or Reduce functions. The second challenge of our session will be to design a model both able to deal with the absence of relations between data and easy to query against. After describing basic but not totally satisfying solutions to this problem, we will delve into a more CouchDB-compliant way.