Agile Zone is brought to you in partnership with:

I am developer and technology maniac who is working on Microsoft and PHP technologies. I have ASP.NET MVP title and I hold MCAD, MCSD and MCTS certificates. When I have free time I usually play with new technologies, hack something, read books, participate in communities and speak in events. I am also active blogger and my ASP.NET blog is the place you can find some interesting reading about my discoveries and personal thoughts. Gunnar is a DZone MVB and is not an employee of DZone and has posted 140 posts at DZone. You can read more from them at their website. View Full User Profile

Agile Database Techniques: Effective Strategies for the Agile Software Developer – Book Review

04.27.2010
| 5166 views |
  • submit to reddit

Agile development expects mind shift and developers are not the only ones who must be agile. Every chain is as strong as it’s weakest link and same goes also for development teams. Agile Database Techniques: Effective Strategies for the Agile Software Developer by Scott W. Ambler is book that calls also data professionals to be part of agile development.

Often are DBA-s in situation where they are not part of application development and later they have to survive large set of applications that all use databases different way. Of course, only some of these applications are not problematic when looking what database server has to do to serve them. I have seen many applications that rape database servers because developers have no clue what is going on in database (~3K queries to database per web application request – have you seen something like this? I have…)

Agile Database Techniques covers some object and database design technologies and gives suggestions to development teams about topics they need help or assistance by DBA-s. The book is also good reading for DBA-s who usually are not very strong in object technologies. You can take this book as bridge between these two worlds.

I think teams that build object applications that use databases should buy this book and try at least one or two projects out with Ambler’s suggestions.

agile-database-techniques

Table of contents

Foreword by Jon Kern.
Foreword by Douglas K. Barry.

Acknowledgments.
Introduction.
About the Author.

Part One: Setting the Foundation.

Chapter 1: The Agile Data 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.

References
Published at DZone with permission of Gunnar Peipman, author and DZone MVB. (source)

(Note: Opinions expressed in this article and its replies are the opinions of their respective authors and not those of DZone, Inc.)

Comments

Sindy Loreal replied on Sat, 2012/02/25 - 8:46am

I am using Visual Studio database project and data generation plan to populate my database with random

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.