Re: Looking for ER Tools (Commercial or PD)

In article <3a412q$39h_at_ionews.io.org>, mkj_at_io.org (mkj) says:
>
>My organization is looking for a decent ER diagramming tool which should
>be capable of supporting the following:
>
>1. database design
>2. ER Diagrams
>3. Some sort of version control
>4. Automatic generation of database scripts for oracle, sybase etc.
>5. Has a GUI interface (motif or MS Windows).
>
>The tool can either be a commercial one or available in public domain.
>Any pointers will be appreciated. In case, you are a vendor, please
>let me know how I can obtain your evaluation kit.
>
>thanks,
>mkj_at_io.org

I'm also looking for the above, but we also need:

1. Data modeling tool supports supertypes/subtypes, as does data dictionary
2. Data modeling tool supports development of multiple user views, with automatic generation of a global schema
3. Data dictionary supports multiple decomposition of DD entries (e.g., person = name + ssn; name = last name + first name + middle intitial)
4. Supports concurrent network users
5. Diagrams can be exported to standard graphic files

I'm trying to do an evaluation of about 7 different CASE tools to see how they rate in these and other areas before we select one...

I haven't seen any CASE newsgroups... anybody know of one?

Stacy H. Charland                       Email: charlans_at_gm1.nigms.nih.gov
National Institute of             <- I only work here  -  my postings are 
General Medical Sciences          my OPINIONS  and are in no way intended
Bethesda, MD                      to represent the views of my employer!