Chapter 3The Process of Database Refactoring
A new scientific truth does not triumph by convincing its opponents and making them see the light, but rather because its opponents eventually die, and a new generation grows up that is familiar with it.
—Max Planck
This chapter describes how to implement a single refactoring within your database. We work through an example of applying the Move Column (page 103), a structural refactoring. Although this seems like a simple refactoring, and it is, you will see it can be quite complex to safely implement it within a production environment. Figure 3.1 overviews how we will move the Customer.Balance column to the Account table, a straightforward change to improve the database design.
Figure 3.1. ...
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.
