1 / 13

Understanding NoSQL: Key Insights from SQLPort Community Meeting

In this comprehensive presentation, we explore the world of NoSQL databases, emphasizing their significance for modern applications. Moving beyond traditional relational databases (RDBMS), we delve into the flexible, non-relational structures of NoSQL, including key-value stores, document-oriented databases, wide-column stores, and graph databases. We discuss why NoSQL is becoming essential for web-based applications, highlighting its scalability, availability, and adaptability. Join us for a detailed look at how NoSQL addresses the evolving needs of data management in today's digital landscape.

jacob-mccormick
Télécharger la présentation

Understanding NoSQL: Key Insights from SQLPort Community Meeting

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. NoSQL The Lightning Way XIV Encontro da comunidade SQLPort LX 2011.08.16

  2. Why should we care? When all you have is a hammer, you tend to see every problem as a nail. Abraham Maslow

  3. What is NoSQL? • “Next Generation Databases mostly addressing some of the points: beingnon-relational, distributed, open-source and horizontally scalable. (…)” from nosql-databases.org

  4. Ok, what does it means? • Non-relational AKA “Structured Storage” • No fixed Table Schemas • No (or minimal) JOIN operations • Usually low-level record-at-a-time instead of SQL clauses • Scale horizontally

  5. Why NoSQL? • “Most” modern applications are web-based • As such, must be able to scale out by simply adding commodity servers • NoSQL DBMS are built to be able to scale out • No fixed schema provides flexibility of design and development – no “schema written in stone syndrome”

  6. NoSQL DBMS vs. RDBMS • RDBS are mostly all about ACID • Atomicity, Consistency, Isolation, Durability • NoSQL are mostly BASE • Basically Available, Soft state, Eventual consistency

  7. So, BASE is…. • It’s like a teenager: • Always Basically Available (open to new relationships) • in a Soft state (none of the relationships last very long) • and Eventually consistent (one day he/shewill get a girlfriend/boyfriend and eventually get married).

  8. NoSQL Logical Model • Key Value • Amazon Dynamo, Voldemort, Dynomite, Azure TableStorage • Document Oriented • Couch DB, MongoDB

  9. NoSQL Logical Model • Wide Column Store • Google BigTable, HBase • Graph • Twitter’s FlockDB, Neo4J

  10. Communalities • Loosely typed extensible data schema • Consistency gives place to scalability and availability • Designed for horizontal scaling through data distribution model across multiple nodes • Support various 'Non-SQL' interfaces (REST, Get/Put, API,etc.)

  11. NoSQL cheat-sheet AKA References • NoSQL - Your Ultimate Guide to the Non - Relational Universe • http://nosql-database.org/ • NoSQL in the Enterprise • http://www.infoq.com/articles/nosql-in-the-enterprise • Whitepaper on NoSQL and the Windows Azure Platform • http://blogs.msdn.com/b/sqlazure/archive/2011/05/04/10160671.aspx • NoSQL Ecosystem • http://www.rackspace.com/cloud/blog/2009/11/09/nosql-ecosystem/ • Why NoSQL? • http://www.couchbase.com/why-nosql/nosql-database • BASE: AnAcidAlternative • http://queue.acm.org/detail.cfm?id=1394128

  12. Q&A Time…

  13. Thank you for your patience! How to find me… if you care to know! (really? don’t you have anything better to do?) Twitter: @pjtmatos e-mail: mail@paulomatos.com

More Related