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
- Updated Zucker punched: Google gobbles Facebook-wooed Titan Aerospace
- Elon Musk's LEAKY THRUSTER gas stalls Space Station supply run
- Android engineer: We DIDN'T copy Apple OR follow Samsung's orders
- Pics Audio fans, prepare yourself for the Second Coming ... of Blu-ray
- Microsoft: Windows version you probably haven't upgraded to yet is ALREADY OBSOLETE