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

Customers buy this book with Agile Database Techniques by Scott Ambler

Price For Both: £49.68

Agile Database Techniques by Scott Ambler  (1)  £20.89

Patterns of Enterprise Application Architecture (The Addison-Wesley Signature Series) by Martin Fowler  (9)  £25.79

Refactoring: Improving the Design of Existing Code (Object Technology Series) by Martin Fowler  (17)

xUnit Test Patterns: Refactoring Test Code (Addison Wesley Signature): Refactoring Test Code by Gerard Meszaros  (2)  £23.99

Working Effectively with Legacy Code (Robert C Martin) by Michael Feathers  (3)  £21.59

› Explore similar items : Books (99)

Synopsis
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 covers every fundamental concept underlying database refactoring, and helps you overcome the practical obstacles to refactoring real-world databases. Start-to-finish examples walk you through refactoring both simple standalone database applications and 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. The 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. 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.

From the Back Cover

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 Am