Replace Type Code With Property Flags
Replace a code column with individual property flags, usually implemented as Boolean columns, within the same table column.
Example
For more information see page 196 of Database Refactoring
- Architecture Refactoring
- Structural Refactoring
- Drop Column
- Drop Table
- Drop View
- Introduce Calculated Column
- Introduce Surrogate Key
- Merge Columns
- Merge Tables
- Move Column
- Rename Column
- Rename Table
- Rename View
- Replace LOB With Table
- Replace Column
- Replace One-To-Many With Associative Tables
- Replace Surrogate Key With Natural Key
- Split Column
- Split Table
- Data Quality Refactoring
- Referential Integrity Refactoring
- Transformation
- Method Refactoring
- Parameterize Methods
- Remove Parameter
- Rename Method
- Reorder Parameters
- Replace Parameter with Explicit Methods
- Consolidate Conditional Expression
- Decompose Conditional
- Extract Method
- Introduce Variable
- Remove Control Flag
- Remove Middle Man
- Replace Literal with Table Lookup
- Replace Nested Conditional with Guard Clauses
- Split Temporary Variable
- Substitute Algorithm
Hosted By: ThoughtWorks