Contents
- About the Authors
- Forewords
- Preface
- Acknowledgments
- 1. Evolutionary Database Development
- 2. Database Refactoring
- 3. The Process of Database Refactoring
-
- 3.1 Verify That a Database Refactoring Is Appropriate
- 3.2 Choose the Most Appropriate Database Refactoring
- 3.3 Deprecate the Original Database Schema
- 3.4 Test Before, During, and After
- 3.5 Modify the Database Schema
- 3.6 Migrate the Source Data
- 3.7 Refactor External Access Program(s)
- 3.8 Run Your Regression Tests
- 3.9 Version Control Your Work
- 3.10 Announce the Refactoring
- 3.11 What You Have Learned
- 4. Deploying into Production
- 5. Database Refactoring Strategies
-
- 5.1 Smaller Changes Are Easier to Apply
- 5.2 Uniquely Identify Individual Refactorings
- 5.3 Implement a Large Change by Many Small Ones
- 5.4 Have a Database Configuration Table
- 5.5 Prefer Triggers over Views or Batch Synchronization
- 5.6 Choose a Sufficient Transition Period
- 5.7 Simplify Your Database Change Control Board (CCB) Strategy
- 5.8 Simplify Negotiations with Other Teams
- 5.9 Encapsulate Database Access
- 5.10 Be Able to Easily Set Up a Database Environment
- 5.11 Do Not Duplicate SQL
- 5.12 Put Database Assets Under Change Control
- 5.13 Beware of Politics
- 5.14 What You Have Learned
- Online Resources
- 6. Structural Refactorings
-
- Common Issues When Implementing Structural Refactorings
- 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 Table
- Replace Surrogate Key With Natural Key
- Split Column
- Split Table
- 7. Data Quality Refactorings
-
- Common Issues When Implementing Data Quality Refactorings
- 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
- 8. Referential Integrity Refactorings
- 9. Architectural Refactorings
- 10. Method Refactorings
-
- 10.1 Interface Changing Refactorings
- 10.2 Internal Refactorings
-
- 10.2.1 Consolidate Conditional Expression
- 10.2.2 Decompose Conditional
- 10.2.3 Extract Method
- 10.2.4 Introduce Variable
- 10.2.5 Remove Control Flag
- 10.2.6 Remove Middle Man
- 10.2.7 Rename Parameter
- 10.2.8 Replace Literal with Table Lookup
- 10.2.9 Replace Nested Conditional with Guard Clauses
- 10.2.10 Split Temporary Variable
- 10.2.11 Substitute Algorithm
- 11. Transformations
- The UML Data Modeling Notation
- Glossary
- References and Recommended Reading
- List of Refactorings and Transformations
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.