Oracle Database Design Tool

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

VP-UML 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 with VP Teamwork Server, Subversion, Perforce or CVS.
8. Annotate ER diagrams with text label or call out.

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.

Download full functions 30 days FREE trial of Visual Paradigm for UML

Windows
Linux
Mac OSX

Notes:
1. Select Visual Paradigm for UML when installing the VP Suite.
2. Click "Try without Evaluation Key" button to get 30 minutes per session evaluation.
3. Click "Request Key" to get a 30-day evaluation key by email (Your email will only be used for sending evaluation key and follow up your evaluation. We will NEVER share your email to third party without your approval).

Pricing

1. VP-UML Standard Edition: US$ 299 (or US$ 358.5 with 1 year maintenance)
2. VP-UML Professional Edition: US$ 699 (or US$ 838.5 with 1 year maintenance)
3. VP-UML Enterprise Edition: US$ 1399 (or US$ 1678.5 with 1 year maintenance)

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.