Refactoring databases : evolutionary database design

Více o knize

Refactoring has shown its value in various development projects, aiding software professionals in enhancing system designs, maintainability, extensibility, and performance. For the first time, leading agile methodologist Scott Ambler and consultant Pramodkumar Sadalage present refactoring techniques tailored for database systems. They illustrate how minor adjustments to table structures, data, stored procedures, and triggers can significantly improve any database design without altering semantics. This guide enables you to evolve database schemas alongside source code, enhancing effectiveness in iterative, agile methodologies. Covering essential concepts of database refactoring, the authors provide practical solutions to real-world challenges. Through comprehensive examples, they guide you in refactoring both simple standalone applications and complex multi-application scenarios. You will master the tasks involved in updating database schemas and learn best practices for implementing refactorings in intricate production environments. The latter half of the book systematically addresses five major categories of database refactorings, focusing on improving database structure, data quality, and referential integrity, along with refactoring architectures and methods. With extensive examples using Oracle and Java, the techniques are easily adaptable to other languages and databases. By applying these methods, you can minimize was