The Many Flavors of NoSQL at TechBash

The relational database has been the dominant model for persisting data for the last 40 years. While SQL databases aren’t going away anytime soon, the NoSQL ("not only SQL") movement has challenged the relational database's place as the default persistence layer for modern applications. Learn about horizontal scaling and eventual consistency as well as key-value stores, document databases, graph databases, and more.

Transcript

1. TechBash
   Bradley Holt, Developer Advocate
   Wednesday, September 28, 2016
   The Many Flavors of NoSQL
   @BradleyHolt
   

   View Slide

2. View Slide

3. @BradleyHolt
   

   View Slide

4. View Slide

5. IBM Cloud Data Services
   Open for Data
   A comprehensive por.olio of open source data services
   

   View Slide

6. View Slide

7. View Slide

8. Big Data
   Get it?
   

   View Slide

9. A Brief History of Data
   

   View Slide

10. The Relational Database
    @BradleyHolt
    order
    *order_id
    customer_id
    date
    customer
    line_item
    *customer_id
    email_address
    name
    *order_id
    *item_id
    price
    quantity
    

    View Slide

11. ACID Guarantees
    Relational databases guarantee atomicity, consistency, isolation and durability
    

    View Slide

12. Big Iron
    The ACID guarantees provided by relational databases were (and often still are) critical
    for systems of record
    

    View Slide

13. The World Wide Web
    The introduction of the Web brought a whole new type of application with
    different constraints than systems of record
    @BradleyHolt
    

    View Slide

14. Mobile Apps
    The introduction of mobile apps added to the growing number of systems of engagement
    

    View Slide

15. Changing Constraints
    

    View Slide

16. Always On
    

    View Slide

17. Big Data
    

    View Slide

18. The CAP Theorem
    @BradleyHolt
    Partition
    Tolerance
    Availability
    Consistency
    Consistency Availability
    Partition
    Tolerance
    

    View Slide

19. Horizontal Scaling
    Horizontal scaling is scaling through the addition of commodity hardware
    

    View Slide

20. Eventual Consistency
    Given no new updates, each node in a distributed system will eventually have a
    consistent view of the data
    

    View Slide

21. Enter "Not only SQL" (NoSQL)
    

    View Slide

22. @BradleyHolt
    key-value
    graph
    document
    …more
    

    View Slide

23. @BradleyHolt
    

    View Slide

24. Key-Value Stores
    Opaque data accessed through unique keys
    

    View Slide

25. Document Databases
    A variation on key-value stores with strictly defined values (e.g. JSON objects)
    

    View Slide

26. Graph Databases
    Nodes and properties of nodes connected via edges
    

    View Slide

27. Choosing the Right Data Layer
    

    View Slide

28. Data Store
    It is not possible to abstract all of the constraints of your data store
    

    View Slide

29. Object-Relational Impedance Mismatch
    Object-oriented programming and relational databases use different models
    

    View Slide

30. Semi-Structured Data
    Relational databases enforce a schema
    

    View Slide

31. High Concurrency
    Database tuning often includes reducing the transaction scope or denormalization
    

    View Slide

32. Eric Evans on NoSQL
    "This is the world of NoSQL to me, that we can choose a tool that fits well with
    the problem we're trying to solve." –Eric Evans (author of Domain-Driven Design)
    @BradleyHolt
    

    View Slide

33. @BradleyHolt
    Catalog
    Document Database
    Key/Value Store
    Graph Database
    Full Text Search
    Shopping
    Cart
    Document Database
    Key/Value Store
    Orders Relational Database
    Big Data Analytics
    

    View Slide

34. Examples
    developer.ibm.com/clouddataservices
    

    View Slide

35. Cloudant
    FoodTracker
    

    View Slide

36. Simple Data Pipe
    @BradleyHolt
    

    View Slide

37. View Slide

38. View Slide

39. Further Reading
    @BradleyHolt
    

    View Slide

40. View Slide

41. Image Credits
    §  Open for Data Dome (outside) by Bradley Holt
    §  Open for Data Dome (inside) by Bradley Holt
    §  Brent Spiner (Data from Star Trek: The Next Generation) with
    Zoltar from Big by Bradley Holt, on Twitter
    
    §  database 2 by Tim Morgan, on Flickr
    §  Hard Disk by Jeff Kubina, on Flickr
    §  IBM 360 Announcement center by Robert Nix, on Flickr
    
    §  Dialing Up Web History by Mike Licht, on Flickr
    
    §  Instagram and other Social Media Apps by Jason Howie, on Flickr
    
    §  Dynamo, un siècle de lumière et de mouvement dans l'art, 1913 – 2013
    - Galeries nationales du Grand Palais - Paris - 10 avril au 22 juillet 2013
    by Yann Caradec, on Flickr
    §  World travel and communications recorded on Twitter by Eric Fischer,
    on Flickr
    §  Server grill with blue light by David Precious, on Flickr
    
    §  Spider Web by Alden Chadwick, on Flickr
    @BradleyHolt
    

    View Slide

42. Image Credits (cont'd)
    §  database by Tim Morgan, on Flickr
    §  Keys for the Stanley Hotel by Mike Silva, on Flickr
    
    §  paper by malik, on Flickr
    §  Edinburgh Road Network analysis by Steven Kay, on Flickr
    
    §  Lina Bo Bardi, SESC Pompéia by paulisson miura, on Flickr
    
    §  Financial District Classical Building Reflection Distortion, San Francisco,
    California, USA by Wonderlane, on Flickr
    §  Untitled by Allen Lai, on Flickr
    §  Traffic Trails by Mohan Noone, on Flickr
    §  Eric Evans by Oliver Gierke, on Flickr
    §  A mockup of the golden Apple iPhone 5S by Zach Vega,
    on Wikimedia Commons
    
    §  Marvin beating Data at Rock, Paper, Scissors by Marvin P Android,
    on Twitter
    
    @BradleyHolt
    

    View Slide

43. techbash.com/evals/sessions/the-many-flavors-of-nosql
    Thank You
    @BradleyHolt
    

    View Slide