Previous Next

Database Modeling Diagram Tool for Oracle!

dbforge Studio for Oracle provides the Oracle Database Designer feature, a powerful entity relationship (ER) database diagram tool for Oracle efficient data modeling. It allows you to build a clear and effective relational model of an Oracle database visually and to see the complete picture of all tables, foreign key relations between them, views, and stored routines of your database. Oracle Database Designer is great for both, managing an existing database, and creating a database from scratch.

Design diagrams instantly with a simple drag-and-drop

Create a relational model of an Oracle database in a few simple steps. All you have to do is drag your database objects from Database Explorer to the ER diagram tool. Your new database diagram will reflect all objects and existing connections simplifying further analysis. From this point, you can layout the diagram automatically or manually by dragging shapes and moving the relations. Your diagram can contain a stamp containing company and project names, diagram author, version, date, and copyright. You also may add notes to your entities relationship diagram to describe its objects.

Entity Relationships Modeling

The Database Diagram feature allows you to easily create and edit both, physical relations between foreign keys, an and virtual relations between tables. To create a new entity relationship, click New Relation or New Virtual Relation on the Database Diagram toolbar, connect child and parent tables with the mouse pointer, and configure the relation properties. To edit an existing relation, simply click the required relation.

Navigating diagrams

Navigating diagrams in Oracle Designer was designed with emphasis on speed and convenience. You can focus on any part of your ER diagram using scrollbars, mouse scroll or the Diagram Overview window. Combined with zooming in and out and quick moving to the needed area, these features add extra convenience to using this data model diagram tool.

Straightaway diagram printing

Oracle database visual designer is packed with outstanding features allowing to organize almost any number of objects on the diagram:

  • notes to explain certain diagram parts
  • unlimited number of stamps to specify information about your diagram
  • containers to group the shapes or store specific kinds of objects
  • packages to show encapsulated collections of related procedures, functions, and other program objects on your diagram
  • wide support of image formats backed by powerful image positioning features
Printing a DiagramPP

Visual Database Diagram Package

Diagram Note

Visual Database Diagram Note

Diagram Stamp

Visual Database Diagram Stamp

Availability in editions of dbForge Studio for Oracle

Features

Pro

Stand

Exp

Visual Database Diagram
Yes
Yes
Click to view restrictions

* The number of schema objects on a diagram is limited.