Book
達人に学ぶDB設計徹底指南書 第2版
ミック
Summary
論理設計（ER 図・正規化）から物理設計（サイジング・インデックス）への変換プロセスを体系化し、 正規化と非正規化のトレードオフを論理的な判断基準とともに解説する DB 設計の必読書。 第2版では現代のクラウドネイティブ環境に即した内容アップデートが施されている。
Target Readers
- DB 設計の判断基準を体系的に学びたい中級エンジニア
- 正規化と非正規化のトレードオフを論理的に下したい開発者
Tags
Colophon
- Publisher
- 翔泳社
- ISBN
- 978-4798186627
- Published
- Aug 2024
- List price
- ¥3,080incl. taxMay differ from the actual selling price on Amazon
Get this book
* The link above is an advertisement via Amazon Associates.Related Books
Prerequisites
- Prerequisite
理論から学ぶデータベース実践入門
奥野幹也
Reason: Once you have internalized relational and normalization theory, the next stage is translating it into real table design. This Japanese book (達人に学ぶDB設計徹底指南書) concretizes theory—normalization, primary keys, foreign keys—into the practical steps of logical and physical design, bridging theory and practice. Hence it is placed as a required prerequisite.
Sources
- Recommended
やさしいデータベース設計
衛藤豊
Reason: After going through the design process from requirements to operations once, you will want to dig into the judgment criteria for choosing between normalization and denormalization. 'DB Design Mastery Guide' covers the conversion process from logical to physical design along with its trade-offs, letting you relearn each stage touched on in the beginner book with concrete decision criteria.
Sources
Next Books
- Recommended
SQL Antipatterns, Volume 1
Bill Karwin
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.
- Recommended
事業分析・データ設計のためのモデル作成技術入門
佐藤正美
Reason: After mastering the basic DB design procedure, advance to the higher skill of mapping a real business domain into data structures. This Japanese book on business analysis and data modeling (事業分析・データ設計のためのモデル作成技術入門) teaches techniques for extracting entities from business analysis, cultivating the judgment of 'what to model' that lies beyond technical normalization.
- Recommended
システム開発・刷新のためのデータモデル大全
渡辺幸三
Reason: After grasping general design guidelines, move to a catalog of modeling patterns specific to business systems. This Japanese data-model compendium (データモデル大全) covers proven patterns for standard domains—ordering, inventory, accounting—expanding your repertoire of reusable, battle-tested structures instead of designing from scratch each time.
- Recommended
データベース・リファクタリング
Scott W. Ambler, Pramod J. Sadalage
Reason: Database design is not build-once-and-done; it must evolve continuously as the application changes. Ambler & Sadalage's 'Refactoring Databases' systematizes techniques for safely changing schemas, connecting initial-design knowledge to evolutionary design that keeps fixing the schema while in operation.
- Related
SQLパフォーマンス詳解
Markus Winand
Reason: After learning normalization-centric logical design, this is a supplementary path to understanding how that design rebounds on physical performance. Reading Winand's 'SQL Performance Explained' reveals how table design and key choices govern index efficiency, giving physical grounding to your logical-design decisions.
- Related
データ指向プログラミング
Yehonathan Sharvit
Reason: Studying RDB table design naturally extends interest to how data is represented on the application side. Yehonathan Sharvit's 'Data-Oriented Programming' advocates treating data as immutable generic structures, offering a view that connects the database's normalization mindset with application-side data modeling.
Sources
- Related
実践dbt入門
関山宜孝, 中谷宙央, 豊原世将, 大橋潤, 疋田宗太郎
Reason: After learning the normalization/denormalization trade-offs from a table-design perspective, you may want to try applying that same judgment to how you structure models on the analytics side. This book (実践dbt入門) covers project structuring and model execution in dbt, offering a supplementary path for carrying the structuring mindset gained from DB design over into building analytics data models.
Sources