Wayne Kernochan recently shared his thoughts on NoSQL best practices in Enterprise Apps Today. His list begins, “ In many if not most cases, the NoSQL database should be used as a complement to an existing or additional relational database that at the least handles deeper post-arrival data analytics.
All else being equal, a NoSQL database that offers a broader range of ‘ACID relaxation’ — if possible, all the way from no consistency to near-ACID-compliance — is better than one that only allows no consistency.