Database restructuring

Author: Ambler
Publisher:
Publish Date: 2007-01-01
Features: This book is the first to focus specifically on database refactoring, demonstrating to data professionals how to use refactoring, test-driven development, and other agile techniques for evolutionary database development. Through numerous practical examples, it elaborates on the process, strategies, and deployment of database refactoring. The first five chapters of the book introduce the basic concepts and techniques of evolutionary database development, while the following six chapters provide detailed descriptions of each type of refactoring, including structural, data quality, referential integrity, architectural, and method refactoring. Additionally, it describes transformation techniques that fall outside the scope of refactoring. The example code in the book is written in Java, Hibernate, and Oracle, and all the code is simple, making it easy for readers to convert them into C#, C++, or Visual Basic code without difficulty. The value of refactoring is undeniable and has been proven in many projects. Refactoring can help software professionals improve system design and its maintainability, scalability, and performance. This book is the first to introduce powerful refactoring techniques specifically designed for database systems. The author fully demonstrates to readers that minor changes to table structures, data, stored procedures, and triggers can significantly improve database design without altering semantics. Readers will also learn step-by-step evolutionary methods for database schemas and source code, making projects that rely on iterative, agile development more efficient. This book provides comprehensive guidance and reference for database refactoring, introducing the basic concepts of database refactoring and helping readers overcome practical challenges when refactoring real database systems. Through complete examples, the author shows how to refactor simple single-database applications and complex multiple-database applications. By reading this book, readers can master the tasks involved in refactoring database schemas and learn the best practices for deploying refactoring in complex product environments. The book systematically introduces five main types of database refactoring techniques. Readers will see how to use refactoring to enhance database structure, data quality, and referential integrity, as well as how to refactor architecture and methods. The book provides numerous examples based on Oracle and Java, and readers can easily adapt them to other languages, such as C#, C++, or VB.NET, or to other databases, such as DB2, SQL Server, MySQL, and Sybase. By using the techniques and examples provided in this book, readers can reduce waste and risk, avoid rework and save costs, smoothly evolve database systems, and extend the lifespan of databases. This book provides comprehensive guidance and reference for database refactoring, introducing the basic concepts of database refactoring and helping readers overcome practical challenges when refactoring knowledge database systems.