Re: Table relationship diagramming tool

Marc, Please don't take this as an attack but how can you say that Erwin is more feature rich that Designer/2000 or that it has been around longer.

Dersigner/2000 is the latest version of Oracle's case technology which has been around since the 80's. Admittedly version 4.0 was not exactly a great tool but Oracle has been steadily enhancing the product for years. Designer/2000 is just a new name for a very mature tool.

While Erwin is a good tool and in some environments would be preferable to Designer/2000 (Typically multi vendor installations ie Oracle & Informix) it is very limited in functionality by comparison.

Erwin has no support for model based application generation, while Designer/2000 allows for the generation of Developer/2000 based applications as well as Visual Basic. All of which I have used so can attest that they work well. Another issue is that Erwin (I believe) stores the definitions of stored procedures/triggers ... as text (to allow them to be compatible with many platforms). while Des/2000 can do this it is also possible to store this information as enumerated data which allows for later impact analysis down to the cursor level within stored objects.

For I don't believe Erwin supports functional modeling at all and BPR modeling is an additional cost item.

I have also been told (but cannot confirm - maybe you could explain for us) that Erwin does not differentiate between Logical (ER) and physical (database shemas) models.

If I am incorrect on this let me know as I would be very interested to know. Just for reference I have used Erwin and actually consider it a good tool. The user interface is very similar to Designer/2000 it's just that for an Oracle environment Designer/2000 fits the need much better IMHO.

Marc Phillips <scott999_at_erols.com> wrote in article <01bc6a31$1794c9e0$d324accf_at_puddin.erols.com>...
> Logic Works Erwin/ERX is significantly better than any tool offered
> by Oracle
> It has been around longer, is ifininately more stable, more user
> friendly, and more feature rich.
>
> Marc Phillips
>
>
>
Received on Tue May 27 1997 - 00:00:00 CDT