← All presentations

Defining What's Normal: The Basics of Database Normalization

Download

Abstract

Determining how to design database structures efficiently for a given application has always relied on the same old answer: “It depends!” So, how do you determine what level of normalization your data requires? This session will review the principles of data normalization, show the impact that normalization can have on performance and data integrity, and, just as importantly, show you when it’s OK to break the rules and denormalize. We will cover some cases where it’s better not to be normal!

Presented at:

  • Retro Data (virtual) on Sep 20, 2025
  • PostgresWorld Webinar (virtual) on May 27, 2025
  • Big Mountain Data & Dev Conference 2023, Salt Lake City, UT on Nov 10, 2023
  • Big Mountain Data & Dev Conference 2022, Salt Lake City, UT on Nov 10, 2022
  • Data Geeks Saturday 2021, South Florida on Aug 7, 2021 (virtual)
  • SQL Saturday #920, Portland, OR on Nov 2, 2019