NoSQL or not NoSQL?
•
10 likes•5,567 views
This document discusses NoSQL databases and when they may be preferable to SQL databases. It notes that NoSQL databases are often used because they are popular rather than being well-suited to the problem. NoSQL databases are more appropriate than SQL for semi-structured data, horizontal scalability for large amounts of read and write operations, and types of data like social networks, data processing, search, and caching. The document also covers NoSQL data models, challenges, and examples of where NoSQL databases could be used.
NoSQL or not NoSQL?
- 1. NoSQL or not NoSQL? 28. June 2010 NoSQL or not NoSQL? Nicolas Ruflin Nicolas Ruflin
- 2. NoSQL or not NoSQL? 8. December 2010 About Me • Nicolas Ruflin @ruflin • Head Developer useKit • Master Thesis: Adequate storage of social data • Elastica: ElasticSearch PHP client Nicolas Ruflin
- 3. NoSQL or not NoSQL? 8. December 2010 NoSQL: Not only SQL • Point being - when I rant about the suitability of NoSQL solutions, I’m mainly complaining that in many cases it seems to me that they’re using them because they’re popular or trendy and not because they are or are not actually suited to the task at hand. ~Monty Taylor • RDBMS was used in some many cases just because it was around for such a long time. ~Alex Popescu Nicolas Ruflin
- 4. NoSQL or not NoSQL? 8. December 2010 Why NoSQL? http://gigaom.com/cloud/sensor-networks-top-social-networks-for-big-data-2/ Nicolas Ruflin
- 5. NoSQL or not NoSQL? 8. December 2010 Why NoSQL? • What is the problem with SQL? • Semi structured data • Horizontal scalability (read & write) • Thousands of nodes • ... Nicolas Ruflin
- 6. NoSQL or not NoSQL? 8. December 2010 NoSQL Data Models http://blogs.neotechnology.com/emil/2009/11/nosql-scaling-to-size-and-scaling-to-complexity.html Nicolas Ruflin
- 7. NoSQL or not NoSQL? 8. December 2010 NoSQL vs. SQL Data model Query language Structured SQL solutions SQL (normalized) NoSQL solutions Semi structured MapReduce, ... Nicolas Ruflin
- 8. NoSQL or not NoSQL? 8. December 2010 NoSQL Challenges • Complexity • Setup • Queries (MapReduce) • Data models • Maturity Nicolas Ruflin
- 9. NoSQL or not NoSQL? 8. December 2010 Where to use NoSQL • Social data • Data processing (Hadoop) • Search (Lucene) • Caching (Memcache, ...) • Data Warehousing • Logging • ... Nicolas Ruflin
- 10. NoSQL or not NoSQL? 8. December 2010 NoSQL or SQL? • Wrong question • What is your problem? • Transactions • Amount of data • Data structure Nicolas Ruflin
- 11. NoSQL or not NoSQL? 8. December 2010 NoSQL or not NoSQL? SQ L QL N oS Nicolas Ruflin
- 12. NoSQL or not NoSQL? 8. December 2010 NoSQL Getting Started • Blogs • http://nosql.mypopescu.com/ • http://highscalability.com/ • Papers • Dynamo (Amazon) • BigTable (Google) Nicolas Ruflin
- 13. NoSQL or not NoSQL? 8. December 2010 Questions - Discussion Nicolas Ruflin
- 14. NoSQL or not NoSQL? 8. December 2010 CAP Theorem http://blog.nahurst.com/visual-guide-to-nosql-systems Nicolas Ruflin