Refactoring, making a small change in source code that will not affect the semantics, has been shown to improve system design and performance, while making systems easier to maintain and extend. Using extensive examples set in Oracle and Java (but easily translatable by other languages including C#, C++ or VB.NET, master practitioners Ambler and Sadalage guide users through a variety of databases and evolutionary, iterative processes. They cover evolutionary database development, database refactoring, core processes such as testing and migrating the source data, deploying into production, strategies, transformations, and refactoring in structure, data quality, referential integrity, architecture, and methods. They include lists of recommended reading.
Annotation ©2006 Book News, Inc., Portland, OR (booknews.com)

Refactoring, making a small change in source code that will not affect the semantics, has been shown to improve system design and performance, while making systems easier to maintain and extend. Using extensive examples set in Oracle and Java (but easily translatable by other languages including C#, C++ or VB.NET, master practitioners Ambler and Sadalage guide users through a variety of databases and evolutionary, iterative processes. They cover evolutionary database development, database refactoring, core processes such as testing and migrating the source data, deploying into production, strategies, transformations, and refactoring in structure, data quality, referential integrity, architecture, and methods. They include lists of recommended reading. Annotation ©2006 Book News, Inc., Portland, OR (booknews.com)

Database refactoring is making a small change to the database's table structures, data, stored procedures, and triggers which improves its design without changing its semantics. This reference book describes the fundamentals of database refactoring.

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, andSybase. 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.