Re: Better Data Modeling Tools for Oracle

You might want to look at Sybase's Powerdesigner. You can download free trials from http://www.sybase.com/products/download.html

--
Terry Dykstra
Canadian Forest Oil Ltd.
Check out Sybase Developer's Network: http://www.sybase.com/sdn

Paul Dorsey wrote in message ...


>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.

>

>