Agile Data

Catalog of Database Refactorings

Follow @scottwambler on Twitter!

A database refactoring is a small change to your database schema which improves its design without changing its semantics. This catalog is organized into several categories of database refactoring:
Category Database Refactorings
Structural Refactorings
Data Quality Refactorings
Referential Integrity Refactorings
Architectural Refactorings
Method Refactorings
Non-Refactoring Transformations

Source

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.