Database refactoring

In 2006 Scott Ambler, Pramod Sadalage describe the following categories of database refactoring: • Architecture Refactoring ::A change which improves the overall manner in which external programs interact with a database. Methods of Architecture Refactoring category: Add CRUD Methods; Add Mirror Table; Add Read Method; Encapsulate Table With View; Introduce Calculation Method; Introduce Index; Introduce Read Only Table; Migrate Method From Database; Migrate Method To Database; Replace Method(s) With View; Replace View With Methods(s); Use Official Data Source. • Structural Refactoring ::A change to the table structure of your database schema. Methods of Structural Refactoring category: 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 ::A change which improves and/or ensures the consistency and usage of the values stored within the database. Methods of Data Quality Refactoring category: Add Lookup Table; Apply Standard Codes; Apply Standard Type; Consolidate Key Strategy; Drop Column Constraint; Drop Default Value; Drop Non Nullable; Introduce Column Constraint; Introduce Common Format; Introduce Default Value; Make Column Non Nullable; Move Data; Replace Type Code With Property Flags. • Referential Integrity Refactoring ::A change which ensures that a referenced row exists within another table and/or that ensures that a row which is no longer needed is removed appropriately. Methods of Referential Integrity Refactoring category: Add Foreign Key Constraint; Add Trigger for Calculated Column; Drop Foreign Key Constraint; Introduce Cascading Delete; Introduce Hard Delete; Introduce Soft Delete; Introduce Trigger for History. • Transformation ::A change which changes the semantics of your database schema by adding new elements to it or by modifying existing elements. Methods of Transformation category: Insert Data; Introduce New Column; Introduce New Table; Introduce View; Update Data. • Method Refactoring ::A change which improves the quality of a stored procedure, stored function, or trigger. Methods of the Method Refactoring category: 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. In 2019 Vladislav Struzik supplemented the categories of database refactoring with a new one: • Access Refactoring ::A change which relates to data access. Methods of the Access Refactoring category: Change Authentication Attributes; Revoke Authorization Privileges; Grant Authorization Privileges; Extract Database Schema; Merge Database Schemas. ==Process of database refactoring==