Book
Tatsujin ni Manabu DB Sekkei Tettei Shinansho, 2nd Edition (A Thorough Guide to DB Design, Learned from an Expert)
Mick
Summary
A Japanese-language book on database design by Mick, a professional DB engineer, in its 2nd edition. It is a revision of the earlier book of the same title, which gently introduces the fundamentals and practical know-how of DB design. The 2nd edition keeps the original structure while updating the content and making it applicable to the cloud. It covers fundamentals such as logical design, normalization, and performance, with many samples and exercises at the end of each chapter, and it explains the anti-patterns to avoid and the gray-area practices to be careful about, including the reasons why. It also covers the process from logical design (ER diagrams and normalization) to physical design (sizing and indexes) and the trade-off between normalization and denormalization, with logical criteria for judging it.
Target Readers
- People aiming to become DB engineers, and people who want to learn the basics and practice of DB design
- DB engineers and application developers who want to move beyond the beginner level
- Intermediate engineers who want to learn criteria for DB design systematically, and developers who want to decide the trade-off between normalization and denormalization logically
Tags
Colophon
- Publisher
- Shoeisha
- 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
Riron kara Manabu Database Jissen Nyumon (Learning Databases from Theory)
Efficient SQL through the Relational Model
Mikiya Okuno
Reason: Once you have internalized relational and normalization theory, the next stage is translating it into real table design. This Japanese book 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.
- Recommended
Yasashii Database Sekkei (A Gentle Guide to Database Design)
Key Points from Requirements Definition through Operations
Yutaka Eto
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.
Next Books
- Recommended
SQL Antipatterns, Volume 1
Avoiding the Pitfalls of Database Programming
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
Jigyo Bunseki, Data Sekkei no Tame no Model Sakusei Gijutsu Nyumon (An Introduction to Modeling Techniques for Business Analysis and Data Design)
Masami Sato
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
System Kaihatsu, Sasshin no Tame no Data Model Taizen (The Complete Book of Data Models for System Development and Renewal)
Kozo Watanabe
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
Refactoring Databases
Evolutionary Database Design
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 Performance Explained
Everything Developers Need to Know about SQL Performance
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
Data-Oriented Programming
Reduce software complexity
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.
- Related
Jissen dbt Nyumon (A Practical Introduction to dbt)
Noritaka Sekiyama, Michiaki Nakaya, Tokimasa Toyohara, Jun Ohashi, Sotaro Hikita
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 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.