# FOSDEM 2019: Data Modeling, Normalization, and Denormalisation

DevFeed: [FOSDEM 2019: Data Modeling, Normalization, and Denormalisation](<https://devfeed.tech/articles/fosdem-2019-data-modeling-normalization-and-denormalisation-34631.md>)

Original publisher: [Read original article](<https://tapoueh.org/conf/fosdem-2019-data-modeling-normalization-and-denormalisation/>)

Published: 2019-02-02T22:00:00Z

Content type: article

Language: en

Sources: [Dimitri Fontaine](<https://devfeed.tech/sources/dimitri-fontaine.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [data-modeling](<https://devfeed.tech/topics/data-modeling.md>), [FOSDEM](<https://devfeed.tech/topics/fosdem.md>), [data-architecture](<https://devfeed.tech/topics/data-architecture.md>), [data](<https://devfeed.tech/topics/data.md>), [Open Source](<https://devfeed.tech/topics/open-source.md>)

Tags: [data-modeling](<https://devfeed.tech/tags/data-modeling.md>), [database](<https://devfeed.tech/tags/database.md>), [fosdem](<https://devfeed.tech/tags/fosdem.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [schema](<https://devfeed.tech/tags/schema.md>)

## AI overview

A FOSDEM 2019 talk about practical database schema modeling with PostgreSQL. It covers normalization examples, anti-patterns, denormalization techniques, advanced data types, and the trade-offs involved in applying these approaches.

## Source excerpt

As a developer using PostgreSQL one of the most important tasks you have to deal with is modeling the database schema for your application. In order to achieve a solid design, it's important to understand how the schema is then going to be used as well as the trade-offs it involves. As Fred Brooks said: "Show me your flowcharts and conceal your tables, and I shall continue to be mystified. Show me your tables, and I won't usually need your flowcharts; they'll be obvious." In this talk we're going to see practical normalisation examples and their benefits, and also review some anti-patterns and their typical PostgreSQL solutions, including Denormalization techniques thanks to advanced Data Types.