Oracle-L: RE: designer autolayout

From: <Jared.Still_at_radisys.com>
Date: Tue, 15 Oct 2002 13:53:43 -0800
Message-ID: <F001.004E9D5B.20021015135343@fatcity.com>

This is just the stuff I've run into with a few hours work.

Supertypes/subtypes. Creating a relation so a subtype does not work in a suitable manner. I ran into this last week, and don't recall the details. The solution was not to use super/sub types, though I would have preferred it.

Creating a FK relationship to table A from table B and C, where B and C have the same primary key. I use PK for the primary key on entities/tables, and assign the UID as an alternate key.

When trying to do this, ER doesn't do it properly. It uses the same attribute/column for the FK to both B and C.

Creating >1 relations between 2 tables using the same primary key from the parent. This is very common. ER doesn't like this.

I struggled with it a bit last week, don't yet have it resolved.

All of the above are quite easy in Oracle Designer.

I'll probably find more...

Jared

"Grabowy, Chris" <cgrabowy_at_fcg.com>
Sent by: root_at_fatcity.com
10/15/2002 11:26 AM
Please respond to ORACLE-L

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        RE: designer autolayout

Ok, I'll bite. Can you name a few Designer features that ER Studio is missing?

I have not used either product, I am stuck with an ancient version of ERwin. Mgmt almost purchased ER Studio, but then the economy, and business, crashed...

-----Original Message-----
Sent: Tuesday, October 15, 2002 1:35 PM
To: Multiple recipients of list ORACLE-L

No.

Though I'm not currently using Designer, I've worked with it quite a bit in the past for data modeling. Don't use the autolayout.

I'm currently using Embarcadero ER Studio. If Designer wasn't such a pig, I would have bought it instead, and am currently wishing I had anyway.

ER Studio is very fast, but not *nearly* the tool that Designer is.

Jared

"Boivin, Patrice J" <BoivinP_at_mar.dfo-mpo.gc.ca> Sent by: root_at_fatcity.com
10/15/2002 06:28 AM
Please respond to ORACLE-L

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>

        cc: 
        Subject:        designer autolayout

Is there a way to make the autolayout feature produce a concise layout in Designer Entity Relationship Diagrammer?

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes 
Technology Services        | Services technologiques 
Informatics Branch         | Direction de l'informatique 
Maritimes Region, DFO      | Région des Maritimes, MPO

E-Mail: boivinp_at_mar.dfo-mpo.gc.ca

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: Jared.Still_at_radisys.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (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 also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Grabowy, Chris
INET: cgrabowy_at_fcg.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: Jared.Still_at_radisys.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------