Curt Gratz

Camp Counselor

Relationships are Hard – Data modeling with NoSQL

Event Logo

Wednesday, January 18, 2023 - 8:30 PM UTC, for 1 hour.

Regular, 60 minute presentation

Room: Campsite 3

Database
NoSQL
Data Modeling
Data Architecture

Learn data modeling with NoSQL databases, and how it differs from relational database data modeling., We will also look at good opportunities for using a NoSQL database and when a relational database is still the way to go. We will see why many NoSQL databases don’t pass the ACID (Atomicity, Consistency, Isolation, Durability) test on purpose and what this means to you, the developer. In this talk we look at the history of NoSQL and how these databases came to be and the problems they solve. Then we dive into looking at ACID and how it can be met or not met within some of the various popular databases out there and the choices you make as a developer because of this. After that we look into both keying in NoSQL and the various ways of storing data in the NoSQL world. Finally, we walk through a real world example of data modeling, looking at how it would differ from relational data model, and some of the choices you can make based on your various use cases. FIVE main points 1) Learn data modeling with NoSQL databases 2) Learn to identify good opportunities to use NoSQL and when not to. 3) Learn about ACID and the implications when using various NoSQL databases 4) Discuss various paradigms for storing different datatypes in NoSQL 5) Discuss the advantages/disadvantages of denormalizing data or replicating data for scaling.

Prerequisites

Basic data modeling/database design principles

Take Aways

  • Learn data modeling with NoSQL databases
  • Learn to identify good opportunities to use NoSQL and when not to.
  • Learn about ACID and the implications when using various NoSQL databases
  • Discuss various paradigms for storing different datatypes in NoSQL
  • Discuss the advantages/disadvantages of denormalizing data or replicating data for scaling.
favorited by:
Cori Drew Caleb Jenkins Joel Lord Mike Clement Allen Zaudtke Sharon Cichelli Olena Kutsenko Arana Fireheart Dave Aronson Kris Kirkland