O'Reilly logo

Refactoring Databases: Evolutionary Database Design by Pramod J. Sadalage, Scott W. Ambler

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required