Refactoring Databases: Evolutionary Database Design

Customers who bought this, also bought: WHS: A Management Guide, 3rd Edition Australian Taxation Law 2012 - 22nd Edition Business Statistics - Abridged: Australia New Zealand Edition, 5th Edition Financial Accounting: A Practical Approach, 3rd Edition Teaching Primary Science Constructively, 4th Edition Australian Business Law + 2011 Update, 6th Edition (For the new 7th edition, please perform a new search using the following ISBN: 9781442537859) C++ Primer Plus (5th Edition) Accounting: An Introduction to Principles and Practice, 6th Edition + Accounting: An Introduction to Principles and Practice Workbook (This is an OLD EDITION. For the new edition, please use ISBN: 9780170165570) Company Accounting: Prepare Financial Reports for a Reporting Entity, 2nd Edition Australian Master Bookkeepers Guide 2010/11 - 3rd Edition

by: Scott W. Ambler, Pramodkumar J. Sadalage, Pramodkumar J. Sadalage

Notify me when in stock

On-line Price: $51.95 (includes GST) Hardcover package 384 20%Off Retail Price You save: $13.00 OUT OF PRINT...must be sought from extended supplier network... Usual delay approx 3 weeks...Subject to change.. Price/availability/options for all order will be confirmed by reply email before processing.	Retail Price: $64.95 Publisher: ADDISON-WESLEY,3.3.2006 Category: Level: ISBN: 0321293533 ISBN13: 9780321293534
Add to Shopping Cart

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.

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