I have been asked for recommendations for books on two topics which I can't say I've ever come across a worthwhile tome. If you were asked to give the best-of-the-best book recommendation covering UML and ER modelling, for a group of seasoned professionals (in object oriented advanced programmed) who just haven't had the inclination or time to use the given technologies and would like an "executive summary" without wasting time explaining inheritence and object oriented philosophies, what would you recommend?
The book I'd recommend isn't specifically about UML or ER. Instead it's about an alternative to ER modeling, "Object Role Modeling", or "ORM". The book is called, "Information Modeling and Relational Databases" and it's by Terry Halpin, the main guru on ORM.
If you are looking for a short, concise book on UML, my hands down choice would be: UML Distilled: A Brief Guide to the Standard Object Modeling Language (2nd Edition) by Martin Fowler http://www.bestwebbuys.com/books/compare/isbn/020165783X
I second the recomendation on ORM instead of UML or ER.
'... instead of UML ...' for database design, I meant.
I'll third both the ORM recommendation and the Fowler UML book. The conceptual modeling approach Halpin uses is just incredible. Like the others said, though, getting through the material is sometimes daunting.
I agree with recommendations above.
I'd really recommend Applying UML and Patterns: An Introduction to Object-Oriented Analysis and Design, and the Unified Process. It might be a little too much for people who aren't motivated to learn, but its a great book.
I'll fourth the ORM recommendation. Terry Halpin's Information Modeling book has great coverage on ER and UML, including the shortcomings of both.
Another interesting book covering ER, UML, and ORM is Requirements Analysis: From Business Views to Architecture by David C. Hay. He seems to feel that although ORM offers advantages that you don't get anywhere else, ER modeling is preferable for its visual conciseness. I'm not sure that's really so much of an issue since the current ORM tool has round-trip ORM-to-ER modeling, allowing you to have the expressiveness of ORM when you need it, and the conciseness of ER, all in the same "model".
Fog Creek Home