May 15, 2008
Discussion Group and Website integration - Monday, June 04, 2007

Our integration layer between our webiste (www.infoadvisors.com) and our discussion server (http://wb.itboards.com) is currently out of service.  That means if you are registering for the first time, you'll need to first register here on the website, then register again on the discussion group (via the ENTER link on each board's page).  If you use the same credentials on both, then when we turn integration back on your accounts will be in sync again.

Please register here on the website first.  Thanks for your patience.

 
Search Minimize

Print  

Discussion Group Login Minimize
Print  

Registered User Poll - Log in to Vote Minimize
Which Modeling Tools Do You Use Regularly?









 
You must sign in to vote in this survey.
Print  

Home    

Welcome... Minimize

Welcome to InfoAdvisors' website dedicated to information technology processes.  You'll find subscriber-written articles on UML, data management, data modeling, process modeling, ITIL, information governance, as well as materials to help you improve your information management resources.





Apr 18

Written by: Karen Lopez
Friday, April 18, 2008 1:36 PM

imageA colleague of mine on the ARTS Data Model Committee, John Glaubitz of Vertex, shared with me a simple technique he uses with the ARTS data model. (click on the image to see a larger version)

For some of the more complex concepts in the model, he adds a text box next to the entity with its definition.  This allows his team members to quickly reference the definition right on the diagram.  This is so simple and so obvious, I'm thinking "why didn't I think of that".

He has to do this manually, though, which means if definitions are refined, there is a huge manual effort to keep these text boxes in sync.  That started me thinking....what if there were features in our tools to do this presentation for us?  What if, on an entity by entity basis, I could say "Fly Out Definition in Diagram"?  I'd want to do this only for certain entities, not necessarily all of them, because I'd want to have this additional meta data at my finger tips only for those of interest to the current display/submodel.  I'd also want to limit the display of definition to the first X characters as well.  I know some entities have long definitions and I'd want to limit the display to getting just that first "A _______ that _________" part of the definition that I always start my definitions with.

image Wait, you say, there is a similar feature in most tools, one that displays the definition right inside the entity.  Yes, there is. (click on the image to see a larger version) I don't want just the definition, I want the full meta data such as attributes, primary keys, foreign keys an datatypes as well as the definitions.

Then I'd also want the drawing features of the program to handle these text boxes correctly, too.  For instance, I want them linked to the entity and tightly coupled with them so that we don't end up with long lines connecting the text boxes an the entity from the other side of the diagram.  Perhaps the solution would be to have these tightly coupled text boxes be a generic concept that use place holders such as [Entity:Definition], [UPD:PrivacyCode], or [Entity:Notes].  That way I could show anything I wanted there.

I know this asking for a lot, but I do believe this sort of enhancement could be significantly beneficial for modelers, developers, and end users.

What do you do to display definitions within your models? Would a feature like this be beneficial?

powered by metaPost

Tags:

Re: Wouldn't this be a great data modeling tool feature?

I know one tool that allows you to display definitions in the entity box, but it overestimates the size of the box needed to display them, so wastes a lot of space. The same tool allows you to decide that you want to display the definition if the mouse cursor is over an entity. Fine if you're using the tool ...
I think have boxes that 'fly out' would be great - a bit like comments in Excel - you can have them fly, or make them show all the time, on an individual basis. As well as definitions, I'd also love to be able to select other properties (including ones I've defined myself) to be shown. How about sending someone an ERD you've reviewed, with your review comments shown automatically? Or perhaps showing the modelling issues you've identified?

By George McGeachie on   Monday, April 21, 2008 12:09 PM

InfoAdvisors Calendar List Minimize

Event StartTitle
5/20/2008 9:00 AM DAMA IA - Des Moines
5/21/2008 9:00 AM DAMA WI - Collaborating with Techs
6/18/2008 8:00 AM Toronto Enterprise Information Management Conference

View MonthView Month  View WeekView Week  List EventsList Events   Print  


New Profies Minimize
Print  

Users Online Minimize
Membership Membership:
Latest New User Latest: mdelatte
New Today New Today: 2
New Yesterday New Yesterday: 0
User Count Overall: 2092

People Online People Online:
Visitors Visitors: 2
Members Members: 0
Total Total: 2

Online Now Online Now:
Print  

Partners Minimize
InfoAdvisors partners with
 
embt.png
 
 
CA
Microsoft
Sybase
Telelogic
 
We can help you evaluate and successfully implement our partners' products
 

Archive  Minimize 
Print  

Share The Page Minimize
Social Bookmarks -  email email | del.icio.us del.icio.us | digg digg | technorati technorati | stumbleupon stumbleupon | facebook facebook | newsvine newsvine
Print  

  Minimize

  Home|Groups|About Us|Bookstore|Services|Articles & Videos|Member Profiles|What's New
Copyright 2006-7 InfoAdvisors, Inc. Terms Of Use Privacy Statement