Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Database design tool

RE: Database design tool

From: Diana Duncan <>
Date: Mon, 23 Oct 2000 16:36:00 -0400
Message-Id: <>


If you are comfortable with Designer and have designed with it in the past, I would recommend that you stick with it. It really is a beautiful tool, but may I ask - why not use some of the generation abilities? It does require thoughtful planning and a commitment to generation, but in the long run can be quite a boon for documentation and maintenance efforts.

Anyway, I don't think you would have any problems sticking with Designer. Go with what you know! ;-)


-----Original Message-----

From: Rao, Maheswara [] Sent: Monday, October 23, 2000 2:37 PM
To: Multiple recipients of list ORACLE-L Subject: RE: Database design tool


We are using Designer 6 for our ERD and server model generation. Currently, our systems are small in nature (i.e., less number of tables). However, we are planning to design a OLTP system (which will be having 4,000 transactions inserts per minute hitting the Oracle db) Schema will have around 40 tables (transaction and Master tables; this number does not include look up tables). Also, we are in the process of developing Oracle warehouse for the same system. Currently, we are in the process of identifying a consultant organization.

Question: We are thinking of using Designer for generation and maintenance of ERD. Also for the generation and maintenance of server db. Front end will be written in Java. Any stored procedures will be written manually (i.e. Designer will not be used for the generation of stored procedures). Given the above scenario, do you think we will face problems with Oracle designer as we move along down the road?

Your opinion will be helpful for us in making the right choice early in this project.



-----Original Message-----

Sent: Monday, October 23, 2000 12:36 PM
To: Multiple recipients of list ORACLE-L

Opinions only:

ER/Studio - very good tool, if somewhat buggy sometimes and does not yet support "instead-of" triggers on views. One great feature is the ability to export schema diagrams to image files. This is what I use daily now, and I'm quite happy.

ERwin - formerly my absolute favorite (when it was Logicworks and then Platinum), it is now languishing at the hands of CA. I couldn't even get a working demo version for 8i, even after signing scary contracts. While I love the tool, I'd avoid it. (caveat - I'm an ex-CA acquired employee)

Designer 2000 - a great tool, but serious overkill for ER modelling. I recommend Designer for anyone who is serious about generating a large percentage of their entire system.


-----Original Message-----

Sent: Monday, October 23, 2000 5:43 AM
To: Multiple recipients of list ORACLE-L

At the moment i am using ODD (Oracle Database Designer) to design my Oracle databases.

Which you find the best choice: ER/Studio (Embarcadero), ERwin (CA) or Designer 2000 (Oracle).



Please see the official ORACLE-L FAQ:

Author: Rao, Maheswara

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may Received on Mon Oct 23 2000 - 15:36:00 CDT

Original text of this message