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
- Geek's Guide to Britain Kingston's aviation empire: From industry firsts to Airfix heroes
- Analysis Happy 2nd birthday, Windows 8 and Surface: Anatomy of a disaster
- Review Vulture trails claw across Lenovo's touchy N20p Chromebook
- Adobe spies on readers: EVERY DRM page turn leaked to base over SSL
- Analysis The future health of the internet comes down to ONE simple question…