Brightsurf Science News and Current Science News Events
 

View Larger Image

Agile Database Techniques: Effective Strategies for the Agile Software Developer (Wiley Application Development)


by Scott Ambler

List Price: $40.00
Price: $26.40
You Save: $13.60 (34%)
Available: Usually ships in 24 hours
Sales Rank: 183118
Studio: Wiley
Binding: Paperback
Number Of Pages: 480
Publication Date: October 17, 2003
Publisher: Wiley


EDITORIAL REVIEWS

Product Description
  • Describes Agile Modeling Driven Design (AMDD) and Test-Driven Design (TDD) approaches, database refactoring, database encapsulation strategies, and tools that support evolutionary techniques
  • Agile software developers often use object and relational database (RDB) technology together and as a result must overcome the impedance mismatch
  • The author covers techniques for mapping objects to RDBs and for implementing concurrency control, referential integrity, shared business logic, security access control, reports, and XML
  • An agile foundation describes fundamental skills that all agile software developers require, particularly Agile DBAs
  • Includes object modeling, UML data modeling, data normalization, class normalization, and how to deal with legacy databases
  • Scott W. Ambler is author of Agile Modeling (0471202827), a contributing editor with Software Development (www.sdmagazine.com), and a featured speaker at software conferences worldwide


CUSTOMER REVIEWS (Average Customer Rating: 4.5 based on 13 reviews)

Excellent book. Required reading for anyone who works with databases.  
If you are an application developer that has ever worked with a system that is difficult and convoluted because of fear of touching the Database then you owe it to yourself to read this book. This book will provide you with the insight and techniques to make changes to your Database with confidence.

I also recommend Refactoring Databases: Evolutionary Database Design (The Addison-Wesley Signature Series) for those who seek details on how to implement the topics discussed in "Agile Database Techniques"

November 23, 2007

OK, but not much from a DBA side of things  
To be fair, the book title suggests that it is for the software developer, and not a database administrator. I thought that it had a good overview of agile related items. Although it was probably not as useful for software developers who might have more exposure to the agile methods. From a DBA point of view, I thought it was a nice overview because agile is not typically used in DBA teams.

As far as specifics relating to databases, I thought it could have had more real-life scenarios and suggestions on how to deal with them. Some of the ideas presented were just too unrealistic for my liking.

That being said, there are a few good ideas in this book. It was a quick read too. So if you are a DBA who has no idea of agile, it might be something to start with.
September 27, 2007

Great book, I recommend it !  
Database refactoring is the harder part of development and this book give great information about how to deal with change.
I personally recommend it.
February 28, 2007

Go boldly beyond the persistence layer  
This is very well written, enjoyable book, with few (if any) competitors. Given its agile sensitivities, it's perfect for a programmer looking for an overview of the whole data modelling she-bang, from use cases to impedance mismatch. Despite clocking in at 400 pages of fairly dense type, interspersed with various tables and UML diagrams, it's a breeze to read. It assumes a bit of knowledge of database technologies, but you don't need anything more than a nodding familiarity with SQL and basic concepts like normalisation.

This book deals with a lot of issues related to using databases as part of agile modelling. The main message is that agile application developers need to think about persistence issues, and database admins need to understand agile development. The differences between data-driven and object-driven models are clearly laid out, and there's an excellent section on refactoring databases.

The important thing about this book is not so much offering you specific solutions to problems, but alerting you to potential problems you might not even know exist, and explaining that you do have options in solving them. As well as introducing agile methods like TDD and refactoring, it also covers database issues like transactions, security, concurrency and object-relational mapping.

Additionally, there is an emphasis on the organisational and political issues you might face in transitioning to agile methodologies, and it's very pragmatic in pointing out that some things that might be considered the preserve of an application developer, could be done in the database itself. The issues are presented at the same level of detail as those presented in the likes of The Pragmatic Programmer (but a different subject, of course). For more specifics, you will need to turn to the likes of Martin Fowler's Patterns of Enterprise Application Architecture, or to see specific technologies being used, Chris Richardson's POJOs in Action. I would definitely recommend this book before reading those.

As someone with little knowledge of databases, I found this an excellent and unique resource to join up the dots when it comes to persistence and agile.
January 11, 2007

quick easy read  
The book was well written and very easy to use. I found many insightfull thoughts as to the purpose of Agile development. If you are looking for a great book to guide you into AGILE development, this will do it.
Drawbacks or missed points, yes this book has two flaws that I have to list. 1. the repeated use of the word Legacy and the very negative congnitation of the word. Older database will have many flaws, and we need to identify them. They will also have many objects and data patterns that are valid and efficient and should not be abandoned because its not todays effort.
2. Agile and refactoring of tables does not address, production, zero down time, large volume databases. How do you refactor a table with 2 terabites of data and can not allow downtime. (medical)
January 10, 2007


SIMILAR PRODUCTS

Refactoring Databases: Evolutionary Database Design (Addison-Wesley Signature Series)
by Scott W. Ambler, Pramodkumar J. Sadalage

The Object Primer: Agile Model-Driven Development with UML 2.0
by Scott W. Ambler

Agile Modeling: Effective Practices for Extreme Programming and the Unified Process
by Scott W. Ambler, Ron Jeffries

Patterns of Enterprise Application Architecture (Addison-Wesley Signature Series)
by Martin Fowler

Agile Project Management with Scrum (Microsoft Professional)
by Ken Schwaber

© 2008 BrightSurf.com