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.


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

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.