Refactoring Databases: Evolutionary Database Design

Chapter 11Transformations

Transformations are changes that change the semantics of your database schema by adding new features to it. The transformations described in this chapter are as follows:

• Insert Data

• Introduce New Column

• Introduce New Table

• Introduce View

• Update Data

Insert Data

Insert data into an existing table.

Motivation

You typically need to apply Insert Data as the result of structural changes within your table design. You may need to apply Insert Data as the result of the following:

• Table reorganization. When you are using Rename Table (page 113), Merge Tables (page 96), Split Table (page 145), or Drop Table (page 77) refactorings, you may have to use Insert Data to reorganize the data in the existing ...