Explore the trade-offs between normalization and denormalization in event data modeling in this 16-minute video tutorial from Confluent's "Designing Events and Event Streams" course. Compare relational database normalization with document database denormalization approaches. Learn about creating normalized streams from normalized tables, the impact on consumers, and strategies for abstraction. Discover techniques like reconstructing streams, building purpose-built joiners, and implementing the Transactional Outbox Pattern. Examine producer-side denormalization and when to apply it appropriately. Use real-world examples, including user behavior events and inventory management, to understand these concepts in practice.
Normalization vs. Denormalization in Event Streaming - Module 4
Overview
Syllabus
Intro
Normalized Tables Make Normalized Streams
Normalization vs. Denormalization
Consumers Couple on the Internal Model
Create an Abstraction Layer and External Model
Option 1: Reconstruct the Streams
Alternative Use Case - User Behavior Events
Build a Purpose-Built Joiner
Transactional Outbox Pattern
Update the Brand Name
Option 2: Producer-Side Denormalization
Tip: Only Denormalize Where Appropriate
Expanded Example - Include Inventory
Taught by
Confluent
