Book
Refactoring Databases
Evolutionary Database Design
Scott W. Ambler, Pramod J. Sadalage
Summary
Refactoring Databases: Evolutionary Database Design, by Scott W. Ambler and Pramod J. Sadalage, was published by Addison-Wesley Professional in 2006 (384 pages). It presents refactoring techniques designed for database systems. Small changes to table structures, data, stored procedures, and triggers improve a database design without changing its semantics, and the schema is evolved in step with the source code in iterative, agile projects. The examples range from simple standalone database applications to scenarios with multiple applications, and the book covers deploying refactorings in production. The second half covers five categories of refactorings: database structure, data quality, referential integrity, architecture, and methods. The examples use Oracle and Java and can be adapted to other languages and databases such as DB2, SQL Server, MySQL, and Sybase.
Target Readers
- Engineers who want to evolve database schemas continuously in agile development
- Development teams who want to integrate database migrations into CI/CD pipelines
- Software professionals on iterative, agile projects who are interested in refactoring techniques designed for database systems
Tags
Colophon
- Publisher
- Pearson Education
- ISBN
- 978-4894715004
- Published
- Apr 2008
- List price
- ¥3,960incl. 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
Tatsujin ni Manabu DB Sekkei Tettei Shinansho, 2nd Edition (A Thorough Guide to DB Design, Learned from an Expert)
Mick
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 Antipatterns, Volume 1
Avoiding the Pitfalls of Database Programming
Bill Karwin
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.
- Related
Database Reliability Engineering
Designing and Operating Resilient Database Systems
Laine Campbell, Charity Majors
Reason: After learning the principles of 'don't break it' operations in 'Database Reliability Engineering', the question becomes how to uphold them when you actually change the schema. The zero-downtime migration techniques in 'Refactoring Databases' form a parallel reference that translates SRE-style reliability goals into concrete schema-change procedures.