Re: Reverse Engineering into Oracle*Case (Designer)

Richard D Holowczak <holowcza_at_andromeda.rutgers.edu> wrote:
>johnsma_at_earlham.edu writes:
 

>>HI,
>> I would like to reverse engineer a production database into
>>Oracle*Case, and take that model all the way back to the Strategy and
>>Design phases so that I can get some diagrams using Case*Designer.

That is apparently in Oracle CASE*Generators and CASE*Dictionary v5.1, which showed up here last week.

>>Do the Oracle consultants
>>have the software to do it now? Thanks.
 

>> -Johnsma

I understand that Oracle Consulting Group has been using beta copies of Dict 5.1.

>The problem one has is that the physical tables in a database many
>not have a one to one correspondance with Entites defined during
>Analysis. For example, there are several ways to implement
>sub-type hierarchies.

Three ways that I know of, each with its own trade-offs.

Also, don't forget the creative use of one-to-one relationships, which Oracle CASE generally handles rather poorly, IMHO.

>In the current (v5) Oracle CASE, there is a gap between the
>Analysis and Design (physical design). If you assume that
>each table corresponds to a single entity, then there may be
>some recourse. The reverse enginerring can get your tables
>from your account and place them into the Design level of
>Oracle CASE. You have to take it from there.

Right, except v5.1 bridges the gap. I have not yet used it and cannot say how well it bridges that gap, though.

Separately, my own favorite piece of v5.1 is the ability to generate and support database stored procedures, triggers, and packages (as well as declarations, etc.) from the CASE tool and from the data and function models.

Cheers.

 -Tom

-- 
Thomas Cox         tcox_at_netcom.com
       PGP Key Available -- finger tcox_at_netcom.com.