~/talk

Relational or Non-Relational? Choosing the Best Database for the Task

Talkat SQLBits 2022 · 2022-03-08..03-12· [databases]
links:none on file
slides:none on file

Compares relational ACID tradeoffs with NoSQL BASE and shows concrete choices: uses Azure Cosmos DB document model to build a URL redirection service (zombocom redirect) with a userID partition key, explains physical partitions limited to 20 GB and automatic splits, and highlights five consistency modes to pick between latency and correctness. Recommends avoiding relational storage for logs, images, or huge text, and favors document stores for schema‑less, large scaleout workloads where single‑record reads dominate.

AI-written summary · about

  1. 0:00Introduction
  2. 1:00Database models defined
  3. 3:15Relational normal forms
  4. 5:58NoSQL database design
  5. 7:53Partitioning in Cosmos DB
  6. 10:15Consistency and CAP theorem
  7. 14:01Choosing the right database
  8. 18:17Conclusion
~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.