Refactoring Databases: Evolutionary Database Design (paperback)

Refactoring Databases: Evolutionary Database Design (paperback)

by Scott J Ambler, Pramod J. Sadalage
     
 

View All Available Formats & Editions

ISBN-10: 0321774515

ISBN-13: 9780321774514

Pub. Date: 05/04/2011

Publisher: Addison-Wesley

Refactoring has proven its value in a wide range of development projects–helping software professionals improve system designs, maintainability, extensibility, and performance. Now, for the first time, leading agile methodologist Scott Ambler and renowned consultant Pramodkumar Sadalage introduce powerful refactoring techniques specifically designed for

Overview

Refactoring has proven its value in a wide range of development projects–helping software professionals improve system designs, maintainability, extensibility, and performance. Now, for the first time, leading agile methodologist Scott Ambler and renowned consultant Pramodkumar Sadalage introduce powerful refactoring techniques specifically designed for database systems.

Ambler and Sadalage demonstrate how small changes to table structures, data, stored procedures, and triggers can significantly enhance virtually any database design–without changing semantics. You’ll learn how to evolve database schemas in step with source code–and become far more effective in projects relying on iterative, agile methodologies.

This comprehensive guide and reference helps you overcome the practical obstacles to refactoring real-world databases by covering every fundamental concept underlying database refactoring. Using start-to-finish examples, the authors walk you through refactoring simple standalone database applications as well as sophisticated multi-application scenarios. You’ll master every task involved in refactoring database schemas, and discover best practices for deploying refactorings in even the most complex production environments.

The second half of this book systematically covers five major categories of database refactorings. You’ll learn how to use refactoring to enhance database structure, data quality, and referential integrity; and how to refactor both architectures and methods. This book provides an extensive set of examples built with Oracle and Java and easily adaptable for other languages, such as C#, C++, or VB.NET, and other databases, such as DB2, SQL Server, MySQL, and Sybase.

Using this book’s techniques and examples, you can reduce waste, rework, risk, and cost–and build database systems capable of evolving smoothly, far into the future.

Product Details

ISBN-13:
9780321774514
Publisher:
Addison-Wesley
Publication date:
05/04/2011
Series:
Addison-Wesley Signature Series (Fowler) Series
Edition description:
New Edition
Pages:
384
Product dimensions:
6.90(w) x 9.20(h) x 0.80(d)

Table of Contents

About the Authors xv

Forewords xvii

Preface xxi

Acknowledgments xxvii

Chapter 1: Evolutionary Database Development 1

Chapter 2: Database Refactoring 13

Chapter 3: The Process of Database Refactoring 29

Chapter 4: Deploying into Production 49

Chapter 5: Database Refactoring Strategies 59

Chapter 6: Structural Refactorings 69

Chapter 7: Data Quality Refactorings 151

Chapter 8: Referential Integrity Refactorings 203

Chapter 9: Architectural Refactorings 231

Chapter 10: Method Refactorings 277

Chapter 11: Transformations 295

Appendix: The UML Data Modeling Notation 315

Glossary 321

References and Recommended Reading 327

Index 331

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >