false 161302 1 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. 155674 13 3 2006 Refactoring Databases: Evolutionary Database Design (The Addison-Wesley Signature Series) total:6|5:1|4:2|3:2|2:1| 6 21 23 0 0 0 false false Wed Sep 30 15:38:00 -0700 2009 Wed Sep 30 15:39:06 -0700 2009 0 0 false false Wed Sep 30 14:06:53 -0700 2009 Wed Sep 30 14:07:17 -0700 2009 0 0 false false Mon Sep 28 15:59:30 -0700 2009 Mon Sep 28 15:59:30 -0700 2009 0 0 false false Tue Sep 01 17:21:20 -0700 2009 Tue Sep 01 17:21:20 -0700 2009 0 0 false false Sun Jul 26 19:11:34 -0700 2009 Sun Jul 26 19:11:34 -0700 2009 0 0 false false Thu Jul 16 05:55:49 -0700 2009 Thu Jul 16 05:56:45 -0700 2009 0 0 false false Thu Jun 18 18:37:25 -0700 2009 Thu Jun 18 18:37:25 -0700 2009 4 0 false false Mon Jun 08 14:31:36 -0700 2009 Mon Jun 08 14:31:36 -0700 2009 0 0 false false Tue May 26 07:23:54 -0700 2009 Tue May 26 07:23:58 -0700 2009 3 0 false false Sun May 17 06:58:40 -0700 2009 Sun May 17 06:58:40 -0700 2009 0 0 false false Wed Apr 22 10:31:59 -0700 2009 Wed Apr 22 10:31:59 -0700 2009 0 0 false false Mon Apr 13 13:14:23 -0700 2009 Fri Aug 28 00:51:41 -0700 2009 3 0 false false Fri Dec 05 19:40:14 -0800 2008 Tue Nov 18 06:18:05 -0800 2008 Fri Dec 05 19:40:14 -0800 2008 2 0 false false Thu Sep 04 18:19:04 -0700 2008 Thu Sep 04 18:19:08 -0700 2008 0 0 false false Wed Sep 03 13:26:15 -0700 2008 Wed Sep 03 13:26:15 -0700 2008 0 0 false false Wed Aug 27 12:03:21 -0700 2008 Wed Aug 27 12:03:21 -0700 2008 0 0 false false Tue Aug 26 04:25:53 -0700 2008 Tue Aug 26 04:25:59 -0700 2008 4 0 false false Thu Aug 14 23:24:34 -0700 2008 Thu Aug 14 23:24:41 -0700 2008 5 0 false false Wed Jul 02 18:33:14 -0700 2008 Wed Jul 02 18:33:18 -0700 2008 0 0 false false Tue May 20 10:38:07 -0700 2008 Tue May 20 10:38:07 -0700 2008