# Database Modelization Anti-Patterns

DevFeed: [Database Modelization Anti-Patterns](<https://devfeed.tech/articles/database-modelization-anti-patterns-34584.md>)

Original publisher: [Read original article](<https://tapoueh.org/blog/2018/03/database-modelization-anti-patterns/>)

Author: Dimitri Fontaine PostgreSQL Major Contributor; Author

Published: 2018-03-08T17:00:43Z

Content type: article

Language: en

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

Topics: [data-modeling](<https://devfeed.tech/topics/data-modeling.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Database](<https://devfeed.tech/topics/database.md>)

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

## AI overview

This article examines database modeling and normalization by discussing three anti-patterns: entity-attribute-value designs, storing multiple values in one column, and using UUIDs in some situations. It focuses on the practical problems these designs can create, including typos, weak typing, extra processing, and more complex SQL queries.

## Source excerpt

Next week we see two awesome PostgreSQL conferences in Europe, back to back, with a day in between just so that people may attend both! In chronological order we have first Nordic pgDay in Oslo where I will have the pleasure to talk about Data Modeling, Normalization and Denormalization. Then we have pgday.paris with an awesome schedule and a strong focus on the needs of application developers!