Book
Shippai kara Manabu RDB no Tadashii Arukikata (The Right Way to Work with RDBs, Learned from Failure)
Taketomo Sone
Summary
A Japanese-language guide to relational-database anti-patterns by Taketomo Sone. It opens with complaints the book treats as common: a database that keeps going down, tables and SQL left behind by a previous engineer that no one can decipher, and unexpected bugs after swapping out an RDBMS. The author argues that teams designing and operating MySQL- or PostgreSQL-based business systems and web services run into problems like these often. The book introduces incorrect ways of using a relational database, or anti-patterns, while explaining the know-how needed to avoid creating them. Each chapter also covers the RDB and SQL fundamentals required to solve the problem at hand, which the author recommends to newcomers who have only recently started working with an RDBMS.
Target Readers
- Engineers designing and operating MySQL- or PostgreSQL-based business systems and web services who often run into failures whose cause they can't pin down, and want to fix that
- Developers who inherit tables and SQL left behind by a previous engineer that they can't decipher, or who have hit unexpected bugs after swapping out their RDBMS
- Newcomers who have only recently started working with an RDBMS, since each chapter also covers the RDB and SQL fundamentals needed to follow it
Tags
Colophon
- Publisher
- Gijutsu-Hyohron
- ISBN
- 978-4297104085
- Published
- Mar 2019
- List price
- ¥3,014incl. 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
Spring Tettei Nyumon (A Thorough Introduction to Spring)
Java Application Development with the Spring Framework
NTT Data
Reason: Once you handle databases with Spring, the quality of the SQL and table design running behind the ORM starts to govern performance and maintainability. This book teaches the principles of relational design from a practitioner's angle, framed around the antipatterns people commonly fall into.
- Recommended
SQL Jissen Nyumon (A Practical Introduction to SQL)
Writing Fast, Easy-to-Understand Queries
Mick
Reason: Once you study query tuning and index design, you see that many performance problems trace back to early schema and operational decisions. This Japanese book on RDB pitfalls covers operational anti-patterns—soft deletes, caching, idempotency—lifting your view above optimizing individual SQL statements.
- Recommended
SQL Antipatterns, Volume 1
Avoiding the Pitfalls of Database Programming
Bill Karwin
Reason: Where Karwin's 'SQL Antipatterns' addresses failures at the logical-design and SQL level, this Japanese book 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.
- Related
Clean Architecture
A Craftsman's Guide to Software Structure and Design
Robert C. Martin
Reason: Architecturally, the database sits on the outside as a 'detail,' but neglecting that detail—relational design—breaks down in practice. Learning the antipatterns sharpens your instincts for schema design, reconciling the ideal of abstraction with the reality of implementation.
- Related
Tatsujin ni Manabu SQL Tettei Shinansho, 2nd Edition (A Thorough Guide to SQL, Learned from an Expert)
For Those Who Do Not Want to Remain Beginners
Mick
Reason: Even when you can write applied SQL fluently, the RDB-specific pitfalls you meet in production are a separate body of knowledge. Adding the operational perspective from this Japanese book on RDB pitfalls balances the ability to write SQL with the ability to operate the database.
Next Books
- Recommended
Designing Data-Intensive Applications
The Big Ideas Behind Reliable, Scalable, and Maintainable Systems
Martin Kleppmann
Reason: Having understood the design of a single relational database, you broaden your view to the big picture of large-scale systems involving multiple data stores. Designing Data-Intensive Applications systematizes the fundamentals of data systems—replication, partitioning, consistency, faults—without being swayed by passing trends.