Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ER/Win vs Designer/2000 - Which is better?

Re: ER/Win vs Designer/2000 - Which is better?

From: Dan Townsend <townsend_at_ebmud.com>
Date: 1997/04/09
Message-ID: <334BB049.5FD0@ebmud.com>#1/1

ERWin's trigger generation is an option that can be suppressed. It is a great strength of the product. We use ERWin extensively. It does a very good job of reverse-engineering our schemas, then forward-engineering our changes.

One limitation is the inability to deal with stored Packages, but even though we make extensive use of Packages to encapsulate data, that has not been a significant problem.

+-----------------------------------------------------
| Dan Townsend, Supervising Database Architect
| EBMUD Enterprise Object Designer
| mailto:townsend_at_ebmud.com
+-----------------------------------------------------
Robert Miller wrote:
> Instead of generating declarative referential integrity constraints when
> foreign keys are specified, the thing create a trigger for every foreign
> key. This is not desirable in Oracle, and in earlier releases, there
> was a limit on the number and type of triggers that can be placed on one
> table. Also, on earlier releases, triggers were run-time interpreted
> and this would have created unnecessary performance hits.
Received on Wed Apr 09 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US