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 7Data Quality Refactorings

Data quality refactorings are changes that improve the quality of the information contained within a database. Data quality refactorings improve and/or ensure the consistency and usage of the values stored within the database. The data quality refactorings are as follows:

• Add Lookup Table

• Apply Standard Codes

• Apply Standard Type

• Consolidate Key Strategy

• Drop Column Constraint

• Drop Default Value

• Drop Non-Nullable Constraint

• Introduce Column Constraint

• Introduce Common Format

• Introduce Default Value

• Make Column Non-Nullable

• Move Data

• Replace Type Code With Property Flags

Common Issues When Implementing Data Quality Refactorings

Because data quality refactorings change the ...

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