Data Denormalization in Modern System Design

Partner: Udemy
Affiliate Name:
Area:
Description: We will dive deep into the cutting-edge world of modern database and software engineering, where traditional data normalization is increasingly giving way to more powerful techniques: denormalized views.Whether you’re struggling with slow queries, high latency, or scaling data for millions of users, this series will teach you how to harness the true potential of denormalized views.We’ll break down complex concepts in simple terms, showing you how modern views replicate and transform data for specific use cases, reduce the need for real-time processing, and improve overall performance. We'll cover how to implement such denormalization process, from using event-driven architecture to using batch processing instead and materialized views. We'll talk about denormalization techniques, and how to map and handle all of the many edge cases they will bring about.In this course, I want to challenge the way we think about databases and system design. In the past, normalization —structuring data into its smallest parts, and forbidding data duplication— was the golden rule for optimizing databases. But nowadays things have changed. When we’re dealing with massive amounts of data, oftentimes normalization can actually slow us down.What if there was another approach? I’ll show how effective denormalization of your data to what I call “denormalized views” can help provide an alternative solution to complete normalization. We’ll demonstrate how replicating your data in a new denormalized format, designed for fast read access for a specific use case, can help you solve a new class of problem you weren’t able to serve before because of perf
Category: IT & Software > Other IT & Software > System Design Interview
Partner ID:
Price: 24.99
Commission:
Source: Impact
Go to Course