Normalization vs. Denormalization in Event Streaming - Module 4
Offered By: Confluent via YouTube
Course Description
Overview
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.
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
Related Courses
Statistics for Genomic Data ScienceJohns Hopkins University via Coursera Fundamentals of database systems
Indian Institute of Technology Kanpur via Swayam Database Systems Concepts and Design
Georgia Institute of Technology via edX Introduction to Data Modeling
Microsoft via edX Введение в базы данных
St. Petersburg State Polytechnic University via Stepik