Oracle Database Design Tool

Visual Paradigm is an easy to use visual database and UML class diagram design tool. Visual Paradigm is built on top of Visual Paradigm award-winning visual modeling engine to deliver intuitive database design experience. Visual Paradigm connects to Oracle 8i, 9i, 10g and 11g for generating database, reverse database and alter database. Visual Paradigm can show difference 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 object-oriented static model with UML class diagram.
3. Excel export and import for mass editing.
4. Compare and show differences between two databases visually (visual diff).
5. Generate database design in PDF, MS Word 2007 and HTML format.
6. Publish database design to Intranet web server for fast query (Project publisher).
7. Design database collaboratively

Database engineering

1. Automatic creation of entity relationship diagrams from exiting database.
2. Generate well formatted DDL scripts to create database or alter database.
3. Customizable generated SQL format.
4. Design database offline - No need to connect database when design.

Object-Relational Mapping (Hibernate and NHibernate) code generation

1. Generate class diagram from ERD and vice versa.
2. Synchronize changes between class diagram and ERD.
3. Visualize and document mapping between ERD and 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 no hidden library.

Pricing

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

Supported database

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, 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 trademark of Microsoft Corporation
Oracle is U.S. registered trademark of Oracle Corporation
Sybase is U.S. registered trademark of Sybase, Inc.
MySQL is trademark of MySQL AB
Mac OSX is U.S. registered trademark of Apple, Inc.