NoSQL - SQLPort

Document Sample
NoSQL - SQLPort Powered By Docstoc
					The Lightning               Way

XIV Encontro da comunidade SQLPort
           LX 2011.08.16



                                     1
When all you have is a
hammer, you tend to see
every problem as a nail.

Abraham Maslow



                           2
• “Next Generation Databases mostly
  addressing some of the points: being non-
  relational, distributed, open-
  source and horizontally scalable. (…)”

                     from nosql-databases.org




                                              3
• 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



                                               4
• “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”

                                         5
• RDBS are mostly all about ACID
  • Atomicity, Consistency, Isolation, Durability


• NoSQL are mostly BASE
  • Basically Available, Soft state, Eventual
    consistency



                                                    6
• 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/she will get a girlfriend/boyfriend and
    eventually get married).


                                                      7
• Key Value
  – Amazon Dynamo, Voldemort, Dynomite,
    Azure Table Storage


• Document Oriented
  – Couch DB, MongoDB




                                          8
• Wide Column Store
  – Google BigTable, HBase


• Graph
  – Twitter’s FlockDB, Neo4J




                               9
• 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.)

                                                 10
•   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: An Acid Alternative
•   http://queue.acm.org/detail.cfm?id=1394128



                                                                        11
12
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




                                            13

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:2
posted:11/14/2012
language:English
pages:13