Agile Data

Catalog of Database Refactorings - Transformations

Follow @scottwambler on Twitter!

A non-refactoring transformation is a change which affects the semantics of your database schema by adding new elements to it or by modifying existing elements. 
Transformation Example
Insert Data. Add new data into an existing table.
Introduce New Column. Add a new column into an existing table.
Introduce New Table. Add a new table into an existing database.
Introduce View. Add a new view based on existing tables within the database.
Update Data.  Update data within an existing table.


Refactoring Databases This book describes, in detail, how to refactor a database schema to improve its design. The first section of the book overviews the fundamentals evolutionary database techniques in general and of database refactoring in detail. More importantly it presents strategies for implementing and deploying database refactorings, in the context of both "simple" single application databases and in "complex" multi-application databases. The second section, the majority of the book, is a database refactoring reference catalog. It describes over 60 database refactorings, presenting data models overviewing each refactoring and the code to implement it.