4 December 2013

Introduction to NoSQL by Martin Fowler



Impedance Mismatch problem: O/R issues
SQL: does not work well with large clusters
Google: Bigtable
Amazon: Dynamo
=> NoSQL
Origin: a Twitter hashtag to advertise a single meeting #nosql

  • non-relational
  • open-source
  • cluster-friendly
  • schema-less
    • when you are getting a price from a row, you are utilizing schema, but when you don't have schema there is no guarantee data is there
  • 21st Century Web
Data Model:
  • 1 Aggregate-oriented
  • 1 Document (usually JSON, you could do it in XML as well)
    • there is an id, simillar to key in key value
  • 1 Key-Value
    • you can have metadata, and you can index them
  • 1 Column-Family
    • row key, column key 
different data on different cluster based on the aggregate 
aggregate = key
aggregate = document

changing aggregate is pain if you want to change the data and aggregate


    • Graph

    1 comment:

    1. Amazon SimpleDB service is also NO-SQL Cloud Database Service. Amazon SimpleDB can be useful for those who need a non-relational database for storage of smaller, non-structural data. Amazon SimpleDB has restricted storage size to 10GB per domain and it can achieve up to 25 writes/second. Amazon SimpleDB offers simplicity and flexibility. SimpleDB automatically indexes all data. Amazon SimpleDB pricing is based on your actual box usage. You can store any UTF-8 string data in Amazon SimpleDB.

      http://www.sdbexplorer.com/

      ReplyDelete