Evolutionary and Agile Database Books

www.agiledata.org: Techniques for Successful Evolutionary/Agile Database Development

This book describes, in detail, how to refactor a database schema to improve its design. The first section of the book overviews the fundamentals evolutionary database techniques in general and of database refactoring in detail.  More importantly it presents strategies for implementing and deploying database refactorings, in the context of both "simple" single application databases and in "complex" multi-application databases.  The second section, the majority of the book, is a database refactoring reference catalog.  It describes over 60 database refactorings, presenting data models overviewing each refactoring and the code to implement it.

This book describes the philosophies and skills required for developers and database administrators to work together effectively on project teams following evolutionary/agile software processes such as Extreme Programming (XP), the Rational Unified Process (RUP), the Agile Unified Process (AUP), Feature Driven Development (FDD), Dynamic System Development Method (DSDM), or The Enterprise Unified Process (EUP).  In March 2004 it won a Jolt Productivity award.

This book describes an agile data warehousing strategy. 

This book provides a set of strategies for modifying the code in database applications to dramatically improve the way they work.  Strategies include determining if and where you can expect performance gains; applying quick fixes such as limiting calls to the database in stored functions and procedures; refactor tasks, such as replacing application code by a stored procedure, or replacing iterative, procedural statements with sweeping SQL statements; refactor flow by increasing parallelism and switching business-inducted processing from synchronous to asynchronous; refactor database design using schema extensions, regular views, materialized views, partitioning, and more; and comparing before and after versions of a program to ensure you get the same results once you make modifications.