Oracle 9i Designer

pts.
Tags:
Availability
Backup and Recovery
Migration
Modeling
Normalization
Oracle 9i
Performance/Tuning
Security
Storage management
Very Large Databases
Do you have any opinions on the use of Designer versus a tool like Erwin or PowerDesigner in handling the following concerns:
  1. Database generation
  2. Reverse engineering
  3. Accurately representing every detail of a database
  4. Speed
  5. Use for different DB platforms
Thanks for any comments.

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hi.

Any of those products will allow you to document at an extremely low level of granularity.

Haven’t used Designer since 6i (the previous version), but it is strongest for “traditional” data modelers (using information engineering approach) deploying to an Oracle DBMS. It’s absolutely brilliant. I especially liked the stored procedure generation aspects and CRUD matrices.

However, its not an ideal cross-platform tool. ErWin or PowerDesigner will handle multiple platforms more readily.

Reverse engineering and generation should excel on all the products.

I’m currently using PowerDesigner 10 on a SQL Server backend and am sufficiently happy with it. If you want a variety of modeling tools (ERD, UML, BPM) in one box, it does a decent job.

I’d strongly recommend downloading demos of all of them (which should be available), exploring ease of use, and trying them out against some test schemas.

None of them are cheap, so playing with them upfront will be worthwhile.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Hopkihc
    Hi. Any of those products will allow you to document at an extremely low level of granularity. Haven't used Designer since 6i (the previous version), but it is strongest for "traditional" data modelers (using information engineering approach) deploying to an Oracle DBMS. It's absolutely brilliant. I especially liked the stored procedure generation aspects and CRUD matrices. However, its not an ideal cross-platform tool. ErWin or PowerDesigner will handle multiple platforms more readily. Reverse engineering and generation should excel on all the products. I'm currently using PowerDesigner 10 on a SQL Server backend and am sufficiently happy with it. If you want a variety of modeling tools (ERD, UML, BPM) in one box, it does a decent job. I'd strongly recommend downloading demos of all of them (which should be available), exploring ease of use, and trying them out against some test schemas. None of them are cheap, so playing with them upfront will be worthwhile.
    0 pointsBadges:
    report
  • Hopkihc
    Hi. Any of those products will allow you to document at an extremely low level of granularity. Haven't used Designer since 6i (the previous version), but it is strongest for "traditional" data modelers (using information engineering approach) deploying to an Oracle DBMS. It's absolutely brilliant. I especially liked the stored procedure generation aspects and CRUD matrices. However, its not an ideal cross-platform tool. ErWin or PowerDesigner will handle multiple platforms more readily. Reverse engineering and generation should excel on all the products. I'm currently using PowerDesigner 10 on a SQL Server backend and am sufficiently happy with it. If you want a variety of modeling tools (ERD, UML, BPM) in one box, it does a decent job. I'd strongly recommend downloading demos of all of them (which should be available), exploring ease of use, and trying them out against some test schemas. None of them are cheap, so playing with them upfront will be worthwhile.
    0 pointsBadges:
    report
  • 17051966
    I have used occasionally all three tools, but I am not an expert in their use. My response is as follows. Database generation, Reverse engineering, Accurately representing every detail of a database, and Speed - All three of them are quite comparable, but there is no clear winner. However, Designer can be used only for Oracle databases, while the other two supports a variety of platforms and databases. They all generate SQL scripts to implement the design. Designer has an impact analysis feature. I do not remember if the other two also have it. Use for different DB platforms - Designer is Oracle specific, the other two are not. Sitansu S. Mittra
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following