This document provides an overview of database anti-patterns including: - The entity-attribute-value pattern, which stores data in a type-value format and cannot efficiently model constraints. Other options include seeking proper relational models or a "poor man's EAV" approach. - Materialized path trees, which reference the full parent path for each child and violate normalization rules but allow
![Models for hierarchical data](https://cdn-ak-scissors.b.st-hatena.com/image/square/38ddacaf2a042485615907547f5cbc93a0ac0878/height=288;version=1;width=512/https%3A%2F%2Fcdn.slidesharecdn.com%2Fss_thumbnails%2Fmodelsforhierarchicaldata-100520123959-phpapp02-thumbnail.jpg%3Fwidth%3D640%26height%3D640%26fit%3Dbounds)