Re: ERwin and Informix

In <3oad8k$snd@Mars.mcs.com> wood@MCS.COM (Greg Woodard) writes: > >Anyone using ERwin with Informix 5.x? How do you like it? > >greg. > If you are looking for design tools, you might want to check out one called Infomodeler, published by Asymetrix. Infomodeler is based on Object Role Modeling (ORM). I have an MSWORD version of a paper written by Dr. Terry Halpin, who is one of the fathers of ORM. I have also just started a thread called "Object Role Modeling / Infomodeler" in the comp.databases.theory newsgroup. The 30 second overview of ORM (and hence Infomodeler) is that you model business facts and rules, instead of tables. Once you have a complete conceptual model of facts (expressed in natural language), an algorithim is applied that automatically creates a fully normalized logical schema. From the logical schema, Infomodeler will write DDL for most major databases, including Informix. Thanks, Bill MacLean