On Twitter earlier today, I exchanged tweets with Jane Roberts (@redjane) about finding myself in the phone book. Well, now I’ve just found myself on YouTube!
I was actually curious about videos of a different George McGeachie, a retired footballer who’s a tad older than I am, and searched for my name in YouTube. I didn’t find what I was looking for, but I did find a video that had previously been published on mypowerdesigner.com, which SAP closed down years ago; it was recorded at a SAP conference in the Venetian Hotel in Las Vegas.
I thought it had disappeared without trace, but there it is. It’s me (of course), talking about my soon-to-be-published book “Data Modeling Made Simple with PowerDesigner” – this was before the editor suggested drastic re-ordering of the chapters, so my chapter references are wrong, but hey, I’ve re-discovered myself!
In 2011 I co-authored “Data Modeling Made Simple with PowerDesigner” with Steve Hoberman. From the title it’s obvious that data modellers were the primary audience, though I did my best to structure the book so that other users of PowerDesigner could make use of it. The book also contains Steve Hoberman’s work on ‘how to do’ data modelling, so I inevitably had to make some compromises in the PD content. I’m sure nobody would have bought a 1,000 page book that weighs 3 Kg and costs over $120.
I’m currently planning the second edition of the book, and I intend to address the compromises, to ensure that we create material of interest to the whole PD market. A number of readers have been kind enough to point out the compromises that they’ve noticed, and to suggest topics to be included later on.
Here’s my challenge to you
What would you regard as essential knowledge for PowerDesigner users, and just has to be included in the future book (or books – there will probably be more than one)?
for any PD user
for portal users
for PD ‘super-users’, those people who like to push the tool to the limit
for PD administrators
for a given type of user
Please use this form to respond, or add a comment to this page
If you’re like me, you’re a book addict. I’ve built up a large library of books related to metadata and data modelling, and also on subjects such as process management, IT service management and mind mapping. When I was working with Steve Hoberman on our recent book, I didn’t want the book to give the impression that data modellers work in isolation, so I went through my library looking for useful material. I thought I’d share some of my findings with others, so here’s a list of books you should take a look at:
Business Rule Concepts (Ronald G. Ross, 2009) – read pages 74, 77 about the role of verbs in describing facts. See also Chapter 1 about noun concepts and terms; I especially like the statement that a “noun or noun phrase…represents merely the tip of an iceberg with respect to meaning”
Building Business Solutions: Business Analysis with Business Rules (Ronald G. Ross and Gladys S.W. Lam, 2011) – Read the chapter on Fact Models and how similar these are to Conceptual Data Models – see also my review of this book
Data Quality Assessment (Arkady Maydanchik, 2007) – chapter 4 provides an excellent introduction to and a detailed discussion of attribute domains
Document Engineering (Robert J. Glushko and Tim McGrath, 2008) – if you’re modelling the data in documents or service messages, you really must read this book
Mind Maps for Kids (Tony Buzan, 2003) – OK, it’s aimed at kids, but it’s a great introduction to the topic – look at the use of colour in his mind maps – how can you use colour effectively in your data models?
The Data Administration Newsletter (TDAN) have just published a new article by myself and Steve Hoberman, based on our recent book “Data Modeling Made Simple with PowerDesigner”.
Tools are necessary for data modeling. You can’t avoid having them, but which one suits you? Well, that depends on what you want to do with those tools, where you want to work in the Data Model Pyramid. See the article to find out what we mean.