Summary

Bill Karwin built this from patterns he kept seeing in thousands of requests for SQL help: developers aren't usually SQL experts, and the SQL that gets written tends toward a small set of recurring, avoidable mistakes. Each of the 25 chapters names one antipattern, the Naive Tree for storing hierarchical data, Entity-Attribute-Value for flexible schemas, Polymorphic Associations, explains why it seems reasonable and where it breaks down, then walks through the fix and the relational theory behind it. This second edition, supervised in translation by Takuto Wada, updates the original for current database practice, and reads well both as something to skim for a name you recognize in your own schema and as something to read straight through to build design instincts.

Target Readers

• Developers who want a design vocabulary sharp enough to name specific problems in code review, not just say something feels wrong
• Engineers designing a schema who keep reaching for entity-attribute-value or polymorphic associations and want the tradeoffs first
• Teams doing a schema review who need a shared checklist of recurring, avoidable mistakes to check against

Colophon

Publisher

オライリー・ジャパン

ISBN

978-4814400744

Published

Jul 2025

List price

¥4,290incl. taxMay differ from the actual selling price on Amazon