Catalog of Database Refactorings: Data Quality Refactorings (Data Repairs)

Data quality database refactorings have been renamed data repairs and are considered a data quality technique in their own right.  Please visit that page for details

A data repair is a change which improves and/or ensures the consistency and usage of the values stored within the database. Data repairs, because they change data values, may change the data semantics (unlike database refactorings).

Recommended Reading

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.