Refactoring Databases: Evolutionary Database Design (Addison-Wesley Signature Series (Fowler))

Contents
About the Authors
Forewords
Preface
Acknowledgments
Chapter 1: Evolutionary Database Development
	1.1 Database Refactoring
	1.2 Evolutionary Data Modeling
	1.3 Database Regression Testing
	1.4 Configuration Management of Database Artifacts
	1.5 Developer Sandboxes
	1.6 Impediments to Evolutionary Database Development Techniques
	1.7 What You Have Learned
Chapter 2: Database Refactoring
	2.1 Code Refactoring
	2.2 Database Refactoring
		2.2.1 Single-Application Database Environments
		2.2.2 Multi-Application Database Environments
		2.2.3 Maintaining Semantics
	2.3 Categories of Database Refactorings
	2.4 Database Smells
	2.5 How Database Refactoring Fits In
	2.6 Making It Easier to Refactor Your Database Schema
	2.7 What You Have Learned
Chapter 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.4.1 Testing Your Database Schema
		3.4.2 Validating Your Data Migration
		3.4.3 Testing Your External Access Programs
	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
Chapter 4: Deploying into Production
	4.1 Effectively Deploying Between Sandboxes
	4.2 Applying Bundles of Database Refactorings
	4.3 Scheduling Deployment Windows
	4.4 Deploying Your System
	4.5 Removing Deprecated Schema
	4.6 What You Have Learned
Chapter 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
Chapter 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
Chapter 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
Chapter 8: Referential Integrity Refactorings
	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
Chapter 9: Architectural Refactorings
	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 Method(s)
	Use Official Data Source
Chapter 10: Method Refactorings
	10.1 Interface Changing Refactorings
		10.1.1 Add Parameter
		10.1.2 Parameterize Method
		10.1.3 Remove Parameter
		10.1.4 Rename Method
		10.1.5 Reorder Parameters
		10.1.6 Replace Parameter with Explicit Methods
	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
Chapter 11: Transformations
	Insert Data
	Introduce New Column
	Introduce New Table
	Introduce View
	Update Data
Appendix: The UML Data Modeling Notation
Glossary
	A
	B
	C
	D
	E
	F
	I
	M
	O
	P
	R
	S
	T
	U
	W
	X
References and Recommended Reading
Index
	A
	B–C
	D
	E
	F
	G–H
	I
	J–K
	L
	M
	N
	O–P
	Q–R
	S
	T
	U
	V–Z