reverse engineering, case tools and repositories
Date: 19 Jul 1994 14:36:45 GMT
Message-ID: <30goeg$rqv_at_news4all.hacktic.nl>
This is a compilation of answers people supplied to my recently posted question on the internet for reverse engineering tools on oracle:
I am looking for getting ER diagrams (with constraints) and process flow diagrams
(data flow diagrams, or whatever you would call them). The idea of
course being able to more easily adapt applications to changing business
environments and possibly simplify upgrading to other versions of oracle.
(FLEXIBILITY)
Possible products are:
Product Company Remarks
ERwinERX, Logic Works Gives relations when constraints defined
Rudimentary Autoarrange diagrams
BPwin, Logic works Gives relations when constraints defined
Rudimentary Autoarrange diagrams
Database Ilustrator Gives relations when constraints defined
Autoarrange diagrams
CASE*Dictionary 5.0 Oracle
CASE Dictionary 5.1 Oracle
MS Access 2.0 Microsoft Great for multi-database repository Designor SDP Technologies
DEFT
Own-made PL/SQL programs that read flat files to get the datamodel
Remarks:
Why autoarrange:
Skilled people must spend their time moving boxes and lines around on a
screen. An autoarrange tool that itself figures the optimal placement of the
entities. Mostly you'll need constraints to be able to do this.
Multi-database repository:
Often in an existing environment you'll find different databases in use on
different platforms (e.g. Oracle, dbase, ingres etc on VAX, pc, unix etc). However
the existing database applications might serve the same business application. E.g.
in a visualbasic-oracle client-server application the client also retrieves
information from a access database.
A multi-database repository could be seen as a data dictionary (with its
constraints) for several different database products.
Does anybody know more about reverse engineering. Or has somebody developed some good tools?
Stefan Received on Tue Jul 19 1994 - 16:36:45 CEST