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

Get Refactoring Databases: Evolutionary Database Design now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial