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

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