RE: Data Modeling?

DE, On new > work, I think > the best Data Modeling tool is still pencil and paper, or a > white board. I completly agree. Mike > This is a fun time, where you can actually design the data without any > restrictions other than what the business people throw into > it to screw > it up. > > On existing systems, probably best to reverse engineer the > schema with > some kind of software tool, but even the best I've never used > to go and > make changes to the database with it. PowerDesigner does a good job, > even Visio is adequate for that. But I've yet to see some > kind of software > product actually go beyond just linking primary and foreign > keys. You can > write your own column cross-reference tool to see column > relationships, > which is basically what visual tools are going to do, unless > you can link > some kind of documentation in the metadata describing what > each table is > and how it relates to the other tables. Good luck if you > find something > that doesn't cost a fortune, and actually does more than just > draw lines > connecting primary-keys and foreign-keys together. The evaluation of > current products will be interesting, you should produce a white paper > of comparison products, it might be quite beneficial for the rest of > us. > > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > >