Re: Better Data Modeling Tools for Oracle

[Quoted] Oracle Designer is the obvious solution. That probably has much more than you are used to. ERWIN from Logic Works (bought by Platinum ... last year?) is a lighter, easier to use, less complete tool.

--
Paul Dorsey
Dulcian, Inc.
(212) 595-7223
web address: http://www.dulcian.com
email: pdorsey_at_dulcian.com


<billmil_at_my-deja.com> wrote in message news:817797$3db$1_at_nnrp1.deja.com...


> Please bear with me oracle-experts, I'm new to your world.


>

> I have a lot of experience with a text-based data modelling tool called

> Synon (which runs only with DB2 for IBM's AS/400).  In the past year,

> at another company, I've used Popkin's System Architect for data

> modeling.

>

> We're switching to Oracle now and considering switching data modeling

> tools.

>

> Here's my quesion: I miss Synon's ability to define relationships

> between tables. Example:

> Order Header *Known by* Order Number

>

> Order Detail *owned by* Order Header

> Order detail *known by* Line number

> Order detail *refers to* Product

> Order detail *has* quantity

>

> Synon was "merely" text based, but actually very powerful. Changes to

> the key structure for the order header or product tables, for example,

> would automatically flow through to the order detail.

>

> System Architect has a visual-ERD tool, but either a) we didn't use it

> right or b) it didn't provide that ability. I thought the tool was more

> complex than what we needed.

>

> TOAD looks way-cool (especially for freeware), but it doesn't offer

> that data modeling ability.

>

> What do y'all recommend?

>

>

> Sent via Deja.com http://www.deja.com/

> Before you buy.