Book
SQL Antipatterns, Volume 1
Bill Karwin
Summary
ナイーブツリー・EAV（エンティティ・アトリビュート・バリュー）・ポリモーフィック関連など、 現場で頻出する不適切な設計と SQL の失敗例を 25 章で網羅し、回避策を提示する世界的名著。 第2版では現代の DB 事情を反映した加筆が施され、和田卓人氏の監訳が付く。
Target Readers
- コードレビューで強力に指摘できる設計眼を養いたいエンジニア
- 現場の DB 設計で陥りがちな失敗を未然に回避したい開発者
Tags
Colophon
- Publisher
- オライリー・ジャパン
- ISBN
- 978-4814400744
- Published
- Jul 2025
- List price
- ¥4,290incl. taxMay differ from the actual selling price on Amazon
Get this book
* The link above is an advertisement via Amazon Associates.Related Books
Prerequisites
- Recommended
達人に学ぶDB設計徹底指南書 第2版
ミック
Reason: After learning the correct design procedure, the next step is learning what not to do from cautionary examples. Bill Karwin's 'SQL Antipatterns' systematizes classic failures—missing foreign keys (Keyless Entry), EAV, comma-separated lists—reinforcing from the flip side why enforcing integrity with constraints matters.
- Related
理論から学ぶデータベース実践入門
奥野幹也
Reason: Understanding the relational model and normalization theory lets you read each failure in Karwin's 'SQL Antipatterns' through the lens of 'which theoretical principle it violates'. Knowing the theory lets you judge why an anti-pattern is bad from first principles, turning it into transferable knowledge rather than memorization.
Sources
Next Books
- Recommended
失敗から学ぶRDBの正しい歩き方
曽根壮大
Reason: Where Karwin's 'SQL Antipatterns' addresses failures at the logical-design and SQL level, the Japanese book '失敗から学ぶRDBの正しい歩き方' addresses RDB pitfalls that surface in production operation. Extending from design-time anti-patterns to operation-time ones gives a full panorama of failure patterns from design through operation.
Sources
- Related
データベース・リファクタリング
Scott W. Ambler, Pramod J. Sadalage
Reason: Once Karwin's 'SQL Antipatterns' lets you spot bad designs already baked in, you next need a safe way to fix them. 'Refactoring Databases' offers a catalog of patterns for incrementally improving a schema while preserving production data, joining the discovery of anti-patterns to their remediation end to end.