Agile Database Techniques: Effective Strategies for the Agile Software Developer

"I wish I had a book like this eight years ago. You’ll want to be sure to have enough copies for both your development and database folks."
—Jon Kern, Founding Member of the Agile Alliance
"You will find workable, real–world advice here."
—Doug Barry, Author, Web Services and Service–Oriented Architectures and The Object Database Handbook
An agile database administrator (DBA) has the difficult task of focusing on data–oriented issues, including traditional database administration as well as any application development involving data. Agile DBAs also collaborate with enterprise professionals to ensure that the efforts of the project team reflect enterprise realities. 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.
With every chapter you’ll be introduced to essential facets of data–oriented activities such as: The basics of object orientation, relational databases, data modeling, and how to deal with legacy data issuesDatabase refactoring, an evolutionary technique that enables you to improve your database design in small stepsMapping objects to relational databases, performance tuning, database encapsulation, and supporting tools Implementation techniques and strategies such as concurrency control, security access control, finding objects in relational databases, referential integrity, and the effective use of XMLStrategies and advice for individuals who want to become agile software developers and organizations that want to adopt agile techniques

Spis treści:
Foreword by Jon Kern.
Foreword by Douglas K. Barry.
Acknowledgments.
Introduction.
About the Author.
Part One: Setting the Foundation.
Chapter 1: The Agile D ata Method.
Chapter 2: From Use Cases to Databases — Real–World UML.
Chapter 3: Data Modeling 101.
Chapter 4: Data Normalization.
Chapter 5: Class Normalization.
Chapter 6: Relational Database Technology, Like It or Not.
Chapter 7: The Object–Relational Impedance Mismatch.
Chapter 8: Legacy Databases — Everything You Need to Know But Are Afraid to Deal With.
Part Two: Evolutionary Database Development.
Chapter 9: Vive L’ Évolution.
Chapter 10: Agile Model–Driven Development (AMDD).
Chapter 11: Test–Driven Development (TDD).
Chapter 12: Database Refactoring.
Chapter 13: Database Encapsulation Strategies.
Chapter 14: Mapping Objects to Relational Databases.
Chapter 15: Performance Tuning.
Chapter 16: Tools for Evolutionary Database Development.
Part Three: Practical Data–Oriented Development Techniques.
Chapter 17: Implementing Concurrency Control.
Chapter 18: Finding Objects in Relational Databases.
Chapter 19: Implementing Referential Integrity and Shared Business Logic.
Chapter 20: Implementing Security Access Control.
Chapter 21: Implementing Reports.
Chapter 22: Realistic XML.
Part Four: Adopting Agile Database Techniques.
Chapter 23: How You Can Become Agile.
Chapter 24: Bringing Agility into Your Organization.
Appendix: Database Refactoring Catalog.
References and Suggested Reading.
Index.

Nota biograficzna:
SCOTT AMBLER is president and a senior consultant of Ronin International (www.ronin–intl.com), a software services consulting firm that specializes in software process mentoring and object/component–based software architecture and development. He is a contributing editor for Software Development magazine and a columnist for Computing Canada. His personal Web site is www.ambysoft.com.

Okładka tylna:
"I wish I had a book like this eight years ag o. You’ll want to be sure to have enough copies for both your development and database folks."
—Jon Kern, Founding Member of the Agile Alliance
"You will find workable, real–world advice here."
—Doug Barry, Author, Web Services and Service–Oriented Architectures and The Object Database Handbook
An agile database administrator (DBA) has the difficult task of focusing on data–oriented issues, including traditional database administration as well as any application development involving data. Agile DBAs also collaborate with enterprise professionals to ensure that the efforts of the project team reflect enterprise realities. 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.
With every chapter you’ll be introduced to essential facets of data–oriented activities such as: The basics of object orientation, relational databases, data modeling, and how to deal with legacy data issuesDatabase refactoring, an evolutionary technique that enables you to improve your database design in small stepsMapping objects to relational databases, performance tuning, database encapsulation, and supporting tools Implementation techniques and strategies such as concurrency control, security access control, finding objects in relational databases, referential integrity, and the effective use of XMLStrategies and advice for individuals who want to become agile software developers and organizations that want to adopt agile techniques