Add CRUD Methods
Introduce four stored procedures (methods) to implement the creation, retrieval, update, and deletion (CRUD) of the data representing a business entity.
Example
For more information see page 232 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