Refactoring Databases: Evolutionary Database Design (paperback)

Description

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, and Sybase. 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.

Get the book

Amazon.com

Search the book

eBay.com

Search the book

Other editions

• 

  Refactoring Databases: Evolutionary Database Design

  • 2006
  • - pages
  • Paperback
  • Addison-Wesley Professional

Similar books

• 

  Refactoring Databases

  By Ambler

  Refactoring Databases

• 

  Recipes for Continuous Database Integration: Evolutionary Database Development (Digital Short Cut)

  By Pramod J. Sadalage

  This is the eBook version of the printed book.

• 

  Agile Database Techniques: Effective Strategies for the Agile Software Developer

  By Scott Ambler

  Scott Ambler has written this invaluable book from the point of view of an agile DBA, enabling you to learn the techniques that agile DBAs use to work effectively on evolutionary (iterative and incremental) software projects.

• 

  NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot Persistence

  By Martin Fowler, Pramod J. Sadalage

  'NoSQL Distilled' is designed to provide you with enough background on how NoSQL databases work, so that you can choose the right data store without having to trawl the whole web to do it.

• 

  Refactoring SQL Applications

  By Stephane Faroult, Pascal L'Hermite

  If and when your application bogs down, this book will help you get it back up to speed.

• 

  Refactoring: Ruby Edition

  By Martin Fowler, Kent Beck, Jay Fields

  This book will help you Understand the core principles of refactoring and the reasons for doing it Recognize “bad smells” in your Ruby code Rework bad designs into well-designed code, one step at a time Build tests to make sure your ...

• 

  Building Evolutionary Architectures: Support Constant Change

  By Neal Ford, Rebecca Parsons, Patrick Kua

  This practical guide ties those parts together with a new way to think about architecture and time.

• 

  Refactoring Legacy T-SQL for Improved Performance: Modern Practices for SQL Server Applications

  By Lisa Bohm

  This book shows you how to significantly improve the performance of older applications by finding common anti-patterns in T-SQL code, then rewriting those anti-patterns using new functionality that is supported in current versions of SQL ...

• 

  Refactoring SQL Applications

  By Stephane Faroult, Pascal L'Hermite

  This practical work explains how to improve database performance dramatically and inexpensively with surgical changes to the code.

• 

  Refactoring Workbook

  By William C. Wake

  Refactoring Workbook provides user-friendly references such as: A handy, quick-reference "smell finder" A standard format for describing smells Appendices showing key refactorings A listing of Java(tm) tools that support refactoring This ...