DeZign for Databases
The Ultimate Data Modeling Tool
Database Design Tool
Standard: $ 259
Professional: $ 499
Expert: $ 899
Upgrade to version 9

Visual Data Modeling Environment for Oracle Databases

DeZign for Databases is a data design solution that you can use to discover, model, relate, standardize, and document Oracle databases. It offers a sophisticated visual modeling environment for database development.

Elements from data models are visually represented in ER diagrams using industry standard design notations (IDEF1X or Information Engineering). You can forward engineer and reverse engineer Oracle databases. The compare and synchronize features can be used to ensure that the data model is consistent (insync) with the database. It is easy-to-use and an alternative to Oracle SQL Developer Data Modeler.

 > Download trial      > Purchase DeZign for Databases      > Learn more      > Take the screenshot tour

oracle data model


DeZign for Databases is designed for all data modelers, from business architects to DBAs and application developers. It serves as a powerful communication tool and accelerates your processes by connecting the database designers to the rest of the development team and business users.

Key Features

Graphically Design Databases

DeZign for Databases has an easy-to-use graphical interface that simplifies database design and automates many time-consuming modeling tasks. In your diagram you can visually make a design using entities, relationships, subcategories, group boxes and text blocks. The tool enables you to present your design at various levels of detail.

Reverse Engineer Oracle Databases

Connect to your Oracle database with a direct native connection and derive a graphical model from that database. Import from multiple schemas or just choose one. You can also import an existing database from a SQL script (DDL). When connecting to an Oracle database, the Oracle client software is not required.

Large Model Management

DeZign for Databases helps you manage large data models through subdiagrams (subviews). Subdiagrams provide a focused view for individual data modelers, dividing the model into smaller, manageable subsets.

Database Generation

Generate output from your data model. From the modelís design, definitions (DDL) are generated for all database objects such as tables, views, columns with defaults and constraints, primary keys, foreign keys, indexes, triggers, stored procedures and object descriptions.

Model and Database Synchronization

DeZign for Databases allows users to compare and optionally synchronize a data model and a (live) Oracle database. The tool displays the differences between a model and your Oracle database and lets you select which differences to move to the database or to the model. If model changes move into the database then a database update script will be created.

Collaboration: Merge Models

Development teams can work in parallel on a single model. DeZign for Databases' compare and merge models utility lets you merge different versions of the model. This utility reduces parallel development complexity.

Database Documentation Generation

You can generate detailed database model documentation with DeZign for Databases. Import an existing Oracle database or generate documentation for the model you are currently working on. The documentation generated has a form of static html files, a MS Word document or a PDF file and describes all objects in the Oracle database schema defined by your model.

Multiple Database Systems

DeZign for Databases supports multiple databases. You can create target DBMS specific models or database-independent models (with portable data types). You can create a database-independent model when you want to output your model to more than one target DBMS. You can also convert your model from one database system to another. Editable data type and function conversion rules are used for the translation.

Supported Oracle Versions

DeZign for Databases can forward engineer and reverse engineer Oracle 8,9,10,11 and 12 databases. Database specific definitions like for example BITMAP indexes etc are supported.

     > Learn More