Chapter 5Database Refactoring Strategies
Knowing more today than yesterday is good news about today, not bad news about yesterday.
—Ron Jeffries
This chapter describes some of our experiences with database refactoring on actual projects, and suggests a few potential strategies that you may want to consider. In many ways, this chapter summarizes a collection of “lessons learned” that we hope will help your adoption efforts. These lessons include the following:
• Smaller changes are easier to apply.
• Uniquely identify individual refactorings.
• Implement a large change by many small ones.
• Have a database configuration table.
• Prefer triggers over views or batch synchronization.
• Choose a sufficient deprecation period.
• Simplify your ...
Get Refactoring Databases: Evolutionary Database Design now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
