Oracle Database Design Tool

September 1, 2009
Views: 84,213
PDF Download
Compatible: Enterprise, Professional, Standard

Visual Paradigm is an easy-to-use visual database and UML class diagram design tool. Visual Paradigm is built on top of the award-winning Visual Paradigm visual modeling engine to deliver an intuitive database design experience. Visual Paradigm connects to Oracle 8i, 9i, 10g, and 11g for generating databases, reverse-engineering databases, and altering databases. Visual Paradigm can show the differences between two databases visually through a feature called Visual Diff. Visual Paradigm generates Java, .NET, Hibernate, and NHibernate Mapping.

Visual Paradigm offers:

Database and UML Design

  1. Visually design tables, indexes, and relationships without SQL (ERD).
  2. Design an object-oriented static model with a UML class diagram.
  3. Excel export and import for mass editing.
  4. Compare and show the differences between two databases visually (Visual Diff).
  5. Generate a database design in PDF, MS Word 2007, and HTML format.
  6. Publish a database design to an intranet web server for fast querying (Project Publisher).
  7. Design a database collaboratively.

Database Engineering

  1. Automatic creation of entity relationship diagrams from an existing database.
  2. Generate well-formatted DDL scripts to create or alter a database.
  3. Customizable generated SQL format.
  4. Design a database offline—no need to connect to a database when designing.

Object-Relational Mapping (Hibernate and NHibernate) Code Generation

  1. Generate a class diagram from an ERD and vice versa.
  2. Synchronize changes between a class diagram and an ERD.
  3. Visualize and document the mapping between an ERD and a class diagram (ORM Diagram).
  4. Generate Hibernate XML and annotation mapping.
  5. Generate Java (or C#) source files for accessing the DB through Hibernate.
  6. All generated source, mapping layer, and mapping engine are royalty-free and have no hidden libraries.

Pricing

  1. Visual Paradigm Monthly Subscription: US$ 35 per month (billed every 3 months for $35 per month, or billed monthly for $39 per month)
  2. Visual Paradigm Perpetual License: US$ 799

Supported Databases

  1. Oracle 8i, 9i, 10g, and 11g
  2. DB2 7 and 8
  3. Microsoft SQL Server 2000, 2005, and 2008
  4. Sybase Adaptive Server Enterprise 12.5
  5. Sybase SQL Anywhere 9
  6. MySQL 3, 4, and 5
  7. HSQLDB 1.61 - 1.8
  8. Cloudscape/Derby 10
  9. PostgreSQL 7/8
  10. IBM Informix
  11. Ingres 2006
  12. Progress OpenEdge Release 10
  13. Firebird 2.0
  14. FrontBase 4

Supported Platforms

  1. Microsoft Windows 98/2000/XP/2003/Vista/7
  2. Linux (well-tested in Fedora, Ubuntu, and Debian)
  3. Mac OSX

Microsoft, Microsoft Excel, and Microsoft SQL Server are U.S. registered trademarks of Microsoft Corporation.
Oracle is a U.S. registered trademark of Oracle Corporation.
Sybase is a U.S. registered trademark of Sybase, Inc.
MySQL is a trademark of MySQL AB.
Mac OSX is a U.S. registered trademark of Apple, Inc.