In the second of two articles about cloud-based data storage, the focus is on the options available and how to decide on one approach rather than the other. (Part 1 is here). Find the keys Not-so-relational databases do not store data in tables – at least, not the sort of tables we associate with relational databases. …
The scale dilemma
As indicated, NoSQL is perceived as more scalable than SQL databases like MySQL. Most people would rather work with a scalable SQL database and not take the risk of using NoSQL, unless it is the only way to go (which is possible when very large scales are needed, Facebook / Twitter kind). 99% of the market would find a scalable SQL solution more than sufficient for their needs.
Few solutions are in the market today for scalable MySQL. For example, Xeround is one of the leading Scalable Cloud Database solutions.
Take it away
"It is entirely possible in a key/value store to orphan an order because you have deleted the customer. You can prevent this but not in the database; you would have to do it in the application code instead."
It sounds rubbish.
I believe I did, Bob.
Querying key value stores: http://browsertoolkit.com/fault-tolerance.png
- Google: Surge in pressure from govts to DELETE CHUNKS of the web
- Oi, bank manager. Only you've got my email address - where're these TROJANS coming from?
- Review Gran Turismo 6: Another glossy, gorgeous Mario Kart on steroids
- Updated ARM server chip upstart Calxeda bites the dust on road to 64-bit glory
- Feminist Software Foundation gets grumpy with GitHub … or does it?